Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 6 discussion

Actual exam question from Microsoft's DP-200

Question #: 6
Topic #: 1

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization.
Customer organizations have peak usage at different periods during the year.
You need to implement the Azure SQL Database elastic pool to minimize cost.
Which option or options should you configure?

A. Number of transactions only
B. eDTUs per database only
C. Number of databases only
D. CPU usage only
E. eDTUs and max data size

Show Suggested Answer

Suggested Answer: E 🗳️
The best size for a pool depends on the aggregate resources needed for all databases in the pool. This involves determining the following:
✑ Maximum resources utilized by all databases in the pool (either maximum DTUs or maximum vCores depending on your choice of resourcing model).
✑ Maximum storage bytes utilized by all databases in the pool.
Note: Elastic pools enable the developer to purchase resources for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases. You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

by induna at June 24, 2020, 7:59 p.m.

Comments

Submit Cancel

induna

Highly Voted 5 years ago

An additional note from the reference link: "There is no per-database charge for elastic pools. You are billed for each hour a pool exists at the highest eDTU or vCores, regardless of usage or whether the pool was active for less than an hour." So no need to figure out the needs of an individual database to size the pool

upvoted 10 times

...

JESUSBB

Most Recent 4 years, 4 months ago

Answer E

upvoted 4 times

...

chaoxes

4 years, 6 months ago

Answer is correct - E. How do I choose the correct pool size? The best size for a pool depends on the aggregate resources needed for all databases in the pool. This involves determining the following: -> Maximum resources utilized by all databases in the pool (either maximum DTUs or maximum vCores depending on your choice of purchasing model). -> Maximum storage bytes utilized by all databases in the pool. Source: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

upvoted 3 times

...

syu31svc

4 years, 7 months ago

Link provided supports E as the right answer

upvoted 1 times

...

ThieryLeLuronNadieline

4 years, 7 months ago

indeed the correct answer is E

upvoted 1 times

...

Egocentric

4 years, 7 months ago

answer is E

upvoted 1 times

...

Rickii

4 years, 10 months ago

Answer is E

upvoted 3 times

...

Vijaya

4 years, 10 months ago

so answer here is B i.e eDTU's per database only

upvoted 1 times

Varma_Saraswathula

4 years, 10 months ago

The best size for a pool depends on the aggregate resources needed for all databases in the pool. This involves determining the following: Maximum resources utilized by all databases in the pool (either maximum DTUs or maximum vCores depending on your choice of purchasing model). Maximum storage bytes utilized by all databases in the pool.

upvoted 2 times

...

groy

4 years, 9 months ago

Vijaya...please don't confuse people, answer is E!

upvoted 13 times

...