Question 710
In this retired AZ-500 educational case, A database owner believes Transparent Data Encryption encrypts query results from the application to the database. Which security principle BEST explains the appropriate response?
Explanation
Correct Answer
The relevant security principle is: TDE encrypts database storage whereas transport encryption protects traffic in motion. That is why the action is: Enable transport TLS for connections and document TDE as at-rest database protection. The directly relevant confirmation is: A network test shows protected TLS while the database TDE state remains enabled.
Incorrect Answers
“JIT controls risk by restricting who can connect and how long access remains open” reflects the mechanism: JIT controls risk by restricting who can connect and how long access remains open. The actual reported symptoms are better explained by: TDE encrypts database storage whereas transport encryption protects traffic in motion.
The offered principle describes: Azure Bastion offers controlled browser or client-based access to VMs over private network paths. The situation in this question instead depends on: TDE encrypts database storage whereas transport encryption protects traffic in motion. These are different technical conditions.
“Platform-managed at-rest encryption and customer-managed key policies provide different key-control models” reflects the mechanism: Platform-managed at-rest encryption and customer-managed key policies provide different key-control models. The actual reported symptoms are better explained by: TDE encrypts database storage whereas transport encryption protects traffic in motion.