Correct Answer: Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) encrypts Azure SQL Database storage at rest. It performs real-time encryption and decryption of the database, associated backups, and transaction ...
Correct Answer
Transparent Data Encryption (TDE)
Why This Answer Is Correct
Transparent Data Encryption (TDE) encrypts Azure SQL Database storage at rest. It performs real-time encryption and decryption of the database, associated backups, and transaction log files without requiring changes to the application.
This question evaluates your knowledge of Relational Data — a core concept tested in Microsoft Certified: Azure Data Fundamentals (DP-900). Understanding Relational Data is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
In a relational database, what is used to enforce a relationship between two tables, ensuring that a value in one table corresponds to a valid row in another table?
You are writing a query in SQL. Which of the following commands is considered a Data Manipulation Language (DML) statement?
Your company wants to lift-and-shift an existing on-premises SQL Server to Azure. You require full control over the operating system, SQL Server instance configuration, and SQL Server Agent. Which deployment option should you choose?
You want a fully managed relational database service in Azure that automatically handles patching, backups, and high availability. You do not need instance-level features like SQL Server Agent. Which service is the best fit?
What is the process of structuring a relational database to reduce data redundancy and improve data integrity by dividing large tables into smaller tables and defining relationships between them?