Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 691:

  Which command will unload data from a table into an external stage?

  A. PUT
  B. INSERT
  C. COPY INTO
  D. GET
  C. COPY INTO

  ---

  Explanation

• Question 692:

  What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

  A. Use the automatic sharing feature for seamless access.
  B. Drop the object and then re-add it to the database to trigger sharing.
  C. Recreate the object with a different name in the database before sharing.
  D. Use the GRANT privilege ... TO SHARE command to grant the necessary privileges.
  D. Use the GRANT privilege ... TO SHARE command to grant the necessary privileges.

  ---

  Explanation

• Question 693:

  Which functions can be used to automatically detect and generate a file's metadata schema and column definitions, when loading semi-structured data into Snowflake from 9? (Select TWO).

  A. GENERATOR
  B. GET_OBJECT_REFERENCES
  C. INFER_SCHEMA
  D. GENERATE_COLUMN_DESCRIPTION
  E. SPLIT TO TABLE
  C. INFER_SCHEMA
  D. GENERATE_COLUMN_DESCRIPTION

  ---

  Explanation

  Snowflake provides functions to detect and generate metadata schema and column definitions when loading semi-structured data like JSON or Avro: Why Other Options Are Incorrect:

  A. GENERATOR: Used for creating synthetic datasets, not for schema inference.

  B. GET_OBJECT_REFERENCES: Provides dependency references for objects, not for schema detection.

  E. SPLIT_TO_TABLE: Splits data into rows but does not infer metadata.

  References:

  Semi-Structured Data Loading

  INFER_SCHEMA Documentation

• Question 694:

  The Snowflake Cloud Data Platform is described as having which of the following architectures?

  A. Shared-disk
  B. Shared-nothing
  C. Multi-cluster shared data
  D. Serverless query engine
  C. Multi-cluster shared data

  ---

  Explanation

• Question 695:

  What column type does a Kafka connector store formatted information in a single column?

  A. ARRAY
  B. OBJECT
  C. VARCHAR
  D. VARIANT
  D. VARIANT

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/kafka-connector-overview

• Question 696:

  What is the impact on queries that are being executed when a resource monitor set to the "Notify and Suspend" threshold level is exceeded?

  A. All statements being executed are queued.
  B. All statements being executed are restarted.
  C. All statements being executed are cancelled.
  D. All statements being executed are completed.
  D. All statements being executed are completed.

  ---

  Explanation

  Notify and Suspend

  Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed.

  Notify and Suspend Immediately

  Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time.

  Notify

  Perform no action, but send an alert notification (to all account administrators with notifications enabled).

• Question 697:

  What command will list all of the roles that have been granted to role DATA_ENGINEER?

  A. SHOW GRANTS OF ROLE DATA_ENGINEER;
  B. SHOW GRANTS TO ROLE DATA_ENGINEER;
  C. SHOW GRANTS ON ROLE DATA_ENGINEER;
  D. SHOW ROLES LIKE 'DATA_ENGINEER';
  B. SHOW GRANTS TO ROLE DATA_ENGINEER;

  ---

  Explanation

• Question 698:

  Which Snowflake data governance feature can support auditing when a user query reads column data?

  A. Access History
  B. Data classification
  C. Column-level security
  D. Object dependencies
  A. Access History

  ---

  Explanation

• Question 699:

  An external stage many_stage contains many directories including one, app_files that contains CSV files

  How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

  A. COPY INTO my_table FROM @my_stage PATTERN='.*[.]csv';
  B. COPY INTO my_table FROM @my_stage/app_files PATTERN='.*[.]csv';
  C. COPY INTO my_table FROM @my_stage/app_files PATTERN='.*[.]txt';
  D. COPY INTO my_table FROM @my_stage PATTERN='.*[.]txt';
  B. COPY INTO my_table FROM @my_stage/app_files PATTERN='.*[.]csv';

  ---

  Explanation

• Question 700:

  Which Snowflake object type can be used to restrict users from viewing the DDL associated with the object?

  A. Materialized view
  B. Secure view
  C. Data masking policy
  D. Stored procedure
  B. Secure view

  ---

  Explanation

  A Secure View in Snowflake restricts users from accessing the underlying DDL (e.g., CREATE VIEW statement) and prevents unauthorized access to the underlying data.

  Secure views are designed for enhanced data security and privacy.

  Why Other Options Are Incorrect:

  A. Materialized view: Does not restrict access to DDL.

  C. Data masking policy: Applies to column-level data but does not restrict DDL access.

  D. Stored procedure: Does not restrict DDL access to itself.

  References:

  Secure Views Documentation