You are the administrator of the Contoso financial group. You are responsible for security on the Azure SQL database called Finance_DB_Main. You have been tasked to ensure that the database and its data is secure at rest via encryption. However, the solution should be flexible enough to support geo-replication and geo-restore. Which encryption technology method should you use?
Transparent Data Encryption is correct, as this allows the data stored on the disk to be encrypted and it supports geo-replication and geo-restore. Always Encrypted will not suffice as this is focused on transport encryption (data in transit is encrypted). Azure key vault will not suffice, as this is a vault where you can store passwords and certificates, not a specific database encryption tool.