Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1451:

  What MINIMUM permissions are required to create a pipe in Snowflake? (Select TWO).

  A. CREATE PIPE at the schema level
  B. SELECT and INSERT on the table in the pipe definition
  C. CREATE SCHEMA at the database level
  D. USAGE on the virtual warehouse
  E. OWNERSHIP on the table in the pipe definition
  A. CREATE PIPE at the schema level
  B. SELECT and INSERT on the table in the pipe definition

  ---

  Explanation

• Question 1452:

  A team is developing a machine learning model by training on the latest Snowflake features. The training is taking much longer than expected to complete.

  Which step will accelerate the model training?

  A. Increase the size of the virtual warehouse.
  B. Add additional clusters to the virtual warehouse.
  C. Use a Snowpark-optimized virtual warehouse.
  D. Enable the query acceleration service.
  A. Increase the size of the virtual warehouse.

  ---

  Explanation

• Question 1453:

  How many days is load history for Snowpipe retained?

  A. 1 day
  B. 7 days
  C. 14 days
  D. 64 days
  C. 14 days

  ---

  Explanation

• Question 1454:

  What is the expiration period for a file URL used to access unstructured data in cloud storage?

  A. The remainder of the session
  B. An unlimited amount of time
  C. The length of time specified in the expiration_time argument
  D. The same length of time as the expiration period for the query results cache
  B. An unlimited amount of time

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/unstructured-intro

• Question 1455:

  Which table function is used to perform additional processing on the results of a previously-run query?

  A. QUERY_HISTORY
  B. RESULT_SCAN
  C. DESCRIBE_RESULTS
  D. QUERY_HISTORY_BY_SESSION
  B. RESULT_SCAN

  ---

  Explanation

• Question 1456:

  Which features make up Snowflake's column level security? (Choose two.)

  A. Continuous Data Protection (CDP)
  B. Dynamic Data Masking
  C. External Tokenization
  D. Key pair authentication
  E. Row access policies
  B. Dynamic Data Masking
  C. External Tokenization

  ---

  Explanation

• Question 1457:

  Which Snowflake multi-cluster virtual warehouse scaling policy or mode will MINIMIZE query queuing by prioritizing the startup of additional clusters?

  A. Economy policy
  B. Standard policy
  C. Auto-scale mode
  D. Maximized mode
  D. Maximized mode

  ---

  Explanation

• Question 1458:

  When loading data into Snowflake, the COPY command supports:

  A. Joins
  B. Fitters
  C. Data type conversions
  D. Column reordering
  E. Aggregates
  C. Data type conversions
  D. Column reordering

  ---

  Explanation

• Question 1459:

  How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

  A. A defined level of access to an object
  B. An entity in which access can be granted
  C. Each object has an owner, who can in turn grail access to that object.
  D. Access privileges are assigned to roles. which are in turn assigned to use's
  C. Each object has an owner, who can in turn grail access to that object.

  ---

  Explanation

• Question 1460:

  If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  A. 4
  B. 16
  C. 32
  D. 128
  A. 4

  ---

  Explanation

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