COF-C03 Data Collaboration — All Questions With Answers

Question 1mediummultiple choice

Read the full Data Collaboration explanation →

A financial services company based in the US-East region needs to share a large scale dataset with a partner who operates solely in the EU-West region. What is the standard Snowflake procedure to facilitate this cross-region data sharing?

Question 2mediummulti select

Read the full Data Collaboration explanation →

Which TWO statements accurately describe the functionality and benefits of Snowflake Marketplace listings compared to Direct Sharing?

Question 3hardmultiple choice

Read the full Data Collaboration explanation →

A data provider wants to share a view that joins a table in DATABASE_A with a table in DATABASE_B. Both tables contain sensitive information. What is the most critical security configuration the provider must implement to ensure the share works for a consumer?

Question 4mediummulti select

Read the full Data Collaboration explanation →

Which THREE types of objects can be explicitly added to a Snowflake Share for consumption by another account?

Question 5mediummultiple choice

Read the full Data Collaboration explanation →

A provider updates the data in a table that is currently part of an active share. When will the consumer see these updates in their own account?

Question 6easymulti select

Read the full Data Collaboration explanation →

Which TWO system-defined roles have the inherent ability to create and manage Shares by default, or can be granted the necessary privileges to do so?

Question 7mediummultiple choice

Read the full Data Collaboration explanation →

A company is using Data Exchanges to collaborate with multiple partners. They need to ensure that data sets are automatically updated for consumers without the provider manually pushing changes. How can this be accomplished?

Question 8mediummultiple choice

Read the full Data Collaboration explanation →

Which THREE actions are required for an organization to consume data from a provider via a Private Data Exchange?

Question 9hardmultiple choice

Read the full Data Collaboration explanation →

A data provider has created a share and granted SELECT on a table to it. The provider now wants to revoke the consumer's access to a specific column containing personally identifiable information (PII) without removing the entire table from the share. What should the provider do?

Question 10mediummultiple choice

Read the full Data Collaboration explanation →

A data provider at ACME Corp wants to share a secure view with a partner. The secure view reads from a table that is not included in the share. After creating the share and adding the secure view, what must be configured to allow the consumer to query the view successfully?

Question 11mediummultiple choice

Read the full Data Collaboration explanation →

A Snowflake provider wants to share a secure view with a consumer, but the view is defined on a table that is not included in the share. The view's owner has the necessary privileges on the underlying table. What is the minimum additional step required for the consumer to query the view successfully?

Question 12hardmultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer but needs to ensure that the consumer can only see a subset of rows based on the consumer's account. The provider has a table SALES with a column REGION. The provider wants to create a secure view that filters rows based on the consumer's account name. Which approach should the provider use?

Question 13mediummulti select

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer using a direct share. The provider has created the share and added a database and a secure view to it. Which two additional steps must the provider perform to make the share accessible to the consumer? (Choose two.)

Question 14mediummultiple choice

Read the full Data Collaboration explanation →

A consumer has created a database from a share and wants to grant a role in their account the ability to query the shared data. Which privilege must the consumer grant to the role on the shared database?

Question 15mediummultiple choice

Read the full Data Collaboration explanation →

A data provider at a healthcare company has created a share called PATIENT_SHARE and granted USAGE on the database PATIENT_DB and the schema CLAIMS to the share. They now need to share a secure view named CLAIMS_SUMMARY that is owned by the role ANALYST_ROLE but resides in the CLAIMS schema. The provider's current active role is PROVIDER_ROLE, which has been granted the global privilege to create shares. What must the provider do to make the view available to consumers?

Question 16hardmulti select

Read the full Data Collaboration explanation →

A provider wants to share a table with a partner but must ensure the partner can query the data while the provider can continue to update it, and the partner must not be able to see any rows outside an approved region. The provider has created a secure view that filters by region and joins a lookup table. Which TWO grants must the provider include on the share for the consumer to query the secure view successfully? (Choose two.)

Question 17hardmultiple choice

Read the full Data Collaboration explanation →

A provider has created a share and added a table. The consumer reports that they can see the shared database but cannot query the table. The provider verifies that the table is listed in the share. Which action should the provider take to resolve the issue?

Question 18hardmulti select

Read the full Data Collaboration explanation →

A provider wants to share a secure view named sales_db.public.regional_summary with a consumer account. The view joins sales_db.public.orders with sales_db.public.customers and includes a WHERE clause that filters rows based on CURRENT_ACCOUNT(). The provider also wants to prevent the consumer from seeing the view definition or the underlying tables. Which two actions must the provider perform? (Choose two.)

Question 19hardmulti select

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer account using a share. The provider has created the share and granted SELECT on a table to the share. Which TWO additional steps must the provider perform to complete the sharing setup? (Choose two.)

