SnowPro Core Recertification Exam - COF-R02 Exam Practice Test

Question 1

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A. 24 hours

B. 7 days

C. 48 hours

D. 30 days

Correct Answer: A

Question 2

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the pipe for 14 days

B. In the metadata of the target table for 64 days

C. In the metadata of the target table for 14 days

D. In the metadata of the pipe for 64 days

Correct Answer: C

Question 3

In which use cases does Snowflake apply egress charges?

A. Query result retrieval

B. Data sharing within a specific region

C. Loading data into Snowflake

D. Database replication

Correct Answer: B

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

Question 4

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

A. Authentication

B. Query execution

C. Compute resources

D. Data storage

E. Metadata

Correct Answer: A,E

Question 5

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A. Micro-partitions have been reclustered since the query was last run

B. The new query is run using the same virtual warehouse as the previous query

C. The user has the appropriate privileges on the objects associated with the query

D. The query has been run within 24 hours of the previously-run query

E. The query includes a User Defined Function (UDF)

Correct Answer: C,D

Question 6

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A. The tables are now orphaned

B. SYSADMIN

C. The user that deleted the role

D. The assumed role that dropped the role

Correct Answer: D

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

Question 7

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

A. COPY INTO

B. CREATE PIPE

C. TABLE STREAM

D. INSERT INTO

Correct Answer: B

Question 8

Which of the following objects can be cloned? (Choose four.)

A. Schemas

B. Shares

C. Databases

D. Users

E. Named File Formats

F. Tables

Correct Answer: A,C,E,F

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

Question 9

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

A. Compute can be scaled up or down without the requirement to add more storage

B. Storage expands without the requirement to add more compute

C. Growth of storage and compute are tightly coupled together

D. Multiple compute clusters can access stored data without contention

Correct Answer: A,B,D

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

Question 10

Which of the following DML commands isn't supported by Snowflake?

A. UPDATE

B. MERGE

C. UPSERT

D. TRUNCATE TABLE

Correct Answer: C

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

Question 11

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A. Compute Credits = 200 Credits Cloud Services = 26

B. Compute Credits = 80 Credits Cloud Services = 5

C. Compute Credits = 50 Credits Cloud Services = 10

D. Compute Credits = 120 Credits Cloud Services = 10

E. Compute Credits = 10 Credits Cloud Services = 9

Correct Answer: B,D

Question 12

What is a best practice after creating a custom role?

A. Assign the custom role to the SYSADMIN role

B. Create the custom role using the SYSADMIN role.

C. Add__CUSTOM to all custom role names

D. Assign the custom role to the PUBLIC role

Correct Answer: A

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

Question 13

How does Snowflake Fail-safe protect data in a permanent table?

A. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

B. Fail-safe makes data available up to 1 day, recoverable by user operations.

C. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

D. Fail-safe makes data available for 7 days, recoverable by user operations.

Correct Answer: A

Question 14

How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 64 days

D. 14 days

Correct Answer: D

Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test

Latest Update

Useful Links

Contact Us