Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1021:

  Which object allows you to limit the number of credits consumed within a Snowflake account?

  A. Account usage Tracking
  B. Resource Monitor
  C. Warehouse Limit Parameter
  D. Credit Consumption Tracker
  B. Resource Monitor

  ---

  Explanation

  The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

• Question 1022:

  What type of authentication is recommended when creating a Snowflake service account that will connect to a third-party application?

  A. Username and password
  B. Key-pair authentication
  C. Multi-Factor Authentication (MFA)
  D. Single Sign-on (SSO)
  B. Key-pair authentication

  ---

  Explanation

• Question 1023:

  Micro-partition metadata enables some operations to be completed without requiring Compute.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://blog.ippon.tech/innovative-snowflake-features-caching/

• Question 1024:

  Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

  A. Directory table
  B. Temporary table
  C. Transient table
  D. A table with a materialized view
  A. Directory table

  ---

  Explanation

• Question 1025:

  Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

  A. An FTP server with TLS encryption
  B. An HTTPS server with WebDAV
  C. A Google Cloud storage bucket
  D. A Windows server file share on Azure
  C. A Google Cloud storage bucket

  ---

  Explanation

• Question 1026:

  Which data types optimally store semi-structured data? (Choose two.)

  A. ARRAY
  B. CHARACTER
  C. STRING
  D. VARCHAR
  E. VARIANT
  A. ARRAY
  E. VARIANT

  ---

  Explanation

• Question 1027:

  Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

  A. Access history
  B. Data classification
  C. Dynamic Data Masking
  D. Object tagging
  A. Access history

  ---

  Explanation

• Question 1028:

  What is the purpose of enabling Federated Authentication on a Snowflake account?

  A. Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting
  B. Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake
  C. Forces users to connect through a secure network proxy
  D. Allows users to connect using secure single sign-on (SSO) through an external identity provider
  D. Allows users to connect using secure single sign-on (SSO) through an external identity provider

  ---

  Explanation

• Question 1029:

  When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

  According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  A. Use multi-clustered warehousing to scale out warehouse capacity.
  B. Scale up the warehouse size to allow Queries to execute faster.
  C. Stop and start the warehouse to clear the queued queries
  D. Migrate some queries to a new warehouse to reduce load
  E. Limit user access to the warehouse so fewer queries are run against it.
  A. Use multi-clustered warehousing to scale out warehouse capacity.
  D. Migrate some queries to a new warehouse to reduce load

  ---

  Explanation

• Question 1030:

  What does a Notify and Suspend action for a resource monitor do?

  A. Send an alert notification to all account users who have notifications enabled.
  B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
  C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
  D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
  C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

  ---

  Explanation