Question 20mediummultiple choice

Read the full Data Collaboration explanation →

A data provider wants to share data with a consumer, but the consumer must not be able to re-share the data with others. Which Snowflake feature should the provider use?

Question 21hardmulti select

Read the full Data Collaboration explanation →

A provider wants to expose a shared database to consumers and ensure that only specific consumer roles can query it, while also preventing consumers from seeing rows for regions they are not entitled to. Which two approaches should the provider use? (Choose two.)

Question 22mediummulti select

Read the full Data Collaboration explanation →

A provider is setting up a share to a consumer. Which TWO privileges must be granted to the share to allow the consumer to query a table named SALES in the schema PUBLIC of database DB1? (Choose two.)

Question 23easymultiple choice

Read the full Data Collaboration explanation →

A Snowflake data provider creates a Reader Account for a consumer who does not have a Snowflake account. Who is responsible for the compute costs incurred by the queries executed within this Reader Account?

Question 24mediummultiple choice

Read the full Data Collaboration explanation →

Refer to the exhibit. A provider has executed these commands to prepare data for a consumer. What is the final mandatory step required before the consumer can access the 'campaign_stats' table?

Exhibit

CREATE SHARE marketing_share;
GRANT USAGE ON DATABASE marketing_db TO SHARE marketing_share;
GRANT USAGE ON SCHEMA marketing_db.public TO SHARE marketing_share;
GRANT SELECT ON TABLE marketing_db.public.campaign_stats TO SHARE marketing_share;

Question 25easymultiple choice

Read the full Data Collaboration explanation →

A consumer has mounted a shared database named 'SALES_DATA_SHARED'. They need to add a new column to one of the tables in this database to store local annotations. Which statement best describes the outcome if they attempt this?

Question 26hardmulti select

Read the full Data Collaboration explanation →

To publish a data listing on the Snowflake Marketplace and make it available to all Snowflake customers, which TWO requirements must the provider fulfill?

Question 27mediummultiple choice

Read the full Data Collaboration explanation →

Refer to the exhibit. Based on the JSON configuration for this Snowflake listing, who will be able to discover and access this data?

Exhibit

{
  "listing_title": "Global Weather Daily",
  "listing_type": "FREE",
  "visibility": "PRIVATE",
  "target_accounts": ["ORG_A.ACCOUNT_1", "ORG_B.ACCOUNT_2"]
}

Question 28mediummultiple choice

Read the full Data Collaboration explanation →

A provider wants to ensure that a Reader Account they created does not exceed a budget of 50 credits per month. What is the most effective way to implement this control?

Question 29mediummultiple choice

Read the full Data Collaboration explanation →

An organization wants to create a 'Data Exchange' but only for its internal departments and a few selected vendors. They want to control who can join and what data is listed. Which Snowflake feature is best suited for this?

Question 30mediummultiple choice

Read the full Data Collaboration explanation →

A consumer has created a database from a share. They want to grant their 'ANALYST' role the ability to query the tables within this shared database. Which privilege should they grant to the role?

Question 31mediummultiple choice

Read the full Data Collaboration explanation →

A data provider wants to share a subset of data with a specific consumer while ensuring the consumer cannot see any other tables in the same database. What is the most secure and efficient method to achieve this?

Question 32easymultiple choice

Read the full Data Collaboration explanation →

Which object acts as the primary container for sharing data with external Snowflake accounts?

Question 33hardmultiple choice

Read the full Data Collaboration explanation →

Which TWO statements are true regarding the costs associated with Data Sharing in Snowflake?

Question 34mediummultiple choice

Read the full Data Collaboration explanation →

Which feature should a provider use if they need to allow a consumer to access data based on the consumer's specific identity or organizational attributes?

Question 35mediummultiple choice

Read the full Data Collaboration explanation →

A provider shares a database with a consumer using a direct share. The consumer reports that queries against the shared database fail with an error indicating the database does not exist, even though the share was successfully created and granted to the consumer account. The provider confirmed that the share contains the necessary tables and that the consumer account has been added to the share. What is the most likely cause of the issue?

Question 36mediummultiple choice

Read the full Data Collaboration explanation →

A Snowflake provider wants to share a secure view with a consumer. The view is defined on a table in a different database than the one containing the view, and the provider must ensure the consumer cannot access the underlying base table directly. Which action should the provider take?

Question 37mediummultiple choice

Read the full Data Collaboration explanation →

A data provider at ACME Corp has created a share named REGIONAL_SALES_SHARE and added a secure view on the SALES table. The provider now wants to grant a specific consumer account, named CONSUMER_ACCT, access to this share. Which command should the provider use to accomplish this?

