DP-203 Certification Practice Question #219

Question

You have an Azure Synapse Analytics SQL pool named Pool1. In Azure Active Directory (Azure AD), you have a security group named Group1.
You need to control the access of Group1 to specific columns and rows in a table in Pool1.
Which Transact-SQL commands should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

This hotspot maps directly to the two Synapse security primitives involved. Row-level security is enforced through a security policy, while column-level security is handled through granular `GRANT` permissions on selected columns. Microsoft Learn states both behaviors explicitly, and the best community comments converge on the same mapping.

More DP-203 practice questions