[Feb 10, 2023] COF-C02 Questions Truly Valid For Your Snowflake Exam! [Q97-Q111]

QUESTION 97
When cloning a database, what is cloned with the database? (Choose two.)

QUESTION 98
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

QUESTION 99
What is the recommended Snowflake data type to store semi-structured data like JSON?

QUESTION 100
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

QUESTION 101
True or False: Fail-safe can be disabled within a Snowflake account.

QUESTION 102
Which command is used to unload data from a Snowflake table into a file in a stage?

QUESTION 103
What happens to the underlying table data when a CLUSTER BY clause is added to a
Snowflake table?

QUESTION 104
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

QUESTION 105
What type of query benefits the MOST from search optimization?

QUESTION 106
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

QUESTION 107
What are value types that a VARIANT column can store? (Select TWO)

QUESTION 108
Which statement MOST accurately describes clustering in Snowflake?

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

QUESTION 110
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

QUESTION 111
In which use cases does Snowflake apply egress charges?