Microsoft Exam PL-200 Topic 3 Question 62 Discussion

Actual exam question for Microsoft's PL-200 exam

Question #: 62
Topic #: 3

You are using the Data import wizard to import records into the account table from a CSV file. The CSV-to-table mapping is as follows:

* The Name column represents the account name and maps to the Account Name column.

* The Parent Name column represents the holding company of the account with subsidiaries underneath.

Records that are imported into the table are only related to other records in the file.

You need to configure the import to create the relationship between records.

What should you do?

AMap Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.

BCreate an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.

CLook up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column.

DMap Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.

Show Suggested Answer

Suggested Answer: C

by Lindsey at Nov 24, 2023, 03:29 PM

Limited Time Offer

25%

Off

Get Premium PL-200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ezekiel

10 months ago

Ah, I see what you mean, Elinore. Option D seems to be the best choice here, as it maps the Parent Name column to the Parent Account column and uses the Account Name as the lookup criteria.

upvoted 0 times

...

Elinore

10 months ago

Hold on, I'm not sure about that. Shouldn't we be using the Account Name column as the lookup criteria instead? That way, we can match the records more accurately.

upvoted 0 times

...

10 months ago

Hmm, this question seems a bit tricky. We need to find a way to create the relationship between the records in the account table based on the Parent Name column in the CSV file.

upvoted 0 times

...