Data Collaboration — COF-C03 Practice Quiz

Question 1

A data engineer runs CREATE DATABASE analytics_dev CLONE analytics_prod; to give the development team a copy of production for testing. Shortly after, the team drops several tables in analytics_dev and adds new columns to others. A manager worries this experimentation could harm the production database. Which statement correctly describes the relationship between the cloned database and its source?

Accepted Answer

The clone is an independent object; changes to schemas and tables in analytics_dev do not affect analytics_prod, and cloned data initially shares underlying micro-partitions with the source at no extra storage cost.

Answer

The clone is a read-only reference to analytics_prod, so any attempt to drop tables in analytics_dev will fail with a permission error.

Answer

The clone physically duplicates all micro-partitions immediately, so it consumes the same storage as analytics_prod, but changes remain isolated from the source.

Answer

The clone stays synchronized with analytics_prod, so dropping tables in analytics_dev will also drop them in production unless the link is broken.

Question 2

A data provider shares a database containing several large tables with a consumer account using a direct share. The consumer's data engineering team runs frequent analytical queries against the shared tables. During a cost review, the provider's finance team notices no compute charges related to the consumer's query activity on their account, and the consumer asks who pays for the compute used to query the shared data. Which statement correctly describes how compute is billed for querying shared data?

Accepted Answer

The consumer pays for all compute using their own virtual warehouses when querying the shared data.

Answer

The provider pays for the compute because they own the underlying data being queried.

Answer

Compute charges are split equally between the provider and consumer accounts.

Answer

Querying shared data is serverless, so neither the provider nor consumer is charged for compute.

Question 3

A data provider on Snowflake runs in AWS us-east-1 and has created a direct share containing several secure views. A prospective consumer runs their Snowflake account in Azure West Europe. The provider wants to share the data with this consumer with the least ongoing management overhead while ensuring the data remains accessible. What must the provider do to enable this cross-cloud, cross-region sharing?

Accepted Answer

Set up database replication to a secondary database in an account located in the consumer's region/cloud, then create and share from that replicated database (or use an auto-fulfillment listing).

Answer

Nothing special — direct shares automatically work across any cloud and region because sharing does not copy data.

Answer

Create a reader account for the consumer so they can access the share without their own Snowflake account.

Answer

Export the secure views to an external stage in Azure and grant the consumer access to the stage.

Question 4

A large enterprise has 12 separate Snowflake accounts across its business units. The central data governance team wants to establish a private, curated hub where each business unit can both publish datasets and discover datasets from other business units, but only accounts explicitly invited by the enterprise should be able to participate. Which Snowflake data collaboration feature best fits this requirement?

Accepted Answer

A Data Exchange, where the enterprise acts as the exchange administrator and invites specific member accounts to publish and consume listings

Answer

A public listing on the Snowflake Marketplace so any of the 12 accounts can freely subscribe

Answer

A set of reader accounts created for each business unit to consume shared data

Answer

A single direct share created by the governance team and shared once with all 12 accounts

Question 5

A provider account wants to share a curated database with a business partner who already has their own Snowflake account in the same cloud region. The provider wants the partner to query the data in real time without the provider paying for the partner's compute or creating a managed account. Which sharing approach should the provider use?

Accepted Answer

Create a direct share and add the partner's account as a consumer to the share

Answer

Create a reader account for the partner and grant it access to the share

Answer

Use database replication to copy the database into the partner's account

Answer

Publish the data as a public listing on the Snowflake Marketplace

Question 6

A data provider wants to publish a curated dataset so that any Snowflake customer across multiple regions and cloud platforms can discover it, request access, and consume it without the provider having to know each consumer's account identifier in advance. Which data collaboration mechanism best meets this requirement?

Accepted Answer

Publish a listing on the Snowflake Marketplace

Answer

Create a direct share and add each consumer account to the share individually

Answer

Set up reader accounts for each prospective consumer

Answer

Create a private data exchange and invite each member by account

Question 7

A data provider publishes a free public listing on the Snowflake Marketplace from their account in AWS US East. A prospective consumer running a Snowflake account in Azure West Europe wants to access the listed dataset with the lowest ongoing effort and no data copying on the provider's side. What must happen for the consumer to successfully query this listing's data?

