Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 181:

  Which data type can be used to store geospatial data in Snowflake?

  A. Variant

  B. Object

  C. Geometry

  D. Geography

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

• Question 182:

  Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  A. The table contains a column that has very low cardinality

  B. DML statements that are being issued against the table are blocked

  C. The table has a small number of micro-partitions

  D. Queries on the table are running slower than expected

  E. The clustering depth for the table is large

  Correct Answer: AE

• Question 183:

  What is a best practice after creating a custom role?

  A. Create the custom role using the SYSADMIN role.

  B. Assign the custom role to the SYSADMIN role

  C. Assign the custom role to the PUBLIC role

  D. Add__CUSTOM to all custom role names

  Correct Answer: B

  When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

• Question 184:

  True or False: Fail-safe can be disabled within a Snowflake account.

  A. True

  B. False

  Correct Answer: B

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

  Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

• Question 185:

  What data is stored in the Snowflake storage layer? (Select TWO).

  A. Snowflake parameters

  B. Micro-partitions

  C. Query history

  D. Persisted query results

  E. Standard and secure view results

  Correct Answer: BD

• Question 186:

  What SQL command would be used to view all roles that were granted to user.1?

  A. show grants to user USER1;

  B. show grants of user USER1;

  C. describe user USER1;

  D. show grants on user USER1;

  Correct Answer: A

• Question 187:

  What is the minimum Snowflake edition required to create a materialized view?

  A. Standard Edition

  B. Enterprise Edition

  C. Business Critical Edition

  D. Virtual Private Snowflake Edition

  Correct Answer: B

  Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

• Question 188:

  A sales table FCT_SALES has 100 million records.

  The following Query was executed

  SELECT COUNT (1) FROM FCT__SALES;

  How did Snowflake fulfill this query?

  A. Query against the result set cache

  B. Query against a virtual warehouse cache

  C. Query against the most-recently created micro-partition

  D. Query against the metadata excite

  Correct Answer: D

• Question 189:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management

  B. Metadata management

  C. Query execution

  D. Query parsing and optimization

  E. Management of the storage layer

  Correct Answer: C

• Question 190:

  What are ways to create and manage data shares in Snowflake? (Select TWO)

  A. Through the Snowflake web interface (Ul)

  B. Through the DATA_SHARE=TRUE parameter

  C. Through SQL commands

  D. Through the enable__share=true parameter

  E. Using the CREATE SHARE AS SELECT * TABLE command

  Correct Answer: CD