QUESTION: 97

What features does Snowflake Time Travel enable?

Querying data-related objects that were created within the past 365 days
Restoring data-related objects that have been deleted within the past 90 days
Conducting point-in-time analysis for Bl reporting
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

Reveal Solution Next Question

QUESTION: 98

Which statement about billing applies to Snowflake credits?

Credits are billed per-minute with a 60-minute minimum
Credits are used to pay for cloud data storage usage
Credits are consumed based on the number of credits billed for each hour that a warehouse runs
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

Reveal Solution Next Question

QUESTION: 99

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

The ability to scale up warehouses
The use of warehouse auto scaling
The ability to resize warehouses
Use of multi-clustered warehouses
The use of warehouse indexing

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 100

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).

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

Answer(s): A,D

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 25)

QUESTION: 97

Explanation:

Reference:

QUESTION: 98

Explanation:

Reference:

QUESTION: 99

QUESTION: 100