Accepted Answer

The provider must enable auto-fulfillment (cross-cloud auto-fulfillment) so Snowflake automatically replicates the listing's data to the consumer's region when it is requested.

Answer

The consumer must create a reader account in AWS US East and query the data from there, since Marketplace listings cannot cross cloud regions.

Answer

The provider must manually export the dataset to external cloud storage and grant the consumer a storage integration to load it.

Answer

The consumer can query the shared database directly because Marketplace listings are globally accessible in all regions without any replication.

Question 8

A software vendor wants to package proprietary stored procedures, UDFs, and Streamlit UI together and distribute this application to customer Snowflake accounts through the Snowflake Marketplace, while keeping the underlying business logic hidden from consumers and running entirely inside each consumer's account. Which Snowflake feature is designed for this use case?

Accepted Answer

Snowflake Native App Framework

Answer

Secure data sharing with a reader account

Answer

Snowpark Container Services deployed in the provider account

Answer

A database clone shared via a private listing

Question 9

A data provider on AWS US-East-1 has published a listing on the Snowflake Marketplace. A prospective consumer runs their Snowflake account on Azure West Europe and wants to query the shared dataset. The provider does not want the consumer's queries to incur any compute charges on the provider's account. Which statement correctly describes what must happen for this cross-cloud collaboration to work and who bears the compute cost?

Accepted Answer

The provider must replicate the shared database to a Snowflake account in Azure West Europe (or use auto-fulfillment), and the consumer's own virtual warehouse pays for the query compute.

Answer

Direct sharing works across clouds and regions with no replication, and the provider's warehouse is billed for consumer queries.

Answer

The consumer must create a reader account under the provider, and the provider is billed for all compute the reader consumes.

Answer

Cross-cloud sharing is not supported on the Marketplace; the consumer must migrate their account to AWS US-East-1 first.

Question 10

A data provider has created a direct share called SALES_SHARE and added a secure view to it. A partner company operates its own Snowflake account in the same region and needs to begin querying the shared data. What must the provider do so this specific partner account can access the share?

Accepted Answer

Add the partner's account identifier to the share as a consumer account

Answer

Create a reader account and give the partner the login credentials

Answer

Publish the share as a public listing on the Snowflake Marketplace

Answer

Replicate the database containing the share to the partner's account

Question 11

A data provider has created a direct share containing a secure view over a curated sales table. After the consumer account has already imported the shared database, the provider adds a new column to the underlying base table and updates the secure view definition to expose that column. What must the provider do so the consumer sees the newly exposed column?

Accepted Answer

Nothing extra — because the consumer queries live data through the share, the updated secure view immediately reflects the new column

Answer

Recreate the entire share and have the consumer re-import the shared database before the new column is visible

Answer

Manually copy the updated view into the consumer account using a database replication job

Answer

Grant SELECT on the new column to the consumer account's ACCOUNTADMIN role for the change to propagate

Question 12

A data provider maintains a share that currently exposes several secure views to a consumer account. The provider wants to reorganize how access is granted so that groups of shared objects can be managed together and easily added to or removed from the share as a unit, without recreating the share. Which approach lets the provider group and manage the shared objects most efficiently within the share?

Accepted Answer

Create one or more database roles in the shared database, grant object privileges to those database roles, and grant the database roles to the share

Answer

Create an account-level role, grant it the shared objects, and add that account role to the share

Answer

Create a separate share for each group of objects and add all shares to the consumer account

Answer

Clone the shared database into groups and add each clone to the share individually

Question 13

A data provider wants to share curated sales data with a small business partner. The partner does not have a Snowflake account and has no intention of purchasing one, but still needs to run SQL queries against the shared data. The provider wants to avoid copying or exporting any data. Which approach should the provider use?

Accepted Answer

Create a reader account for the partner and share the data into it; the provider bears the compute costs for the partner's queries

Answer

Create a direct share and grant it to the partner's account identifier, which the partner accesses using their own compute

Answer

Publish the data as a private listing on the Snowflake Marketplace and email the partner an access link

Answer

