Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 62 discussion

Actual exam question from Microsoft's DP-300

Question #: 62
Topic #: 1

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. General Purpose Standard
B. Business Critical Memory Optimized Premium
C. General Purpose Premium
D. Business Critical Premium
E. Business Critical Standard

Show Suggested Answer

Suggested Answer: ABC 🗳️

by igorclapa at Oct. 23, 2023, 1:42 a.m.

Comments

Submit Cancel

voodoo_sh

7 months, 3 weeks ago

Selected Answer: ABC

as of 2024/12/11 - A,B,C,D support up to 16 TB - according to this doc: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql#hardware-configuration-characteristics

upvoted 1 times

...

voodoo_sh

11 months, 3 weeks ago

I have two SQL MI - one at West US 2 and one at West US 3. General purpose are all up to 16 GB: - standard (up to 16 TB) - premium (up to 16 TB) - premium memory optimized (up to 16 TB) Business Critical show different limits, depending on region: West US 2: Business Critical - standard (up to 4 TB) - premium (up to 16 TB) - premium memory optimized (up to 16 TB) West US 3: Business Critical - standard (up to 4 TB) - premium (up to 5.5 TB) - premium memory optimized (up to 5.5 TB) It means at West US 2 answer is: A, B, C, D And at West US 3 answer is: A, C Bad job by Microsoft on such question. Hope won't get it at exam.

upvoted 1 times

...

Natali

12 months ago

By today, Business Critical Premium non-optimized is also supporting up to 16TB (I can literally see it in my Azure account UI). I hope they do not include this question in exam anymore, because hardware specs seem to grow more and more with time flow

upvoted 3 times

...

MJamesP

1 year, 4 months ago

Selected Answer: ABC

Answer is correct. Only Memory optimized premium-series in Business Critical tier supports up to 16TB, unlike all three series for General Purpose. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy?view=sql-server-ver16

upvoted 3 times

...

erz

1 year, 6 months ago

These service tiers do not have the "Standard" or "Premium" distinction that is common with other Azure SQL offerings like Azure SQL Database.

upvoted 1 times

...

ghola

1 year, 7 months ago

answer is perfect https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

upvoted 4 times

sca88

1 year, 3 months ago

Thanks for sharing this documentation link!

upvoted 1 times

...

igorclapa

1 year, 9 months ago

Answer is correct, you can confirm this with the Azure cost calculator. https://azure.microsoft.com/en-us/pricing/calculator/ SQL MI supports: Service Tier: 1. General Purpose 2. Business Critical Hardware Type: 1. Standard-series 2. Premium-series 3. Premium-series, memory optimized

upvoted 3 times

SamBalbij

1 year, 9 months ago

that makes no sense. I suspect the question is referring to an obsolete storage limit, as mentioned in: https://techcommunity.microsoft.com/t5/azure-sql-blog/increased-storage-limit-to-16-tb-for-sql-managed-instance/ba-p/2421443

upvoted 2 times

...