PL-600 · Question #29
A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf. The company must import the data from the…
The correct answer is A. Power Platform dataflows. Power Platform dataflows are ETL (Extract, Transform, Load) tools that support data transformation during the import process. They allow you to use Power Query to combine, reshape, and map columns - such as merging 'Room' and 'Shelf' into a single concatenated column - before…
Question
Options
- APower Platform dataflows
- BData Import Wizard
- Cimport from CSV
- DMicrosoft Excel Online
How the community answered
(37 responses)- A81% (30)
- B3% (1)
- C5% (2)
- D11% (4)
Explanation
Power Platform dataflows are ETL (Extract, Transform, Load) tools that support data transformation during the import process. They allow you to use Power Query to combine, reshape, and map columns - such as merging 'Room' and 'Shelf' into a single concatenated column - before writing the data into Dataverse. The Data Import Wizard (B) and CSV import (C) support basic field mapping but do not provide column-level transformation logic. Microsoft Excel Online (D) is a productivity tool, not an import pipeline for Power Platform.
Topics
Community Discussion
No community discussion yet for this question.