Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 101:

  When should a multi-cluster warehouse be used in auto-scaling mode?

  A. When it is unknown how much compute power is needed
  B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  C. If the runtime of the executed query is very slow
  D. When a large number of concurrent queries are run on the same warehouse
  D. When a large number of concurrent queries are run on the same warehouse

• Question 102:

  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 target table for 14 days
  B. In the metadata of the pipe for 14 days
  C. In the metadata of the target table for 64 days
  D. In the metadata of the pipe for 64 days
  A. In the metadata of the target table for 14 days

• Question 103:

  Network policies can be set at which Snowflake levels? (Choose two.)

  A. Role
  B. Schema
  C. User
  D. Database
  E. Account
  F. Tables
  C. User
  E. Account

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

• Question 104:

  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
  D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

• Question 105:

  Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

  Which SQL command should be used to delete the files?

  A. PURGE
  B. MODIFY
  C. REMOVE
  D. DELETE
  D. DELETE

  ---

  Explanation/Reference:

  Reference: https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20SQL,the%20records%20from%20a%20table

• Question 106:

  Which of the following statements would be used to export/unload data from Snowflake?

  A. COPY INTO @stage
  B. EXPORT TO @stage
  C. INSERT INTO @stage
  D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
  A. COPY INTO @stage

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

• Question 107:

  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. INSERT INTO
  D. TABLE STREAM
  B. CREATE PIPE

• Question 108:

  What are ways to create and manage data shares in Snowflake? (Select TWO)

  A. Through the Snowflake web interface (Ul)
  B. Through the DATA_SHARE=TRUE parameter
  C. Through SQL commands
  D. Through the enable__share=true parameter
  E. Using the CREATE SHARE AS SELECT * TABLE command
  C. Through SQL commands
  D. Through the enable__share=true parameter

• Question 109:

  Which command can be used to stage local files from which Snowflake interface?

  A. SnowSQL
  B. Snowflake classic web interface (Ul)
  C. Snowsight
  D. .NET driver
  A. SnowSQL

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/snowsql-use.html

• Question 110:

  True or False: It is possible to load data into Snowflake without creating a named File Format object.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html