Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location
Mob_nav_barsMENU

Microsoft Exam PL-200 Topic 1 Question 69 Discussion

Actual exam question for Microsoft's PL-200 exam
Question #: 69
Topic #: 1
[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

by Thurman at Apr 09, 2024, 09: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
Glenna
2 days ago
I think C makes more sense, though.
upvoted 0 times
...
Eura
8 days ago
A is the way to go! Map Parent Name to Parent Account.
upvoted 0 times
...
Charlene
14 days ago
I think option C could work too, but it seems more complicated. I’m leaning towards option A since it directly maps the Parent Name.
upvoted 0 times
...
Wenona
19 days ago
I’m a bit confused about whether we should create an alternate key. I thought that was only necessary if we weren’t mapping the Parent Name.
upvoted 0 times
...
Kenny
25 days ago
I remember practicing a similar question where we had to establish relationships. I feel like option A makes the most sense for this scenario.
upvoted 0 times
...
Francine
1 month ago
I think we need to map the Parent Name to the Parent Account column, but I'm not sure if we should select the Account Name as the lookup criteria.
upvoted 0 times
...
Marge
1 month ago
This seems straightforward enough. I'm going to go with option A - it makes the most sense to me based on the information provided in the question.
upvoted 0 times
...
Serina
1 month ago
Hmm, I'm not sure about this one. The wording is a bit tricky. I'm leaning towards option D, but I'm not 100% confident that's the right approach. Guess I'll have to think it through carefully.
upvoted 0 times
...
Soledad
1 month ago
Okay, I think I've got this. The key is to create the relationship between the records in the file. Option A looks like the best way to do that by mapping the Parent Name to the Parent Account column.
upvoted 0 times
...
Viola
1 month ago
I'm a bit confused here. The question says the records are only related within the file, so I'm not sure if using the Account Name as the lookup criteria would work. Maybe option C would be better?
upvoted 0 times
...
Elouise
1 month ago
Hmm, this seems straightforward. I think I'll go with option A - mapping the Parent Name column to the Parent Account column and using that as the lookup criteria.
upvoted 0 times
...
Dorothy
1 month ago
Wait, is that the right file? I'm not totally sure about the SysV init process configuration.
upvoted 0 times
...
Marion
1 month ago
Okay, let's see. The script is already importing the necessary libraries, so I just need to figure out what needs to be added to the script to get a successful HTTP response. I'm thinking it might have something to do with the API token and the reference set name, but I'm not sure.
upvoted 0 times
...
Jesusita
1 month ago
I practiced a similar question before, and I think ExpressRoute was definitely mentioned as a connection option.
upvoted 0 times
...
Lavina
1 year ago
I understand your point, But I think mapping Parent Name to Parent Account column makes more sense.
upvoted 0 times
...
Izetta
1 year ago
I'm not sure, but I think option C might also work.
upvoted 0 times
...
Dana
1 year ago
I disagree, I believe option D is the right choice.
upvoted 0 times
...
Lavina
1 year ago
I think the correct answer is A.
upvoted 0 times
...
Serita
1 year 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
1 year 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
2 years 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
2 years 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
2 years 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
2 years 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
2 years 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
2 years 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
2 years ago
A) Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
upvoted 0 times
...
Josphine
2 years ago
D) Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.
upvoted 0 times
...
...
Sean
2 years ago
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
2 years 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
2 years 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
2 years 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
2 years 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
2 years 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
1 year ago
Agreed, mapping Parent Name to Parent Account makes sense.
upvoted 0 times
...
Arlie
2 years ago
I think option A is the correct choice.
upvoted 0 times
...
...

Save Cancel