exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 32 discussion

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

HOTSPOT -
You have the following Azure Resource Manager template.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

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
Syldana
Highly Voted 3 years, 7 months ago
Answer is correct
upvoted 15 times
voodoo_sh
4 months, 3 weeks ago
Agree. In the Template, there is Standard with 10 DTU capacity. There is no Serverless under DTU model. DTU databases can't be deployed to Azure SQL MI. No, No, Yes
upvoted 1 times
...
nicolase
3 years, 1 month ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart
upvoted 1 times
...
...
mnfatboy1
Highly Voted 3 years, 3 months ago
The SKU type of Standard is only available in DTU pricing model
upvoted 10 times
...
[Removed]
Most Recent 1 year, 5 months ago
No, the pricing tier specified in the provided template snippet is not based on DTUs (Database Transaction Units), but instead it's based on vCores. This is evident from the `sku` block in the snippet: ```json "sku" : { "name": "Standard", "tier": "Standard", "capacity": 10 } ``` In this block, the `capacity` property is set to `10`, which in the context of a vCore-based purchasing model would indicate the number of vCores. In a DTU-based model, the `tier` and `name` properties would typically be used to specify a performance level that includes a predefined number of DTUs, and you might see values like `Basic`, `Standard`, or `Premium` for the `name` property, along with a specific DTU count or range. In summary, the template is utilizing a vCore-based pricing model, not a DTU-based pricing model.
upvoted 5 times
...
vcloudpmp
1 year, 9 months ago
Managed instance uses a different resource type: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?view=azuresql-mi&tabs=azure-powershell type": "Microsoft.Sql/managedInstances", "apiVersion": "2021-11-01-preview", "name": "[parameters('managedInstanceName')]", "location": "[parameters('location')]",
upvoted 1 times
...
josf77
1 year, 11 months ago
all answers are correct. The first one is tricky which looks like correct but it is not. The keyword is "serverless" which is not available in DTU purchasing option.
upvoted 2 times
...
BrenFa101
2 years, 2 months ago
The selected sku is Standard which means the pricing model chosen is DTU and DTU does not support serverless.
upvoted 3 times
...
polinoma
3 years, 1 month ago
I think that it should be Yes, No, Yes, because the ARM template deploys a serverless SQL Database. Please correct me if I am wrong. Thanks
upvoted 1 times
polinoma
3 years ago
The provided answer is correct, because the tier is Standard and the DTU is 10. It was my mistake.
upvoted 2 times
freemun05
2 years, 12 months ago
so? I just created Azure SQL on Standard DDUs = 10
upvoted 1 times
...
...
MissEl
1 year, 11 months ago
The key word is to understand that DTU(we know its DTU because the service tier specified in the question is standard)pricing model supports only provisioned computers. While Vcore supports both Serverless and provisioned.
upvoted 1 times
...
...
matongax
3 years, 6 months ago
i cant find why is this DTU ...
upvoted 1 times
quermi
3 years, 5 months ago
the value of "capacity" = 10
upvoted 4 times
...
susejzepol
1 year, 11 months ago
In my opion can because the value of tier is "standard" (sku/tier="standard").
upvoted 1 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