- (Exam Topic 2)
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

1. A. Pipe
2. B. External stage
3. C. Task
4. D. Stream

Correct Answer: A
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

- (Exam Topic 3)
What is true about sharing data in Snowflake? (Choose two.)

1. A. The Data Consumer pays for data storage as well as for data computing.
2. B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
3. C. A Snowflake account can both provide and consume shared data.
4. D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
5. E. The Data Consumer pays only for compute resources to query the shared data.

Correct Answer: BC

- (Exam Topic 3)
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

1. A. CREATE_SHARE on the account
2. B. SHARE on databases and schemas
3. C. SELECT on tables used by the secure view
4. D. REFERENCE_USAGE on databases

Correct Answer: C

- (Exam Topic 1)
True or False: Snowflake charges a premium for storing semi-structured data.

1. A. True
2. B. False

Correct Answer: B
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data

- (Exam Topic 2)
Which of the following objects can be shared through secure data sharing?

1. A. Masking policy
2. B. Stored procedure
3. C. Task
4. D. External table

Correct Answer: D
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enab