SnowPro-Core Free Practice Test

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

- (Exam Topic 2)
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

1. A. list @mytable;
2. B. list @%raytable;
3. C. list @ %m.ystage;
4. D. list @mystage;

Correct Answer: D

- (Exam Topic 2)
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

1. A. list @file__stage
2. B. show @file__stage
3. C. view @file__stage
4. D. verify @file__stage

Correct Answer: A