Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1061:

  A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

  How can this be achieved?

  A. Flatten the data and store it in structured data types in a flattened table. Query the table.
  B. Store the data in a table with a VARIANT data type. Query the table.
  C. Store the data in a table with a VARIANT data type and include STRIP_NULL_VALUES while loading the table. Query the table.
  D. Store the data in an external stage and create views on top of it. Query the views.
  A. Flatten the data and store it in structured data types in a flattened table. Query the table.

  ---

  Explanation

• Question 1062:

  Which views are included in the DATA_SHARING_USAGE schema?

  A. ACCESS_HISTORY
  B. DATA_TRANSFER_HISTORY
  C. WAREHOUSE_METERING_HISTORY
  D. MONETIZED_USAGE_DAILY
  E. LISTING_TELEMETRY_DAILY
  D. MONETIZED_USAGE_DAILY
  E. LISTING_TELEMETRY_DAILY

  ---

  Explanation

• Question 1063:

  While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL
  B. GET_ABSOLUTE_PATH
  C. BUILD_SCOPED_FILE_URL
  D. GET_PRESIGNED_URL
  A. BUILD_STAGE_FILE_URL

  ---

  Explanation

• Question 1064:

  Account-level storage usage can be monitored via:

  A. The snowflake wet Interface (UI) in the Databases section.
  B. The Snowflake web interface (UI) in the Account-> Billing a usage section
  C. The Information Schema-> ACCOUNT_USAGE_HISTORY View
  D. The Account usage Schema-> ACCOUNT_USAGE_METRICS View
  B. The Snowflake web interface (UI) in the Account-> Billing a usage section

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/admin-usage-billing.html

• Question 1065:

  How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

  A. Configure the warehouse to a size larger than generally required
  B. Set the minimum and maximum clusters to autoscale
  C. Use the standard warehouse scaling policy
  D. Use the economy warehouse scaling policy
  C. Use the standard warehouse scaling policy

  ---

  Explanation

• Question 1066:

  Which view can be used to determine if a table has frequent row updates or deletes?

  A. TABLES
  B. TABLE_STORAGE_METRICS
  C. STORAGE_DAILY_HISTORY
  D. STORAGE_USAGE
  B. TABLE_STORAGE_METRICS

  ---

  Explanation

• Question 1067:

  What can the Snowflake SCIM API be used to manage? (Choose two.)

  A. Integrations
  B. Network policies
  C. Session policies
  D. Roles
  E. Users
  D. Roles
  E. Users

  ---

  Explanation

• Question 1068:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management
  B. Metadata management
  C. Query execution
  D. Query parsing and optimization
  E. Permanent storage of micro-partitions
  C. Query execution

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20required,rows%20from%20tables% 20and%20views)

• Question 1069:

  What privilege is required to view the load statistics on a virtual warehouse?

  A. MODIFY
  B. OPERATE
  C. MONITOR
  D. USAGE
  C. MONITOR

  ---

  Explanation

• Question 1070:

  How does Snowflake use Multi-Factor Authentication (MFA)?

  A. MFA is an integrated feature powered by the Duo Security service.
  B. MFA is enabled by default for any user having the ACCOUNTADMIN role.
  C. An MFA login is designed to log in to Snowflake only through Snowsight.
  D. MFA is enabled by default for each user and does not require activation.
  A. MFA is an integrated feature powered by the Duo Security service.

  ---

  Explanation