- (Exam Topic 2)
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

1. A. ORC
2. B. XML
3. C. Avro
4. D. Parquet
5. E. JSON

Correct Answer: DE
Semi-structured JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-Th

- (Exam Topic 1)
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

1. A. Configure the Maximum Clusters setting to “Auto-Scale”
2. B. Set the Warehouse type to “Auto”
3. C. Set the Minimum Clusters and Maximum Clusters settings to the same value
4. D. Set the Minimum Clusters and Maximum Clusters settings to the different values

Correct Answer: D
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

- (Exam Topic 1)
What is the lowest Snowflake edition that offers Time Travel up to 90 days?

1. A. standard Edition
2. B. Premier Edition
3. C. Enterprise Edition
4. D. Business Critical Edition

Correct Answer: C
Reference: https://docs.snowflake.com/en/user-guide/data-availability.html

- (Exam Topic 3)
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

1. A. Business Critical Edition
2. B. Standard Edition
3. C. Virtual Private Snowflake (VPS)
4. D. Enterprise Edition

Correct Answer: D

- (Exam Topic 3)
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

1. A. Use data encryption.
2. B. Use dynamic data masking.
3. C. Use secure materialized views.
4. D. Revoke all roles for functional managers and end users.

Correct Answer: B