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.
Hot Area:
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
http://msdn.microsoft.com/en-us/library/azure/dn369873.aspx
