SnowPro-Core Free Practice Test

- (Exam Topic 3)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

1. A. Reader
2. B. Consumer
3. C. Vendor
4. D. Standard
5. E. Personalized

Correct Answer: DE

- (Exam Topic 1)
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

1. A. SnowSQL
2. B. ODBC
3. C. R
4. D. HIVE

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

- (Exam Topic 3)
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

1. A. Authentication
2. B. Resource management
3. C. Virtual warehouse caching
4. D. Query parsing and optimization
5. E. Query execution
6. F. Physical storage of micro-partitions

Correct Answer: ADE

- (Exam Topic 1)
Which of the following commands sets the Virtual Warehouse for a session?

1. A. COPT WAREHOUSE FROM <<Config file> ;
2. B. SET warehouse = <>;
3. C. USE WAREHOUSE <>;
4. D. USE VIRTUAL_WAREHOUSE <>;

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

- (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