COF-R02 by Snowflake Actual Free Exam Q&As

Question 1

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A. When the system has enough load for 8 minutes B. When the system has enough load for 2 minutes C. When the system has enough load for 6 minutes D. When the system has enough load for 10 minutes

Discussion 0

Correct Answer: D Vote an answer

Question 2

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

A. False B. True

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible. B. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse. C. Enclose fields that contain delimiter characters in single or double quotes. D. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost. E. Aim to produce data files that are between 100 MB and 250 MB in size, compressed. F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 4

How can a row access policy be applied to a table or a view? (Choose two.)

A. Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>; B. By future APPLY for all objects in a schema C. Within the create table or create view DDL D. Within a control table E. Within the policy DDL

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

When is the result set cache no longer available? (Select TWO)

A. When the warehouse used to execute the query is suspended B. When another warehouse is used to execute the query C. When another user executes the query D. When the underlying data has changed E. When it has been 24 hours since the last query

Discussion 0

Correct Answer: D,E Vote an answer

Question 6

How long is Snowpipe data load history retained?

A. As configured in the create pipe settings B. 14 days C. Until the pipe is dropped D. 64 days

Discussion 0

Correct Answer: D Vote an answer

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

Question 7

What data is stored in the Snowflake storage layer? (Select TWO).

A. Snowflake parameters B. Micro-partitions C. Query history D. Standard and secure view results E. Persisted query results

Discussion 0

Correct Answer: B,E Vote an answer

Question 8

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A. Contact Snowflake Support to have the data retrieved from Fail-safe storage. B. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage. C. The transient table version cannot be retrieved after 24 hours. D. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

Discussion 0

Correct Answer: C Vote an answer

Question 9

When loading data into Snowflake, how should the data be organized?

A. Into files of maximum size of 4 GB of compressed data per file B. Into files of maximum size of 1 GB of compressed data per file C. Into single files with 1-100 MB of compressed data per file D. Into single files with 100-250 MB of compressed data per file

Discussion 0

Correct Answer: D Vote an answer

Question 10

What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

A. Simplicity B. Concurrency C. Open source based D. On-premise availability E. Performance

Discussion 0

Correct Answer: A,B,E Vote an answer

Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test