MB-200 Exam QuestionsBrowse all questions from this exam

MB-200 Exam - Question 28


DRAG DROP -

You import data into Dynamics 365 for Customer Service by using the Import Data wizard.

Errors occur when you try to import the following data lines:

You need to identify the cause of the errors.

What error types have occurred? To answer, drag the appropriate error types to the correct data. Each error type 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 Answer
Correct Answer:

The errors occurred due to inconsistent usage of delimiters in the data. In the first data line, 'Fabrikam, Inc.' and '123 Main Street' are enclosed in quotation marks, but they use different closing quotes (' and `). Additionally, there are mismatched delimiters seen in the fields. The 'Company Name,Address,City,State/t' line indicates a comma-separated format, but the usage of delimiters within the data lines is inconsistent. Specifically, the issues are: 1. Inconsistent data delimiter: There is a mix of different types of quotation marks being used (' and `), which causes the inconsistency. 2. Inconsistent field delimiter: The fields are not consistently delimited, causing errors when attempting to parse using the Import Data wizard. Adopting a consistent delimiter (such as double quotes for text and commas for fields) can resolve these issues.

Discussion

5 comments
Sign in to comment
mgharably
Sep 14, 2019

this is the missing options: https://drive.google.com/file/d/1GT1DFh6z-rC-e15bGBBvF8MHoraTGJRH/view?usp=sharing

Suchi
Sep 15, 2019

Thank you

AneeG
May 3, 2020

not all the heroes are wearing the cup

AneeG
May 3, 2020

*wearing the cap

Nyanne
Sep 21, 2020

*cape hehe also the answer is correct. reference: https://cloudblogs.microsoft.com/dynamics365/no-audience/2009/12/09/data-wizard-using-field-delimiters-characters-in-data-source-files/

Nyanne
Sep 21, 2020

*cape hehe also the answer is correct. reference: https://cloudblogs.microsoft.com/dynamics365/no-audience/2009/12/09/data-wizard-using-field-delimiters-characters-in-data-source-files/

AneeG
May 3, 2020

*wearing the cap

Nyanne
Sep 21, 2020

*cape hehe also the answer is correct. reference: https://cloudblogs.microsoft.com/dynamics365/no-audience/2009/12/09/data-wizard-using-field-delimiters-characters-in-data-source-files/

Nyanne
Sep 21, 2020

*cape hehe also the answer is correct. reference: https://cloudblogs.microsoft.com/dynamics365/no-audience/2009/12/09/data-wizard-using-field-delimiters-characters-in-data-source-files/

mgharably
Sep 14, 2019

the answer is : inconsistent Data Declimar, inconsistent Field Declimar

SoMuchConfusion
Dec 29, 2019

Agreed. Thank you!

mkhaleel
May 20, 2020

In Exam

Ameen
May 30, 2020

In exam

HenryMcienzie
Sep 6, 2020

What is the logic / rules Behind this Answer? How to identify if this is DAta Delimeter or field Delimeter?

Nyanne
Sep 21, 2020

Check out this article for full explanation https://cloudblogs.microsoft.com/dynamics365/no-audience/2009/12/09/data-wizard-using-field-delimiters-characters-in-data-source-files/