COF-R02 Snowflake SnowPro Core Recertification Exam exact Exam Questions

SnowPro Core Recertification Exam

Last Update 8 hours ago Total Questions : 330

The SnowPro Core Recertification Exam content is now fully updated, with all current exam questions added 8 hours ago. Deciding to include COF-R02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our COF-R02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these COF-R02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Core Recertification Exam practice test comfortably within the allotted time.

Question # 41

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

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

Question # 42

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Management of metadata

Computing the data

Maintaining Availability Zones

Infrastructure security

Parsing and optimizing queries

Question # 43

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

Question # 44

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?

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Question # 45

Which statement is true about running tasks in Snowflake?

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

Question # 46

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

When the system has enough load for 2 minutes

When the system has enough load for 6 minutes

When the system has enough load for 8 minutes

When the system has enough load for 10 minutes

Question # 47

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Use the DROP < file > command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO < table > command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

Question # 48

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;