SnowPro-Core Free Practice Test

- (Exam Topic 1)
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

1. A. More micro-partitions
2. B. Better query scheduling
3. C. Double the numbers of servers In the compute duster
4. D. Higher storage costs

Correct Answer: C

- (Exam Topic 3)
What are common issues found by using the Query Profile? (Choose two.)

1. A. Identifying queries that will likely run very slowly before executing them
2. B. Locating queries that consume a high amount of credits
3. C. Identifying logical issues with the queries
4. D. Identifying inefficient micro-partition pruning
5. E. Data spilling to a local or remote disk

Correct Answer: AD

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

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

- (Exam Topic 2)
What is a key feature of Snowflake architecture?

1. A. Zero-copy cloning creates a mirror copy of a database that updates with the original
2. B. Software updates are automatically applied on a quarterly basis
3. C. Snowflake eliminates resource contention with its virtual warehouse implementation
4. D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
5. E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Correct Answer: D

- (Exam Topic 2)
What is a responsibility of Snowflake's virtual warehouses?

1. A. Infrastructure management
2. B. Metadata management
3. C. Query execution
4. D. Query parsing and optimization
5. E. Management of the storage layer

Correct Answer: C