Microsoft Exam PL-200 Topic 1 Question 69 Discussion

Actual exam question for Microsoft's PL-200 exam

Question #: 69
Topic #: 1

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 Thurman at Apr 09, 2024, 08:14 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lavina

6 months ago

I understand your point, But I think mapping Parent Name to Parent Account column makes more sense.

upvoted 0 times

...

Izetta

6 months ago

I'm not sure, but I think option C might also work.

upvoted 0 times

...

Dana

6 months ago

I disagree, I believe option D is the right choice.

upvoted 0 times

...

Lavina

6 months ago

I think the correct answer is A.

upvoted 0 times

...

Serita

6 months ago

I agree with Tamesha. Mapping Parent Name to the Parent Account column and selecting Account Name as the lookup criteria seems like the best option (Option D).

upvoted 0 times

...

Arletta

6 months ago

I think we should look up the record IDs of the records in the Parent Account column and add them as a new column in the file (Option C).

upvoted 0 times

...

Angella

7 months ago

I disagree. I believe we should create an alternate key on the account table using the Account Name column and not map Parent Name (Option B).

upvoted 0 times

...

Tamesha

7 months ago

I think we should map Parent Name to the Parent Account column and select Parent Account as the lookup criteria (Option A).

upvoted 0 times

...

Emilio

8 months ago

I don't know, option C with the record IDs sounds kind of clever. But it also seems overly complicated compared to just mapping the Parent Name column directly.

upvoted 0 times

...

Cordelia

8 months ago

Option B seems a bit odd to me. Creating an alternate key on the account table and not mapping the Parent Name column? That doesn't seem like it would create the necessary relationships.

upvoted 0 times

...

Coral

8 months ago

Well, option B is just completely off-base. Creating an alternate key on the Account Name column isn't going to help with the parent-child relationship at all.

upvoted 0 times

...

Bulah

8 months ago

Ha! I can just see someone trying to manually look up all those record IDs. Talk about a recipe for disaster! I'm with Dyan - option A is the way to go.

upvoted 0 times

Carrol

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

...

Josphine

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

...

Yeah, I agree with Kirby. That seems like the most straightforward way to establish the parent-child relationship between the records. The other options don't seem to directly address that requirement.

upvoted 0 times

...

Dyan

8 months ago

I'm not a big fan of option C. Seems like a lot of extra work and potential for errors. I'd rather go with the simpler option A and let the Data Import Wizard handle the relationship mapping.

upvoted 0 times

...

Kirby

8 months ago

Hmm, this is an interesting one. The key here seems to be creating the relationship between the records in the import file. I'm leaning towards option A - mapping the Parent Name column to the Parent Account column and using Parent Account as the lookup criteria.

upvoted 0 times

...

Wynell

8 months ago

I'm not so sure about that. Option C looks interesting to me. If we can look up the record IDs of the parent accounts and add them as a new column in the file, that might be a more robust way to establish the relationship.

upvoted 0 times

...

Nieves

8 months ago

I agree with Precious. Option A seems like the most logical choice here. Mapping the Parent Name column to the Parent Account column should create the necessary relationship between the records.

upvoted 0 times

...

Precious

8 months ago

This question seems straightforward, but it's important to understand the relationship between the account records and the parent accounts. I think option A is the best way to go, as it directly maps the Parent Name column to the Parent Account column in the account table.

upvoted 0 times

Laura

7 months ago

Agreed, mapping Parent Name to Parent Account makes sense.

upvoted 0 times

...

Arlie

7 months ago

I think option A is the correct choice.

upvoted 0 times

...

Microsoft Exam PL-200 Topic 1 Question 69 Discussion

Contribute your Thoughts:

Lavina

Izetta

Dana

Lavina

Serita

Arletta

Angella

Tamesha

Emilio

Cordelia

Coral

Bulah

Carrol

Josphine

Sean

Dyan

Kirby

Wynell

Nieves

Precious

Laura

Arlie