Use COPY INTO to unload the data to an external stage and give the partner temporary credentials to the cloud storage bucket

Question 14

A data provider wants to share curated datasets with a small business partner who does not have a Snowflake account and has no intention of purchasing one. The partner only needs to run read-only queries against the shared data occasionally. The provider creates a reader account for this partner. Which statement correctly describes how compute usage and billing work for this reader account?

Accepted Answer

The reader account queries the shared data using compute resources provisioned and billed to the provider account that created it.

Answer

The partner must sign up for a Snowflake trial account, and their own account is billed for all compute used against the shared data.

Answer

Compute for reader account queries is free of charge because reader accounts are limited to read-only operations.

Answer

The reader account shares the provider's virtual warehouses directly, so no separate warehouses need to be created in the reader account.

Question 15

A data engineering team maintains a SQL UDF that encapsulates proprietary business logic to calculate a customer risk score. They plan to share this UDF with an external partner account through a data share. The team is concerned that the partner should be able to call the function and get results, but must NOT be able to view the underlying SQL expression that defines the calculation. Which approach satisfies this requirement?

Accepted Answer

Create the UDF as a SECURE UDF so its definition is hidden from users who did not create it, then grant usage through the share.

Answer

Create a standard UDF and rely on the partner not having the MONITOR privilege to inspect the definition.

Answer

Wrap the UDF logic in a JavaScript UDF, since JavaScript function bodies are always encrypted in Snowflake.

Answer

Store the UDF in a separate schema and revoke SELECT on the ACCOUNT_USAGE views from the partner account.

Question 16

A data engineer builds a view that joins a proprietary customer-scoring table with a public reference table. The view will be shared with an external partner account through a Snowflake data share. Company policy requires that the partner must be able to query the results but must NOT be able to see the underlying SQL logic or infer excluded rows through query optimizations. Which view type should the engineer create?

Accepted Answer

A secure view, because it hides the view definition and disables query optimizations that could expose underlying data

Answer

A standard view, because standard views always hide their definition from consumers by default

Answer

A materialized view, because materialized views cannot be inspected and are the only view type shareable

Answer

A standard view with a masking policy applied to every column

Question 17

A retail analytics company creates a direct share containing a secure view and grants it to a partner's Snowflake account in the same region. The partner immediately begins querying the shared data. The provider's data engineering lead is asked how storage is billed for this arrangement. Which statement correctly describes the storage and data-access behavior of Snowflake Secure Data Sharing?

Accepted Answer

No data is copied to the consumer; the consumer queries the provider's live data and only the provider pays for storage, while the consumer pays for the compute they use.

Answer

The shared data is physically replicated into the consumer account, so the consumer is billed for the duplicated storage.

Answer

Both provider and consumer are billed for a copy of the shared storage, split evenly between the two accounts.

Answer

The consumer receives a nightly snapshot copy of the data and pays for storage of that snapshot in their account.

Question 18

A data provider wants to share a curated subset of a large customer transactions table with a consumer account in the same region. The provider must ensure that consumers cannot see the underlying table structure or query columns that were excluded, and that no data is physically copied to the consumer. Which approach correctly satisfies all of these requirements when adding objects to a share?

Accepted Answer

Create a secure view that selects only the required columns and rows, then grant SELECT on that secure view to the share

Answer

Add the base transactions table directly to the share and rely on column-level masking policies to hide excluded columns

Answer

Create a materialized view over the transactions table and add the materialized view to the share so results are precomputed

Answer

Clone the transactions table into the consumer's account and grant SELECT on the cloned copy

Question 19

A data engineering team needs the ability to configure Time Travel retention on critical permanent tables for up to 90 days to support recovery and auditing requirements. Their organization currently runs on Snowflake Standard Edition. What is the minimum edition they must move to in order to set a data retention period of 90 days?

Accepted Answer

Enterprise Edition, which raises the maximum Time Travel retention for permanent objects to 90 days

Answer

Standard Edition, since it already supports up to 90 days of Time Travel

Answer

Business Critical Edition, because extended Time Travel requires HIPAA-level compliance features

Answer

Virtual Private Snowflake (VPS), which is the only edition that unlocks retention beyond 1 day

More COF-C03 practice