Snowflake COF-R02 Exam Questions Instant Access

Question 1

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

AThe Pipe load history is reset to empty.

BThe REFRESH command is executed.

CThe stage will be purged.

DThe destination table is truncated.

Answer : B

Question 2

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

ATrue

BFalse

Answer : A

Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

Question 3

How long is the Fail-safe period for temporary and transient tables?

AThere is no Fail-safe period for these tables.

B1 day

C7 days

D31 days

E90 days

Answer : A

Question 4

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

ACustom

BEconomy

COptimized

DStandard

Answer : B, D

Question 5

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

ASTATEMENT_TIMEOUT__IN__SECONDS

BSTATEMENT_QUEUED_TIMEOUT_IN_SECONDS

CMAX_CONCURRENCY__LEVEL

DQUERY_TIMEOUT_IN_SECONDS

Answer : B

The parameterSTATEMENT_QUEUED_TIMEOUT_IN_SECONDSsets 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-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

Question 6

What happens when a cloned table is replicated to a secondary database? (Select TWO)

AA read-only copy of the cloned tables is stored.

BThe replication will not be successful.

CThe physical data is replicated

DAdditional costs for storage are charged to a secondary account

EMetadata pointers to cloned tables are replicated

Answer : C, D

Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.

Question 7

Which of the following describes a Snowflake stored procedure?

AThey can be created as secure and hide the underlying metadata from the user.

BThey can only access tables from a single database.

CThey can contain only a single SQL statement.

DThey can be created to run with a caller's rights or an owner's rights.

Answer : A

Snowflake SnowPro Core Recertification COF-R02 Exam Questions