Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1511:

  What is cached during a query on a virtual warehouse?

  A. All columns in a micro-partition
  B. Any columns accessed during the query
  C. The columns in the result set of the query
  D. All rows accessed during the query
  B. Any columns accessed during the query

  ---

  Explanation

• Question 1512:

  What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  A. Reader
  B. Consumer
  C. Vendor
  D. Standard
  E. Personalized
  D. Standard
  E. Personalized

  ---

  Explanation

• Question 1513:

  Which command is used to take away staged files from a Snowflake stage after a successful data ingestion?

  A. DELETE
  B. DROP
  C. REMOVE
  D. TRUNCATE
  C. REMOVE

  ---

  Explanation

• Question 1514:

  When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

  A. True
  B. false:
  B. false:

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-snowflake.html

• Question 1515:

  What data type is used to ingest semi-structured data into a Snowflake table?

  A. BOOLEAN
  B. NUMBER
  C. VARBINARY
  D. VARIANT
  D. VARIANT

  ---

  Explanation

• Question 1516:

  Use of what parameter will allow files to be loaded even if the le metadata has expired?

  A. MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
  B. ENFORCE_LENGTH = TRUE
  C. PURGE = TRUE
  D. LOAD_UNCERTAIN_FILES = TRUE
  D. LOAD_UNCERTAIN_FILES = TRUE

  ---

  Explanation

• Question 1517:

  Data Providers can share data with only the Data Consumer.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 1518:

  How does Snowflake store a table's underlying data? (Choose two.)

  A. Columnar file format
  B. Micro-partitions
  C. Text file format
  D. Uncompressed
  E. User-defined partitions
  A. Columnar file format
  B. Micro-partitions

  ---

  Explanation

• Question 1519:

  Snowflake best practice recommends that which role be used to enforce a network policy on a Snowflake account?

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

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/create-network-policy

• Question 1520:

  What is the recommended method for loading data into Snowflake?

  A. Load row by row
  B. Load data in batch
  C. Load data by writing it In the Snowflake Web Interface (UI)
  D. Load data via frequent, angle row DML's
  B. Load data in batch

  ---

  Explanation