ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam
Go to Exam

Exam AZ-500 topic 5 question 38 discussion

Actual exam question from Microsoft's AZ-500
Question #: 38
Topic #: 5
[All AZ-500 Questions]

HOTSPOT -
You have an Azure subscription that contains the following resources:
✑ An Azure key vault
✑ An Azure SQL database named Database1
Two Azure App Service web apps named AppSrv1 and AppSrv2 that are configured to use system-assigned managed identities and access Database1

You need to implement an encryption solution for Database1 that meets the following requirements:
✑ The data in a column named Discount in Database1 must be encrypted so that only AppSrv1 can decrypt the data.
✑ AppSrv1 and AppSrv2 must be authorized by using managed identities to obtain cryptographic keys.
How should you configure the encryption settings for Database1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell
by C6H6 at Sept. 30, 2021, 4:26 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
C6H6
Highly Voted 2 years, 7 months ago
Always Encrypted by Using Azure Key Vault Create an Access Policy in azure Key vault https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell#create-a-key-vault-to-store-your-keys
upvoted 52 times
TJ001
2 years, 3 months ago
Agree with you
upvoted 4 times
...
cfsxtuv33
2 years, 4 months ago
After reviewing that link you provided I will agree with you. Thank you.
upvoted 1 times
...
...
zellck
Highly Voted 12 months ago
1. Always Encrypted by Using Azure Key Vault 2. Create an Access Policy in Azure Key Vault https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-tutorial-getting-started
upvoted 6 times
...
wardy1983
Most Recent 5 months, 2 weeks ago
Always Encrypted by Using Azure Key Vault Create an Access Policy in azure Key vault https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure? tabs=azure-powershell#create-a-key-vault-to-store-your-keys
upvoted 3 times
...
tweleve
6 months, 2 weeks ago
in exam 13 Oct
upvoted 2 times
...
Psychosikh
1 year ago
In exam 15/04/2023
upvoted 3 times
...
tutonata
1 year, 1 month ago
Always Encrypted and Keyvault access policy. For info on TDE vS Alawys Encrypted go read: https://azure.microsoft.com/en-us/blog/transparent-data-encryption-or-always-encrypted/
upvoted 2 times
...
majstor86
1 year, 1 month ago
Always Encrypted by Using Azure Key Vault Create an Access Policy in azure Key vault
upvoted 2 times
...
Muaamar_Alsayyad
1 year, 6 months ago
Given answer is worng! Correct answser 1) Always encrypted using AKV 2) Create an Access policy
upvoted 2 times
...
Amit3
1 year, 7 months ago
# In Exam 01-Oct-2022.
upvoted 3 times
...
DarkCyberGhost
2 years, 3 months ago
from the Link given by C6H6 Now that your client app is configured and you have your application ID, it's time to create a key vault and configure its access policy so you and your application can access the vault's secrets (the Always Encrypted keys). So I agree, that is should be box 1: Always Encrypted by Using Azure Key Vault box 2: reate an Access Policy in azure Key vault
upvoted 1 times
...
JL15546
2 years, 3 months ago
1) Always encrypted using AKV 2) Create an Access policy
upvoted 1 times
...
BillBaits
2 years, 5 months ago
Transparent Data Encryption works on the database level and not on the column level. Therefore the first answer has to be: "Always Encrypted by Using Azure Key Vault" https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
upvoted 5 times
...
zioggs
2 years, 5 months ago
Exam - 4/11/21
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago