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

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

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

by Syldana at Sept. 28, 2021, 9:41 a.m.

Comments

Submit Cancel

Syldana

Highly Voted 3 years, 10 months ago

Answer is correct

upvoted 15 times

voodoo_sh

8 months 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, 4 months 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, 7 months ago

The SKU type of Standard is only available in DTU pricing model

upvoted 10 times

...

vcloudpmp

Most Recent 2 years 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

2 years, 2 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, 5 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, 4 months 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, 3 months ago

The provided answer is correct, because the tier is Standard and the DTU is 10. It was my mistake.

upvoted 2 times

freemun05

3 years, 3 months ago

so? I just created Azure SQL on Standard DDUs = 10

upvoted 1 times

...

MissEl

2 years, 2 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, 9 months ago

i cant find why is this DTU ...

upvoted 1 times

quermi

3 years, 8 months ago

the value of "capacity" = 10

upvoted 4 times

...

susejzepol

2 years, 2 months ago

In my opion can because the value of tier is "standard" (sku/tier="standard").

upvoted 1 times

...