exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 12 discussion

Actual exam question from Microsoft's DP-300
Question #: 12
Topic #: 6
[All DP-300 Questions]

You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?

  • A. two Azure SQL Databases in an elastic pool
  • B. two databases hosted in SQL Server on an Azure virtual machine
  • C. two databases in an Azure SQL Managed instance
  • D. two single Azure SQL databases
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
Azure 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 server and share a set number of resources at a set price.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Dbayusuf
Highly Voted 5 months, 1 week ago
Elastic pool distributes workload across databases in a cluster,seems right
upvoted 12 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago