PL-200 Exam - Question 43

Question

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?

Examice · Accepted Answer

To correctly create the relationship between records in the data import, you should map the Parent Name in the CSV file to the Parent Account column and select Account Name as the lookup criteria. This approach ensures that each record can properly reference its parent record based on the account name, aligning with the provided mapping details and maintaining relational integrity within the imported data.

Nyanne · Answer

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.

OldHand1 · Answer

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.

charles879987 · Answer

This is self-referential mapping. 
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-query-hierarchical-data

Ceddy · Answer

Everyone in here has a different answer...

kty · Answer

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.

wsjones · Answer

on the test - 8/1/2023

CalebXin · Answer

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/create-data-maps-for-import

Kindum · Answer

The answer is A not D Please publisher Explain this confusing

SuchiS · Answer

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

ttien · Answer

on exam 20/9/2023

Jeremy92 · Answer

In exam 15-10-23

Marshallrf · Answer

On exam 09/11/2023

I choose A

620 my score

solidshag · Answer

No discussion needed

MrEz · Answer

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?!

RominaT · Answer

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

rockyoz · Answer

It is A, just export a table and import by youself

5f14337 · Answer

A. Correct

PL-200 Exam - Question 43

Discussion