Exam MB-600 All Questions

View all questions & answers for the MB-600 exam

Exam MB-600 topic 2 question 4 discussion

Actual exam question from Microsoft's MB-600

Question #: 4
Topic #: 2

A company plans to implement Dynamics 365 Sales. The company stores data about book locations in the fields, room, and shelf.
The company must import legacy data into the new system. Legacy data must be modified to match the current system design.
You need to recommend a solution to combine the room and shelf fields into a single field on import.
Which tool should you recommend?

A. Data Import Wizard
B. web services
C. Microsoft Excel Online
D. import from CSV

Show Suggested Answer

Suggested Answer: A 🗳️

by Gkane at Sept. 26, 2020, 3:29 p.m.

Comments

Submit Cancel

cvocvocvo

Highly Voted 4 years, 6 months ago

The answer is incorrect. It should be Web Services. From the docs: "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." See Link on Microsoft Docs: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/import-data

upvoted 10 times

cvocvocvo

4 years, 5 months ago

I did the exam and got this question but Web Services was no longer an answer. They had something else in it's place! I went with Data Import in the end on a whim. I passed, but don't know if I got this question right or wrong, but just know that Web Services is no longer an option.

upvoted 8 times

...

Karlomanio

4 years, 2 months ago

The answer is the Import Data wizard, even after reading your link. The Data Import Wizard is a Web Service- that's what the article is saying and it is confusing. "IMPORT DATA WIZARD" is NOT the "DATA IMPORT WIZARD." Please note the word order.

upvoted 1 times

...

xofowi5140

Most Recent 4 years, 2 months ago

CSV https://docs.microsoft.com/en-us/dynamics365/sales-professional/import-data#import-records-from-a-csv-file

upvoted 1 times

...

malyaban

4 years, 2 months ago

Answer is C Excel Online

upvoted 2 times

...

midriano

4 years, 7 months ago

I believe the correct answer is A. The unfortunate part of this question and the possible answers is that they do not describe the complete solution. To me the source whether an XML or a CSV can be used to concatenate. Once completed, the import tool should be the Data import wizard

upvoted 3 times

...

janisk

4 years, 7 months ago

Data import wizard does not allow field concatenate. I think correct answer is Web Services

upvoted 2 times

...

arshad

4 years, 8 months ago

Data import wizard allow user for mapping of fields in entity while import, so answer A is correct.

upvoted 1 times

Zeus6

4 years, 7 months ago

The DIW does not allow the concatenation of two fields into one during the import though...based on that part of the question, webservices makes sense

upvoted 3 times

Zeus6

4 years, 7 months ago

I personally, for one off simple imports, update the data in excel first then use the out box DIW (just like Dude says above), but the question seems to want us to provide a solution for the changes to be done during the import - hence why i think the answer is webservices

upvoted 2 times

...

Dude

4 years, 9 months ago

I really don't like questions like this since anyone of them is right to come degree. for example; Data import wizard, I would prepare the data in Excel using a concatenate formula to join to fields into a single line of text and then when importing the file I would map the lookup to the new field. Or web services, else Microsoft Excel Online if the number of records is not too many. Finally, for the CSV file, I would do the same. My personal preference is to prep the data in Excel, make the changes I need, save the file in an XML format and then use the import wizard.

upvoted 2 times

...

Tryly

4 years, 9 months ago

Web services if it was data integration to continously do data transformation. One time data migration any tool, even excel for small loads will work just fine.

upvoted 1 times

...

Gkane

4 years, 9 months ago

Web services is the correct answer since it requires data transformation

upvoted 1 times

...