Provisioning SQL Databases — Question 48

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You use the always Encrypted wizard to encrypt all possible for the tables in the primary instance.
Does the solution meet the goal?

Answer options

Correct answer: B

Explanation

The solution does not meet the goal because while Always Encrypted enables encryption for data at rest and in transit, it does not apply to backups. Backups need to be encrypted separately, and the solution provided does not address that requirement.