PL-400 Question #288: Real Exam Question with Answer & Explanation

Question

You are mapping data from an enterprise resource planning (ERP) system to Microsoft Dataverse. You must reference the Name and Email from the ERP system during mapping to ensure that records are unique. You need to create an alternate key that references the Name and Email columns. How should you create the key?

Options

• AAdd a Power Apps command function.
• BUse Power Fx.
• CAdd column to the Account table in Dataverse.
• DCreate a key in the Account table in Dataverse.

Explanation

An alternate key in Microsoft Dataverse allows you to define one or more columns (or a combination of columns) that uniquely identify a record, serving as an alternative to the system-generated primary key (GUID). To reference both Name and Email from an ERP system for unique record matching, you create a composite alternate key on the Account table that includes both columns. This is done through the Power Apps Maker portal under the table's Keys section. Alternate keys are used for upsert operations and data integration scenarios to ensure idempotent record creation/update. Power Apps command functions (A) and Power Fx (B) are not mechanisms for defining data schema keys. Adding a column (C) is about schema extension, not key definition. Creating a key (D) on the table is the correct approach.

No community discussion yet for this question.