SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 85

- (Exam Topic 3)
Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?

A. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg SnowPro-Core dumps exhibit

B. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg SnowPro-Core dumps exhibit

C. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg SnowPro-Core dumps exhibit

D. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg SnowPro-Core dumps exhibit

Correct Answer:A

Question 86

- (Exam Topic 2)
Which command can be used to stage local files from which Snowflake interface?

A. SnowSQL

B. Snowflake classic web interface (Ul)

C. Snowsight

D. .NET driver

Correct Answer:A
https://docs.snowflake.com/en/user-guide/snowsql-use.html

Question 87

- (Exam Topic 3)
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A. A directory table is a separate database object.

B. Directory tables store data file metadata.

C. A directory table will be automatically added to a stage.

D. Directory tables do not have their own grantable privileges.

E. Directory table data can not be refreshed manually.

Correct Answer:BD

Question 88

- (Exam Topic 1)
Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)

A. Migrate Users

B. Migrate Schemas

C. Migrate Indexes

D. Build the Data pipeline

Correct Answer:CD

Question 89

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

A. More micro-partitions

B. Better query scheduling

C. Double the numbers of servers In the compute duster

D. Higher storage costs

Correct Answer:C

Question 90

- (Exam Topic 1)
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

A. True

B. False

Correct Answer:A
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

START SnowPro-Core EXAM