Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 921:

  What is the MAXIMUM data retention period of transient databases when using the Snowflake Enterprise edition?

  A. 1 day
  B. 7 days
  C. 30 days
  D. 90 days
  A. 1 day

  ---

  Explanation

  In Snowflake Enterprise Edition, the maximum data retention period for transient databases is 1 day.

  Transient databases do not support Time Travel for longer durations because they are designed to minimize storage costs.

  References:

  Snowflake Documentation: Transient Databases

  Snowflake Editions Comparison

• Question 922:

  Which statement is true about running tasks in Snowflake?

  A. A task can be called using a CALL statement to run a set of predefined SQL commands.
  B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
  C. A task allows a user to execute a set of SQL commands on a predefined schedule.
  D. A task can be executed using a SELECT statement to run a predefined SQL command.
  B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

  ---

  Explanation

• Question 923:

  The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?

  A. Medium
  B. Large
  C. 2X-Large
  D. 4X-Large
  C. 2X-Large

  ---

  Explanation

• Question 924:

  How long is the Fail-safe period for recovering historical data from permanent tables?

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

  ---

  Explanation

• Question 925:

  What Snowflake objects can be added to a share? (Choose two.)

  A. Views
  B. Tables
  C. Stored procedures
  D. Streams
  E. Secure views
  B. Tables
  E. Secure views

  ---

  Explanation

• Question 926:

  How is enhanced authentication achieved in Snowflake? (Choose two.)

  A. Snowflake-managed keys
  B. Object level access control
  C. Multi-Factor Authentication (MFA)
  D. Federated authentication and Single Sign-On (SSO)
  D. Federated authentication and Single Sign-On (SSO)

  ---

  Explanation

• Question 927:

  How can a Snowflake user access a JSON object, given the following table? (Choose two.)

  

  A. src:salesperson.name
  B. src:salesPerson.name
  C. src:salesPerson.Name
  D. SRC:salesPerson.name
  E. SRC:salesPerson.Name
  B. src:salesPerson.name
  D. SRC:salesPerson.name

  ---

  Explanation

• Question 928:

  What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

  A. The provisioning of new compute resources for the warehouse will begin immediately.
  B. The warehouse will remain suspended but new resources will be added to the query acceleration service.
  C. The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
  D. The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.
  C. The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

  ---

  Explanation

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

• Question 929:

  Which role can create and manage Snowflake accounts?

  A. SYSADMIN
  B. ACCOUNTADMIN
  C. ORGADMIN
  D. SECURITYADMIN
  C. ORGADMIN

  ---

  Explanation

• Question 930:

  If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?

  A. Decrease the warehouse size.
  B. Decrease the MIN_CLUSTER_COUNT parameter.
  C. Change the multi-cluster settings to add additional clusters.
  D. Start a separate warehouse and move queued queries there.
  D. Start a separate warehouse and move queued queries there.

  ---

  Explanation