You have an Azure subscription that contains an Azure SQL database named SQL1. You need to configure SQL1 to use Always Encrypted. What should you use?

The correct answer is B. Microsoft SQL Server Management Studio (SSMS). To configure Always Encrypted in your database, follow these steps: 1. Provision cryptographic keys to protect your data. 2. Set up encryption for specific database columns that include sensitive information to ensure You can perform the above steps using SQL tools: ->…

Submitted by stefanr· Mar 6, 2026Secure compute, storage, and databases

Question

You have an Azure subscription that contains an Azure SQL database named SQL1. You need to configure SQL1 to use Always Encrypted. What should you use?

Options

ApgAdmin
BMicrosoft SQL Server Management Studio (SSMS)
CMySQL Workbench
Dthe Azure portal

How the community answered

(40 responses)

B
93% (37)
C
5% (2)
D
3% (1)

Explanation

To configure Always Encrypted in your database, follow these steps: 1. Provision cryptographic keys to protect your data. 2. Set up encryption for specific database columns that include sensitive information to ensure You can perform the above steps using SQL tools: *-> Provision Always Encrypted keys using SQL Server Management Studio * Configure Always Encrypted using PowerShell * sqlpackage - which automate the setup process https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-

Community Discussion

No community discussion yet for this question.

Full AZ-500 Practice