BlackFriday 2024! 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 9 Question 37 Discussion

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

Salome
5 months ago
I've read that SQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves is also a strong option.
upvoted 0 times
...
Shawn
6 months ago
I'm not sure. But I think Azure SQL Managed Instance that has Always Encrypted configured could be a good choice.
upvoted 0 times
...
Vanna
6 months ago
I disagree. I believe Azure SQL Database with virtualization-based security (VBS) enclaves would be a better option.
upvoted 0 times
...
Sunshine
6 months ago
I think we should go with Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves.
upvoted 0 times
...
James
7 months ago
I'm not so sure about that. Option C, Azure SQL Managed Instance with Always Encrypted, also looks promising. It provides the data protection we need, and it's a managed service, which could be easier to set up.
upvoted 0 times
...
Belen
7 months ago
Haha, I hear you! Though I guess that's why they call it a 'certification' exam - they want to make sure we really know our stuff.
upvoted 0 times
...
Monte
7 months ago
That's a great question. I think it really comes down to personal preference and which features are more important to your specific use case.
upvoted 0 times
Daron
6 months ago
D) Azure SQL Database with Intel Software Guard Extensions (Intel SGX) enclaves
upvoted 0 times
...
Katie
6 months ago
C) Azure SQL Managed Instance that has Always Encrypted configured
upvoted 0 times
...
Evette
6 months ago
B) Azure SQL Database with virtualization-based security (VBS) enclaves
upvoted 0 times
...
Jeffrey
6 months ago
A) SQL Server on Azure Virtual Machines with virtualization-based security (VBS) enclaves
upvoted 0 times
...
...
Christiane
7 months ago
Hmm, this is a tricky one. I think the key here is to find an Azure database solution that meets all the requirements, including the hardware-based encryption and Azure Attestation support.
upvoted 0 times
...

Save Cancel