Question 38mediummultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer and ensure that the consumer can only read the data but cannot create any objects in the shared database. The provider has already created a share and granted USAGE on the database and schema, and SELECT on the table. What additional step, if any, is required to enforce read-only access?

Question 39mediummultiple choice

Read the full Data Collaboration explanation →

A provider account named PROVIDER_ACCT has created a share named PARTNER_SHARE and granted SELECT on a secure view to it. The provider now needs to make this share available to a specific consumer account named CONSUMER_ACCT. Which single command should the provider execute to accomplish this?

Question 40easymultiple choice

Read the full Data Collaboration explanation →

A consumer has created a database from a share provided by a partner. The consumer wants to query the shared data but receives an error indicating insufficient privileges. Which role must the consumer's user be granted to access the shared database?

Question 41hardmultiple choice

Read the full Data Collaboration explanation →

A provider has shared a database with a consumer. The consumer reports that they can see the shared database but cannot query any tables because they get an error about insufficient privileges. The provider used the following command to create the share: CREATE SHARE MY_SHARE; then added a database and a table to the share. The provider also granted USAGE on the database and SELECT on the table to a role named SHARE_ROLE, and then granted SHARE_ROLE to MY_SHARE. What is the most likely cause of the consumer's issue?

Question 42hardmultiple choice

Read the full Data Collaboration explanation →

A provider has created a share and added a table. The consumer reports that they can see the shared database and schema but cannot see the table. The provider confirms the table was added with ALTER SHARE ... ADD TABLE. Which additional privilege must the provider grant to the share so the consumer can query the table?

Question 43hardmultiple choice

Read the full Data Collaboration explanation →

A provider shares a secure view named SALES_VIEW with a consumer. The view references a table in the provider's database. The provider later renames the underlying table. What is the impact on the consumer's access to SALES_VIEW?

Question 44hardmulti select

Read the full Data Collaboration explanation →

A provider is preparing to share a secure view that references a table in another database. The provider must ensure the consumer can query the view but cannot access the base table. Which two actions must the provider take? (Choose two.)

Question 45easymultiple choice

Read the full Data Collaboration explanation →

A data provider at a healthcare analytics company wants to share live patient-readmission metrics with a partner hospital. The partner must query the data with low latency and the provider must retain full ownership and control of the underlying tables. The provider creates a share and grants USAGE on a secure view to the share. Which action must the provider perform next so the partner account can mount and query the shared data?

Question 46easymultiple choice

Read the full Data Collaboration explanation →

A provider wants to share a database with a consumer account. After creating the share and granting the necessary privileges, which command must the provider run to make the share available to the consumer account?

Question 47mediummulti select

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer using a Direct Share. Which two statements accurately describe the consumer's experience after the share is mounted? (Choose two.)

Question 48mediummultiple choice

Read the full Data Collaboration explanation →

A retail provider shares a secure view that joins a table in its SALES database with a table in its INVENTORY database. A consumer reports that queries against the shared view fail with an authorization error, even though the view itself is granted to the share. The provider confirms both underlying tables exist and the view definition is valid. Which issue most likely explains the failure?

Question 49easymultiple choice

Read the full Data Collaboration explanation →

A consumer wants to access a shared database from a provider. The provider has already created the share and granted the necessary privileges. What must the consumer do to access the shared data?

Question 50mediummultiple choice

Read the full Data Collaboration explanation →

A provider runs CREATE SHARE sales_share; then GRANT USAGE ON DATABASE sales_db TO SHARE sales_share; GRANT USAGE ON SCHEMA sales_db.public TO SHARE sales_share; GRANT SELECT ON TABLE sales_db.public.orders TO SHARE sales_share; ALTER SHARE sales_share ADD ACCOUNT = consumer_acct; A consumer in consumer_acct queries the shared database and receives results. Six months later, the provider executes REVOKE SELECT ON TABLE sales_db.public.orders FROM SHARE sales_share; What is the immediate effect for the consumer?

Question 51easymultiple choice

Read the full Data Collaboration explanation →

A consumer has mounted a share from a provider and wants to grant a role in their account the ability to query the shared data. What must the consumer do?

Question 52easymultiple choice

Read the full Data Collaboration explanation →

A consumer has created a database from a share provided by a partner. The consumer wants to allow a specific role, ANALYST_ROLE, to query the shared data. Which privilege must the consumer grant to ANALYST_ROLE on the shared database?

Question 53hardmultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer but needs the shared data to reflect changes in the provider's source tables in near real time. The provider also wants to avoid granting the consumer access to the underlying base tables. Which approach best meets these requirements?

Question 54mediummultiple choice

Read the full Data Collaboration explanation →

A provider has created a share and added a table. The provider now wants to revoke access for a specific consumer account without affecting other consumers. Which command should the provider use?

