exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 1 question 43 discussion

Actual exam question from Microsoft's PL-200
Question #: 43
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?

  • A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.
  • B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
  • C. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Nyanne
Highly Voted 2 years, 8 months ago
Selected Answer: A
Answer provided seems incorrect. I choose option A. A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria. Run through this in the system and see the steps match exactly. The important difference between Option A and B is the last step. "Select Account Name as the lookup criteria." This is where you select the column 'Account name' on the Account table, which is referenced via the Parent Account lookup.
upvoted 15 times
Zmajica
2 years, 8 months ago
Relation Parent Account : Account is 1:N or Account:Parent Account 1:N I think that lookup criteria should be Parent Account. I would choose option B
upvoted 3 times
Nyanne
2 years, 8 months ago
Its not about the relationship, its about the column name on the Parent Account, which is 'Account name'.
upvoted 4 times
...
...
...
OldHand1
Highly Voted 2 years, 8 months ago
It has to be A, because the records in the file ONLY relate to other records in the file, so how could you look up the ID? It won't have one if its not in the system.
upvoted 8 times
...
ewertowskip
Most Recent 8 months, 3 weeks ago
I am sure it's D. If you worked with Excel/CSV uploads, you know that not using the GUIDs in lookups is a bad idea.
upvoted 1 times
...
Nuelovo
10 months, 2 weeks ago
B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria. I believe it is B, because the concept of lookUp is simply a child table, to be a ble to reference records in another table(the parent table), using ForeignKeys from the child table to relate to corresponding values in the parent table using primary Key. This Table is a "Child table" Like the question stated, "Record imported into the table are only related to other records in the file" hence the table is simply a child table, and the only column/field that make sence to be used as the foreign key, is the "parent Account Name" Again looking at this phenomenon, the "parent name" field is the only tie, to the Parent table. Because Multiple accounts can be linked to ONLY one Parent Holding company.
upvoted 1 times
...
5f14337
10 months, 3 weeks ago
Selected Answer: A
A. Correct
upvoted 1 times
...
rockyoz
1 year, 1 month ago
It is A, just export a table and import by youself
upvoted 1 times
...
RominaT
1 year, 3 months ago
Correct answer: A. When you select the mapping column (Parent Account) you have to select which is the lookup mapping criteria which is Account Name because it's the name of the holding account
upvoted 1 times
...
MrEz
1 year, 3 months ago
if the child has the same name as the parent, then you will have a problem if you don't use the guid? guid is saver?!
upvoted 1 times
...
solidshag
1 year, 4 months ago
Selected Answer: A
No discussion needed
upvoted 1 times
...
Marshallrf
1 year, 7 months ago
On exam 09/11/2023 I choose A 620 my score
upvoted 1 times
...
Jeremy92
1 year, 7 months ago
In exam 15-10-23
upvoted 1 times
...
ttien
1 year, 8 months ago
on exam 20/9/2023
upvoted 1 times
...
SuchiS
1 year, 9 months ago
B should be correct answer. When we use the Import Wizard, it maps the Account Name to Account Name. And Parent name to Parent Name (Lookup) field
upvoted 1 times
...
Kindum
1 year, 9 months ago
The answer is A not D Please publisher Explain this confusing
upvoted 1 times
...
wsjones
1 year, 10 months ago
on the test - 8/1/2023
upvoted 2 times
MSDev23
1 year, 10 months ago
Which is the right answer? Please!!
upvoted 2 times
...
...
kty
1 year, 10 months ago
Selected Answer: A
The Parent Name column in the CSV file represents the parent account of the account being imported. The Parent Account column in the account table is a lookup field, which means that it can reference another record in the account table. When you import the data, you need to map the Parent Name column in the CSV file to the Parent Account column in the account table. The lookup criteria for the Parent Account column should be the Account Name column. This will ensure that the parent account is correctly linked to the child account.
upvoted 2 times
...
Ceddy
1 year, 11 months ago
Everyone in here has a different answer...
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...