Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 531:

  Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

  A. Authy
  B. Duo Security
  C. One Login
  D. RSA SecurID Access
  B. Duo Security

  ---

  Explanation

• Question 532:

  Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

  A. The number of queries executed
  B. The number of active users assigned to the warehouse
  C. The size of the virtual warehouse
  D. The length of time the warehouse is running
  E. The duration of the queries that are executed
  C. The size of the virtual warehouse
  D. The length of time the warehouse is running

  ---

  Explanation

• Question 533:

  Which Snowflake technique can be used to improve the performance of a query?

  A. Clustering
  B. Indexing
  C. Fragmenting
  D. Using INDEX__HINTS
  A. Clustering

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 534:

  How does Snowflake enable OAuth?

  A. By creating an external integration
  B. By configuring a security integration
  C. By establishing IP allowed lists and IP blocked lists
  D. By using SnowSQL to enable an external OAuth using the Snowflake protocol
  B. By configuring a security integration

  ---

  Explanation

  Administrators configure OAuth using a Security integration, which enables clients that support OAuth to redirect users to an authorization page and generate access tokens (and optionally, refresh tokens) for accessing Snowflake.

• Question 535:

  Which object can be used to query the data loading history for the last 365 days for a Snowflake account?

  A. The SNOWFLAKE.ACCOUNT_USAGE.COPY_HISTORY view
  B. The SNOWFLAKE.ACCOUNT_USAGE.DATA_TRANSFER_HISTORY view
  C. The database INFORMATION_SCHEMA.COPY_HISTORY table function
  D. The database INFORMATION_SCHEMA.DATA_TRANSFER_HISTORY table function
  A. The SNOWFLAKE.ACCOUNT_USAGE.COPY_HISTORY view

  ---

  Explanation

• Question 536:

  Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).

  A. Synchronization
  B. Remote disk IO
  C. Local disk IO
  D. Pruning
  E. Spillage
  B. Remote disk IO
  D. Pruning

  ---

  Explanation

  Two key metrics in Snowflake's Query Profile that provide insights for performance improvement are:

  Remote Disk IO: This measures the time the query spends waiting on remote disk access, indicating potential performance issues related to I/O bottlenecks. Pruning: This metric reflects how effectively Snowflake's micro-partition pruning is

  reducing the data scanned. Better pruning (more partitions excluded) leads to faster query performance, as fewer micro-partitions need to be processed. These metrics are essential for identifying and addressing inefficiencies in data retrieval

  and storage access, optimizing overall query performance.

• Question 537:

  Which property or parameter can be used to temporarily disable Multi-Factor Authentication (MFA) for a Snowflake user?

  A. DISABLE_MFA
  B. EXT_AUTHN_DUO
  C. MINS_TO_BYPASS_MFA
  D. ALLOW_CLIENT_MFA_CACHING
  C. MINS_TO_BYPASS_MFA

  ---

  Explanation

  The MINS_TO_BYPASS_MFA property can temporarily disable Multi-Factor Authentication (MFA) for a user, allowing them to log in without providing an MFA code for a specific duration (in minutes).

  Example:

  ALTER USER my_user SET MINS_TO_BYPASS_MFA = 10;

  References:

  Snowflake Documentation: Multi-Factor Authentication

• Question 538:

  Which stage type can not be altered and dropped?

  A. Database stage
  B. External stage
  C. Table stage
  D. User stage
  B. External stage

  ---

  Explanation

• Question 539:

  Which command is used to unload data from a Snowflake table into a Snowflake stage?

  A. GET
  B. CREATE STAGE
  C. COPY INTO
  D. PUT
  C. COPY INTO

  ---

  Explanation

• Question 540:

  Which object consumes Snowflake credits for its maintenance?

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

  ---

  Explanation