Which three actions should you perform?

HOTSPOT

You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table.

User1 executes a query on the database, and the query returns the results shown in the following exhibit.

User1 is the only user who has access to the unmasked data.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic . NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Box 1: 0

The YearlyIncome column is of the money data type.

The Default masking function: Full masking according to the data types of the designated fields

✑ Use a zero value for numeric data types (bigint, bit, decimal, int, money, numeric, smallint, smallmoney, tinyint, float, real).

Box 2: the values stored in the database

Users with administrator privileges are always excluded from masking, and see the original data without any mask.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

2 1. You develop data engineering solutions for a company.

A project requires the deployment of data to Azure Data Lake Storage.

You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources.

Which three actions should you perform? Each correct answer presents part of the solution . NOTE: Each correct selection is worth one point.
A . Assign Azure AD security groups to Azure Data Lake Storage.
B . Configure end-user authentication for the Azure Data Lake Storage account.
C . Configure service-to-service authentication for the Azure Data Lake Storage account.
D . Create security groups in Azure Active Directory (Azure AD) and add project members.
E . Configure access control lists (ACL) for the Azure Data Lake Storage account.

View Answer

Answer: ADE

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-secure-data