Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 651:

  What action will cause the cache associated with compute resources to be dropped?

  A. Increasing the size of a running standard virtual warehouse
  B. Decreasing the size of a running standard virtual warehouse
  C. Adding a new standard virtual warehouse that is the same size as a running warehouse
  D. Adding a multi-cluster virtual warehouse that is of a similar size to a running warehouse
  B. Decreasing the size of a running standard virtual warehouse

  ---

  Explanation

• Question 652:

  What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

  A. Fail-safe
  B. Time Travel
  C. Cloning
  D. Account replication
  A. Fail-safe

  ---

  Explanation

• Question 653:

  A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.

  Which file format option MUST be used to do this?

  A. encoding
  B. escape
  C. file_extension
  D. single
  D. single

  ---

  Explanation

• Question 654:

  Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

  A. DELETE
  B. DROP
  C. REMOVE
  D. TRUNCATE
  C. REMOVE

  ---

  Explanation

• Question 655:

  User-level network policies can be created by which of the following roles? (Select TWO).

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

  ---

  Explanation

• Question 656:

  Data storage for individual tables can be monitored using which commands and/or object(s)? (Choose two)

  A. SHOW TABLES;
  B. SHOW STORAGE BY TABLE;
  C. Information Schema-> TABLE_STORAGE_METRICS
  D. Information Schema-> TASLE_HISTORY
  A. SHOW TABLES;
  C. Information Schema-> TABLE_STORAGE_METRICS

  ---

  Explanation

• Question 657:

  What metadata is stored for each micro-partition? (Choose two.)

  A. The number of distinct values
  B. The clustering key used in the table
  C. The average depth of values for each of the columns
  D. The range of values for each of the columns in the full table
  E. The minimum and maximum values for each of the columns
  A. The number of distinct values
  E. The minimum and maximum values for each of the columns

  ---

  Explanation

• Question 658:

  A Snowflake user wants to unload data from a relational table sized 5 GB using CSV. The extract needs to be as performant as possible.

  What should the user do?

  A. Use Parquet as the unload file format, using Parquet's default compression feature.
  B. Use a regular expression in the stage specification of the COPY command to restrict parsing time.
  C. Increase the default MAX_FILE_SIZE to 5 GB and set SINGLE = true to produce a single file.
  D. Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.
  D. Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.

  ---

  Explanation

• Question 659:

  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
  C. REMOVE

  ---

  Explanation

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

• Question 660:

  Which table function will automatically detect the file metadata schema for a set of staged semi-structured data files, and then retrieve the column definitions?

  A. VALIDATE
  B. INFER_SCHEMA
  C. SPLIT_TO_TABLE
  D. GET_OBJECT_REFERENCES
  B. INFER_SCHEMA

  ---

  Explanation