Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 811:

  Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  A. Schema

  B. View

  C. Internal stage

  D. Table

  E. User

  F. Role

  Correct Answer: AD

• Question 812:

  Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  A. External Tokenization

  B. External Tables

  C. Materialized Views

  D. User-Defined Table Functions (UDTF)

  Correct Answer: A

• Question 813:

  When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  A. 10-50 MB

  B. 100-250 MB

  C. 300-500 MB

  D. 1000-1500 MB

  Correct Answer: B

• Question 814:

  Which command sets the Virtual Warehouse for a session?

  A. COPY WAREHOUSE FROM <>;

  B. SET WAREHOUSE = <>;

  C. USE WAREHOUSE <>;

  D. USE VIRTUAL_WAREHOUSE <>;

  Correct Answer: C

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

• Question 815:

  Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

  A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

  B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

  C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

  D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

  E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

  F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

  Correct Answer: DEF

• Question 816:

  What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  A. The warehouse size does not change until all queries currently running in the warehouse have completed.

  B. The warehouse size does not change until all queries currently in the warehouse queue have completed.

  C. The warehouse size does not change until the warehouse is suspended and restarted.

  D. It does not return from the command until the warehouse has finished changing its size.

  Correct Answer: D

• Question 817:

  Where is Snowflake metadata stored?

  A. Within the data files

  B. In the virtual warehouse layer

  C. In the cloud services layer

  D. In the remote storage layer

  Correct Answer: C

• Question 818:

  Which of the following describes the Snowflake Cloud Services layer?

  A. Coordinates activities in the Snowflake account

  B. Executes queries submitted by the Snowflake account users

  C. Manages quotas on the Snowflake account storage

  D. Manages the virtual warehouse cache to speed up queries

  Correct Answer: A

• Question 819:

  Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  A. CREATE_SHARE on the account

  B. SHARE on databases and schemas

  C. SELECT on tables used by the secure view

  D. REFERENCE_USAGE on databases

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 820:

  What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  A. 30 days

  B. 7 days

  C. 48 hours

  D. 24 hours

  Correct Answer: D