Exam PL-200 All QuestionsBrowse all questions from this exam
Go to Exam
Question 43

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?

    Correct Answer: A

    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.

Discussion
NyanneOption: 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.

Zmajica

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

Nyanne

Its not about the relationship, its about the column name on the Parent Account, which is 'Account name'.

OldHand1Option: A

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.

wsjones

on the test - 8/1/2023

MSDev23

Which is the right answer? Please!!

ktyOption: 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.

Ceddy

Everyone in here has a different answer...

charles879987Option: A

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

5f14337Option: A

A. Correct

rockyozOption: A

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

RominaTOption: A

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

MrEz

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

solidshagOption: A

No discussion needed

MarshallrfOption: A

On exam 09/11/2023 I choose A 620 my score

Jeremy92

In exam 15-10-23

ttien

on exam 20/9/2023

SuchiSOption: B

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

KindumOption: A

The answer is A not D Please publisher Explain this confusing

CalebXinOption: A

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