HOTSPOT
You have an Azure SQL Database named Contosodb. Contosodb is running in the Standard/S2 tier and has
a service level objective of 99 percent.
You review the service tiers in Microsoft Azure SQL Database as well as the results of running performance
queries for the usage of the database for the past week as shown in the exhibits. (Click the Exhibits
button.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Answer:

Explanation:
* The P1 performance level has 100 DTUs compared to the 200 DTUs of the P2 performance level. That
means that the P1 performance level provides half the performance of the P2 performance level. So 50%
of CPU utilization in P2 equals 100% CPU utilization in P1. As long as the application does not have
timeouts, it may not matter if a big job takes 2 hours or 2.5 hours to complete as long as it gets done
today. An application in this category can probably just use a P1 performance level. You can take
advantage of the fact that there are periods of time during the day where resource usage is lower,
meaning that any “big peak” might spill over into one of the
*

Azure SQL Database Performance Guidance
URL: http://msdn.microsoft.com/en-us/library/azure/dn369873.aspx