- (Exam Topic 2)
Which account ____ usage views are used to evaluate the details of dynamic data masking? (Select TWO)

1. A. ROLES
2. B. POLICY_REFERENCES
3. C. QUERY_HISTORY
4. D. RESOURCE_MONIT ORS
5. E. ACCESS_HISTORY

Correct Answer: BC
https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING

- (Exam Topic 3)
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

1. A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
2. B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
3. C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
4. D. A user cannot specify a default warehouse when using the ODBC driver.
5. E. The default virtual warehouse size can be changed at any time.

Correct Answer: A

- (Exam Topic 1)
True or false: it is best practice to define a clustering key on every table.

1. A. True
2. B. False

Correct Answer: B
Reference: https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/

- (Exam Topic 1)
Which of the following is true of Snowpipe via REST API? Choose 2 answers

1. A. you can only use it on internal Stages
2. B. All COPY INTO options are available fluting pipe creation
3. C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
4. D. Snowpipe keeps track of which files it has loaded

Correct Answer: CD
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes

- (Exam Topic 1)
Which of the following items does the Cloud services Layer manage? Choose 4 answers

1. A. user authentication
2. B. Metadata
3. C. Query compilation and optimization
4. D. external blob storage
5. E. Data security

Correct Answer: ABCE