Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 291:

  Which of the following statement is true of Snowflake? Select one.

  A. It was built specifically for the cloud

  B. it was built as an on-premises solution and then potted to the cloud

  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

  D. It was built for Hadoop architecture

  E. It's based on an Oracle Architecture

  Correct Answer: A

• Question 292:

  Which of the following are true of multi-cluster Warehouses? Select all that apply below.

  A. A multi-cluster Warehouse can add clusters automatically based on query activity

  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

  C. A multi-cluster Warehouse can scale down when query activity slows

  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

  Correct Answer: ABCD

• Question 293:

  Which of the following DML commands isn't supported by Snowflake?

  A. UPSERT

  B. MERGE

  C. UPDATE

  D. TRUNCATE TABLE

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

• Question 294:

  When can a Virtual Warehouse start running queries?

  A. 12am-5am

  B. Only during administrator defined time slots

  C. When its provisioning is complete

  D. After replication

  Correct Answer: C

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

• Question 295:

  Which interfaces can be used to create and/or manage Virtual Warehouses?

  A. The Snowflake Web Interface (UI)

  B. SQL commands

  C. Data integration tools

  D. All of the above

  Correct Answer: D

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

• Question 296:

  True or False: A single database can exist in more than one Snowflake account.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 297:

  True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

  A. True

  B. False

  Correct Answer: A

  Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

• Question 298:

  True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  A. True

  B. False

  Correct Answer: B

• Question 299:

  True or False: It is possible to load data into Snowflake without creating a named File Format object.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

• Question 300:

  True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  A. True

  B. False

  Correct Answer: A

  Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.