Microsoft Exam SC-100 Topic 3 Question 56 Discussion

Actual exam question for Microsoft's SC-100 exam

Question #: 56
Topic #: 3

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?

AAzure SQL Managed Instance

BAzure Synapse Analytics dedicated SQL pools

CAzure SQL Database

DSQL Server on Azure Virtual Machines

Show Suggested Answer

Suggested Answer: D

by Catina at Oct 20, 2024, 09:26 AM

Limited Time Offer

25%

Off

Get Premium SC-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Oretha

16 days ago

Wait, are we sure we can't just use a pigeons and paper clips architecture? That's gotta be the cheapest option, right?

upvoted 0 times

...

Marilynn

19 days ago

SQL Server on Azure Virtual Machines? Nah, that's just too much work. I'm with Pete - Azure SQL Managed Instance is the way to go.

upvoted 0 times

...

Filiberto

21 days ago

Hold up, did someone say 'minimize costs'? Looks like Azure Synapse Analytics is the way to go! It's probably the most cost-effective option, right?

upvoted 0 times

...

Carolynn

1 months ago

I was thinking Azure SQL Database, but Azure SQL Managed Instance makes more sense if they want to minimize operational requirements.

upvoted 0 times

Hannah

29 days ago

A) Azure SQL Managed Instance

upvoted 0 times

...

Leslee

2 months ago

I'm not sure, I think Azure SQL Database could also be a good choice to minimize costs.

upvoted 0 times

...

2 months ago

I think we should go with Azure SQL Managed Instance for secure architecture.

upvoted 0 times

...