Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 11:

  How does Snowflake enable OAuth?

  A. By creating an external integration

  B. By configuring a security integration

  C. By establishing IP allowed lists and IP blocked lists

  D. By using SnowSQL to enable an external OAuth using the Snowflake protocol

  Correct Answer: B

  Administrators configure OAuth using a Security integration, which enables clients that support OAuth to redirect users to an authorization page and generate access tokens (and optionally, refresh tokens) for accessing Snowflake.

• Question 12:

  Which type of workload traditionally benefits from the use of the query acceleration service?

  A. Workloads with a predictable data volume for each query

  B. Workloads that include on-demand data analyses

  C. Queries with small scans and non-selective filters

  D. Queries that do not have filters or aggregation

  Correct Answer: B

  The query acceleration service (QAS) can accelerate parts of the query workload in a warehouse. When it is enabled for a warehouse, it can improve overall warehouse performance by reducing the impact of outlier queries, which are queries that use more resources than the typical query. The query acceleration service does this by offloading portions of the query processing work to shared compute resources that are provided by the service.

• Question 13:

  Which type of workload is recommended for Snowpark-optimized virtual warehouses?

  A. Workloads with ad hoc analytics

  B. Workloads that have large memory requirements

  C. Workloads with unpredictable data volumes for each query

  D. Workloads that are queried with small table scans and selective filters

  Correct Answer: B

• Question 14:

  What can be used to process unstructured data?

  A. External tables

  B. The COPY INTO

  C. External functions

  D. Snowpipe

  Correct Answer: A

• Question 15:

  What objects can be cloned within Snowflake? (Choose two.)

  A. Schemas

  B. Users

  C. External tables

  D. Internal named stages

  E. External named stages

  Correct Answer: AE

• Question 16:

  How can staged files be removed during data loading once the files have loaded successfully?

  A. Use the DROP command.

  B. Use the PURGE copy option.

  C. Use the FORCE = TRUE parameter.

  D. Use the LOAD_UNCERTAIN_FILES copy option.

  Correct Answer: B

• Question 17:

  How does Snowflake utilize clustering information to improve query performance?

  A. It prunes unnecessary micro-partitions based on clustering metadata.

  B. It compresses the data within micro-partitions for faster querying.

  C. It automatically allocates additional resources to improve query execution.

  D. It organizes clustering information to speed-up data retrieval from storage.

  Correct Answer: A

• Question 18:

  In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)

  A. Implementation of column-level security will optimize query performance.

  B. Column-level security supports encryption of the entire database.

  C. Column-level security ensures that only the table owner can access the data.

  D. Column-level security limits access to specific columns within a table based on user privileges.

  E. Column-level security allows the application of a masking policy to a column within a table or view.

  Correct Answer: DE

• Question 19:

  Which Snowflake object is supported by both database replication and replication groups?

  A. Pipes

  B. Users

  C. Stages

  D. Materialized views

  Correct Answer: A

• Question 20:

  When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)

  A. ESCAPE_UNENCLOSED_FIELD

  B. REPLACE_INVALID_CHARACTERS

  C. FIELD_OPTIONALLY_ENCLOSED_BY

  D. EMPTY_FIELD_AS_NULL

  E. SKIP_BLANK_LINES

  Correct Answer: CD

  https://docs.snowflake.com/en/user-guide/data-unload-considerations