Chapter 7: Cloning Data Sharing Flashcards
Which of the following are true regarding cloned tables? (Select all that apply.)
Cloning physically copies data from one table to another.
A cloned table does not contribute to the overall storage.
Cloning is a metadata operation.
Cloning is almost instantaneous.
A cloned table does not contribute to the overall storage.
Cloning is a metadata operation.
True or False: Cloning is a metadata operation.
True
False
True
Which of the following can be cloned? (Select all that apply.)
Databases
Schemas
Tables
Databases
Schemas
Tables
True or False: After cloning, any updates to the cloned table automatically update the source table.
True
False
False
Which of the following are true regarding cloning? (Select all that apply.)
Cloning a database does not copy any of its child schemas or their objects.
Cloning a database copies all of its child schemas and their objects.
A database cannot be cloned.
If a database or schema is cloned, child object privileges are copied.
Which of the following is correct regarding cloning? (Select all that apply.)
Internal named stages cannot be cloned.
A Snowflake account can be cloned.
When a database or schema is cloned, any Snowpipes that reference an internal named stage are not cloned.
Which of the following are Snowflake’s product offerings for Secure Data Sharing? (Select all that apply.)
Direct Sharing
Data Monetization
Snowflake Data Marketplace
Data Exchange
A data provider has shared a set of tables with a consumer through a share. The consumer has created a read-only database on the share and can successfully see and read the table data. If the data provider adds new tables to the share, which of the following statements apply?
The consumer is required to drop and re-create the database on the share to see the new tables.
The new tables automatically appear in the read-only database.
It is not possible to add tables to a share after it has been shared with a consumer.
A data provider has shared a set of tables with a data consumer who is a Snowflake customer. Who is billed for the compute usage when the consumer runs queries on the shared data?
The data provider
The data consumer
A data provider has shared a set of tables with a non-Snowflake user. The data provider created a reader account to enable the sharing. Who is billed for the compute usage when the consumer runs queries on the shared data?
The data provider
The data consumer
Is it possible to add multiple consuming accounts to a single share?
Yes
Only if you are an Enterprise customer
No
Only when using AWS as the cloud provider
Which of the following roles can create a Share in Snowflake? (Select all that apply.)
ACCOUNTADMIN
SECURITYADMIN
SYSADMIN
A role that has been granted the CREATE SHARE privilege
Which of the following roles can create a read-only database from a share in Snowflake? (Select all that apply.)
ACCOUNTADMIN
SECURITYADMIN
SYSADMIN
A role that has been granted the IMPORT SHARE privilege
Which of the following is true regarding Data Exchange in Snowflake? (Select all that apply.)
Data Exchange is your own private data sharing hub where you can share data with an invite-only group of people and organizations.
Participating members can share, consume, or do both, depending on their privileges.
The account owning the Data Exchange is responsible for inviting members.
Data Exchange allows businesses to share data among a limited set of trustworthy partners, suppliers, vendors, and customers.
Which of the following is true regarding Data Marketplace in Snowflake? (Select all that apply.)
Snowflake accounts can also publish and monetize datasets on the Marketplace.
Snowflake Data Marketplace is a marketplace for discovering and gaining access to third-party datasets made available by various organizations.
The third-party datasets on Data Marketplace are always free.
Except for VPS Snowflake accounts, all Snowflake accounts have access to the Snowflake Data Marketplace.
