Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1611:

  How can network and private connectivity security be managed in Snowflake?

  A. By setting up network policies with IPv4 IP addresses
  B. By putting the Snowflake URL on the allowed list for get method responses
  C. By manually setting up vulnerability patch management policies
  D. By manually setting up an Intrusion Prevention System (IPS) on each account
  A. By setting up network policies with IPv4 IP addresses

  ---

  Explanation

• Question 1612:

  What affects whether the query results cache can be used?

  A. If the query contains a deterministic function
  B. If the virtual warehouse has been suspended
  C. If the referenced data in the table has changed
  D. If multiple users are using the same virtual warehouse
  C. If the referenced data in the table has changed

  ---

  Explanation

• Question 1613:

  What Snowflake objects can contain custom application logic written in JavaScript? (Choose two.)

  A. Stored procedures
  B. Stages
  C. Tasks
  D. Views
  E. User-Defined Functions (UDFs)
  A. Stored procedures
  E. User-Defined Functions (UDFs)

  ---

  Explanation

• Question 1614:

  What is the default authenticator while using the JDBC driver connection in Snow ake?

  A. externalbrowser
  B. snowlake
  C. username_password_mfa
  D. snow ake_jwt
  B. snowlake

  ---

  Explanation

• Question 1615:

  The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

  A. In the metadata of the target table for 14 days
  B. In the metadata of the pipe for 14 days
  C. In the metadata of the target table for 64 days
  D. In the metadata of the pipe for 64 days
  C. In the metadata of the target table for 64 days

  ---

  Explanation

• Question 1616:

  Which command allows for continuous loading of data files as soon as they are available in a stage?

  A. COPY INTO [table]
  B. PUT
  C. CREATE PIPE
  D. GET
  C. CREATE PIPE

  ---

  Explanation

• Question 1617:

  The use of which technique or tool will improve Snowflake query performance on very large tables?

  A. Indexing
  B. Clustering keys
  C. Multi-clustering
  D. Materialized views
  B. Clustering keys

  ---

  Explanation

• Question 1618:

  Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

  A. Secure functions
  B. Secure views
  C. Object tagging
  D. Row-level security
  C. Object tagging

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/object-tagging

• Question 1619:

  Which stream type can be used for tracking the records in external tables?

  A. Append-only
  B. External
  C. Insert-only
  D. Standard
  B. External

  ---

  Explanation

• Question 1620:

  Which of the following is true of Snowpipe via REST API? (Choose two)

  A. you can only use it on internal Stages
  B. All COPY INTO options are available fluting pipe creation
  C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
  D. Snowpipe keeps track of which files it has loaded
  C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
  D. Snowpipe keeps track of which files it has loaded

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes