exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 2 question 26 discussion

Actual exam question from Microsoft's DP-700
Question #: 26
Topic #: 2
[All DP-700 Questions]

HOTSPOT
-

You plan to process the following three datasets by using Fabric:

Dataset1: This dataset will be added to Fabric and will have a unique primary key between the source and the destination. The unique primary key will be an integer and will start from 1 and have an increment of 1.
Dataset2: This dataset contains semi-structured data that uses bulk data transfer. The dataset must be handled in one process between the source and the destination. The data transformation process will include the use of custom visuals to understand and work with the dataset in development mode.
Dataset3: This dataset is in a lakehouse. The data will be bulk loaded. The data transformation process will include row-based windowing functions during the loading process.

You need to identify which type of item to use for the datasets. The solution must minimize development effort and use built-in functionality, when possible.

What should you identify for each dataset? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
zxc01
2 days, 16 hours ago
Dataset1 -> Dataflow Gen2 Dataset2 -> Notebook Dataset3 -> Dataflow Gen2 (the target is Lakehouse, we cannot use T-SQL)
upvoted 1 times
...
abdulbasit170
1 week, 1 day ago
Dataset1 -> Dataflow Gen2 -> Simple structured data, low-code batch ingestion with built in incremental load functionality Dataset2 -> Notebook -> Semi-structured, custom visuals, all logic in one place Dataset3 -> T-SQL statement -> Lakehouse bulk transformation with windowing functions natively supported by TSQL
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago