SnowPro-Core Free Practice Test

- (Exam Topic 1)
True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

1. A. True
2. B. False

Correct Answer: B

- (Exam Topic 1)
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

1. A. Temporary Tables
2. B. Transient Tables
3. C. Provisional Tables
4. D. Permanent Tables

Correct Answer: AB
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

- (Exam Topic 3)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

1. A. Custom Edition
2. B. Virtual Private Snowflake
3. C. Business Critical Edition
4. D. Standard Edition
5. E. Enterprise Edition

Correct Answer: BC

- (Exam Topic 1)
Which of the following commands are not blocking operations? Choose 2 answers

1. A. UPDATE
2. B. INSERT
3. C. MERGE
4. D. COPY

Correct Answer: BD

- (Exam Topic 3)
What are supported file formats for unloading data from Snowflake? (Choose three.)

1. A. XML
2. B. JSON
3. C. Parquet
4. D. ORC
5. E. AVRO
6. F. CSV

Correct Answer: BCF