Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 601:

  A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

  How can this requirement be met?

  A. Use data encryption.
  B. Use dynamic data masking.
  C. Use secure materialized views.
  D. Revoke all roles for functional managers and end users.
  B. Use dynamic data masking.

  ---

  Explanation

• Question 602:

  Which con guration of the function PARSE_JSON( ) will retrieve a valid SQL NULL value?

  A. SELECT parse_json(NULL)
  B. SELECT parse_json('null')
  C. SELECT parse_json('[ null ]')
  D. SELECT parse_json('{"a": null}'):a
  B. SELECT parse_json('null')

  ---

  Explanation

• Question 603:

  When should a multi-cluster virtual warehouse be used in Snowflake?

  A. When queuing is delaying query execution on the warehouse
  B. When there is significant disk spilling shown on the Query Profile
  C. When dynamic vertical scaling is being used in the warehouse
  D. When there are no concurrent queries running on the warehouse
  A. When queuing is delaying query execution on the warehouse

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster#what-is-a-multi-cluster-warehouse

• Question 604:

  What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

  A. The stage definition
  B. The table definition
  C. The use of a copy into statement
  D. The use of a copy into statement
  C. The use of a copy into statement

  ---

  Explanation

• Question 605:

  What privilege is needed for a Snowflake user to see the definition of a secure view?

  A. OWNERSHIP
  B. MODIFY
  C. CREATE
  D. USAGE
  A. OWNERSHIP

  ---

  Explanation

• Question 606:

  What are benefits of using reader accounts when sharing data in Snowflake? (Select TWO)

  A. Consumers can create and apply masking policies to unloaded data.
  B. Consumers can use resource monitors to track and limit costs.
  C. Consumers can use a single reader account to access data from multiple data providers.
  D. Providers can share data with consumers who do not have Snowflake accounts.
  E. Consumers can unload data using the COPY INTO command.
  C. Consumers can use a single reader account to access data from multiple data providers.
  D. Providers can share data with consumers who do not have Snowflake accounts.

  ---

  Explanation

  Reader accounts are created by data providers for consumers who do not have their own Snowflake accounts. This allows providers to share data without requiring the consumer to create or pay for their own Snowflake account. While a consumer can access multiple shares via a single reader account administrative functions , (like resource monitors) are managed by the provider.

  Snowflake Docs: Data Sharing: Reader Accounts

• Question 607:

  What happens to historical data when the retention period for an object ends?

  A. The data is cloned into a historical object.
  B. The data moves to Fail-safe
  C. Time Travel on the historical data is dropped.
  D. The object containing the historical data is dropped.
  D. The object containing the historical data is dropped.

  ---

  Explanation

• Question 608:

  What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?

  A. Improved performance for small, simple queries
  B. Improved performance for large, complex queries
  C. Decreased performance for large, complex queries
  D. Decreased consumption of Snowflake credits
  C. Decreased performance for large, complex queries

  ---

  Explanation

• Question 609:

  A Snowflake user wants to share data using my_share with account xy12345. Which command should be used?

  A. grant usage on share my_share to account xy12345;
  B. grant select on share my_share to account xy12345;
  C. alter share my_share add accounts = xy12345;
  D. alter account xy12345 add share my_share;
  C. alter share my_share add accounts = xy12345;

  ---

  Explanation

• Question 610:

  What mechanisms can be used to inform Snowpipe that there are staged files available to load into a Snowflake table? (Choose two.)

  A. Cloud messaging
  B. Email integrations
  C. Error notifications
  D. REST endpoints
  E. Snowsight interactions
  A. Cloud messaging
  D. REST endpoints

  ---

  Explanation