Which T-SQL statement is used to grant a user permission to execute a stored procedure?

DENY EXECUTE ON [procedure_name] TO [user]

GRANT EXECUTE ON [procedure_name] TO [user]

Which T-SQL statement is used to add Dynamic Data Masking to an existing column?

ALTER TABLE ... ALTER COLUMN ... MASKED WITH (FUNCTION = '...')

ALTER DATABASE ... SET MASKING ON

CREATE MASK ON TABLE ... COLUMN

UPDATE TABLE ... SET COLUMN = MASK

Which security measure is critical for maintaining data confidentiality when communicating with an MCP endpoint?

Encrypting data in transit using TLS

Using a strong password for the endpoint

A multi-tenant SaaS application uses a single SQL database to store data for multiple customers. Each customer's users should only see their own rows. The application passes the customer ID via SESSION_CONTEXT. Which security feature should you implement?

Row-Level Security with a predicate function that filters by SESSION_CONTEXT

Dynamic Data Masking on the CustomerID column

Column-level encryption on the CustomerID column

Object-level permissions with separate schemas per customer

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 1

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

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 16–20

16foundation · easy
Which T-SQL statement is used to grant a user permission to execute a stored procedure?
Select an answer first
17foundation · easy
Which T-SQL statement is used to add Dynamic Data Masking to an existing column?
Select an answer first
18foundation · easy
Which security measure is critical for maintaining data confidentiality when communicating with an MCP endpoint?
Select an answer first
19foundation · easy
Which Azure service is commonly used to store audit logs from Azure SQL Database for compliance purposes?
Select an answer first
20application · medium
A multi-tenant SaaS application uses a single SQL database to store data for multiple customers. Each customer's users should only see their own rows. The application passes the customer ID via SESSION_CONTEXT. Which security feature should you implement?
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.