Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1171:

  A company needs to share sales data with multiple marketing agency partners. Which Snowflake data share mechanism is recommended for this use case?

  A. A shared Amazon S3 bucket
  B. Direct share
  C. A reader account
  D. Data Exchange
  C. A reader account

  ---

  Explanation

• Question 1172:

  What situation is likely to cause data spillage when a query is run?

  A. When the query contains multiple filters and no data is returned.
  B. When a virtual warehouse runs out of memory while executing the query.
  C. When the number of queries exceeds the max_concurrency_level parameter setting.
  D. When running queries that exceed the statement_timecut_in_seccnds parameter setting.
  B. When a virtual warehouse runs out of memory while executing the query.

  ---

  Explanation

• Question 1173:

  What command is used to export or unload data from Snowflake?

  A. PUT @mystage
  B. GET @mystage
  C. Copy INTO @mystage
  D. INSERT @mystage
  C. Copy INTO @mystage

  ---

  Explanation

• Question 1174:

  The number of queries that a Virtual Warehouse can concurrently process is determined by:

  A. The complexity of each query
  B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
  C. The size of the data required for each query
  D. The tool that s executing the query
  A. The complexity of each query
  C. The size of the data required for each query

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 1175:

  What notation methods are supported in Snowflake to access elements in a JSON object? (Select TWO).

  A. Classless Inter-Domain Routing (CIDR) notation
  B. Vertical bar notation
  C. Bracket notation
  D. Slash notation
  E. Dot notation
  C. Bracket notation
  E. Dot notation

  ---

  Explanation

• Question 1176:

  Which function will provide the proxy information needed to protect Snowsight?

  A. SYSTEM$GET_TAG
  B. SYSTEM$GET_PRIVATELINK
  C. SYSTEM$ALLOWLIST
  D. SYSTEM$AUTHORIZE_PRIVATELINK
  C. SYSTEM$ALLOWLIST

  ---

  Explanation

  To determine the fully qualified URL and port for Snowsight, review the SNOWSIGHT_DEPLOYMENT entry in the return value of the SYSTEM$ALLOWLIST function. https://docs.snowflake.com/en/user-guide/ui-snowsight-gs#accessing-sf-web-interface-through-a-proxy-or-firewall

• Question 1177:

  Which action will scale-out a Snowflake virtual warehouse?

  A. Removing 1 cluster from a multi-cluster warehouse
  B. Adding 2 additional clusters to a multi-cluster warehouse
  C. Resizing a warehouse from size Small to X-Large
  D. Resizing a warehouse from size Large to Medium
  B. Adding 2 additional clusters to a multi-cluster warehouse

  ---

  Explanation

• Question 1178:

  A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 24-hour mark?

  A. The file will continue to load until all contents arc loaded.
  B. The tile will slop loading and all data up to that point will be committed.
  C. The file loading could be aborted without any portion of the file being committed.
  D. The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake
  C. The file loading could be aborted without any portion of the file being committed.

  ---

  Explanation

• Question 1179:

  A Snowflake user has a query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk.

  What is causing this to happen?

  A. The result cache is almost full and is unable to hold the results.
  B. The cloud storage staging area is not sufficient to hold the data results.
  C. Clustering has not been applied to the table so the table is not optimized.
  D. The warehouse memory is not sufficient to hold the intermediate query results.
  D. The warehouse memory is not sufficient to hold the intermediate query results.

  ---

  Explanation

• Question 1180:

  Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

  A. Tags
  B. Comments
  C. Internal tokenization
  D. Row access policies
  A. Tags

  ---

  Explanation