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

Page 25 of 83
PDF with 330 Questions

What features does Snowflake Time Travel enable?

  1. Querying data-related objects that were created within the past 365 days
  2. Restoring data-related objects that have been deleted within the past 90 days
  3. Conducting point-in-time analysis for Bl reporting
  4. Analyzing data usage/manipulation over all periods of time

Answer(s): B

Explanation:

Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:
Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.
Duplicating and backing up data from key points in the past.
Analyzing data usage/manipulation over specified periods of time.


Reference:

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



Which statement about billing applies to Snowflake credits?

  1. Credits are billed per-minute with a 60-minute minimum
  2. Credits are used to pay for cloud data storage usage
  3. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
  4. Credits are consumed based on the warehouse size and the time the warehouse is running

Answer(s): D

Explanation:

Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.


Reference:

https://docs.snowflake.com/en/user-guide/what-are-credits.html



What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

  1. The ability to scale up warehouses
  2. The use of warehouse auto scaling
  3. The ability to resize warehouses
  4. Use of multi-clustered warehouses
  5. The use of warehouse indexing

Answer(s): B,D



When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  1. Use multi-clustered warehousing to scale out warehouse capacity.
  2. Scale up the warehouse size to allow Queries to execute faster.
  3. Stop and start the warehouse to clear the queued queries
  4. Migrate some queries to a new warehouse to reduce load
  5. Limit user access to the warehouse so fewer queries are run against it.

Answer(s): A,D






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

COF-R02 Discussions & Posts