Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 371:

  Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

  A. C0PY_INT0 command
  B. Data replication
  C. Snowpipe
  D. Direct share
  C. Snowpipe

  ---

  Explanation

  Snowpipe is Snowflake's continuous data ingestion service that loads data from cloud storage (e.g., S3, Azure Blob, Google Cloud Storage) into Snowflake as soon as the files become available in a stage.

  Snowpipe uses event-driven architecture to automatically detect new files and load them with low-latency.

  Why Other Options Are Incorrect:

  A. COPY INTO command: This command is for manual or scheduled bulk data loading, not continuous, automated loading.

  B. Data replication: Used for replicating databases across regions, not for data loading.

  D. Direct share: Used for sharing data between Snowflake accounts, not for loading files.

  References:

  Snowpipe Documentation

• Question 372:

  Masking policies can be applied to which of the following Snowflake objects? (Choose two.)

  A. A materialized view
  B. A stored procedure
  C. A table
  D. A stream
  E. A pipe
  F. A User-Defined Function (UDF)
  A. A materialized view
  C. A table

  ---

  Explanation

• Question 373:

  Which Snowflake edition enables data sharing only through Snowflake Support?

  A. Virtual Private Snowflake
  B. Business Critical
  C. Enterprise
  D. Standard
  A. Virtual Private Snowflake

  ---

  Explanation

• Question 374:

  Which steps will help optimize query performance? (Select TWO).

  A. Using the query acceleration service
  B. Clustering a table
  C. Indexing a column
  D. Increasing the size of the micro-partitions
  E. Decreasing the size of the virtual warehouse
  A. Using the query acceleration service
  B. Clustering a table

  ---

  Explanation

  Query Acceleration Service (A):

  Clustering a Table (B):

  Why Other Options Are Incorrect:

  C. Indexing a column: Snowflake does not use traditional indexes.

  D. Increasing micro-partition size: Micro-partitions have a fixed size managed by Snowflake.

  E. Decreasing virtual warehouse size: Reducing compute power reduces query performance.

  References:

  Clustering Keys

  Query Acceleration Service

• Question 375:

  What Snowflake tool can be used to share data and metadata to one or more accounts in Snowflake?

  A. Secure views
  B. Listings
  C. Direct shares
  D. Data Exchange
  D. Data Exchange

  ---

  Explanation

• Question 376:

  Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  A. UPDATE TABLE FROM STREAM
  B. SELECT FROM STREAM
  C. INSERT INTO TABLE SELECT FROM STREAM
  D. ALTER TABLE AS SELECT FROM STREAM
  E. BEGIN COMMIT
  A. UPDATE TABLE FROM STREAM
  C. INSERT INTO TABLE SELECT FROM STREAM

  ---

  Explanation

• Question 377:

  What objects are required to unload data into cloud data storage? (Select TWO).

  A. An external stage
  B. A FILE FORMAT definition
  C. A STORAGE_INTEGRATION definition
  D. An external table
  E. A directory table
  A. An external stage
  B. A FILE FORMAT definition

  ---

  Explanation

• Question 378:

  Which Query Profile operator provides information on pruning e ciency?

  A. TableScan
  B. ExternalScan
  C. InternalObject
  D. Generator
  A. TableScan

  ---

  Explanation

• Question 379:

  How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

  A. 32
  B. 64
  C. 128
  D. 256
  C. 128

  ---

  Explanation

• Question 380:

  What is the default compression typo when unloading data from Snowflake?

  A. Brotli
  B. bzip2
  C. Zstandard
  D. gzip
  D. gzip

  ---

  Explanation