Data Engineering on Microsoft Azure DP-203 Practice Test 1
© examsiri.com
Question : 14 of 20
Marks:
+1,
-0
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.
Hot Area:
You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table.
| Name | Role |
|---|---|
| User1 | Server admin |
| User2 | db_datereader |
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.
Hot Area:
- When User2 queries the YearlyIncome column, the values returned will be [answer choice]. ______
- When User1 queries the BirthDate column, the values returned will be [answer choice]. ______
Go to Question: