Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 301:

  Which Snowflake objects can be defined with future grants? (Select TWO).

  A. Schemas
  B. Databases
  C. Masking policies
  D. External functions
  E. Virtual warehouses
  A. Schemas
  B. Databases

  ---

  Explanation

  Future grants allow privileges to be automatically applied to new objects (e.g., schemas, tables, databases) created in the future.

  Supported objects for future grants include:

  Why Other Options Are Incorrect:

  C. Masking policies /

  D. External functions /

  E. Virtual warehouses: These objects are not supported for future grants.

  References:

  Future Grants Documentation

• Question 302:

  Which Snowflake database object can be shared with other accounts?

  A. Tasks
  B. Pipes
  C. Secure User-Defined Functions (UDFs)
  D. Stored Procedures
  C. Secure User-Defined Functions (UDFs)

  ---

  Explanation

• Question 303:

  Which feature uses a Snowflake key with a customer-managed key to protect data?

  A. Trust Center
  B. Tri-Secret Secure
  C. Key-pair authentication
  D. Multi-Factor Authentication (MFA)
  B. Tri-Secret Secure

  ---

  Explanation

• Question 304:

  What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  A. The shared objects are transferred.
  B. The shared objects are copied.
  C. The shared objects become accessible.
  D. The shared objects can be re-shared.
  C. The shared objects become accessible.

  ---

  Explanation

• Question 305:

  What should be used to show the status of partial data loads and loading errors?

  A. The COPY_HISTORY function
  B. The QUERY_HISTORY function
  C. The ACCESS_HISTORY view
  D. The WAREHOUSE_LOAD_HISTORY function
  A. The COPY_HISTORY function

  ---

  Explanation

• Question 306:

  When semi-structured data includes dates and timestamps as string values, what Snowflake recommendation will OPTIMIZE pruning and MINIMIZE storage consumption?

  A. Store the data as a VARIANT data type.
  B. Store the data as an ARRAY data type.
  C. Strip the outer array using TRY_PARSE_JSON.
  D. Flatten the key data into relational columns.
  D. Flatten the key data into relational columns.

  ---

  Explanation

• Question 307:

  Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  A. Is available to all Snowflake Editions
  B. Is only available to customers with Business Critical Edition
  C. Restricts or enables access to specific IP addresses
  D. Is activated using an "ALTER DATABASE" command
  A. Is available to all Snowflake Editions
  C. Restricts or enables access to specific IP addresses

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

• Question 308:

  When should a stored procedure be created with caller's rights?

  A. When the caller needs to be prevented from viewing the source code of the stored procedure
  B. When the caller needs to run a statement that could not execute outside of the stored procedure
  C. When the stored procedure needs to run with the privileges of the role that called the stored procedure
  D. When the stored procedure needs to operate on objects that the caller does not have privileges on
  C. When the stored procedure needs to run with the privileges of the role that called the stored procedure

  ---

  Explanation

• Question 309:

  Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

  A. ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
  B. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
  C. ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
  D. ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';
  D. ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

  ---

  Explanation

• Question 310:

  What tasks can be completed using the copy command? (Select TWO)

  A. Columns can be aggregated
  B. Columns can be joined with an existing table
  C. Columns can be reordered
  D. Columns can be omitted
  E. Data can be loaded without the need to spin up a virtual warehouse
  C. Columns can be reordered
  D. Columns can be omitted

  ---

  Explanation