SnowPro-Core Free Practice Test

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

- (Exam Topic 3)
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

1. A. Removing a column from the query SELECT list
2. B. Stopping the virtual warehouse that the query is running against
3. C. Clustering of the data used by the query
4. D. Executing the RESULTS_SCAN() table function
5. E. Changing a column that is not in the cached query

Correct Answer: AD

- (Exam Topic 1)
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

1. A. True
2. B. False

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

- (Exam Topic 2)
What are ways to create and manage data shares in Snowflake? (Select TWO)

1. A. Through the Snowflake web interface (Ul)
2. B. Through the DATA_SHARE=TRUE parameter
3. C. Through SQL commands
4. D. Through the enable share=true parameter
5. E. Using the CREATE SHARE AS SELECT * TABLE command

Correct Answer: CD