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 1 Question 58 Discussion

Actual exam question for Microsoft's SC-100 exam
Question #: 58
Topic #: 1
[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

Contribute your Thoughts:

Shantell
29 days ago
I'm going with Option D. Intel SGX sounds like the kind of high-tech, futuristic solution that will impress the examiners. Plus, it has 'Intel' in the name, so it must be good, right?
upvoted 0 times
Alyce
3 days ago
User 2: Yeah, I agree. It's always good to go with high-tech solutions for security.
upvoted 0 times
...
Jarvis
8 days ago
User 1: I think Option D is the way to go. Intel SGX enclaves sound impressive and futuristic.
upvoted 0 times
...
...
Erasmo
1 months ago
Wow, this question is really specific. I bet the exam writers spent way too much time coming up with these obscure Azure options. I just hope I don't have to explain the difference between VBS and SGX enclaves on the exam!
upvoted 0 times
...
Geraldo
1 months ago
I'm not sure about the virtualization-based security options. I think we should go with the Azure SQL Managed Instance with Always Encrypted, as it's a more well-known and proven solution.
upvoted 0 times
Janessa
7 days ago
Let's go with that option then, it seems like the best fit for our requirements.
upvoted 0 times
...
Teddy
19 days ago
I agree, it's a reliable solution for encrypting sensitive data.
upvoted 0 times
...
Isreal
25 days ago
I think Azure SQL Managed Instance with Always Encrypted is the way to go.
upvoted 0 times
...
...
Aileen
1 months ago
I agree with Frank, B seems to be the best option as it meets all the specified requirements.
upvoted 0 times
...
Salley
1 months ago
Option D looks like the best fit. Azure SQL Database with Intel SGX enclaves covers all the requirements, including hardware-based encryption and preventing database admins from accessing sensitive data.
upvoted 0 times
Matthew
18 days ago
Yes, Azure SQL Database with Intel SGX enclaves seems like the most secure and suitable option for this scenario.
upvoted 0 times
...
Marcelle
25 days ago
I agree, Option D seems to meet all the specified requirements for migrating the database to Azure.
upvoted 0 times
...
Graham
30 days ago
Option D looks like the best fit. Azure SQL Database with Intel SGX enclaves covers all the requirements, including hardware-based encryption and preventing database admins from accessing sensitive data.
upvoted 0 times
...
...
Frank
2 months ago
But D doesn't support Microsoft Azure Attestation, which is one of the requirements.
upvoted 0 times
...
Sarah
2 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
...
Frank
2 months ago
I think the answer is B) Azure SQL Database with virtualization-based security (VBS) enclaves.
upvoted 0 times
...

Save Cancel