Exam SnowPro Core topic 1 question 123 discussion

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

A is correct. Reader account is an url. Snowflake says data can be "copy to location" to a cloud storage. Which means the data is moved out of snowflake. Reader can be using an other cloud provider or On-prem. He is given an UDL access. Dara can be copied to outside of snowflake. No DB will restrict the data being accessed from an other DB application.

B better

A reader can use the COPY INTO command to unload data to a file on external cloud; https://docs.snowflake.com/en/user-guide/data-sharing-reader-create#what-is-restricted-allowed-in-a-reader-account https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

A reader can query data at the expense of the provider. If you can query, you can have the data in memory locally. This means you can save it (extract it).