Exam PL-600 topic 2 question 12 discussion

Actual exam question from Microsoft's PL-600

Question #: 12
Topic #: 2

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 existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution.
You need to recommend a solution to combine the room and shelf fields into a single column during the import process.
Which tool should you recommend?

A. Power Platform dataflows
B. Data Import Wizard
C. import from CSV
D. Microsoft Excel Online

Show Suggested Answer

Suggested Answer: A 🗳️

by N8n0z at May 15, 2021, 3:45 p.m.

Comments

Submit Cancel

malyaban

Highly Voted 3 years ago

Wrong answer - Concatenation is for values in one column and using a delimiter. Column merging is only possible in DataFlows. Answer is A

upvoted 40 times

...

tumaj

Highly Voted 2 years, 9 months ago

The key phrase of the question is: "The company must import the data from the existing system into a Power Platform solution." Data Import Wizard is used to import data from a .csv or xml file and not directly from an external data source. Therefore an ETL tool is needed here and the "Power Platform Data Flows" is the correct answer.

upvoted 9 times

...

Attendee1

Most Recent 7 months ago

Selected Answer: A

Dataflows can combine the fields.

upvoted 1 times

...

CESBCN

1 year, 1 month ago

Selected Answer: A

Power Platform dataflows are designed to extract, transform, and load (ETL) data from various sources into Common Data Service or other destinations in Power Platform. They are particularly useful for handling complex data transformations and cleansing tasks

upvoted 2 times

...

stv

1 year, 3 months ago

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/import-data The Dataverse web services provide the following additional capabilities that aren’t available in the Import Data Wizard: - Create data maps that include complex transformation mapping, such as concatenation, split, and replace.

upvoted 1 times

...

Muzera

1 year, 7 months ago

Selected Answer: A

Answer : A

upvoted 1 times

...

petertwilliams

1 year, 8 months ago

Well I'm going for A. But I do see why B was provided as an answer. Once upon a time this may have been the way to go. https://cloudblogs.microsoft.com/dynamics365/no-audience/2008/03/24/data-migration-manager-advanced-transformation-mappings/ https://cloudblogs.microsoft.com/dynamics365/no-audience/2008/04/04/data-migration-manager-advanced-transformations/

upvoted 1 times

...

mister_exam

1 year, 9 months ago

I'd go with B because using a Dataflow for data import seems heavily overkill. Combine the data in Excel first using formulas, generate a csv, then import using the Data Import Wizard.

upvoted 3 times

...