PrepAway - Latest Free Exam Questions & Answers

Which pricing tier should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

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

2 Comments on “Which pricing tier should you use?

  1. Caspar says:

    Currently (april 2018) the answer is A in my opinion. Recently the max database sizes of S3 and higher have been increased to 1 TB. And S3 offers 200 max concurrent logins. See page 3 of Microsoft exam ref 70-765.




    2



    0

Leave a Reply