Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam PL-200 Topic 3 Question 62 Discussion

Actual exam question for Microsoft's PL-200 exam
Question #: 62
Topic #: 3
[All PL-200 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Ezekiel
8 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
8 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
...
Aron
8 months ago
I think option A is the way to go. By mapping the Parent Name column to the Parent Account column, we can establish the parent-child relationship between the records.
upvoted 0 times
Ines
7 months ago
A) Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
upvoted 0 times
...
Felicidad
8 months ago
That doesn't sound right. We want to link the Parent Name to the Parent Account, not the Account Name.
upvoted 0 times
...
Cheryl
8 months ago
D) Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.
upvoted 0 times
...
Mendy
8 months ago
I don't think that's necessary. Mapping directly from Parent Name to Parent Account should work fine.
upvoted 0 times
...
Precious
8 months ago
C) Look 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.
upvoted 0 times
...
Bev
8 months ago
I agree, that makes sense. It will create the relationship we need between the records.
upvoted 0 times
...
Mireya
8 months ago
A) Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
upvoted 0 times
...
...
Luisa
8 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
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77