New Year Sale ! 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 Exam SC-100 Topic 3 Question 44 Discussion

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

You have an on-premises server that runs Windows Server and contains a Microsoft SQL Server database named DB1.

You plan to migrate DB1 to Azure.

You need to recommend an encrypted Azure database solution that meets the following requirements:

* Minimizes the risks of malware that uses elevated privileges to access sensitive data

* Prevents database administrators from accessing sensitive data

* Enables pattern matching for server-side database operations

* Supports Microsoft Azure Attestation

* Uses hardware-based encryption

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Stefany at Jun 20, 2024, 11: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
Melynda
6 months ago
I agree with Edgar, A seems to be the most secure option based on the requirements given.
upvoted 0 times
...
Edgar
6 months ago
But D doesn't prevent database administrators from accessing sensitive data, so I still think A is the best option.
upvoted 0 times
...
Mona
6 months ago
I don't know, man. All these options sound like they're trying to out-encrypt each other. Why don't they just use a good old-fashioned lock and key? That's secure enough, right? (Just kidding, of course. Option B is the way to go.)
upvoted 0 times
Olga
5 months ago
Haha, yeah, a lock and key might not cut it for this level of security. Option B with Azure SQL Database is the way to go for sure.
upvoted 0 times
...
Miriam
5 months ago
Option B is definitely the best choice. It provides the necessary encryption and security features for migrating the database to Azure.
upvoted 0 times
...
...
Peggie
6 months ago
Hmm, I'm not sure. Option C with Always Encrypted also looks promising. But I guess the VBS enclaves in Option B provide an extra layer of security.
upvoted 0 times
...
Katheryn
6 months ago
I agree with Rozella. Azure SQL Database with VBS enclaves is the way to go. It's a secure option that protects against malware and prevents database admins from accessing sensitive data.
upvoted 0 times
Ty
5 months ago
D) Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves
upvoted 0 times
...
Julene
5 months ago
I agree with Rozella. Azure SQL Database with VBS enclaves is the way to go. It's a secure option that protects against malware and prevents database admins from accessing sensitive data.
upvoted 0 times
...
Cora
5 months ago
B) Azure SQL Database with virtualization-based security (VBS) enclaves
upvoted 0 times
...
Ronna
6 months ago
A) SQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves
upvoted 0 times
...
...
Son
6 months ago
I disagree, I believe the correct answer is D) Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves.
upvoted 0 times
...
Rozella
6 months ago
Option B seems like the best choice. It meets all the requirements, including the hardware-based encryption and Azure Attestation support.
upvoted 0 times
Albina
5 months ago
I agree, Azure SQL Database with virtualization-based security (VBS) enclaves is the way to go for this scenario.
upvoted 0 times
...
Breana
5 months ago
Option B seems like the best choice. It meets all the requirements, including the hardware-based encryption and Azure Attestation support.
upvoted 0 times
...
...
Edgar
7 months ago
I think the answer is A) SQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves.
upvoted 0 times
...

Save Cancel