11.11 Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Changed DP-203 Exam Questions

Page: 9 / 12
Total 341 questions

Data Engineering on Microsoft Azure Questions and Answers

Question 33

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables.

Which distribution type should you recommend to minimize data movement?

Options:

A.

HASH

B.

REPLICATE

C.

ROUND ROBIN

Question 34

You have an Azure Synapse Analytics dedicated SQL pool.

You run PDW_SHOWSPACEUSED(dbo,FactInternetSales’); and get the results shown in the following table.

Which statement accurately describes the dbo,FactInternetSales table?

Options:

A.

The table contains less than 1,000 rows.

B.

All distributions contain data.

C.

The table is skewed.

D.

The table uses round-robin distribution.

Question 35

You need to design the partitions for the product sales transactions. The solution must meet the sales transaction dataset requirements.

What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 36

You need to design a data ingestion and storage solution for the Twitter feeds. The solution must meet the customer sentiment analytics requirements.

What should you include in the solution? To answer, select the appropriate options in the answer area

NOTE: Each correct selection b worth one point.

Options:

Page: 9 / 12
Total 341 questions