CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 14)

Page 13 of 83
PDF with 330 Questions

True or False: Pipes can be suspended and resumed.

  1. True
  2. False

Answer(s): A

Explanation:

Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:


Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes



Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  1. The validation_mode option is used when creating an Internal Stage
  2. validation_mode=return_all_errors is a parameter of the copy command
  3. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
  4. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer(s): B,D


Reference:

https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html



What privileges are required to create a task?

  1. The global privilege create task is required to create a new task.
  2. Tasks are created at the Application level and can only be created by the Account Admin role.
  3. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
  4. The role must have access to the target schema and the create task privilege on the schema itself.

Answer(s): D

Explanation:

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.


Reference:

https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks



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

  1. True
  2. False

Answer(s): A

Explanation:

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






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts