COF-C01 by Snowflake Actual Free Exam Q&As

Question 1

True or False: You can define multiple columns within a clustering key on a table.

A. False B. True

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which of the following are options when creating a Virtual Warehouse?

A. Auto-resume B. Local SSD size C. User count D. Auto-suspend

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

A. The last query using the warehouse completes. B. All Snowflake sessions using the warehouse are terminated. C. The Warehouse is inactive for a specified period of time. D. There are no users loaned into Snowflake.

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which of the following items does the Cloud services Layer manage? Choose 4 answers

A. external blob storage B. Data security C. Query compilation and optimization D. user authentication E. Metadata

Discussion 0

Correct Answer: B,C,D,E Vote an answer

Question 5

For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

A. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse. B. The size of the Warehouse and the number of clusters that ran within a given time period. C. The number of users who accessed the Warehouse. D. The number of queries that ran using the Warehouse.

Discussion 0

Correct Answer: B Vote an answer

Question 6

True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

A. False B. True

Discussion 0

Correct Answer: A Vote an answer

Question 7

How would you execute a series of SQL statements using Task?

A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where .. B. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially. C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside(): D. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

Discussion 0

Correct Answer: C Vote an answer

Question 8

True or False: Snowflake charges a premium for storing semi-structured data.

A. False B. True

Discussion 0

Correct Answer: A Vote an answer

Question 9

What is the most granular object that the Time Travel retention period can be defined on?

A. Account B. Schema C. Table D. Database

Discussion 0

Correct Answer: C Vote an answer

Question 10

Which of the following best describes where Snowflake's metadata is stored?

A. Inside the Virtual Warehouses B. within the drivers C. Within the data files D. In the Cloud Services Layer

Discussion 0

Correct Answer: D Vote an answer

Question 11

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Standard B. Custom C. Optimized D. Economy

Discussion 0

Correct Answer: A,D Vote an answer

Question 12

What is the minimum duration charged when starting a virtual warehouse?

A. 1 hour B. 1 minute C. 1 second D. 1 day

Discussion 0

Correct Answer: B Vote an answer

Snowflake SnowPro Core Certification - COF-C01 Exam Practice Test