Exam SnowPro Core topic 1 question 123 discussion

Reader Accounts are special Snowflake accounts created and managed by a data provider to let consumers query shared data without needing their own Snowflake account. These accounts are intended for read-only access to shared data within Snowflake. They cannot export or unload data to external locations like S3, Azure Blob Storage, or even download locally.

You cannot perform the following tasks in a reader account: - Set a data metric function on objects in the reader account. - Upload new data. - Modify existing data. - Unload data using a storage integration. "However, you can use the COPY INTO <location> command with your connection credentials to unload data into a cloud storage location."

I think its false, copy into a <location> doesnt mean you can use it because it can be a metadata copy.

A: https://docs.snowflake.com/en/user-guide/data-sharing-reader-create#what-is-restricted-allowed-in-a-reader-account

Reader accounts can unload data to storage integration using COPY INTO

A. True

you cannot execute the following commands in a reader account: INSERT UPDATE DELETE MERGE COPY INTO <table> CREATE MASKING POLICY CREATE PIPE CREATE ROW ACCESS POLICY CREATE SHARE CREATE STAGE SHOW PROCEDURES

A. True Reader Accounts in Snowflake have the ability to extract data from shared data objects for use outside of Snowflake. This capability allows organizations to securely share data with external parties while still maintaining control over access and usage.

False: Reader Accounts are not able to extract data from shared data objects for use outside of Snowflake. Here's why: Snowflake's Secure Data Sharing with Reader Accounts provides a mechanism to grant controlled access to data without requiring the recipient to have a full Snowflake account. Reader Accounts can query and analyze the shared data objects (tables, views, etc.) within the Snowflake environment. However, they cannot directly extract the data and download it for use outside of Snowflake. This restriction helps ensure data security and governance. Data providers maintain control over who can access the data and how it's used. While users in reader accounts can gain insights from the data, they cannot export it for potential misuse or unauthorized sharing.

A True

What is restricted/allowed in a reader account? A reader account is intended primarily for querying data shared by the provider of the account. You can work with data, for example, by creating materialized views. You cannot perform the following tasks in a reader account: - Uploading new data. - Modifying existing data. - Unloading data using a storage integration. However, you can use the COPY INTO <location> command with your connection credentials to unload data into a cloud storage location. So the answer is A, you can export data into a cloud storage location. Link: https://docs.snowflake.com/en/user-guide/data-sharing-reader-create

yes, Reader account can download data

A. Reader accounts are Snowflake accounts that are created and managed by data providers on behalf of their consumers. They allow data consumers to: Access and query data shared by the provider of the account Explore and export their data Create customized exports and materialized views

https://docs.snowflake.com/en/user-guide/data-sharing-reader-create Reader accounts (formerly known as “read-only accounts”) enable providers to share data with consumers who are not already Snowflake customers, without requiring the consumers to become Snowflake customers.

https://community.snowflake.com/s/question/0D5Do00000H2a5fKAB/hello-expertsis-it-possible-for-reader-accounts-to-extract-data-from-shared-data-objects-for-outside-use-of-snowflakemany-thanks-in-advance

https://community.snowflake.com/s/question/0D5Do00000H2a5fKAB/hello-expertsis-it-possible-for-reader-accounts-to-extract-data-from-shared-data-objects-for-outside-use-of-snowflakemany-thanks-in-advance

Unloading data using a storage integration. However, you can use the COPY INTO <location> command with your connection credentials to unload data into a cloud storage location. https://docs.snowflake.com/en/user-guide/data-sharing-reader-create