What type of events are captured by Azure SQL Database auditing?

Successful and failed database operations, such as SELECT, INSERT, UPDATE, and DELETE

A development team is building a serverless application that connects to Azure SQL Database. The security policy requires that no secrets (passwords or connection strings with credentials) be stored in application code or configuration files. The application runs in Azure and uses a system-assigned managed identity. What should you do to connect to the database?

Enable Always Encrypted and use a column master key in Azure Key Vault.

Use the managed identity to authenticate to Azure SQL by creating a contained database user mapped to the identity and using the DefaultAzureCredential in the application.

Create a SQL login with a strong password and store the connection string in Azure Key Vault.

Use a shared access signature (SAS) token for the database connection.

Which encryption approach protects data at rest in an Azure SQL database by encrypting the entire database file and backup without requiring changes to the application?

Transparent Data Encryption (TDE)

A machine learning model is deployed as an endpoint in Azure. The endpoint should only be accessible by a specific application running in Azure. You want to avoid managing secrets. Which authentication method should you configure?

Key-based authentication with a shared key

Managed Identity authentication

Certificate-based authentication

Azure AD token-based authentication

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 1

Implement Data Security and Compliance DP-800 Practice Questions (Page 1)

Part of the Secure, optimize, and deploy database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 55 practice questions to prepare you well beyond it. (estimate)

55questions here

11free pages

15concepts

35–40%of the exam

Questions 1–5

1foundation · easy
What type of events are captured by Azure SQL Database auditing?
Select an answer first
2foundation · easy
Which T-SQL statement is used to create a security policy for Row-Level Security?
Select an answer first
3application · medium
A development team is building a serverless application that connects to Azure SQL Database. The security policy requires that no secrets (passwords or connection strings with credentials) be stored in application code or configuration files. The application runs in Azure and uses a system-assigned managed identity. What should you do to connect to the database?
Select an answer first
4foundation · easy
Which encryption approach protects data at rest in an Azure SQL database by encrypting the entire database file and backup without requiring changes to the application?
Select an answer first
5application · medium
A machine learning model is deployed as an endpoint in Azure. The endpoint should only be accessible by a specific application running in Azure. You want to avoid managing secrets. Which authentication method should you configure?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.

Implement Data Security and Compliance DP-800 Practice Questions (Page 1)

Questions 1–5

What type of events are captured by Azure SQL Database auditing?

Which T-SQL statement is used to create a security policy for Row-Level Security?

Which encryption approach protects data at rest in an Azure SQL database by encrypting the entire database file and backup without requiring changes to the application?

A machine learning model is deployed as an endpoint in Azure. The endpoint should only be accessible by a specific application running in Azure. You want to avoid managing secrets. Which authentication method should you configure?

Keep studying — Secure, optimize, and deploy database solutions