Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1:

  How can a dropped internal stage be restored?

  A. Enable Time Travel.
  B. Clone the dropped stage.
  C. Execute the UNDROP command.
  D. Recreate the dropped stage.
  D. Recreate the dropped stage.

  ---

  Explanation

• Question 2:

  What is a benefit of using Snowflake directory tables?

  A. Directory tables store file-level metadata about the data files in a temporary table.
  B. Directory table owners can configure the tables to have unique privileges.
  C. Any directory table user can configure the tables to have unique privileges.
  D. Directory tables can be joined with other tables in Snowflake.
  D. Directory tables can be joined with other tables in Snowflake.

  ---

  Explanation

• Question 3:

  Which command should be used to drop files from an internal or external stage?

  A. DELETE
  B. DROP
  C. REMOVE
  D. TRUNCATE
  C. REMOVE

  ---

  Explanation

• Question 4:

  To start using data listings from the Snowflake Marketplace as a provider or consumer. Snowflake customers must agree to additional terms of service and abide by Snowflake policies using which role?

  A. SECURTTYADMTN
  B. ACCOUNTADMIN
  C. SYSADMIN
  D. ORGADMIK
  B. ACCOUNTADMIN

  ---

  Explanation

  Snowflake Marketplace allows customers to share or consume data through data listings.

  To participate as a provider or consumer, users must agree to additional terms of service.

  The ACCOUNTADMIN role is required to manage agreements and enable Marketplace features because this role has the necessary permissions to modify account-level configurations.

  References:

  Snowflake Documentation: Snowflake Marketplace Setup Snowflake Roles and Privileges

• Question 5:

  When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  B. The listing is replicated into all selected regions automatically, the data is not.
  C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
  D. Shares attached to listings in remote regions can be viewed from any account in an organization.
  E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
  B. The listing is replicated into all selected regions automatically, the data is not.
  E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

  ---

  Explanation

• Question 6:

  A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

  What will Snowflake do if the user's IP address does not match the user-level network policy rules?

  A. Log the user out.
  B. Deactivate the network policy.
  C. Prevent the user from executing additional queries.
  D. Allow the user to continue until the session or login token expires.
  D. Allow the user to continue until the session or login token expires.

  ---

  Explanation

• Question 7:

  What can a Snowflake user do to reduce queuing on a multi-cluster virtual warehouse?

  A. Increase the warehouse size.
  B. Use an economy scaling policy.
  C. Increase the maximum number of clusters.
  D. Convert the warehouse to a Snowpark-optimized warehouse.
  C. Increase the maximum number of clusters.

  ---

  Explanation

• Question 8:

  How can a Snowflake user validate data that is unloaded using the COPY INTO command?

  A. Load the data into a CSV file.
  B. Load the data into a relational table.
  C. Use the VALIDATION_MODE = SQL statement.
  D. Use the VALIDATION_MODE = RETURN_ROWS statement.
  D. Use the VALIDATION_MODE = RETURN_ROWS statement.

  ---

  Explanation

  https://community.snowflake.com/s/article/Best-Practices-for-Data-Unloading

• Question 9:

  Users are able to see the result sets of queries executed by other users that share their same role.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 10:

  The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  A. True
  B. False
  B. False

  ---

  Explanation

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