SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which of the following are options when creating a Virtual Warehouse?

1. A. Auto-suspend
2. B. Auto-resume
3. C. Local SSD size
4. D. User count

Correct Answer: AB

- (Exam Topic 1)
As a best practice, clustering keys should only be defined on tables of which minimum size?

1. A. Multi-Kilobyte (KB) Range
2. B. Multi-Megabyte (MB) Range
3. C. Multi-Gigabyte (GB) Range
4. D. Multi-Terabyte (TB) Range

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

- (Exam Topic 2)
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

1. A. Use multi-clustered warehousing to scale out warehouse capacity.
2. B. Scale up the warehouse size to allow Queries to execute faster.
3. C. Stop and start the warehouse to clear the queued queries
4. D. Migrate some queries to a new warehouse to reduce load
5. E. Limit user access to the warehouse so fewer queries are run against it.

Correct Answer: AD

- (Exam Topic 2)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

1. A. Load files that are approximately 25 MB or smaller.
2. B. Remove all dates and timestamps.
3. C. Load files that are approximately 100-250 MB (or larger)
4. D. Avoid using embedded characters such as commas for numeric data types
5. E. Remove semi-structured data types

Correct Answer: CD
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

- (Exam Topic 2)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

1. A. Standard
2. B. Premium
3. C. Enterprise
4. D. Business Critical

Correct Answer: D
https://docs.snowflake.com/en/user-guide/privatelink-azure.html