Question 139 of 170 from exam DP-200: Implementing an Azure Data Solution

Question 139 of 170 from exam DP-200: Implementing an Azure Data Solution

Question

HOTSPOT -

You have an Azure subscription that contains the following resources:

-> An Azure Active Directory (Azure AD) tenant that contains a security group named Group1

-> An Azure Synapse Analytics SQL pool named Pool1

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.

Hot Area:

Explanations

Box 1: GRANT -

You can implement column-level security with the GRANT T-SQL statement.

Box 2: CREATE SECURITY POLICY -

Implement Row Level Security by using the CREATE SECURITY POLICY Transact-SQL statement

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security