Exam-Answer

Home / Microsoft / AZ-300 / Question 110

Prev Question
Next Question

Question 110

A company wants to set up an elastic pool to support 20 single SQL databases that are managed as part of the same SQL database server. Database Transaction Unit (DTU) utilization is as follows:

* Average DTU utilization per database - 18

* Peak DTU utilization per database - 47

* Number of concurrently peaking databases - 2

You need to determine the size of the elastic DTU (eDTU) pool you need to configure.

Which pool size should you configure?

Answers


Advertisement

Explanation

You should configure a 400 eDTU pool. The following are used to calculate the pool size:

Number of databases X average DTU per database

Number of currently peaking databases X peak DTU

The larger value of the two is used to determine the eDTU pool.

20 (databases) X 18 (average DTU) = 360

2 (concurrent peaks) X 47 (peak DTU) = 94

The larger value, 360, is used. The nearest fit from the supported eDTU pool sizes is 400.

You should not choose 100 or 200. Neither is sufficient to support the pool requirements.

You should not choose 360. This is not supported as a pool size.

References

Comments

Load more
Prev Question
Next Question