PrepAway - Latest Free Exam Questions & Answers

What will be the impact of pausing resources?

HOTSPOT
You deploy a Microsoft Azure SQL Data Warehouse instance. The instance must be available eight hours each day.
You need to pause Azure resources when they are not in use to reduce costs.
What will be the impact of pausing resources? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

the database during the night and on weekends, you can pause it during those times, and resume it during theday. You won’t be charged for DWUs while the database is paused.

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

To save costs, you can pause and resume compute resources on-demand. For example, if you won’t be using
When you pause a database:
Compute and memory resources are returned to the pool of available resources in the data center
Data Warehouse Unit (DWU) costs are zero for the duration of the pause.
Data storage is not affected and your data stays intact.
SQL Data Warehouse cancels all running or queued operations.
When you resume a database:
SQL Data Warehouse acquires compute and memory resources for your DWU setting.
Compute charges for your DWUs resume.
Your data will be available.
You will need to restart your workload queries.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-managecompute-rest-api


Leave a Reply