ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam
Go to Exam

Exam DP-201 topic 5 question 4 discussion

Actual exam question from Microsoft's DP-201
Question #: 4
Topic #: 5
[All DP-201 Questions]

You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?

  • A. Business critical Azure SQL Database single database
  • B. General purpose Azure SQL Database Managed Instance
  • C. Business critical Azure SQL Database Managed Instance
  • D. General purpose Azure SQL Database single database
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Azure resource costs must be minimized where possible.
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
The SLA for Planning Assistance is 70 percent, and multiday outages are permitted.
by toandm at May 23, 2021, 4:26 a.m.

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
Submit Cancel
toandm
Highly Voted 4 years ago
Why use Managed Instance? No mention about migrating on-prem SQL Server to Azure SQL Server
upvoted 6 times
Dhaval_Azure
3 years, 11 months ago
In requirement, it says "sharded Azure SQL Database."
upvoted 1 times
...
memo43
4 years ago
i think so. answer should be D
upvoted 10 times
...
...
BigMF
Most Recent 3 years, 11 months ago
Sharded is not applicable to Managed Instances as clearly stated in the MS documentation below. I think it can be done in MI indirectly via linked servers but your costs go up therefore making the Azure SQL DB the more cost-effective option. The answer should be D. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management
upvoted 1 times
...
Abyodp
3 years, 12 months ago
Key point: shared DB. Answer is correct
upvoted 2 times
bsa_2021
3 years, 11 months ago
The text is "Sharded" not "shared".n If the text is shared then you are right. But as per the text, correct answer is D.
upvoted 2 times
...
...
Qrm_1972
4 years ago
The answer is : corret
upvoted 3 times
...
g935f
4 years ago
Exam is for Azure solutions
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