SnowPro Core (COF-C03) · Free practice question 9 of 15
Reader accounts for non-Snowflake consumers
You want to share a subset of your production data with an external partner who does not have a Snowflake account of their own. The data must not be physically copied; the partner should query it live. Which Snowflake feature enables this?
- A.Use `COPY INTO` to export the subset to S3 and grant the partner pre-signed-URL access.
- B.Create a Reader Account from your account and grant the partner credentials to it.
- C.Snowflake does not support sharing with non-Snowflake customers; the partner must sign up first.
- D.Create a database replica in the partner's region for them to query.
Show answer and explanation
Correct answer: B. Create a Reader Account from your account and grant the partner credentials to it.
Why: Reader Accounts let you share live data with non-Snowflake customers. Your account creates and pays for the reader account; the partner gets a login that can query the shared objects without copying data. Export to S3 violates the no-copy constraint. Replication is for cross-region availability, not external sharing.
More free SnowPro Core (COF-C03) questions
- Micro-partition immutability
- SECURITYADMIN for user and role management
- Multi-cluster warehouses for concurrency
- Snowflake edition for extended Time Travel
- Recovering a truncated table with Time Travel
- Types of internal stages
- File sizing for COPY INTO
- Query result cache
- LATERAL FLATTEN on VARIANT arrays
- Streams and tasks for change data capture
- Clustering keys for partition pruning
- Network policies for IP allowlisting
- Zero-copy cloning for QA environments
- Snowpipe auto-ingest for low latency