DP-203 Practice Test

You have a data model that you plan to implement in a data warehouse in Azure Synapse
Analytics as shown in the following exhibit.

Note: This question is part of a series of questions that present the same scenario.
Each question in the series contains a unique solution that might meet the stated
goals. Some question sets might have more than one correct solution, while others
might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a
result, these questions will not appear in the review screen.
You are designing an Azure Stream Analytics solution that will analyze Twitter data.
You need to count the tweets in each 10-second window. The solution must ensure that
each tweet is counted only once.
Solution: You use a hopping window that uses a hop size of 5 seconds and a window size
10 seconds.
Does this meet the goal?

A.

Yes

B.

No

You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL
pool. The table will contains approximately 60 million rows per month and will be partitioned
by month. The table will use a clustered column store index and round-robin distribution.
Approximately how many rows will there be for each combination of distribution and
partition?

A.

1 million

B.

5 million

C.

20 million

D.

60 million

You have an Azure data factory.
You need to examine the pipeline failures from the last 60 days.
What should you use?

A.

the Activity log blade for the Data Factory resource

B.

the Monitor & Manage app in Data Factory

C.

the Resource health blade for the Data Factory resource

D.

Azure Monitor

You have an Azure Active Directory (Azure AD) tenant that contains a security group
named Group1. You have an Azure Synapse Analytics dedicated SQL pool named dw1
that contains a schema named schema1.
You need to grant Group1 read-only permissions to all the tables and views in schema1.
The solution must use the principle of least privilege.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of
the correct orders you select.