Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam SC-100 Topic 3 Question 56 Discussion

Actual exam question for Microsoft's SC-100 exam
Question #: 56
Topic #: 3
[All SC-100 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

Oretha
1 months 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
Craig
10 days ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Nicolette
16 days ago
C) Azure SQL Database
upvoted 0 times
...
Dorthy
24 days ago
B) Azure Synapse Analytics dedicated SQL pools
upvoted 0 times
...
Willis
27 days ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Marilynn
2 months 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
2 months 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
Sheldon
9 days ago
C) Azure SQL Database
upvoted 0 times
...
Annabelle
13 days ago
B) Azure Synapse Analytics dedicated SQL pools
upvoted 0 times
...
Alonzo
24 days ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Carolynn
2 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
Shenika
24 days ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Ngoc
27 days ago
C) Azure SQL Database
upvoted 0 times
...
Hannah
2 months ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Leslee
3 months ago
I'm not sure, I think Azure SQL Database could also be a good choice to minimize costs.
upvoted 0 times
...
Pete
3 months ago
Azure SQL Managed Instance seems like the best fit here. It offers automated patching and dynamic data masking, which aligns with the requirements.
upvoted 0 times
Marlon
28 days ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Lorita
1 months ago
C) Azure SQL Database
upvoted 0 times
...
Ernest
2 months ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Lizbeth
3 months ago
I agree with Shawn, Azure SQL Managed Instance is the best option to minimize operational requirements and protect sensitive data.
upvoted 0 times
...
Shawn
3 months ago
I think we should go with Azure SQL Managed Instance for secure architecture.
upvoted 0 times
...

Save Cancel