Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 831:

  A user has been granted the APPLY privilege on a masking policy that partially masks customer telephone numbers. Which additional privilege must be granted, so that the user can apply the masking policy to the relevant columns?

  A. SELECT on the relevant tables or views
  B. USAGE on the parent database and schemas
  C. USAGE on the parent schemas and SELECT on the relevant tables or views
  D. USAGE on the parent database and schemas and SELECT on the relevant tables or views
  D. USAGE on the parent database and schemas and SELECT on the relevant tables or views

  ---

  Explanation

• Question 832:

  The customer table in the T1 database is accidentally dropped. Which privileges are required to restore this table? {Select TWO).

  A. SELECT privilege on the customer table
  B. ownership privilege on the customer table
  C. All privileges on the customer table
  D. All privileges on the T1 database
  E. CREATE TABIE privilege on the T1 database
  D. All privileges on the T1 database
  E. CREATE TABIE privilege on the T1 database

  ---

  Explanation

• Question 833:

  What is a fundamental characteristic of Snowflake micro-partitions?

  A. They can be read directly as les.
  B. They serve as an index for Snowflake tables.
  C. They are sized based on Time Travel requirements.
  D. Once established, they cannot be changed.
  D. Once established, they cannot be changed.

  ---

  Explanation

• Question 834:

  You can resize a Virtual Warehouse while queries are running.

  A. True
  B. False
  A. True

  ---

  Explanation

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

• Question 835:

  A data provider shares a Snowflake secure view with a user who is outside of the provider's organization. Which parameter can the provider use to impersonate the user and access the view?

  A. CLIENT_METADATA_USE_SESSION_DATABASE
  B. ALLOWED_SHARES
  C. SIMULATED_DATA_SHARING_CONSUMER
  D. SHOW_SHARES
  C. SIMULATED_DATA_SHARING_CONSUMER

  ---

  Explanation

• Question 836:

  How can a user improve the performance of a single large complex query in Snowflake?

  A. Scale up the virtual warehouse.
  B. Scale out the virtual warehouse.
  C. Enable standard warehouse scaling.
  D. Enable economy warehouse scaling.
  A. Scale up the virtual warehouse.

  ---

  Explanation

  https://dzone.com/articles/snowflake-performance-tuning-top-5-best-practices

• Question 837:

  What type of account can be used to share data with a consumer who does have a Snowflake account?

  A. Data provider
  B. Data consumer
  C. Reader
  D. Organization
  A. Data provider

  ---

  Explanation

• Question 838:

  How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

  A. SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)
  B. SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)
  C. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)
  D. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)
  E. SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)
  B. SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)
  E. SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)

  ---

  Explanation

  SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS) SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS) BE give 10 rows

• Question 839:

  Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Choose two.)

  A. GO driver
  B. Node.js driver
  C. ODBC driver
  D. Python connector
  E. Spark connector
  C. ODBC driver
  D. Python connector

  ---

  Explanation

• Question 840:

  Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

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

  ---

  Explanation