Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 661:

  Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

  A. SnowSQL
  B. Snowflake Python connector
  C. Snowsight
  D. SnowCD
  A. SnowSQL

  ---

  Explanation

• Question 662:

  True or False the longer the data retention period, the higher the resulting storage costs.

  A. True
  B. False
  A. True

  ---

  Explanation

• Question 663:

  A table, STUDENTS, is created using this command:

  An example value for the marks is:

  Which query will return all of the students' names and history marks?

  A. SELECT NAME, MARKS [0] FROM STUDENTS;
  B. SELECT NAME, MARKS:history FROM STUDENTS;
  C. SELECT NAME, GET (MARKS, 'history') FROM STUDENTS;
  D. SELECT NAME, MARKS: HISTORY FROM STUDENTS;
  C. SELECT NAME, GET (MARKS, 'history') FROM STUDENTS;

  ---

  Explanation

• Question 664:

  Which of the following statements are true of Snowflake data loading? (Choose three)

  A. VARIANT "nut" values are not the same as SQL Null values
  B. It is recommended to do frequent, single row DMLS
  C. It is recommended to validate the data before loading into the Snowflake target table
  D. It is recommended to use staging tables to manage MERGE statements
  A. VARIANT "nut" values are not the same as SQL Null values
  C. It is recommended to validate the data before loading into the Snowflake target table
  D. It is recommended to use staging tables to manage MERGE statements

  ---

  Explanation

• Question 665:

  Which URL type should be used for custom applications that need to access unstructured data files?

  A. Scoped URL
  B. File URL
  C. Pre-signed URL
  D. Relative URL
  C. Pre-signed URL

  ---

  Explanation

• Question 666:

  Which file formats are supported for unloading data from Snowflake? (Choose two.)

  A. Avro
  B. JSON
  C. ORC
  D. XML
  E. Delimited (CSV, TSV, etc.)
  B. JSON
  E. Delimited (CSV, TSV, etc.)

  ---

  Explanation

• Question 667:

  Which command can be used to determine if data from a le has been previously loaded?

  A. COPY_HISTORY
  B. DATA_TRANSFER_HISTORY
  C. WAREHOUSE_LOAD_HISTORY
  D. STAGE_STORAGE_USAGE_HISTORY
  A. COPY_HISTORY

  ---

  Explanation

• Question 668:

  In the Snowflake access control model, which entity owns an object by default?

  A. The user who created the object
  B. The SYSADMIN role
  C. Ownership depends on the type of object
  D. The role used to create the object
  D. The role used to create the object

  ---

  Explanation

• Question 669:

  Snowpark provides libraries for which programming languages? (Choose two.)

  A. JavaScript
  B. Python
  C. Scala
  D. R
  E. C++
  B. Python
  C. Scala

  ---

  Explanation

  Snowpark provide libs for Java Python Scala https://docs.snowflake.com/en/developer-guide/snowpark/index#developer-guides

• Question 670:

  What happens when a cloned table is replicated to a secondary database? (Select TWO)

  A. A read-only copy of the cloned tables is stored.
  B. The replication will not be successful.
  C. The physical data is replicated
  D. Additional costs for storage are charged to a secondary account
  E. Metadata pointers to cloned tables are replicated
  C. The physical data is replicated
  D. Additional costs for storage are charged to a secondary account

  ---

  Explanation

  Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20areandtext=However%2C%20when%20a%20cloned%20table,storage% 20usage%20for% 20your%20account.