Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 861:

  Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

  A. Schema Stage

  B. User Stage

  C. Database Stage

  D. Table Stage

  E. External Named Stage

  F. Internal Named Stage

  Correct Answer: BDF

• Question 862:

  A user is preparing to load data from an external stage

  Which practice will provide the MOST efficient loading performance?

  A. Organize files into logical paths

  B. Store the files on the external stage to ensure caching is maintained

  C. Use pattern matching for regular expression execution

  D. Load the data in one large file

  Correct Answer: A

• Question 863:

  How would a user run a multi-cluster warehouse in maximized mode?

  A. Configure the maximum clusters setting to "Maximum."

  B. Turn on the additional clusters manually after starting the warehouse.

  C. Set the minimum Clusters and maximum Clusters settings to the same value.

  D. Set the minimum clusters and maximum clusters settings to different values.

  Correct Answer: C

• Question 864:

  Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

  Which diagram indicates a well-clustered table?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 865:

  What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  A. VIEWS_HISTORY

  B. OBJECT_HISTORY

  C. ACCESS_HISTORY

  D. LOGIN_HISTORY

  Correct Answer: C

• Question 866:

  Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

  A. Management of metadata

  B. Computing the data

  C. Maintaining Availability Zones

  D. Infrastructure security

  E. Parsing and optimizing queries

  Correct Answer: AE

• Question 867:

  What actions will prevent leveraging of the ResultSet cache? (Choose two.)

  A. Removing a column from the query SELECT list

  B. Stopping the virtual warehouse that the query is running against

  C. Clustering of the data used by the query

  D. Executing the RESULTS_SCAN() table function

  E. Changing a column that is not in the cached query

  Correct Answer: AC

• Question 868:

  Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

  B. A Data Exchange allows groups of accounts to share data privately among the accounts.

  C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

  D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

  Correct Answer: BE

• Question 869:

  A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

  A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  Correct Answer: D

• Question 870:

  What happens to historical data when the retention period for an object ends?

  A. The data is cloned into a historical object.

  B. The data moves to Fail-safe

  C. Time Travel on the historical data is dropped.

  D. The object containing the historical data is dropped.

  Correct Answer: D