Question 1

You have an Azure SQL database that contains a table named Customer. Customer contains the columns shown in the following table.

You apply a masking rule as shown in the following table.

Which users can view the email addresses of the customers?

AServer administrators and all users who are granted the UNMASK permission to the Customer_Email column only.

BAll users who are granted the UNMASK permission to the Customer_Email column only.

CServer administrators only.

DServer administrators and all users who are granted the SELECT permission to the Customer_Email column only.

Answer : B

Grant the UNMASK permission to a user to enable them to retrieve unmasked data from the columns for which masking is defined.

https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking

Question 2

You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub.

You need to define a query in the Stream Analytics job. The query must meet the following requirements:

Count the number of clicks within each 10-second window based on the country of a visitor.

Ensure that each click is NOT counted more than once.

How should you define the query?

ASELECT Country, Count(*) AS Count
FROM ClickStream TIMESTAMP BY CreatedAt
GROUP BY Country, TumblingWindow(second, 10)

BSELECT Country, Count(*) AS Count
FROM ClickStream TIMESTAMP BY CreatedAt
GROUP BY Country, SessionWindow(second, 5, 10)

CSELECT Country, Avg(*) AS Average
FROM ClickStream TIMESTAMP BY CreatedAt
GROUP BY Country, SlidingWindow(second, 10)

DSELECT Country, Avg(*) AS Average
FROM ClickStream TIMESTAMP BY CreatedAt
GROUP BY Country, HoppingWindow(second, 10, 2)

Answer : A

Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.

Example:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

Question 3

You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day.

You must ensure that staging tables are optimized for data loading.

You need to design the staging tables.

What type of tables should you recommend?

ARound-robin distributed table

BHash-distributed table

CReplicated table

DExternal table

Answer : A

Question 4

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains 9 column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead.

What should you do?

AFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.

BFrom the Azure portal, set a mask on the Email column.

CFrom Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.

Answer : B

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

Question 5

You have an activity in an Azure Data Factory pipeline. The activity calls a stored procedure in a data warehouse in Azure Synapse Analytics and runs daily.

You need to verify the duration of the activity when it ran last.

What should you use?

Athe sys.dm_pdw_wait_stats data management view in Azure Synapse Analytics

Ban Azure Resource Manager template

Cactivity runs in Azure Monitor

DActivity log in Azure Synapse Analytics

Answer : C

Monitor activity runs. To get a detailed view of the individual activity runs of a specific pipeline run, click on the pipeline name.

Example:

The list view shows activity runs that correspond to each pipeline run. Hover over the specific activity run to get run-specific information such as the JSON input, JSON output, and detailed activity-specific monitoring experiences.

You can check the Duration.

https://docs.microsoft.com/en-us/azure/data-factory/monitor-visually

Free DP-200 Questions for Microsoft DP-200 Exam as PDF & Practice Test Software

Question 1

Question 2

Question 3

Question 4

Question 5