You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB)
of storage.
The database must support 50 concurrent logins. You must minimize the cost associated with hosting the
database.
You need to create the database.
Which pricing tier should you use?
A.
Standard S3 pricing tier
B.
Premium P2 tier
C.
Standard S2 pricing tier
D.
Premium P1 tier
Explanation:
For a database size of 500 GB the Premium tier is required.
Both P1 and P2 are adequate. P1 is preferred as it is cheaper.
Note:
Incorrect Answers:
A, C: Maximum database size is 250 GB for the Standard pricing tier.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers
