You need to recommend an Azure SQL Database service tier.
What should you recommend?
A . Business Critical
B . General Purpose
C . Premium
D . Standard
E . Basic
Answer: C
Explanation:
The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs.
Note: There are three architectural models that are used in Azure SQL Database:
– General Purpose/Standard
– Business Critical/Premium
– Hyperscale
Incorrect Answers:
A: Business Critical service tier is designed for the applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), fast recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database.
Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-business-critical