PL-200 Question #146: Real Exam Question with Answer & Explanation

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 following: - Name column represents the account and maps to the Account column. - TIE 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?

Options

• AMap Parent Name in the CSV file to the Parent Account column.
• BLookup the record IDs Of the records in the ParentAccount column.
• CMap Parent Name in the file to the Parent Account column.
• DCreate an alternate key the account table by using the Account Name column.

Explanation

{"question_number": 2, "question": "You are using the Data import wizard to import records into the account table from a CSV file. Records imported are only related to other records in the file. You need to configure the import to create the relationship between records.", "correct_answer": "A", "explanation": "When importing a self-referential dataset (accounts that are subsidiaries of other accounts in the same file), the Data Import Wizard supports resolving parent-child relationships within the file itself. The correct action is to map the 'Parent Name' column in the CSV to the 'Parent Account' column in the Account table during the column-mapping step. The wizard will resolve the relationship by matching names to records created in the same import batch. Option B (manually looking up GUIDs) is unnecessary - the wizard handles resolution. Option D (alternate key on Account Name) is a useful technique for de-duplication but is not the mechanism that creates the parent-child relationship.", "generated_by": "claude-sonnet", "llm_judge_score": 3}

No community discussion yet for this question.