Question 1

What is cached during a query on a virtual warehouse?

Accepted Answer

B

Explanation: :

Question 2

Which command can be used to load data into an internal stage?

Accepted Answer

D

Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internalstages-7121cc3cc9

Question 3

Select the different types of Internal Stages: (Choose three.)

Accepted Answer

Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#SnowflakeInternal- Named-Stage

Question 4

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Accepted Answer

A

Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Question 5

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Accepted Answer

Explanation: Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-datawarehousedoesnt- separate-storage-and-compute-65d2dffd450f

Question 6

Which of the following objects can be cloned? (Choose four.)

Accepted Answer

Explanation: Which Objects Can Be Cloned? Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

Question 7

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Accepted Answer

A

Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

Question 8

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

Accepted Answer

B

Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question 9

Which Snowflake technique can be used to improve the performance of a query?

Accepted Answer

A

Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Question 10

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Accepted Answer

B

Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-TimeoutParameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets% 20the,indefinitely%20in%20the%20waiting%20queue.

Question 11

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Accepted Answer

Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

Question 12

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Accepted Answer

A

Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Question 13

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Accepted Answer

A

Explanation: :

Question 14

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Accepted Answer

A

Explanation: :

Question 15

Which of the following terms best describes Snowflake’s database architecture?

Accepted Answer

C

Explanation: https://www.snowflake.com/product/architecture/ Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.

Free SnowFlake COF-R02 Actual Exam Questions