Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 171:

  Which statement accurately describes Snowflake's architecture?

  A. It uses a local data repository for all compute nodes in the platform.
  B. It is a blend of shared-disk and shared-everything database architectures.
  C. It is a hybrid of traditional shared-disk and shared-nothing database architectures.
  D. It reorganizes loaded data into internal optimized, compressed, and row-based format.
  C. It is a hybrid of traditional shared-disk and shared-nothing database architectures.

  ---

  Explanation

• Question 172:

  What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

  A. The Pipe load history is reset to empty.
  B. The REFRESH command is executed.
  C. The stage will be purged.
  D. The destination table is truncated.
  B. The REFRESH command is executed.

  ---

  Explanation

• Question 173:

  For the ALLOWED_VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

  A. 10
  B. 50
  C. 64
  D. 256
  D. 256

  ---

  Explanation

• Question 174:

  Which Snowflake object can be used to record DML changes made to a table?

  A. Snowpipe
  B. Stage
  C. Stream
  D. Task
  C. Stream

  ---

  Explanation

• Question 175:

  What happens when the values for both an ALLOWED_IP_LIST and a BLOCKED_IP_LIST are used in a network policy?

  A. Snowflake ignores the BLOCKED_IP_LIST first.
  B. Snowflake applies the BLOCKED_IP_LIST first.
  C. Snowflake applies the ALLOWED_IP_LIST first.
  D. Snowflake ignores the ALLOWED_IP_LIST first.
  B. Snowflake applies the BLOCKED_IP_LIST first.

  ---

  Explanation

• Question 176:

  Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

  A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
  B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
  C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
  D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
  E. grant SELECT on all tables in database DB1 to role MYROLE;
  F. grant SELECT on future tables in database DB1 to role MYROLE;
  C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
  D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

  ---

  Explanation

• Question 177:

  The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

  

  A user needs to extract the dealership information from the JSON.

  How can this be accomplished?

  A. select src:dealership from car_sales;
  B. select src.dealership from car_sales;
  C. select src:Dealership from car_sales;
  D. select dealership from car_sales;
  A. select src:dealership from car_sales;

  ---

  Explanation

• Question 178:

  A user executed a SELECT query in Snowsight, which returned a 1 GB result set. The user then downloads files from Snowsight. What will occur?

  A. The result set will be successfully downloaded from Snowsight.
  B. The result set will be automatically compressed and the data will be downloaded as individual files.
  C. The download will fail because the result set needs to be be broken up into files no greater than 50 MB before downloading.
  D. The download will result in an error because the filters of the SELECT query need to be changed so that Snowsight returns a smaller result set.
  C. The download will fail because the result set needs to be be broken up into files no greater than 50 MB before downloading.

  ---

  Explanation

  In Snowsight, result sets are limited to 50 MB per file when downloading directly. If the query returns a result larger than this size (e.g., 1 GB), the download will fail unless the result is broken into smaller files.

  To handle large result sets:

  Why Other Options Are Incorrect:

  A. Successfully downloaded: Snowsight does not support downloads of files larger than 50 MB.

  B. Automatically compressed: Compression does not automatically split the file.

  D. Error due to query filters: The issue is related to file size, not query filters.

  References:

  Working with Query Results in Snowsight

• Question 179:

  Which Snowflake objects can be secured to protect data privacy? (Select TWO).

  A. Schemas
  B. Stages
  C. Views
  D. Materialized views
  E. Tags
  C. Views
  D. Materialized views

  ---

  Explanation

• Question 180:

  What happens when a database is cloned?

  A. It does not retain any privileges granted on the source object.
  B. It replicates all granted privileges on the corresponding source objects.
  C. It replicates all granted privileges on the corresponding child objects.
  D. It replicates all granted privileges on the corresponding child schema objects.
  C. It replicates all granted privileges on the corresponding child objects.

  ---

  Explanation