Exam DP-200 topic 1 question 18 discussion

Actual exam question from Microsoft's DP-200

Question #: 18
Topic #: 1

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization.
Customer organizations have peak usage at different periods during the year.
Which two factors affect your costs when sizing the Azure SQL Database elastic pools? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. maximum data size
B. number of databases
C. eDTUs consumption
D. number of read operations
E. number of transactions

Show Suggested Answer

Suggested Answer: AC 🗳️
A: With the vCore purchase model, in the General Purpose tier, you are charged for Premium blob storage that you provision for your database or elastic pool.
Storage can be configured between 5 GB and 4 TB with 1 GB increments. Storage is priced at GB/month.
C: In the DTU purchase model, elastic pools are available in basic, standard and premium service tiers. Each tier is distinguished primarily by its overall performance, which is measured in elastic Database Transaction Units (eDTUs).
References:
https://azure.microsoft.com/en-in/pricing/details/sql-database/elastic/

by EYIT at Sept. 6, 2020, 9:45 p.m.

Comments

Submit Cancel

chaoxes

Highly Voted 4 years, 5 months ago

Number of databases is not affecting pricing. What affects is: Storage: maximum data size eDTU: elasitc database throughput unit - unit of measurement used to determine scale in elastic pool. Thus correct answers: A & C

upvoted 17 times

...

syu31svc

Highly Voted 4 years, 5 months ago

A & C 100%

upvoted 5 times

...

EYIT

Most Recent 4 years, 8 months ago

out of scope post July 2020

upvoted 1 times

azp

4 years, 6 months ago

nope its not

upvoted 4 times

...

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 18 discussion

Comments

chaoxes

syu31svc

EYIT

azp

SY0-701