which configuration option should you use?

HOTSPOT
You have an application that uses three separate databases to store application data, logs, and application
security details. The maximum database throughput unit (DTU) per database does not exceed 50. You plan to
deploy the application to Azure.
You need to recommend a configuration for the databases that minimizes costs.
For each requirement, which configuration option should you use? To answer, select the appropriate
configuration option from each list in the answer area.
Hot Area:

HOTSPOT
You have an application that uses three separate databases to store application data, logs, and application
security details. The maximum database throughput unit (DTU) per database does not exceed 50. You plan to
deploy the application to Azure.
You need to recommend a configuration for the databases that minimizes costs.
For each requirement, which configuration option should you use? To answer, select the appropriate
configuration option from each list in the answer area.
Hot Area:

Answer:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Ted Bundy

Chris L

Chris L

Thanks Ted. Useful link. 😉

Scott

Scott

I disagree, i think it should be Elastic Pools.

https://peter.intheazuresky.com/2016/08/29/elastic-database-pools-purpose-when-and-why/

the question says the max is 50 DTU’s but it doesn’t say what the average is or if that’s consistent. Microsoft even states that elastic pools are the “Cost-effective” way of setting up multiple databases.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

Gary Trembath

Gary Trembath

Elastic & Basic will provide 50eDTU to serve 3 sql database for the lowest cost

marketymark

marketymark

I feel pretty confident Individual / Standard is correct, at least based on current pricing.

3 x 50DTU | Single Database | Standard[£56] = £167
200 eDTU | elastic Pool | Basic| [500DBs] = £220.05

Since it’s up to 50 DTU per database, the lower performance level package of 50 eDTUs on the elastic pool would not meet the requirements as that’s for the entire elastic pool so you need the 200 eDTUs package (150 is not an option)