Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1381:

  How does Snowflake ensure the integrity and consistency of data stored in tables?

  A. Row-level encryption
  B. Dynamic Data Masking
  C. Constraints
  D. Time Travel
  C. Constraints

  ---

  Explanation

• Question 1382:

  Why should a user select the economy scaling policy for a multi-cluster warehouse?

  A. To prevent/minimize query queuing
  B. To increase performance of the clusters
  C. To reduce queuing concurrent user queries
  D. To conserve credits by keeping running clusters fully loaded
  D. To conserve credits by keeping running clusters fully loaded

  ---

  Explanation

• Question 1383:

  When sharing data among multiple Snowflake accounts, what charges are incurred by a data consumer when viewing shared data using their own account?

  A. Cloud services charges
  B. Compute charges
  C. Data storage charges
  D. Data egress charges
  B. Compute charges

  ---

  Explanation

• Question 1384:

  What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
  B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
  C. The ACCOUNTADMIN role must be granted to only one user.
  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
  E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

  ---

  Explanation

• Question 1385:

  A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role.

  Which tasks can this user now perform on the Data Exchange? (Choose two.)

  A. Rename listings
  B. Delete provider profiles
  C. Modify listings properties
  D. Modify incoming listing access requests
  E. Submit listings for approval/publishing
  C. Modify listings properties
  E. Submit listings for approval/publishing

  ---

  Explanation

• Question 1386:

  When unloading data from Snowflake, the user executes a COPY INTO command into an internal stage.

  What additional command is required to load the file onto the local file system?

  A. GET
  B. LIST
  C. PUT
  D. REMOVE
  A. GET

  ---

  Explanation

• Question 1387:

  Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?

  A. TO_JSON
  B. TO_VARIANT
  C. OBJECT_INSERT
  D. OBJECT_CONSTRUCT
  D. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 1388:

  Where can a Snowflake user find the query history in Snowsight?

  A. Admin
  B. Activity
  C. Dashboards
  D. Data
  B. Activity

  ---

  Explanation

• Question 1389:

  Which programming languages are supported for Snowflake User-Defined Functions (UDFs)? (Choose two.)

  A. C#
  B. JavaScript
  C. PHP
  D. Python
  E. TypeScript
  B. JavaScript
  D. Python

  ---

  Explanation

• Question 1390:

  Which command will change the name of shared database role r1 to r4?

  A. ALTER ROLE d1.r1 RENAME TO d1.r4;
  B. ALTER ROLE d1.r1 RENAME TO d2.r4;
  C. ALTER DATABASE ROLE d1.r1 RENAME TO d2.r4;
  D. ALTER DATABASE ROLE d1.r1 RENAME TO d1.r4;
  D. ALTER DATABASE ROLE d1.r1 RENAME TO d1.r4;

  ---

  Explanation