Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 951:

  What Snowflake service or feature can be used to ensure that Snowflake-hosted data is still available if an account becomes inaccessible because of a regional cloud service provider outage ?

  A. Time Travel
  B. Fail-safe
  C. A data share
  D. Cross-region replication
  D. Cross-region replication

  ---

  Explanation

  Cross-region replication ensures data availability across multiple cloud regions . In the event of a regional outage, Snowflake accounts with this feature can fail over to a different region.

  Snowflake Docs: Cross-Region Data Replication

• Question 952:

  The information schema provides storage information for which of the following objects? (Choose two.)

  A. Users
  B. Databases
  C. Internal stages
  D. Resource monitors
  E. Pipes
  B. Databases
  E. Pipes

  ---

  Explanation

• Question 953:

  Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  A. True
  B. False
  A. True

  ---

  Explanation

• Question 954:

  Which command line flags can be used to log into a Snowflake account using SnowSQL? (Choose two.)

  A. -d
  B. -o
  C. -e
  D. -a
  E. -c
  A. -d
  D. -a

  ---

  Explanation

• Question 955:

  How does Snowflake handle the bulk unloading of data into single or multiple files?

  A. It assigns each unloaded data file a unique name.
  B. It uses the PUT command to download the data by default.
  C. It uses COPY INTO for bulk unloading where the default option is SINGLE = TRUE.
  D. It uses COPY INTO to copy the data from a table into one or more files in an external stage only.
  A. It assigns each unloaded data file a unique name.

  ---

  Explanation

• Question 956:

  A company has established this Role-Based Access Control (RBAC) framework:

  Role data_viewer has SELECT privilege on the orders_data table.

  Role data_viewer is granted to the data_scientist role.

  User User_1 has data_scientist as their primary role.

  User User_1 also has data_viewer role granted as secondary role.

  What privileges does User_1 have on the orders_data table?

  A. User_1 can only SELECT from orders_data and must use the primary role.
  B. User_1 can SELECT from orders_data using either the primary or secondary role.
  C. User_1 can SELECT from orders_data only when using the secondary role.
  D. User_1 cannot SELECT from orders_data because having the role granted as both primary and secondary will create a privilege conflict.
  B. User_1 can SELECT from orders_data using either the primary or secondary role.

  ---

  Explanation

• Question 957:

  Which of the following roles is recommended to be used to create and manage users and roles?

  A. SYSADMIN
  B. SECURITYADMIN
  C. PUBLIC
  D. ACCOUNTADMIN
  B. SECURITYADMIN

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

• Question 958:

  Which role has the privileges to describe a share?

  A. ORGADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ACCOUNTADMIN
  C. SYSADMIN

  ---

  Explanation

• Question 959:

  What happens when a user exits Snowsight during a session that a query is running?

  A. Snowflake executes the query during the same session immediately.
  B. Snowflake cancels any queries submitted during this session that are still running.
  C. Snowflake will cancel any queries submitted during this session after 24 hours.
  D. Snowflake will continue to execute and complete upon the next login.
  B. Snowflake cancels any queries submitted during this session that are still running.

  ---

  Explanation

• Question 960:

  Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  A. STRIP_NULL_VALUES
  B. SKIP_BYTE_ORDER_MARK
  C. REPLACE_INVALID_CHARACTERS
  D. VALIDATION_MODE
  D. VALIDATION_MODE

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified: