Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 211:

  How can a Snowflake user share data with another user who does not have a Snowflake account?

  A. Share the data by implementing User-Defined Functions (UDFs)
  B. Create a reader account and create a share of the data
  C. Grant the READER privilege to the database that is going to be shared
  D. Move the Snowflake account to a region where data sharing is enabled
  B. Create a reader account and create a share of the data

  ---

  Explanation

• Question 212:

  How can a Snowflake user traverse semi-structured data?

  A. Insert a colon (:) between the VARIANT column name and any first-level element.
  B. Insert a colon (:) between the VARIANT column name and any second-level element.
  C. Insert a double colon (::) between the VARIANT column name and any first-level element.
  D. Insert a double colon (::) between the VARIANT column name and any second-level element.
  A. Insert a colon (:) between the VARIANT column name and any first-level element.

  ---

  Explanation

• Question 213:

  Which clause is used to de ne a function that may return different values for different rows?

  A. IMMUTABLE
  B. RETURNS
  C. COMMENT
  D. VOLATILE
  D. VOLATILE

  ---

  Explanation

• Question 214:

  What are characteristics of Snowflake directory fables? (Choose two.)

  A. Directory tables are separate database objects.
  B. Directory tables can only be used with an external stage.
  C. Directory tables contain copies of staged files in binary format.
  D. Directory tables store file-level metadata about the data files in a stage.
  E. A directory table can be added to a stage when the stage is created, or later.
  D. Directory tables store file-level metadata about the data files in a stage.
  E. A directory table can be added to a stage when the stage is created, or later.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-dirtables

• Question 215:

  What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

  A. INITTIALLY_SUSPENDED = TRUE/FALSE
  B. START_AFTCR_CREATE = TRUE/FALSE
  C. START_TTIME = 60 // (seconds from now)
  D. START.TIME = CURRENT.DATE()
  A. INITTIALLY_SUSPENDED = TRUE/FALSE

  ---

  Explanation

• Question 216:

  A single cluster virtual warehouse has no free resources. What will happen to new queries that are run against this warehouse?

  A. The queries will be assigned to another virtual warehouse.
  B. The queries will be skipped.
  C. The queries will be placed in a queue.
  D. The warehouse will automatically resize and execute the queries.
  C. The queries will be placed in a queue.

  ---

  Explanation

• Question 217:

  A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1. What are the considerations for recovering table T1?

  A. The user can recover the table T1 after 30 days.
  B. The table can be recovered because the table retention period default is at the database level.
  C. The table can only be recovered by contacting Snowflake Support to recover the table from Fail-safe.
  D. The table cannot be recovered because the DATA_RETENTION_TIME_IN_DAYS was not set for table T1.
  B. The table can be recovered because the table retention period default is at the database level.

  ---

  Explanation

• Question 218:

  A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.

  

  What action should be taken to address this situation?

  A. Increase the warehouse size from Medium to 2XL.
  B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  C. Configure the warehouse to a multi-cluster warehouse.
  D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
  C. Configure the warehouse to a multi-cluster warehouse.

  ---

  Explanation

• Question 219:

  Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?

  A. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
  B. Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user
  C. Can SHOW users, INDEX a given user, or ALTER or DELETE a user
  D. Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user
  A. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user

  ---

  Explanation

• Question 220:

  Which command should be used to unload all the rows from a table into one or more files in a named stage?

  A. COPY INTO
  B. GET
  C. INSERT INTO
  D. PUT
  A. COPY INTO

  ---

  Explanation