Microsoft Exam SC-100 Topic 1 Question 58 Discussion

Actual exam question for Microsoft's SC-100 exam

Question #: 58
Topic #: 1

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?

ASQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves

BAzure SQL Database with virtualization-based security (VBS) enclaves

CAzure SQL Managed Instance that has Always Encrypted configured

DAzure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves

Show Suggested Answer

Suggested Answer: D

by Elliot at Dec 08, 2024, 11:44 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

But D doesn't support Microsoft Azure Attestation, which is one of the requirements.

upvoted 0 times

...

4 days ago

I disagree, I believe the correct answer is D) Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves.

upvoted 0 times

...

4 days ago

I think the answer is B) Azure SQL Database with virtualization-based security (VBS) enclaves.

upvoted 0 times

...