How to Configure Alternate Keys and Columns for External System Integration in Dataverse?
Table of Contents
Question
You are developing a model-driven app that integrates with an existing system. The system uses the actions Put, Patch, and Get. As part of synchronization between the app and the existing system you must save the unique identifier for each record in a table from the internal system.
You need to create a column to store the unique identifier and configure an alternate key for the table.
Which two actions should you perform? Each correct answer presents part of the solution.
Select all answers that apply.
A. Use a Put action and ensure the column does not contain one of the following characters: /, #, <, >, *, %, &, :, \\, ?
B. Use a Patch action and ensure the column does not contain one of the following characters: /, #, <, >, *, %, &, :, \\, ?
C. Create a single line of text column to store the internal systems unique identifier. Add this column as an alternate key.
D. Create a multiline of text column to store the internal systems unique identifier. Add this column as an alternate key.
Answer
B. Use a Patch action and ensure the column does not contain one of the following characters: /, #, <, >, *, %, &, :, \\, ?
C. Create a single line of text column to store the internal systems unique identifier. Add this column as an alternate key.
Explanation
This item tests the candidate’s knowledge about alternate keys.
A multiline of text column cannot be added as an alternate key, therefore a single line of text column should be used to store the internal unique identifier. If a column that is used for an alternate key contains /, #, <, >, *, %, &, :, \\, or ?, the Patch and Get action will not work. Those are required when it comes to integration though.
Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.