Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1341:

  Which of the following statements about data sharing are true? (Choose two)

  A. New objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts
  B. All database objects can be included In a shared database
  C. Reader Accounts are created and funded by Data Prowlers
  D. Shared databases are read-only
  C. Reader Accounts are created and funded by Data Prowlers
  D. Shared databases are read-only

  ---

  Explanation

• Question 1342:

  What COPY INTO SQL command should be used to unload data into multiple files?

  A. SINGLE=TRUE
  B. MULTIPLE=TRUE
  C. MULTIPLE=FALSE
  D. SINGLE=FALSE
  D. SINGLE=FALSE

  ---

  Explanation

• Question 1343:

  Which role grants can be used when creating a role hierarchy in Snowflake? (Select TWO}

  A. GRANT USER u1 TO ROLE r1;
  B. GRANT ROLE r1 TO USER u1;
  C. GRANT USER u1 TO USER u2;
  D. GRANT ROLE r1 TO DATABASE ROLE dr1;
  E. GRANT DATABASE ROLE dr1 TO ROLE r1;
  B. GRANT ROLE r1 TO USER u1;
  D. GRANT ROLE r1 TO DATABASE ROLE dr1;

  ---

  Explanation

  In Snowflake, role grants are used to build role hierarchies. Why Other Options Are Incorrect:

  A. GRANT USER u1 TO ROLE r1: Snowflake does not support granting users to roles.

  C. GRANT USER u1 TO USER u2: This is invalid syntax; user grants are not allowed.

  E. GRANT DATABASE ROLE dr1 TO ROLE r1: Database roles cannot be granted to non-database roles.

  References:

  Role Hierarchies in Snowflake

• Question 1344:

  Which URL type does Snowflake recommend to use when providing unstructured data to other accounts through a share?

  A. File
  B. Pre-signed
  C. Scoped
  D. Staged
  C. Scoped

  ---

  Explanation

• Question 1345:

  What is the expiration period tor a file URL used to access unstructured data in cloud storage?

  A. The remainder of the session
  B. An unlimited amount of time
  C. The length of time specified in the expiration_time argument
  D. The same length of time as the expiration period for the query results cache
  D. The same length of time as the expiration period for the query results cache

  ---

  Explanation

• Question 1346:

  Who can create and manage reader accounts? (Select TWO).

  A. A user with ACCOUNTADMIN role
  B. A user with securityadmin role
  C. A user with SYSADMIN role
  D. A user with ORGADMIH role
  E. A user with CREATE ACCOUNT privilege
  A. A user with ACCOUNTADMIN role
  D. A user with ORGADMIH role

  ---

  Explanation

  In Snowflake, reader accounts are special types of accounts that allow data sharing with external consumers without them having their own Snowflake account. The creation and management of reader accounts can be performed by users with the ACCOUNTADMIN role or the ORGADMIN role. The ACCOUNTADMIN role has comprehensive administrative privileges within a Snowflake account, including managing other accounts and roles. The ORGADMIN role, which is higher in hierarchy, oversees multiple accounts within an organization and can manage reader accounts across those accounts.

  References: Snowflake Documentation: Creating and Managing Reader Accounts

• Question 1347:

  A user has unloaded data from Snowflake to a stage

  Which SQL command should be used to validate which data was loaded into the stage?

  A. list @file__stage
  B. show @file__stage
  C. view @file__stage
  D. verify @file__stage
  A. list @file__stage

  ---

  Explanation

• Question 1348:

  What Snowflake authentication method is recommended to use for logging onto the Snowflake CLI?

  A. Login and password
  B. Okta native authentication
  C. Key-pair authentication
  D. Single Sign-On (SSO) with Multi-Factor Authentication (MFA)
  C. Key-pair authentication

  ---

  Explanation

• Question 1349:

  Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  A. Schema
  B. View
  C. Internal stage
  D. Table
  E. User
  F. Role
  A. Schema
  D. Table

  ---

  Explanation

• Question 1350:

  What happens when a virtual warehouse is resized?

  A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
  C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
  D. Users who are trying to use the warehouse will receive an error message until the resizing is complete
  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

  ---

  Explanation