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:
Argggg I hate when Colin E-mails me!!!
0
0
I would say no-no-no
0
0
How do we answer this without Microsoft revealing any info on how to calculate DTU based on the metrics/parameters?
DTU calc is a combination of the following-
•Processor – % Processor Time
•Logical Disk – Disk Reads/sec
•Logical Disk – Disk Writes/sec
•Database – Log Bytes Flushed/sec
S1 is 20 DTUs while S2 is 50. So how do we know if downgrading to S1 will still meet the performance?
Grrrr!!!
0
0
Answer”E”
0
0
Wrongly pasted
0
0
The Answer should no-no-no.
There would be compromise in performance if downgraded from S2 tier to S1 or Basic.
As performance is measured in DTU for Azure SQL DB’s
And Upgrading to P1 will be more costly option.
0
0
If just using averages than it could be downgraded to an S1 tier. However the peaks are way too high for an S1 tier as S1 has about 60% less DTU than S2. I would think the answer would be no no no.
0
0