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...

Questions › Category: PL-100 › 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…

0 Vote Up Vote Down

Admin Staff asked 4 months ago

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:
 
















 

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

This question is in PL-100 Microsoft Power Platform App Maker Exam
For getting Microsoft Certified: Power Platform App Maker Associate Certificate





Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.