Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 891:

  How are serverless features billed?

  A. Per second multiplied by an automatic sizing for the job
  B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
  C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
  D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
  A. Per second multiplied by an automatic sizing for the job

  ---

  Explanation

• Question 892:

  What internal stages are available in Snowflake? (Choose three.)

  A. Schema stage
  B. Named stage
  C. User stage
  D. Stream stage
  E. Table stage
  F. Database stage
  B. Named stage
  C. User stage
  E. Table stage

  ---

  Explanation

• Question 893:

  How can the performance of queries run on external tables be optimized?

  A. Cluster the tables
  B. Create materialized views on the tables
  C. Use the metadata cache
  D. Enable the search optimization service
  C. Use the metadata cache

  ---

  Explanation

• Question 894:

  What does the LATERAL modifier for the FLATTEN function do?

  A. Casts the values of the flattened data
  B. Extracts the path of the flattened data
  C. Joins information outside the object with the flattened data
  D. Retrieves a single instance of a repeating element in the flattened data
  C. Joins information outside the object with the flattened data

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/querying-semistructured#using-the-flatten-function-to-parse-arrays

• Question 895:

  A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

  A. list @mytable;
  B. list @%raytable;
  C. list @ %m.ystage;
  D. list @mystage;
  D. list @mystage;

  ---

  Explanation

• Question 896:

  Will data cached in a warehouse be lost when the warehouse is resized?

  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  B. Yes. because the compute resource is replaced in its entirety with a new compute resource.
  C. No. because the size of the cache is independent from the warehouse size
  D. Yes. became the new compute resource will no longer have access to the cache encryption key
  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

  ---

  Explanation

• Question 897:

  What is the name of the SnowSQL file that can store connection information?

  A. history
  B. config
  C. snowsql.cnf
  D. snowsql.pubkey
  B. config

  ---

  Explanation

• Question 898:

  What is the recommended file sizing for data loading using Snowpipe?

  A. A compressed file size greater than 100 MB, and up to 250 MB
  B. A compressed file size greater than 100 GB, and up to 250 GB
  C. A compressed file size greater than 10 MB, and up to 100 MB
  D. A compressed file size greater than 1 GB, and up to 2 GB
  A. A compressed file size greater than 100 MB, and up to 250 MB

  ---

  Explanation

  https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute% 20intervals.

• Question 899:

  By definition, a secure view is exposed only to users with what privilege?

  A. IMPORT SHARE
  B. OWNERSHIP
  C. REFERENCES
  D. USAGE
  B. OWNERSHIP

  ---

  Explanation

• Question 900:

  A stream object will advance its offset when it is used in which statement?

  A. SELECT
  B. INSERT
  C. CREATE
  D. COPY INTO
  B. INSERT

  ---

  Explanation

  A stream in Snowflake is used to track changes (inserts, updates, and deletes) to a table. A stream advances its offset (tracking progress) when it is consumed. When a stream is used in an INSERT statement, the stream offset advances, as

  the changes are processed into a target table.

  For example:

  INSERT INTO target_table

  SELECT * FROM table_stream;

  Here, table_stream is a stream object, and using it in the INSERT statement advances the offset.

  Why Other Options Are Incorrect:

  A. SELECT: A SELECT query does not consume the stream or advance its offset.

  C. CREATE: This operation is unrelated to streams.

  D. COPY INTO: This command exports data and does not involve stream offsets.

  References:

  Streams in Snowflake