Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 141:

  How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?

  A. Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.

  B. Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.

  C. Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.

  D. Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

  Correct Answer: C

• Question 142:

  A user creates a stage using the following command:

  CREATE STAGE mystage DIRECTORY = (ENABLE = TRUE) FILE_FORMAT = myformat;

  What will be the outcome?

  A. A stage with a directory table set to automatically refresh will be created.

  B. A stage with a directory table that has metadata that must be manually refreshed will be created.

  C. An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

  D. The command will fail to run because the name of the directory table is not specified.

  Correct Answer: A

• Question 143:

  Which query type is supported for implementing the search optimization service?

  A. Queries with column concatenation

  B. Substring search queries on external tables

  C. String searches on columns using the COLLATE function

  D. Geography value column searches using geospatial functions

  Correct Answer: D

• Question 144:

  What will prevent unauthorized access to a Snowflake account from an unknown source?

  A. Network policy

  B. End-to-end encryption

  C. Multi-Factor Authentication (MFA)

  D. Role-Based Access Control (RBAC)

  Correct Answer: A

• Question 145:

  Which Snowflake database object can be used to track data changes made to table data?

  A. Tag

  B. Task

  C. Stream

  D. Stored procedure

  Correct Answer: C

• Question 146:

  How can a data provider share their Snowflake data? (Choose two.)

  A. External table

  B. Snowpark API

  C. Direct share

  D. External function

  E. Snowflake Marketplace listing

  Correct Answer: CE

• Question 147:

  What does Snowflake recommend when planning virtual warehouse usage for a data load?

  A. Load the fewest possible number of large files.

  B. Dedicate a separate warehouse for loading data.

  C. Increase the size of the warehouse used.

  D. Use several single-cluster warehouses.

  Correct Answer: B

• Question 148:

  What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

  A. FLATTEN

  B. GET_PATH

  C. CHECK_JSON

  D. PARSE_JSON

  Correct Answer: A

• Question 149:

  What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

  A. The objects are dropped.

  B. The objects enter the Fail-safe period.

  C. The objects enter the Time Travel period.

  D. The objects are immediately moved to the provider account.

  Correct Answer: A

• Question 150:

  What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

  A. X-Small

  B. Small

  C. Medium

  D. Large

  Correct Answer: C