Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 141:

  By default, which system roles can create and manage users? (Select TWO)

  A. USERADMIN
  B. SYSADMIN
  C. SECURITYADMIN
  D. PUBLIC
  E. ORGADMIN
  A. USERADMIN
  C. SECURITYADMIN

  ---

  Explanation

  USERADMIN: Used for managing users and roles.

  SECURITYADMIN: Can manage users, roles, and access control.

  SYSADMIN is used primarily for object creation, not user management.

  Snowflake Docs: System-Defined Roles

• Question 142:

  What happens when a table or schema with a standard retention period is dropped?

  A. The object is immediately removed from the system.
  B. The object is instantaneously moved to Fail-safe.
  C. The object is retained but all associated data is immediately purged.
  D. The object is retained for the data retention period.
  D. The object is retained for the data retention period.

  ---

  Explanation

  In Snowflake, when a table or schema is dropped, it is not immediately deleted but retained for the configured data retention period, also known as "Time Travel." During this period, users can use commands like UNDROP to recover the dropped object if needed. After the retention period expires, the object is then moved to Fail-safe (if applicable) for an additional seven days before being permanently removed. This feature is intended to provide data protection and recovery options in case of accidental deletions.

• Question 143:

  Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

  A. Automatic clustering
  B. Materialized views
  C. Query acceleration service
  D. Search optimization service
  D. Search optimization service

  ---

  Explanation

• Question 144:

  Which table type is used in the le processing pipeline to process unstructured data in Snow ake?

  A. Temporary
  B. Directory
  C. Standard
  D. Transient
  B. Directory

  ---

  Explanation

• Question 145:

  Which metadata table will store the storage utilization information even for dropped tables?

  A. DATABASE_STORAGE_USAGE_HISTORY
  B. TABLE_STORAGE_METRICS
  C. STORAGE_DAILY_HISTORY
  D. STAGE_STORAGE_USAGE_HISTORY
  B. TABLE_STORAGE_METRICS

  ---

  Explanation

• Question 146:

  When can a Virtual Warehouse start running queries?

  A. 12am-5am
  B. Only during administrator defined time slots
  C. When its provisioning is complete
  D. After replication
  C. When its provisioning is complete

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 147:

  Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

• Question 148:

  What SQL command would be used to view all roles that were granted to user.1?

  A. show grants to user USER1;
  B. show grants of user USER1;
  C. describe user USER1;
  D. show grants on user USER1;
  A. show grants to user USER1;

  ---

  Explanation

• Question 149:

  Which types of URLs are provided by Snowflake to access unstructured data files? (Choose two).

  A. Absolute URL
  B. Dynamic URL
  C. File URL
  D. Relative URL
  E. Scoped URL
  C. File URL
  E. Scoped URL

  ---

  Explanation

  https://hevodata.com/learn/snowflake-unstructured-data/

• Question 150:

  Which command should be used to load data from a local computer into Snowflake?

  A. CREATE EXTERNAL TABLE
  B. COPY INTO
  C. INSERT
  D. PUT
  B. COPY INTO

  ---

  Explanation