Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 421:

  What consideration should be made when loading data into Snowflake?

  A. Create small data files and stage them in cloud storage frequently.

  B. Create large data files to maximize the processing overhead for each file.

  C. The number of load operations that run in parallel can exceed the number of data files to be loaded.

  D. The number of data files that are processed in parallel is determined by the virtual warehouse.

  Correct Answer: D

• Question 422:

  How can a user improve the performance of a single large complex query in Snowflake?

  A. Scale up the virtual warehouse.

  B. Scale out the virtual warehouse.

  C. Enable standard warehouse scaling.

  D. Enable economy warehouse scaling.

  Correct Answer: A

  https://dzone.com/articles/snowflake-performance-tuning-top-5-best-practices

• Question 423:

  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

  Correct Answer: BE

  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 424:

  When a database is cloned, which objects in the clone inherit all granted privileges from the source object? (Choose two.)

  A. Account

  B. Database

  C. Schemas

  D. Tables

  E. Internal named stages

  Correct Answer: CD

  Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.

• Question 425:

  What setting in Snowsight determines the databases, tables, and other objects that can be seen and the actions that can be performed on them?

  A. Active role

  B. Masking policy

  C. Column-level security

  D. Multi-Factor Authentication (MFA)

  Correct Answer: A

• Question 426:

  Why would a Snowflake user decide to use a materialized view instead of a regular view?

  A. The base tables do not change frequently.

  B. The results of the view change often.

  C. The query is not resource intensive.

  D. The query results are not used frequently.

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/views-materialized

• Question 427:

  Snowflake will return an error when a user attempts to share which object?

  A. Tables

  B. Secure views

  C. Standard views

  D. Secure materialized views

  Correct Answer: C

• Question 428:

  Who can access a referenced file through a scoped URL?

  A. Only the ACCOUNTADMIN

  B. Only the user who generates the URL

  C. Any role specified in the GET REST API call with sufficient privileges

  D. Any user specified in the GET REST API call with sufficient privileges

  Correct Answer: B

  Scoped URL Only the user who generated the scoped URL can use the URL to access the referenced file. File URL Any role that has sufficient privileges on the stage can access the file: External stage: USAGE Internal stage: READ

• Question 429:

  What tasks can an account administrator perform in the Data Exchange? (Choose two.)

  A. Add and remove members.

  B. Delete data categories.

  C. Approve and deny listing approval requests.

  D. Transfer listing ownership.

  E. Transfer ownership of a provider profile.

  Correct Answer: AC

  By default, only an account administrator (a user with the ACCOUNTADMIN role) in the Data Exchange administrator account can manage a Data Exchange, which includes the following tasks: Add or remove members. Approve or deny listing approval requests. Approve or deny provider profile approval requests. https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges

• Question 430:

  What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

  A. Duo Security

  B. OAuth

  C. Okta

  D. Single Sign-On (SSO)

  Correct Answer: A

  MFA provides increased login security for users connecting to Snowflake. MFA support is provided as an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake. https://docs.snowflake.com/en/user-guide/ui-snowsight-profile