Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1181:

  When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

  A. 1 hour
  B. 2 hours
  C. 4 hours
  D. 8 hours
  C. 4 hours

  ---

  Explanation

• Question 1182:

  What happens when the size of a virtual warehouse is changed?

  A. Queries that are running on the current warehouse configuration are not impacted.
  B. Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.
  C. Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.
  D. Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.
  A. Queries that are running on the current warehouse configuration are not impacted.

  ---

  Explanation

• Question 1183:

  Which statement is true about Multi-Factor Authentication (MFA) in Snowflake?

  A. MFA can be enforced or applied for a given role.
  B. Snowflake users are automatically enrolled in MFA.
  C. Users enroll in MFA by submitting a request to Snowflake Support.
  D. MFA is an integrated Snowflake feature.
  D. MFA is an integrated Snowflake feature.

  ---

  Explanation

• Question 1184:

  A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

  How does Snowflake recommend maximizing the load performance?

  A. Use auto-ingest Snowpipes to load large files in a serverless model.
  B. Produce the largest files possible, reducing the overall number of files to process.
  C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
  D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
  C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

  ---

  Explanation

• Question 1185:

  How should a Snowflake use configure a virtual warehouse to be in Maximized mode?

  A. Set the WAREHOUSES_SIZE to 6XL.
  B. Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.
  C. Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.
  D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.
  D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

  ---

  Explanation

  In Snowflake, configuring a virtual warehouse to be in a "Maximized" mode implies maximizing the resources allocated to the warehouse for its duration. This is done to ensure that the warehouse has a consistent amount of compute resources available, enhancing performance for workloads that require a high level of parallel processing or for handling high query volumes. To configure a virtual warehouse in maximized mode, you should set the same value for bothMIN_CLUSTER_COUNTandMAX_CLUSTER_COUNT. This configuration ensures that the warehouse operates with a fixed number of clusters, thereby providing a stable and maximized level of compute resources. Reference to Snowflake documentation on warehouse sizing and scaling: Warehouse Sizing and Scaling Understanding Warehouses

• Question 1186:

  What is the relationship between a Query Profile and a virtual warehouse?

  A. A Query Profile can help users right-size virtual warehouses.
  B. A Query Profile defines the hardware specifications of the virtual warehouse.
  C. A Query Profile can help determine the number of virtual warehouses available.
  D. A Query Profile automatically scales the virtual warehouse based on the query complexity.
  A. A Query Profile can help users right-size virtual warehouses.

  ---

  Explanation

• Question 1187:

  How should the SPLIT_TO_TABLE (, ) function be called?

  A. SELECT SPLIT_TO_TABLE (COL1, *.') FROM DUAL;
  B. SELECT SPLIT_TO_TABLE ( 'a.b.C' , '.');
  C. SELECT * FROM TABLE>;
  D. SELECT * FROM SPLIT TO TABLE (*a.b.C', *.')/
  B. SELECT SPLIT_TO_TABLE ( 'a.b.C' , '.');

  ---

  Explanation

  The SPLIT_TO_TABLE function splits a string into multiple rows based on the specified delimiter.

  The correct syntax for using this function is:

  SELECT SPLIT_TO_TABLE('string', 'delimiter');

  Example:

  SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.')); This will output each substring (a, b, and c) as a separate row.

  References:

  Snowflake Documentation: SPLIT_TO_TABLE Function

• Question 1188:

  What should be considered when deciding to use a Secure View? (Choose two.)

  A. No details of the query execution plan will be available in the query profiler.
  B. Once created there is no way to determine if a view is secure or not.
  C. Secure views do not take advantage of the same internal optimizations as standard views.
  D. It is not possible to create secure materialized views.
  E. The view definition of a secure view is still visible to users by way of the information schema.
  A. No details of the query execution plan will be available in the query profiler.
  C. Secure views do not take advantage of the same internal optimizations as standard views.

  ---

  Explanation

• Question 1189:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management
  B. Metadata management
  C. Query execution
  D. Query parsing and optimization
  E. Management of the storage layer
  C. Query execution

  ---

  Explanation

• Question 1190:

  Which Snowflow object does not consume and storage costs?

  A. Secure view
  B. Materialized view
  C. Temporary table
  D. Transient table
  C. Temporary table

  ---

  Explanation