exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 53 discussion

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

HOTSPOT
-

You have a Microsoft SQL Server 2017 server that hosts five databases.

You plan to migrate the databases to Azure.

You need to recommend a solution that meets the following requirements:

• Automatically scales compute based on the workload demand
• Provides per-second billing

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
eleeitor
Highly Voted 1 year, 7 months ago
We have five bds, SQL Database in serverless compute tier is for single databases.... so we would need no a single serverless SQL Databases... but five. We need to automatically scale compute based on workload, and be billed by the second...For five databses we would create an elastic pool ( with fixed min and max resources for automatic compute scaling of the bds), using vCore model, with provisioned compute tier so we are charged by the second(DTU model charges by hour). vCore model has General Purpose, Business Critical, and Hyperscale.... we would use GEneral purpose. Serverless compute tier es for single databases... so we would need five servers SQL Databases.... not "a single Azure SQL databases in the serverless compute tier".
upvoted 7 times
durdic
10 months, 2 weeks ago
On the other hand, you won't meet the "per-second billing" requirement unless you choose Serverless compute tier. Looks like another question with ambiguous answers, but I would vote "Single Azure database in the serverless compute tier" per each migrated database :).
upvoted 1 times
...
...
[Removed]
Highly Voted 1 year, 7 months ago
In the answer area, you should choose: Azure service: A single Azure SQL database in the serverless compute tier Service tier: General Purpose Here’s the explanation: A single Azure SQL database in the serverless compute tier: This service automatically scales compute based on the workload demand, which is one of your requirements. Additionally, the serverless tier offers per-second billing, allowing you to pay only for the compute you use. General Purpose service tier: This tier is typically available with the serverless compute model and offers a balanced and scalable compute and storage options suitable for most business workloads.
upvoted 5 times
...
Davidjsanchez
Most Recent 7 months, 1 week ago
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. Serverless compute tier - Azure SQL Database | Microsoft Learn
upvoted 1 times
...
MVFGrant
8 months, 2 weeks ago
Azure Service: Serveless computer tier Service Tier: General Purpose the key word is "per second billing" , serveless is the option to use, and General Purpose Service Tier works with it
upvoted 2 times
...
sca88
1 year, 1 month ago
The question talk about five database, so the answer "A single serverless SQL Database" must be to exclude. The only possible is the elastic pool ( with fixed min and max resources for automatic compute scaling). The tier must be a vCore one, because DTU is charged by hour, so the second answer is General Puropse
upvoted 2 times
...
vcloudpmp
1 year, 10 months ago
https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/ Serverless compute tier also mentioned here.
upvoted 3 times
...
vcloudpmp
1 year, 10 months ago
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql-db&tabs=general-purpose Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second.
upvoted 2 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 ...