ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-100 All Questions

View all questions & answers for the PL-100 exam
Go to Exam

Exam PL-100 topic 3 question 56 discussion

Actual exam question from Microsoft's PL-100
Question #: 56
Topic #: 3
[All PL-100 Questions]

DRAG DROP -
A company stores sales orders in a Microsoft Excel workbook. The company stores customer data in a SQL Server database.
You must import the data into a Microsoft Dataverse instance.
You need to define the mapping for the migration.
Which component should you use? To answer, drag the appropriate components to the correct data type. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Table -

Box 2: Data source -

Box 3: Column -

Box 4: Row -
Reference:
https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query
by dfretyhg at Jan. 31, 2022, 9:45 p.m.

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
Submit Cancel
dfretyhg
Highly Voted 3 years, 5 months ago
I think this is the answer: Data source (You are selecting excel as a source) Table (You are picking a table from within the source of SQL) Column Row
upvoted 21 times
...
58117ec
Most Recent 1 year, 6 months ago
I think it's: Table because you can load Excel data into a new table Data Source because there is already an external database with the customer data, doesn't seem necessary to create a new table in that case. column row So what they provided seems correct.
upvoted 1 times
...
charles879987
2 years, 3 months ago
Very vague question. The question asks about migration mapping but the answers are about connectors.
upvoted 3 times
...
trumarlie89
2 years, 4 months ago
Answers: -Table- table from data source -Table - table from data source -Column - i.e customer number -Row - product data would be in the sales order table as row.
upvoted 1 times
...
Jerrycheng
2 years, 5 months ago
I'm not sure why product data should be a row but customer data and order data should be table. I think those customer, order and product should be stored in a table and the id should be stored in column?
upvoted 1 times
...
SHNH
2 years, 6 months ago
I suppose the data source is a data source not a component: TABLE/TABLE/COLUMN/ROW
upvoted 1 times
...
timothy123
2 years, 6 months ago
Excel data is the data source Customer data is a table in Dataverse Customer identifier is a column on the salesorder referring to right customer record in the Customer table Product data is a table in Dataverse.
upvoted 4 times
...
RazielLycas
2 years, 7 months ago
Another interpretation may be: DATASOURCE TABLE COLUMN TABLE just speculation, I have no idea what MS wants to hear
upvoted 3 times
...
RazielLycas
2 years, 7 months ago
The question is vague but I vote for: table table column row due to both the excel data and the SQL data will become tables, the identifier will be a column and the product will be a row but it's just my interpretation of something unclear
upvoted 1 times
...
AliceVO
3 years, 4 months ago
My answers are: -Table -Table -Column -Row https://docs.microsoft.com/en-us/power-query/dataflows/create-use https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query
upvoted 2 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