Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1391:

  Which of the following are best practices for loading data into Snowflake? (Choose three.)

  A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
  B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
  C. Enclose fields that contain delimiter characters in single or double quotes.
  D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
  E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
  F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
  A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
  C. Enclose fields that contain delimiter characters in single or double quotes.
  D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

  ---

  Explanation

• Question 1392:

  The FLATEEN function is used to query which type of data in Snowflake?

  A. Structured data
  B. Semi-structured data
  C. Both of the above
  D. None of the above
  B. Semi-structured data

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/querying-semistructured.html

  FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.

• Question 1393:

  In which hierarchy is tag inheritance possible?

  A. Organization » Account » Role
  B. Account » User » Schema
  C. Database » View » Column
  D. Schema » Table » Column
  D. Schema » Table » Column

  ---

  Explanation

• Question 1394:

  Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)

  A. MULTI_STATEMENT_COUNT
  B. ENABLE_QUERY_ACCELERATION
  C. STATEMENT_TIMEOUT_IN_SECONDS
  D. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  E. QUERY_ACCELERATION_MAX_SCALE_FACTOR
  B. ENABLE_QUERY_ACCELERATION
  E. QUERY_ACCELERATION_MAX_SCALE_FACTOR

  ---

  Explanation

• Question 1395:

  What does Snowflake recommend regarding database object ownership? (Choose two.)

  A. Create objects with ACCOUNTADMIN and do not reassign ownership.
  B. Create objects with SYSADMIN.
  C. Create objects with SECURITYADMIN to ease granting of privileges later.
  D. Create objects with a custom role and grant this role to SYSADMIN.
  E. Use only managed access schemas for objects owned by ACCOUNTADMIN.
  B. Create objects with SYSADMIN.
  D. Create objects with a custom role and grant this role to SYSADMIN.

  ---

  Explanation

• Question 1396:

  Which table function will return the output of a previously-run command?

  A. FLATTEN
  B. QUERY_HISTORY
  C. TASKHISTORY
  D. RESULT_SCAN
  D. RESULT_SCAN

  ---

  Explanation

  The RESULT_SCAN function returns the output of a previously executed query by referencing its query ID.

  Example:

  SELECT * FROM RESULT_SCAN('query_id');

  Other functions like QUERY_HISTORY or TASK_HISTORY provide metadata about queries but do not return query results.

  References:

  Snowflake Documentation: RESULT_SCAN Function

• Question 1397:

  Where is metadata management handled in Snowflake?

  A. Cloud Services
  B. Compute
  C. Database Storage
  D. Query Processing
  A. Cloud Services

  ---

  Explanation

  Snowflake separates its architecture into three distinct layers: Cloud Services, Compute, and Storage.

  Metadata management (e.g., table structures, query history, access control) is handled by the Cloud Services layer.

  The Cloud Services layer provides:

  References:

  Snowflake Documentation: Architecture Overview

  Snowflake Metadata Management

• Question 1398:

  When an ACCOUNTADMIN gives a user a custom role, what privilege or privileges is the user granted by default?

  A. All privileges that have been granted to the ACCOUNTADMIN
  B. All privileges on objects allowed by the custom role
  C. Access to the PUBLIC role
  D. Access to all the objects owned by the USERADMIN role
  C. Access to the PUBLIC role

  ---

  Explanation

• Question 1399:

  A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).

  A. RECORD_TIMESTAMP
  B. RECORD_CONTENT
  C. RECORDKEY
  D. RECORD_SESSION
  E. RECORD_METADATA
  A. RECORD_TIMESTAMP
  C. RECORDKEY

  ---

  Explanation

  When using the Snowflake Kafka connector, the table schema includes two important variant columns:

  RECORD_TIMESTAMP: This column stores the timestamp from the Kafka record, enabling time-based analysis of incoming data.

  RECORDKEY: This captures the unique key of each Kafka message, useful for uniquely identifying records or managing deduplication. These columns ensure that each message's metadata and key information are preserved, facilitating

  data analysis and real-time processing tasks in Snowflake.

• Question 1400:

  Which constraint type is enforced in Snowflake from the ANSI SQL standard?

  A. UNIQUE
  B. PRIMARY KEY
  C. FOREIGN KEY
  D. NOT NULL
  D. NOT NULL

  ---

  Explanation