Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-300 Exam - Topic 4 Question 132 Discussion

You have five on-premises servers that have Microsoft SQL Server 2022 Enterprise installed Each server contains multiple database that store data for web apps and are backed up by using a third-party backup solution.You plan to migrate the databases to Azure.You need to recommend a solution to host the databases. The solution must meet the following requirements:* Compute and storage resources must be shared across the databases.* Costs must be minimized.What should you include in the recommendation?
B) in Azure SQL Database elastic pool
A) SQL Server on Azure Virtual Machines
C) Azure SQL Database
D) Azure SQL Managed Instance

Microsoft DP-300 Exam - Topic 4 Question 132 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 132
Topic #: 4
[All DP-300 Questions]

You have five on-premises servers that have Microsoft SQL Server 2022 Enterprise installed Each server contains multiple database that store data for web apps and are backed up by using a third-party backup solution.

You plan to migrate the databases to Azure.

You need to recommend a solution to host the databases. The solution must meet the following requirements:

* Compute and storage resources must be shared across the databases.

* Costs must be minimized.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

0/2000 characters
Ethan
3 days ago
I think B is the best choice. Elastic pools save costs.
upvoted 0 times
...
Svetlana
8 days ago
D) Azure SQL Managed Instance seems like overkill for just sharing resources.
upvoted 0 times
...
Reuben
13 days ago
C) Azure SQL Database is too limiting for this scenario, right?
upvoted 0 times
...
Brendan
18 days ago
Wait, isn't A) SQL Server on Azure VMs more flexible?
upvoted 0 times
...
Pete
23 days ago
Totally agree, elastic pools are cost-effective for multiple databases!
upvoted 0 times
...
Genevive
29 days ago
I'd go with B) in Azure SQL Database elastic pool. It fits the shared resources requirement.
upvoted 0 times
...
Lacresha
1 month ago
I practiced a similar question before, and I believe the elastic pool is the best choice for sharing resources and minimizing costs.
upvoted 0 times
...
Adaline
1 month ago
I think Azure SQL Managed Instance could work too, but it might not be as cost-effective as the elastic pool option.
upvoted 0 times
...
Hobert
1 month ago
I'm not entirely sure, but I feel like SQL Server on Azure VMs could be more expensive since you have to manage the VMs yourself.
upvoted 0 times
...
Dewitt
2 months ago
I remember studying about Azure SQL Database elastic pools, and I think they allow for shared resources, which might fit the requirement.
upvoted 0 times
...

Save Cancel