If an Azure SQL Data Warehouse is not going to be used for a few weeks, which of the following methods could be used to minimize ongoing costs and keep the database in place for later use?
Answers
To pause a database, use the Suspend-AzSqlDatabase cmdlet. The server is in an Azure aid organization named myResourceGroup.
Explanation:
Pause and resume for devoted SQL swimming pools can be automated by the use of Synapse Pipelines in Azure Synapse Analytics.
Pause and resume can be used to shop costs for a devoted SQL pool.
This solution can without trouble be blanketed with side the modern information orchestration process.
Sign in to the Azure portal, and choose your devoted SQL pool.
To pause compute, click on the Pause button.
To take away the devoted SQL pool so that you aren't charged for computing or storage, click on Delete
Answer:
Azure SQL Data Warehouse
Explanation:
There isn't anyt any manner to forestall SQL Azure Database to keep away from billing prices whilst now no longer in use. The azure digital gadget may be suspended and with the aid of using doing that you may keep away from hourly prices, however you can't do the equal with a SQL Azure Database that is charged hourly in line with database.
There are few options to lessen or forestall prices:
The pricing tier of SQL Azure Database may be modified to Basic.
Export the SQL Azure Database to Azure garage after which delete the SQL Azure Database and repair it whilst needed.
Delete your SQL Azure Database and later use point-in-time repair to repair your database relying at the pricing tier related to the database. Databases with Basic pricing tier may be restored inside 7 days after deleting it, even as the retention length for Standard is 14 days and for the Premium pricing tier is presently 35 days.
#spj2