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?

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 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

5 months ago

I agree with Edgar, A seems to be the most secure option based on the requirements given.

upvoted 0 times

...

Edgar

5 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

...

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

4 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

4 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

5 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

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

Ty

4 months ago

D) Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves

upvoted 0 times

...

Julene

4 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

5 months ago

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

upvoted 0 times

...

Son

5 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

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

Albina

4 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

4 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

6 months ago

I think the answer is A) SQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves.

upvoted 0 times

...

Microsoft Exam SC-100 Topic 3 Question 44 Discussion

Contribute your Thoughts:

Melynda

Edgar

Mona

Olga

Miriam

Peggie

Katheryn

Ty

Julene

Cora

Ronna

Son

Rozella

Albina

Breana

Edgar