SnowPro-Core by Snowflake Valid Free Exam Practice Test

Question 1

What feature can be used to reorganize a very large table on one or more columns?

A. Clustering keys B. Clustered partitions C. Micro-partitions D. Key partitions

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

How many resource monitors can be assigned at the account level?

A. 3 B. 4 C. 2 D. 1

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Which pages are included in the Activity area of Snowsight? (Select TWO).

A. Contacts B. Copy History C. Sharing settings D. Automatic Clustering History E. Query History

Correct Answer: D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

A. ACCESS_HISTORY B. WAREHOUSE_METERING_HISTORY C. MONETIZED_USAGE_DAILY D. DATA_TRANSFER_HISTORY E. LISTING TELEMETRY DAILY

Correct Answer: C,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

A. Bytes written to result B. Partitions scanned C. Partitions total D. Bytes scanned E. Percentage scanned from cache

Correct Answer: B,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A. Queries against a subset of columns in a table B. Queries against tables larger than 1 TB C. Queries against large tables where frequent DML occurs D. Selective point lookup queries

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

A. 7 days B. 1 day C. 0 days D. 14 days

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

What does a Notify & Suspend action for a resource monitor do?

A. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed. B. Send an alert notification to all account users who have notifications enabled. C. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met. D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

Which function is used to convert rows in a relational table to a single VARIANT column?

A. ARRAY_CONSTRUCT B. ARRAY_AGG C. OBJECT_AGG D. OBJECT_CONSTRUCT

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 10

Which of the following describes how clustering keys work in Snowflake?

A. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns B. Clustering keys sort the designated columns over time, without blocking DML operations C. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations. D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Snowflake SnowPro Core Certification - SnowPro-Core Exam Practice Test