Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 4 question 8 discussion

Actual exam question from Microsoft's DP-201

Question #: 8
Topic #: 4

A company has many applications. Each application is supported by separate on-premises databases.
You must migrate the databases to Azure SQL Database. You have the following requirements:
✑ Organize databases into groups based on database usage.
✑ Define the maximum resource limit available for each group of databases.
You need to recommend technologies to scale the databases to support expected increases in demand.
What should you recommend?

A. Read scale-out
B. Managed instances
C. Elastic pools
D. Database sharding

Show Suggested Answer

Suggested Answer: C 🗳️
SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price.
You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model.
Incorrect Answers:
D: Database sharding is a type of horizontal partitioning that splits large databases into smaller components, which are faster and easier to manage.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

by epgd at Feb. 7, 2020, 12:44 p.m.

Comments

Submit Cancel

AhmedReda

Highly Voted 4 years, 10 months ago

Answer is correct (C) Elastic Pool Search for "maximum resource limit" in the below link https://docs.microsoft.com/en-us/azure/azure-sql/database/scale-resources

upvoted 24 times

...

syu31svc

Highly Voted 4 years, 5 months ago

100% C for correct

upvoted 6 times

...

201p

Most Recent 5 years ago

Why not B? Since its a migration case. Managed instance would be more suited.

upvoted 2 times

BHAWS

4 years, 11 months ago

Do not confuse

upvoted 5 times

...

mmat

4 years, 10 months ago

How do you create database groups and allocate resources to those groups on managed instance? Elastic pools seems as an obvious answer considering the emphasis on "groups".

upvoted 6 times

...

epgd

5 years, 3 months ago

Why is Elastic Pool when the increases are expected...?¿

upvoted 1 times

Loai

5 years ago

because of "Define the maximum resource limit available"

upvoted 10 times

...

Leonido