Snowflake SnowPro Core Certification - COF-C02 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

How can a Snowflake user access near real-time metrics that can be used to identify queries affected by disk spilling?

A. Implement a Snowsight dashboard. B. Use a load monitoring chart. C. Use a worksheet. D. Review the history section of the Query Profile.

Discussion 0

Correct Answer: D Vote an answer

Question 2

By default, which system roles can create and manage users? (Select TWO)

A. PUBLIC B. USERADMIN C. ORGADMIN D. SECURITYADMIN E. SYSADMIN

Discussion 0

Correct Answer: B,D Vote an answer

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

Question 3

Which strategy for optimizing virtual warehouse performance should be used to speed the execution of a very large query?

A. Enable the search optimization service. B. Use the query acceleration service. C. Convert to a multi-cluster warehouse. D. Increase the size of the warehouse.

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which transformation techniques are supported for bulk loading data into Snowflake using the copy into < table > command? (Select TWO)

A. Selection of a limited number of rows B. Column reordering C. Column aggregation D. Column omission E. Column grouping

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

What is a Snowflake recommendation for the use of key pair authentication?

A. Key pair rotation should be automated. B. Role access should be designed to cover the operations that the user account anticipates needing. C. Operator access should be limited to read-only access. D. Keys should be stored in a secure location on the ACCOUNTADMIN file system.

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

A. 121 B. 120 C. 60 D. 91

Discussion 0

Correct Answer: A Vote an answer

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

Question 7

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A. True B. False

Discussion 0

Correct Answer: A Vote an answer

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

Question 8

When unloading data to an external stage, what is the MAXIMUM file size supported?

A. 16 GB B. 1 GB C. 5 GB D. 10 GB

Discussion 0

Correct Answer: C Vote an answer

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

Question 9

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A. INDEX B. BYTE_SIZE C. DATATYPE D. CONTENT E. PATH

Discussion 0

Correct Answer: A,E Vote an answer

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

Question 10

When creating a custom role that will be allowed to create warehouses and databases, which system-defined role does Snowflake recommend also be assigned to the custom role?

A. ACCOUNTADMIN B. USERADMIN C. SECURITYADMIN D. SYSADMIN

Discussion 0

Correct Answer: D Vote an answer

Question 11

Which Snowflake URL type is used by directory tables?

A. Pre-signed B. Scoped C. Virtual-hosted style D. File

Discussion 0

Correct Answer: B Vote an answer

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

Question 12

What is the recommended way to change the existing file format type in my format from CSV to JSON?

A. REPLACE FILE FORMAT my format TYPE-JSON; B. ALTER FILE FORMAT my_format SET TYPE=JSON; C. ALTER FILE FORMAT my format SWAP TYPE WITH JSON; D. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

Discussion 0

Correct Answer: B Vote an answer

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

Question 13

Which activities are managed by Slowflake ' s Cloud Services layer? (Select TWO).

A. Data pruning B. Data compression C. Query parsing and optimization D. Authorisation E. Access delegation

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 14

Why would a Snowflake user decide to use a materialized view instead of a regular view?

A. The query is not resource intensive. B. The query results are not used frequently. C. The base tables do not change frequently. D. The results of the view change often.

Discussion 0

Correct Answer: C Vote an answer

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

Question 15

Which Snowflake database object can be used to track data changes made to table data?

A. Tag B. Task C. Stored procedure D. Stream

Discussion 0

Correct Answer: D Vote an answer

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