Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 881:

  A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

  1.Runs a query that takes 3 minutes to complete

  2.Leaves for 15 minutes

  3.Returns and runs a query that takes 10 seconds to complete

  4.Manually suspends the warehouse as soon as the last query was completed

  When the user returns, how much billable compute time will have been consumed?

  A. 4 minutes
  B. 10 minutes
  C. 14 minutes
  D. 24 minutes
  C. 14 minutes

  ---

  Explanation

• Question 882:

  What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

  A. Custom Edition
  B. Virtual Private Snowflake
  C. Business Critical Edition
  D. Standard Edition
  E. Enterprise Edition
  B. Virtual Private Snowflake
  C. Business Critical Edition

  ---

  Explanation

• Question 883:

  Which type of loop requires a BREAK statement to stop executing?

  A. FOR
  B. LOOP
  C. REPEAT
  D. WHILE
  B. LOOP

  ---

  Explanation

• Question 884:

  A user needs to know the maximum value of a date eld in a table, and runs the following query:

  select max(o_orderdate) from ORDERS;

  Which part of Snowflake architecture will this query use?

  A. Database Storage
  B. Query Processing
  C. Cloud Services
  D. Compute
  D. Compute

  ---

  Explanation

• Question 885:

  Which Snowflake object will consume credits during automatic background maintenance?

  A. View
  B. Table
  C. External table
  D. Materialized view
  D. Materialized view

  ---

  Explanation

• Question 886:

  What is included in the calculation of the execution time reported in a Query Profile? (Select TWO).

  A. Pruning
  B. Local disk IO
  C. Processing
  D. Caching
  E. Spilling
  C. Processing
  E. Spilling

  ---

  Explanation

• Question 887:

  A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

  A. view @my_stage
  B. list @my_stage
  C. show @my_stage
  D. display @my_stage
  B. list @my_stage

  ---

  Explanation

• Question 888:

  What is the Snowflake multi-clustering feature for virtual warehouses used for?

  A. To improve the data unloading process to the cloud
  B. To improve data loading from very large data sets
  C. To improve concurrency for users and queries
  D. To speed up slow or stalled queries
  C. To improve concurrency for users and queries

  ---

  Explanation

• Question 889:

  Which columns are available in the output of a Snowflake directory table? (Choose two.)

  A. CATALOG_NAME
  B. FILE_NAME
  C. LAST_MODIFIED
  D. RELATIVE_PATH
  E. STAGE_NAME
  C. LAST_MODIFIED
  D. RELATIVE_PATH

  ---

  Explanation

• Question 890:

  The PUT command: (Choose two.)

  A. Automatically creates a File Format object
  B. Automatically uses the last Stage created
  C. Automatically compresses files using Gzip
  D. Automatically encrypts files
  C. Automatically compresses files using Gzip
  D. Automatically encrypts files

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/put.html