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

Exam SC-100 All Questions

View all questions & answers for the SC-100 exam
Go to Exam

Exam SC-100 topic 3 question 33 discussion

Actual exam question from Microsoft's SC-100
Question #: 33
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?

  • A. SQL Server on Azure Virtual Machines
  • B. Azure Synapse Analytics dedicated SQL pools
  • C. Azure SQL Database
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by AzureJobsTillRetire at Feb. 21, 2023, 7:45 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
AzureJobsTillRetire
Highly Voted 2 years, 3 months ago
Selected Answer: C
Azure SQL Database is the correct option since SQLMI is not in the options
upvoted 12 times
...
emartiy
Most Recent 11 months, 2 weeks ago
Selected Answer: C
Question says "move the databases to Azure" So, here is not migration like move server to azure to operate in azure.. Moving data base to Azure.. So, option C is seem correct.
upvoted 2 times
...
emartiy
11 months, 2 weeks ago
Selected Answer: C
Researching on this topic show that answer is C.
upvoted 1 times
...
ConanBarb
1 year, 8 months ago
Selected Answer: A
"move" SQL srv db -> Azure M.I. "migrate" SQL srv db -> Azure SQLDB
upvoted 3 times
wsrudmen
1 year, 2 months ago
what is the difference between "move" and "migrate"?
upvoted 3 times
...
...
ConanBarb
1 year, 8 months ago
Selected Answer: C
This time the question reads: "The company plans to _move_ the databases to Azure." (in the previous similar question it said "migrate" ) And "move" to me means using backup-restore to re-host a database from one SQL Server to another. That threw me off guard from otherwise preferring the SQL Server option. So strictly interpreting "move" it should be A - SQL Server on VM However, I anyhow don't think that is the intention, and so C
upvoted 1 times
ConanBarb
1 year, 8 months ago
Typo, I meant "preferring the SQL Database option"
upvoted 1 times
...
Ramye
1 year, 4 months ago
The previous question Q23 also said move and not migrate but that question has one more extra answer choice to choose from.
upvoted 1 times
...
...
sherifhamed
1 year, 8 months ago
Selected Answer: C
C is the answer as Microsoft said https://learn.microsoft.com/en-us/azure/cloud-adoption-framework/secure/devsecops-controls#threat-modeling-start-simple
upvoted 3 times
...
zellck
2 years ago
Selected Answer: C
C is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
upvoted 3 times
...
uffman
2 years, 1 month ago
Selected Answer: C
Correct.
upvoted 3 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