You have a Microsoft Azure SQL database that contains Personally Identifiable Information (PII). To mitigate the PII risk, you need to ensure that data is encrypted while the data is at rest. The…

The correct answer is B. transparent data encryption (TDE). Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Data Warehouse against the threat of malicious activity. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at…

Operationalize Big Data solutions

Question

You have a Microsoft Azure SQL database that contains Personally Identifiable Information (PII). To mitigate the PII risk, you need to ensure that data is encrypted while the data is at rest. The solution must minimize any changes to front-end applications. What should you use?

Options

ATransport Layer Security (TLS)
Btransparent data encryption (TDE)
Ca shared access signature (SAS)
Dthe ENCRYPTBYPASSPHRASE T-SQL function

How the community answered

(52 responses)

A
10% (5)
B
83% (43)
C
6% (3)
D
2% (1)

Explanation

Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Data Warehouse against the threat of malicious activity. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application.

Topics

#transparent data encryption#PII#encryption at rest#Azure SQL

Community Discussion

No community discussion yet for this question.

Full 70-475 Practice