Which connection string property is used to specify Azure AD authentication for a SQL database connection?

Authentication=Active Directory Default

A reporting application needs to read data from a specific view in a SQL database but should not have access to the underlying tables. The application uses a dedicated login. Which permission should you grant to the login's user in the database?

SELECT on the underlying tables

What is the effect of the DENY permission on a database object?

It explicitly prevents a user from performing the specified action, even if they have the permission through a role

It allows the user to perform the action only if they are the object owner

It removes a previously granted permission

It grants the permission only for the current session

Which principle of least privilege is applied when designing object-level permissions?

Grant permissions only to the database owner

Grant only the minimum permissions necessary for a user's job function

Grant permissions based on the user's seniority

Grant all permissions to simplify management

Which components are required to implement Always Encrypted in Azure SQL Database?

Server certificate and database master key

A symmetric key stored in the database

Transparent Data Encryption and a database encryption key

Column master key and column encryption key

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 1

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

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 41–45

41foundation · easy
Which connection string property is used to specify Azure AD authentication for a SQL database connection?
Select an answer first
42application · easy
A reporting application needs to read data from a specific view in a SQL database but should not have access to the underlying tables. The application uses a dedicated login. Which permission should you grant to the login's user in the database?
Select an answer first
43foundation · easy
What is the effect of the DENY permission on a database object?
Select an answer first
44foundation · easy
Which principle of least privilege is applied when designing object-level permissions?
Select an answer first
45foundation · easy
Which components are required to implement Always Encrypted in Azure SQL Database?
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.