Microsoft Certified:SQL AI Developer Associate
Domain 2Objective 1
Implement Data Security and Compliance DP-800 Practice Questions (Page 3)
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 11–15
- 11
Which security mechanism is commonly used to protect REST endpoints by requiring a token in the Authorization header?
Select an answer first - 12
What is the main purpose of Row-Level Security (RLS) in a database?
Select an answer first - 13
Which type of Managed Identity is tied to a specific Azure resource and is deleted when that resource is deleted?
Select an answer first - 14
Which T-SQL statement is used to encrypt a specific column in an existing table with column-level encryption?
Select an answer first - 15
Which type of predicate in a security policy filters rows that are visible to a user?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.