Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 251:

  Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

  A. list @bronzestage;
  B. select * from directory(@bronzestage);
  C. select metadata$filename from @bronzestage;
  D. select * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));
  B. select * from directory(@bronzestage);

  ---

  Explanation

• Question 252:

  Which URL type should be used to get a permanent URL to a file in a stage?

  A. File URL
  B. Pre-signed URL
  C. Saved URL
  D. Scoped URL
  A. File URL

  ---

  Explanation

• Question 253:

  In which use cases does Snowflake apply egress charges?

  A. Data sharing within a specific region
  B. Query result retrieval
  C. Database replication
  D. Loading data into Snowflake
  C. Database replication

  ---

  Explanation

  nowflake charges a per-byte fee for data egress when users transfer data from a Snowflake account into a different region on the same cloud platform or into a completely different cloud platform. Data transfers within the same region are free.

• Question 254:

  In Snowflake. where can query pruning information statistics be identified?

  A. Partitions scanned
  B. Byles scanned
  C. Bytes spilled to remote storage
  D. Percentage scanned from cache
  A. Partitions scanned

  ---

  Explanation

  Query pruning statistics in Snowflake indicate how efficiently the query engine has limited the number of micro-partitions scanned. The metric "Partitions scanned" in the query profile shows the number of micro- partitions accessed during

  query execution. Efficient pruning minimizes the number of partitions scanned, improving performance.

  Why Other Options Are Incorrect:

  B. Bytes scanned: Indicates the amount of data read but not pruning details.

  C. Bytes spilled to remote storage: Related to spillage, not query pruning.

  D. Percentage scanned from cache: Refers to the use of local cache, unrelated to partition pruning.

  References:

  Query Profile Documentation

• Question 255:

  Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  A. True
  B. False
  A. True

  ---

  Explanation

  Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

• Question 256:

  How long does Snowflake retain information in the ACCESS_HISTORY view?

  A. 7 days
  B. 14 days
  C. 28 days
  D. 365 days
  D. 365 days

  ---

  Explanation

• Question 257:

  Which commands are supported by the query acceleration service? (Select TWO).

  A. INSERT
  B. MERGE
  C. SELECT
  D. UPDATE
  E. DELETE
  A. INSERT
  B. MERGE

  ---

  Explanation

• Question 258:

  When working with dimension tables that change frequently, what is the recommended way to manage costs?

  A. Keep the Time Travel retention period for the dimension tables to 7 days or less.
  B. Make the dimension tables transient with a retention period of 0 days, and backup the table daily to a permanent table. Delete all but the latest backup.
  C. Make the dimension tables transient and back-up the data daily into a permanent table using cloning.
  D. Make the dimension tables permanent with a retention period of 7 days. Replicate the database to a secondary database once a week.
  B. Make the dimension tables transient with a retention period of 0 days, and backup the table daily to a permanent table. Delete all but the latest backup.

  ---

  Explanation

• Question 259:

  Which types of subqueries does Snowflake support? (Choose two.)

  A. Uncorrelated scalar subqueries in WHERE clauses
  B. Uncorrelated scalar subqueries in any place that a value expression can be used
  C. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
  D. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
  E. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated
  B. Uncorrelated scalar subqueries in any place that a value expression can be used
  E. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

  ---

  Explanation

  Snowflake currently supports the following types of subqueries:

  Uncorrelated scalar subqueries in any place that a value expression can be used.

  Correlated scalar subqueries in WHERE clauses.

  EXISTS, ANY / ALL, and IN subqueries in WHERE clauses. These subqueries can be correlated or uncorrelated.

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

• Question 260:

  How can a 5 GB table be downloaded into a single file MOST efficiently?

  A. Keep the default MAX_FILE_SIZE to 16 MB.
  B. Set the default MAX_FILE_SIZE to 5 GB.
  C. Set the SINGLE parameter to TRUE.
  D. Use a regular expression in the stage specifications of the COPY command.
  C. Set the SINGLE parameter to TRUE.

  ---

  Explanation