Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1061:

  Which of the following items does the Cloud services Layer manage? Choose 4 answers

  A. user authentication

  B. Metadata

  C. Query compilation and optimization

  D. external blob storage

  E. Data security

  Correct Answer: ABCE

• Question 1062:

  What privileges are required to create a task?

  A. The global privilege create task is required to create a new task.

  B. Tasks are created at the Application level and can only be created by the Account Admin role.

  C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

  D. The role must have access to the target schema and the create task privilege on the schema itself.

  Correct Answer: D

  All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema. https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

• Question 1063:

  Which of the following roles is recommended to be used to create and manage users and roles?

  A. SYSADMIN

  B. SECURITYADMIN

  C. PUBLIC

  D. ACCOUNTADMIN

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

• Question 1064:

  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 1065:

  True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 1066:

  True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

  A. True

  B. False

  Correct Answer: A

• Question 1067:

  To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  A. Configure the Maximum Clusters setting to "Auto-Scale"

  B. Set the Warehouse type to "Auto"

  C. Set the Minimum Clusters and Maximum Clusters settings to the same value

  D. Set the Minimum Clusters and Maximum Clusters settings to the different values

  Correct Answer: D

  Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

• Question 1068:

  True or False: You can resize a Virtual Warehouse while queries are running.

  A. True

  B. False

  Correct Answer: A

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

• Question 1069:

  What is the recommended Snowflake data type to store semi-structured data like JSON?

  A. VARCHAR

  B. RAW

  C. LOB

  D. VARIANT

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

• Question 1070:

  What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

  A. Standard

  B. Premier

  C. Enterprise

  D. Business Critical Edition

  Correct Answer: C

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