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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft SC-100 Exam - Topic 3 Question 56 Discussion

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?
D) SQL Server on Azure Virtual Machines
A) Azure SQL Managed Instance
B) Azure Synapse Analytics dedicated SQL pools
C) Azure SQL Database

Microsoft SC-100 Exam - 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

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:

0/2000 characters
Submit Cancel
Fidelia
6 months ago
I’m surprised they didn’t consider Synapse Analytics for this!
upvoted 0 times
...
Lashawna
6 months ago
Wait, are we sure about the costs? Virtual Machines might add up.
upvoted 0 times
...
Shenika
7 months ago
Definitely go with Managed Instance for dynamic data masking!
upvoted 0 times
...
Annmarie
7 months ago
I think Azure SQL Database would be cheaper in the long run.
upvoted 0 times
...
Talia
7 months ago
Azure SQL Managed Instance is a solid choice for this!
upvoted 0 times
...
Phung
7 months ago
SQL Server on Azure VMs seems like it would require more management, which goes against the goal of minimizing operational requirements.
upvoted 0 times
...
Ona
8 months ago
I practiced a similar question, and I feel like Azure Synapse Analytics might be overkill for just moving databases.
upvoted 0 times
...
Eleonore
8 months ago
I'm not entirely sure, but I remember that Azure SQL Managed Instance could also be a good choice for compatibility with on-prem SQL Server.
upvoted 0 times
...
Dudley
8 months ago
I think Azure SQL Database might be the best option since it offers built-in features for dynamic data masking and reduces the need for patching.
upvoted 0 times
...
Salome
8 months ago
I'm not sure SQL Server on Azure VMs is the best fit here. The patching and management overhead might be higher than the other options.
upvoted 0 times
...
Jonell
8 months ago
I'm leaning towards Azure SQL Database. It offers dynamic data masking, which is a key requirement, and the serverless model could help minimize costs.
upvoted 0 times
...
Alpha
8 months ago
Azure SQL Managed Instance seems like the obvious choice here. It provides the security and patching benefits we need, and should be cost-effective compared to running VMs.
upvoted 0 times
...
Johnna
8 months ago
Hmm, I'm a bit unsure about the differences between the Azure SQL options. I'll need to review the key features of each one to determine the best fit.
upvoted 0 times
...
Sage
8 months ago
This looks like a tricky question. I'll need to carefully consider the requirements around security, patching, and cost minimization.
upvoted 0 times
...
Oretha
1 year 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
12 months ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Nicolette
12 months ago
C) Azure SQL Database
upvoted 0 times
...
Dorthy
1 year ago
B) Azure Synapse Analytics dedicated SQL pools
upvoted 0 times
...
Willis
1 year ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Marilynn
1 year 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
1 year 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
12 months ago
C) Azure SQL Database
upvoted 0 times
...
Annabelle
12 months ago
B) Azure Synapse Analytics dedicated SQL pools
upvoted 0 times
...
Alonzo
1 year ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Carolynn
1 year 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
1 year ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Ngoc
1 year ago
C) Azure SQL Database
upvoted 0 times
...
Hannah
1 year ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Leslee
1 year ago
I'm not sure, I think Azure SQL Database could also be a good choice to minimize costs.
upvoted 0 times
...
Pete
1 year 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
1 year ago
D) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Lorita
1 year ago
C) Azure SQL Database
upvoted 0 times
...
Ernest
1 year ago
A) Azure SQL Managed Instance
upvoted 0 times
...
...
Lizbeth
1 year 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
1 year ago
I think we should go with Azure SQL Managed Instance for secure architecture.
upvoted 0 times
...

Save Cancel