You plan to deploy an on-premises SQL Server 2014 database to Azure SQL Database. You have the following requirements:
- Maximum database size of 500 GB
- A point-in-time-restore of 35 days
- Maximum database transaction units (DTUs) of 500
You need to choose the correct service tier and performance level. Which service tier should you choose?
A. Standard S3
B. Premium P4
C. Standard SO
D. Basic
Explanation:
You should choose Premium P4. The Premium tier is the highest Azure SQL Database tier offered. This tier is used for databases and application that require the highest level of performance and recovery. The P4 level supports a maximum of 500 DTUs, a maximum database size of 500 GB, and a point-in-time-restore to any point in the last 35 days.
Incorrect Answers:
A: You should not choose Standard S3. The Standard tier with a performance level of S3 only supports a maximum database size of 250 GB. a maximum of 100 DTUs, and a point-in-timerestore of 35 days.
C: You should not choose Standard SO. The Standard tier with a performance level of SO only supports a maximum database size of 250 GB. a maximum of 10 DTUs, and a point-in-timerestore of 35 days.
D: You should not choose Basic. The Basic service tier only supports a maximum database size of 2 GB, a maximum of 5 DTUs, and a point-in-time-restore of 7 days.
References: https://azure.microsoft.com/en-us/pricing/details/sql-database/