Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 201:

  Which column in the ACCESS_HISTORY view in Snowflake describes access history for a column and provides additional information on how columns have been altered over time?

  A. direct_objects_accessed
  B. objects_modified
  C. object_modified_by_dd1
  D. base_objects_accessed
  B. objects_modified

  ---

  Explanation

• Question 202:

  Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

  A. OAuth
  B. Network policies
  C. Single Sign-On (SSO)
  D. Multi-Factor Authentication (MFA)
  D. Multi-Factor Authentication (MFA)

  ---

  Explanation

• Question 203:

  Which tool or service can be used to graphically explore and manage data stored within a Snowflake account, including databases, tables, and views?

  A. SnowSQL
  B. Snowsight
  C. Snowflake virtual warehouses
  D. SnowCD
  B. Snowsight

  ---

  Explanation

• Question 204:

  When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

  A. There are multiple SQL UDFs with the same names and the same number of arguments.
  B. There are multiple SQL UDFs with the same names and the same number of argument types.
  C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
  D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.
  C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

  ---

  Explanation

• Question 205:

  A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.

  According to best practice, what should the Snowflake user do? (Choose two.)

  A. Provide each non-Snowflake supplier with their own reader account.
  B. Deploy a single reader account to be shared by all of the non-Snowflake suppliers.
  C. Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.
  D. Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
  E. Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.
  A. Provide each non-Snowflake supplier with their own reader account.
  D. Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.

  ---

  Explanation

• Question 206:

  What is the MAXIMUM size limit for a record of a VARIANT data type?

  A. 8 MB
  B. 16 MB
  C. 32 MB
  D. 128 MB
  B. 16 MB

  ---

  Explanation

• Question 207:

  Which role allows a SnowFlake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by the default?

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

  ---

  Explanation

• Question 208:

  Which of the following statement is true of Snowflake?

  A. It was built specifically for the cloud
  B. it was built as an on-premises solution and then potted to the cloud
  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  D. It was built for Hadoop architecture
  E. It's based on an Oracle Architecture
  A. It was built specifically for the cloud

  ---

  Explanation

• Question 209:

  Which statements are true of micro-partitions? (Choose two)

  A. They are approximately 16MB in size
  B. They are stored compressed only if COMPRESS=TRUE on Table
  C. They are Immutable
  D. They are only encrypted in the Enterprise edition and above
  A. They are approximately 16MB in size
  C. They are Immutable

  ---

  Explanation

  https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

• Question 210:

  Which setting will help control credit consumption for a virtual warehouse that needs to run in Auto-scale mode?

  A. Set the warehouse scaling policy to Economy.
  B. Set the MIN_CLUSTER_COUNT to 1.
  C. Set the AUTO_SUSPEND property of the warehouse to 0.
  D. Set the MIN_CLUSTER_COUNT to 2 and set the MAX_CLUSTER_COUNT to 2.
  B. Set the MIN_CLUSTER_COUNT to 1.

  ---

  Explanation