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: 22)

Page 21 of 83
PDF with 330 Questions

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  1. Internal stages
  2. Incremental backups
  3. Time Travel
  4. Zero-copy clones
  5. Fail-safe

Answer(s): C,E

Explanation:

Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.


Reference:

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



Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

  1. The user has the appropriate privileges on the objects associated with the query
  2. Micro-partitions have been reclustered since the query was last run
  3. The new query is run using the same virtual warehouse as the previous query
  4. The query includes a User Defined Function (UDF)
  5. The query has been run within 24 hours of the previously-run query

Answer(s): A,E



Which of the following are benefits of micro-partitioning? (Select TWO)

  1. Micro-partitions cannot overlap in their range of values
  2. Micro-partitions are immutable objects that support the use of Time Travel.
  3. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
  4. Rows are automatically stored in sorted order within micro-partitions
  5. Micro-partitions can be defined on a schema-by-schema basis

Answer(s): A,D


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html



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

  1. Standard Edition
  2. Enterprise Edition
  3. Business Critical Edition
  4. Virtual Private Snowflake Edition

Answer(s): B

Explanation:

Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support


Reference:

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






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

COF-R02 Discussions & Posts