Question 55hardmultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer but needs to ensure that the consumer cannot see the underlying table structure or any data beyond what is explicitly exposed. The provider also wants to prevent the consumer from using the shared data to infer sensitive information. Which Snowflake feature should the provider use?

Question 56hardmulti select

Read the full Data Collaboration explanation →

A provider is preparing to share data with a consumer via a direct share. The provider wants to ensure that the consumer can access the data but cannot see the underlying table structure or any other objects in the database. Which two actions should the provider take? (Choose two.)

Question 57hardmultiple choice

Read the full Data Collaboration explanation →

A consumer account has created a database from a share provided by a partner. The consumer wants to ensure that when the provider adds new tables to the share, those tables become available in the consumer's shared database without any manual intervention. Which statement accurately describes the behavior of shared databases in Snowflake?

Question 58mediummultiple choice

Read the full Data Collaboration explanation →

A provider's account is named PROVIDER_ACCT and it has created a share named PARTNER_SHARE that already contains a secure view. The provider now runs: ALTER SHARE PARTNER_SHARE ADD ACCOUNTS = CONSUMER_ACCT; What is the effect of this command in the provider's environment?

Question 59mediummultiple choice

Read the full Data Collaboration explanation →

A provider uses a reader account to share data with a client that does not have its own Snowflake account. The client now reports that it cannot see newly added tables that the provider granted to the share. The provider confirms the new tables were added to the share with SELECT grants. Which statement explains why the client cannot see the new tables?

Question 60mediummultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer but must ensure that the consumer cannot see the underlying base tables, only an aggregated subset. The provider decides to use a secure view. Which statement is true regarding the use of secure views in a share?

Question 61easymultiple choice

Read the full Data Collaboration explanation →

A consumer account has mounted a shared database named partner_db. The consumer wants to create a local table that combines data from the shared database with their own data. What must the consumer do to create this new table?

Question 62hardmultiple choice

Read the full Data Collaboration explanation →

A provider wants to share a database with a consumer but must prevent the consumer from seeing the database's table and schema names in its own account. The provider also wants the consumer's queries to be isolated from the provider's own warehouse usage. Which approach satisfies both requirements?

Question 63easymultiple choice

Read the full Data Collaboration explanation →

A consumer account has mounted a shared database from a provider. The consumer's role CONSUMER_ROLE has been granted USAGE on the shared database and its schemas. However, when the consumer tries to query a table in the shared database, they receive an error that the table does not exist. What is the most likely cause?

Question 64hardmultiple choice

Read the full Data Collaboration explanation →

A provider wants to share a dynamic table with a consumer. The dynamic table is defined on a base table that is not shared. What must the provider ensure for the consumer to query the dynamic table?

Question 65mediummultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer account, but the consumer's account is in a different Snowflake region. The provider's data is in the US West (Oregon) region, and the consumer is in the EU (Frankfurt) region. The provider needs the consumer to access the data with low latency. Which Snowflake feature should the provider use?

Question 66hardmulti select

Read the full Data Collaboration explanation →

A provider is preparing to share data with a consumer using a direct share. The provider wants to ensure that the consumer can query a specific table and also see any future columns added to that table without additional grants. Which two actions must the provider take? (Choose two.)

Question 67easymultiple choice

Read the full Data Collaboration explanation →

A consumer account has created a read-only database named SHARED_SALES from a provider's share and now wants to combine the shared tables with its own local table, LOCAL_REGIONS, in a single query. Which statement about this operation is accurate?

Question 68hardmultiple choice

Read the full Data Collaboration explanation →

A provider has created a share and granted SELECT on a table to the share. The provider now wants to allow the consumer to query the table but also wants to ensure that the consumer cannot see the table's columns that contain personal data. The provider decides to create a secure view that excludes the sensitive columns and grants SELECT on the view to the share. The provider does NOT grant SELECT on the base table to the share. What will the consumer experience when querying the shared view?

Question 69hardmultiple choice

Read the full Data Collaboration explanation →

A provider has a share containing a secure view that references a table in the same database. The provider wants the share to stop being visible to a specific consumer account but keep the share and its grants intact for other consumers. Which action accomplishes this?

Question 70mediummultiple choice

Read the full Data Collaboration explanation →

A provider wants to share data with a consumer using a reader account because the consumer does not have a Snowflake account. Which statement describes the correct capability of a reader account in this scenario?

CREATE SHARE marketing_share; GRANT USAGE ON DATABASE marketing_db TO SHARE marketing_share; GRANT USAGE ON SCHEMA marketing_db.public TO SHARE marketing_share; GRANT SELECT ON TABLE marketing_db.public.campaign_stats TO SHARE marketing_share;