Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 31:

  Which command can be used to load data files into a Snowflake stage?

  A. JOIN

  B. COPY INTO

  C. PUT

  D. GET

  Correct Answer: C

• Question 32:

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

  A. SELECT SUM (ORDER_AMT) FROM SALES;

  B. SELECT AVG(ORDER_QTY) FROM SALES;

  C. SELECT MIN(ORDER_AMT) FROM SALES;

  D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

  Correct Answer: B

• Question 33:

  What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

  B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

  C. The ACCOUNTADMIN role must be granted to only one user.

  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

  E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

  Correct Answer: AD

• Question 34:

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

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

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

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

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

  Correct Answer: C

• Question 35:

  Which of the following accurately describes shares?

  A. Tables, secure views, and secure UDFs can be shared

  B. Shares can be shared

  C. Data consumers can clone a new table from a share

  D. Access to a share cannot be revoked once granted

  Correct Answer: A

• Question 36:

  Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

  A. Schema Stage

  B. User Stage

  C. Database Stage

  D. Table Stage

  E. External Named Stage

  F. Internal Named Stage

  Correct Answer: AEF

• Question 37:

  A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

  How can this worksheet be shared?

  A. Create a zero-copy clone of the worksheet and grant permissions to teammates

  B. Create a private Data Exchange so that any teammate can use the worksheet

  C. Share the worksheet with teammates within Snowsight

  D. Create a database and grant all permissions to teammates

  Correct Answer: C

• Question 38:

  What actions will prevent leveraging of the ResultSet cache? (Choose two.)

  A. Removing a column from the query SELECT list

  B. Stopping the virtual warehouse that the query is running against

  C. Clustering of the data used by the query

  D. Executing the RESULTS_SCAN() table function

  E. Changing a column that is not in the cached query

  Correct Answer: AD

• Question 39:

  When loading data into Snowflake, how should the data be organized?

  A. Into single files with 100-250 MB of compressed data per file

  B. Into single files with 1-100 MB of compressed data per file

  C. Into files of maximum size of 1 GB of compressed data per file

  D. Into files of maximum size of 4 GB of compressed data per file

  Correct Answer: A

• Question 40:

  How are serverless features billed?

  A. Per second multiplied by an automatic sizing for the job

  B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

  C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

  D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

  Correct Answer: D