Microsoft Power Platform Functional Consultant — Question 66

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because mapping the Parent Name to the Parent Account column and using Account Name as the lookup criteria correctly establishes the relationship between accounts and their parent companies. Option B incorrectly suggests using Parent Account as the lookup criteria, while C fails to map Parent Name, and D complicates the process unnecessarily by requiring record IDs.