Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 761:

  What is the order of precedence (highest to lowest) of network policies when applied at the account, user, and security integrations layers?

  A. Account, user, security integration
  B. Account, security integration, user
  C. User, security integration, account
  D. User, account, security integration
  C. User, security integration, account

  ---

  Explanation

• Question 762:

  Select the three types of tables that exist within Snowflake. (Choose three)

  A. Temporary
  B. Transient
  C. Provisioned
  D. Permanent
  A. Temporary
  B. Transient
  D. Permanent

  ---

  Explanation

  https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 763:

  To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  A. Configure the Maximum Clusters setting to "Auto-Scale"
  B. Set the Warehouse type to "Auto"
  C. Set the Minimum Clusters and Maximum Clusters settings to the same value
  D. Set the Minimum Clusters and Maximum Clusters settings to the different values
  D. Set the Minimum Clusters and Maximum Clusters settings to the different values

  ---

  Explanation

  https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

• Question 764:

  What is a characteristic of a tag associated with a masking policy?

  A. A tag can be dropped after a masking policy is assigned.
  B. A tag can have only one masking policy for each data type.
  C. A tag can have multiple masking policies for each data type.
  D. A tag can have multiple masking policies with varying data types.
  B. A tag can have only one masking policy for each data type.

  ---

  Explanation

• Question 765:

  Which URL type should be used to provide a user with a window of time to access files that are in cloud storage?

  A. Scoped URL
  B. File URL
  C. Pre-signed URL
  D. Redirect URL
  C. Pre-signed URL

  ---

  Explanation

• Question 766:

  How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column, ID_NUMBER?

  A. TRUNC(ID_NUMBER, -6)
  B. TRUNC(ID_NUMBER, 5)
  C. ID_NUMBER*100
  D. TO_CHAR(ID_NUMBER)
  A. TRUNC(ID_NUMBER, -6)

  ---

  Explanation

• Question 767:

  The COPY INTO command can unload data from a table directly into which locations? (Choose two.)

  A. A named internal stage
  B. A Snowpipe REST endpoint
  C. A network share on a client machine
  D. A local directory or folder on a client machine
  E. A named external stage that references an external cloud location
  A. A named internal stage
  E. A named external stage that references an external cloud location

  ---

  Explanation

  Copy into is possible for 1) Named internal stage (or table/user stage). 2) Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). 3) External location https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

• Question 768:

  What is the recommended way to insert a VARIANT value into a Snowflake table?

  A. Use a SELECT statement to convert data to a VARIANT data type before inserting it.
  B. Use the TO_VARIANT function in the INSERT statement.
  C. Cast the data to a VARIANT data type within the INSERT statement.
  D. Use a subquery to convert the data to a VARIANT data type and then insert it.
  B. Use the TO_VARIANT function in the INSERT statement.

  ---

  Explanation

• Question 769:

  What are the benefits of the replication feature in Snowflake? (Choose two.)

  A. Disaster recovery
  B. Time Travel
  C. Fail-safe
  D. Database failover and failback
  E. Data security
  A. Disaster recovery
  D. Database failover and failback

  ---

  Explanation

• Question 770:

  Authorization to execute CREATE