SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 13

- (Exam Topic 3)
What is true about sharing data in Snowflake? (Choose two.)

A. The Data Consumer pays for data storage as well as for data computing.

B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C. A Snowflake account can both provide and consume shared data.

D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E. The Data Consumer pays only for compute resources to query the shared data.

Correct Answer:BC

Question 14

- (Exam Topic 1)
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

A. JDBC

B. SnowSQL

C. Snowflake Web Interface (UI)

D. ODBC

E. PythonD18912E1457D5D1DDCBD40AB3BF70D5D

Correct Answer:ABCDE
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

Question 15

- (Exam Topic 3)
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Correct Answer:DEF

Question 16

- (Exam Topic 3)
A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Correct Answer:D

Question 17

- (Exam Topic 3)
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

A. No virtual warehouse will be used, data will be read from the result cache.

B. No virtual warehouse will be used, data will be read from the local disk cache.

C. The default virtual warehouse will be used to read all data.

D. The virtual warehouse that is defined at the session level will be used to read all data.

Correct Answer:A

Question 18

- (Exam Topic 1)
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

A. The Pipe load history is reset to empty

B. The REFRESH parameter is set to TRUE

C. Previously loaded files will be ignored

D. All of the above

Correct Answer:A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

START SnowPro-Core EXAM