What should you recommend?

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

View Answer

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.

References:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-business-critical