- (Exam Topic 3)
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

1. A. Management of metadata
2. B. Computing the data
3. C. Maintaining Availability Zones
4. D. Infrastructure security
5. E. Parsing and optimizing queries

Correct Answer: AE

- (Exam Topic 1)
Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

1. A. Micro-partitions
2. B. Clustering keys
3. C. Key partitions
4. D. Clustered partitions

Correct Answer: B
Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

- (Exam Topic 1)
What is the recommended method for loading data into Snowflake?

1. A. Load row by row
2. B. Load data in batch
3. C. Load data by writing it In the Snowflake Web Interface (UI)
4. D. Load data via frequent, angle row DML's

Correct Answer: B

- (Exam Topic 3)
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

1. A. Use the DROP <file> command after the load completes.
2. B. Specify the TEMPORARY option when creating the file format.
3. C. Specify the PURGE copy option in the COPY INTO <table> command.
4. D. Use the REMOVE command after the load completes.
5. E. Use the DELETE LOAD HISTORY command after the load completes.

Correct Answer: CD

- (Exam Topic 3)
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?

1. A. Row access policies
2. B. Data masking policies
3. C. Data encryption
4. D. Role based access control

Correct Answer: B