Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1671:

  A security review identified several roles that are no longer being used. Which of the roles can be dropped?

  A. ACCOUNTADMIN
  B. USERADMIN
  C. FINANCEADMIN
  D. PUBLIC
  C. FINANCEADMIN

  ---

  Explanation

• Question 1672:

  Which data type can be used for floating-point numbers without losing precision?

  A. BINARY
  B. VARIANT
  C. INTEGER
  D. DOUBLE
  D. DOUBLE

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/data-types-numeric

• Question 1673:

  When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileged to the stage or to issue access token?

  A. File URL
  B. Scope URL
  C. Relative URL
  D. Pre-Signed URL
  D. Pre-Signed URL

  ---

  Explanation

• Question 1674:

  What step can reduce data spilling in Snowflake?

  A. Using a larger virtual warehouse
  B. Increasing the virtual warehouse maximum timeout limit
  C. Increasing the amount of remote storage for the virtual warehouse
  D. Using a Common Table Expression (CTE) instead of a temporary table
  A. Using a larger virtual warehouse

  ---

  Explanation

  Adjusting the available memory of a warehouse can improve performance because a query runs substantially slower when a warehouse runs out of memory, which results in bytes "spilling" onto storage. https://docs.snowflake.com/en/user-guide/performance-query-warehouse

• Question 1675:

  In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  A. When the system has enough load for 2 minutes
  B. When the system has enough load for 6 minutes
  C. When the system has enough load for 8 minutes
  D. When the system has enough load for 10 minutes
  B. When the system has enough load for 6 minutes

  ---

  Explanation

• Question 1676:

  Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  A. SHOW GRANTS OF ROLE MY_ROLE
  B. SHOW GRANTS TO ROLE MY_ROLE
  C. SHOW GRANTS FOR ROLE MY_ROLE
  D. SHOW GRANTS ON ROLE MY_ROLE
  A. SHOW GRANTS OF ROLE MY_ROLE

  ---

  Explanation

• Question 1677:

  How can a user work with multiple assigned roles without the need to frequently switch roles?

  A. Use secondary roles and primary roles.
  B. Grant the user the ACCOUNTADMIN role.
  C. Grant the user the parent role of the roles that have been assigned.
  D. Create a new role and grant it to the user, then grant the existing roles to the new role.
  A. Use secondary roles and primary roles.

  ---

  Explanation

• Question 1678:

  Which Snowflake partner category is represented at the top of this diagram (labeled 1)?

  

  A. Business Intelligence
  B. Machine Learning and Data Science
  C. Security and Governance
  D. Data Integration
  D. Data Integration

  ---

  Explanation

• Question 1679:

  If a network policy is applied at both the account and user levels, which policy takes precedence?

  A. The account-level policy
  B. The user-level policy
  C. The most-restrictive policy
  D. The policy that was applied first
  C. The most-restrictive policy

  ---

  Explanation

• Question 1680:

  How can a Snowflake user optimize query performance in Snowflake? (Choose two.)

  A. Create a view.
  B. Cluster a table.
  C. Enable the search optimization service.
  D. Enable Time Travel.
  E. Index a table.
  B. Cluster a table.
  C. Enable the search optimization service.

  ---

  Explanation