Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 231:

  Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

  A. Database
  B. Tables
  C. Warehouses
  D. Worksheets
  A. Database
  C. Warehouses
  D. Worksheets

  ---

  Explanation

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

• Question 232:

  Which statements describe benefits of Snowflake's separation of compute and storage?(Select TWO).

  A. The separation allows independent scaling of computing resources.
  B. The separation ensures consistent data encryption across all virtual data warehouses.
  C. The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
  D. Storage volume growth and compute usage growth can be tightly coupled.
  E. Compote can be scaled up or down without the requirement to add more storage.
  A. The separation allows independent scaling of computing resources.
  E. Compote can be scaled up or down without the requirement to add more storage.

  ---

  Explanation

• Question 233:

  Which feature is only available in the Enterprise or higher editions of Snowflake?

  A. Column-level security
  B. SOC 2 type II certification
  C. Multi-factor Authentication (MFA)
  D. Object-level access control
  A. Column-level security

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 234:

  The CUSTOMER table in the T1 database is accidentally dropped. Which privileges are required to restore this table? (Choose two.)

  A. SELECT privilege on the CUSTOMER table
  B. OWNERSHIP privilege on the CUSTOMER table
  C. All privileges on the CUSTOMER table
  D. All privileges on the T1 database
  E. CREATE TABLE privilege on the T1 database
  B. OWNERSHIP privilege on the CUSTOMER table

  ---

  Explanation

• Question 235:

  A Snowflake user is investigating a slow-running query using the Query Profile. Which metric would be a reason to increase the size of the virtual warehouse?

  A. Percentage Scanned from Cache: 81.22%
  B. Processing: 51.8%
  C. Remote Disk I/O: 40.6%
  D. Bytes Scanned: 3.24 GB
  B. Processing: 51.8%

  ---

  Explanation

• Question 236:

  A Snowflake user is querying JSON data and all values in the result set are wrapped in quotes. Which step will unwrap the data from all the columns in the query results?

  A. Use the TRIM function to remove the quotes.
  B. Use the INSTR function to remove the quotes.
  C. Use the SUBSTRING function to select the values that are inside the quotes.
  D. Use the CAST function to convert the columns to the correct data type.
  D. Use the CAST function to convert the columns to the correct data type.

  ---

  Explanation

  When querying VARIANT columns (such as JSON), the values are often returned as strings . To convert them to usable SQL types, users must apply the CAST() function (e.g., CAST(column:value AS NUMBER)).

  Snowflake Docs: Querying Semi-Structured Data

• Question 237:

  What type of queries will benefit from the search optimization service when using equality predicates?

  A. Queries using point-lookups
  B. Queries using data substrings
  C. Queries with geospatial data
  D. Queries of semi-structured data
  A. Queries using point-lookups

  ---

  Explanation

• Question 238:

  Which command should be used to generate a single file when unloading data from a Snowflake table into a file?

  A. PARTITION BY
  B. MAX_FILE_SIZE = 0
  C. SINGLE = TRUE
  D. OVERWRITE = TRUE
  C. SINGLE = TRUE

  ---

  Explanation

• Question 239:

  What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

  A. Stream
  B. Task
  C. Storage integration
  D. Named file format
  D. Named file format

  ---

  Explanation

  A Named File Format is a reusable object in Snowflake that defines file format options for loading and unloading data. When unloading similarly formatted data regularly, using a named file format saves time and ensures consistency.

  Example:

  sql

  CopyEdit

  CREATE FILE FORMAT my_format

  TYPE = CSV

  FIELD_OPTIONALLY_ENCLOSED_BY = '"';

  COPY INTO @my_stage/data.csv

  FROM my_table

  FILE_FORMAT = my_format;

  Why Other Options Are Incorrect:

  A. Stream: Used for change tracking in tables, not for unloading data.

  B. Task: Used for scheduling actions, not for defining file formats.

  C. Storage Integration: Used to connect to cloud storage securely, unrelated to unloading file formats.

  References:

  File Formats Documentation

• Question 240:

  Which URL type permits temporary access to a staged file without granting privileges to the stage?

  A. GET_PRESIGNED_URL
  B. BUILD_SCOPED_FILE_URL
  C. BUILD_STAGE_FILE_URL
  D. GET_STAGE_LOCATION
  A. GET_PRESIGNED_URL

  ---

  Explanation