Q: 4
Your company has on-premises Microsoft SQL Server databases.
The company plans to move the databases to Azure.
You need to recommend a secure architecture for the databases that will minimize operational
requirements for patching and protect sensitive data by using dynamic data masking. The solution
must minimize costs.
What should you include in the recommendation?
Options
Discussion
C. Azure SQL Database
C , saw similar logic in the official guide and practice questions for SC-100.
A tbh. I've seen similar exam questions pick A, since Managed Instance handles patching and supports masking too.
Not A, C. Managed Instance adds cost and you only need database-level features here.
C, easy call here
C
Option C for me. SQL Database keeps patching simple, has DDM built in, plus it's cheapest overall. Pretty sure that's what they're looking for here.
C tbh, had something like this in a mock. Azure SQL Database covers patching and data masking with less effort or cost than the other options.
C , Azure SQL Database makes patching hands-off and supports dynamic data masking natively. Managed Instance (A) is more expensive and really only needed for full instance-level features, which the question doesn't mention. Saw this same logic in Microsoft official docs and a few practice tests.
A but what if you need agent jobs or full instance-level features? Managed Instance cuts down patching too.
Be respectful. No spam.
