You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?
You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?
Given the requirements of minimizing Azure resource costs, storing data in a sharded Azure SQL Database, and allowing multiday outages with a 70 percent SLA, the General purpose Azure SQL Database single database is the suitable recommendation. The General purpose tier offers a balance between cost and performance. Business critical tiers provide higher performance and availability, which are unnecessary given the allowance for multiday outages. Moreover, Managed Instances are not suitable for sharded databases according to Azure documentation, making the single database option the best fit for these criteria.
Why use Managed Instance? No mention about migrating on-prem SQL Server to Azure SQL Server
i think so. answer should be D
In requirement, it says "sharded Azure SQL Database."
The answer is : corret
Key point: shared DB. Answer is correct
The text is "Sharded" not "shared".n If the text is shared then you are right. But as per the text, correct answer is D.
Exam is for Azure solutions
Sharded is not applicable to Managed Instances as clearly stated in the MS documentation below. I think it can be done in MI indirectly via linked servers but your costs go up therefore making the Azure SQL DB the more cost-effective option. The answer should be D. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management