Microsoft Power Platform Developer — Question 50

You are writing C# code to create an alternate key in a table for two columns: Order ID and Order Date. The table has thousands of records.

You use the CreateEntityKey message to create the key. When you retrieve EntityKeyMetadata.EntityKeyIndexStatus, it returns a value of Failed.

You need to resolve the issue with the index creation.

What should you do first?

Answer options

• A. Use the ReactivateEntityKey action.
• B. Publish customizations.
• C. Use the DeleteEntityKeyRequest message.
• D. Delete duplicate combination values in Order ID and Order Date.

Correct answer: D

Explanation

The correct answer is D because duplicate combinations in Order ID and Order Date will prevent the successful creation of an alternate key, resulting in a failed index status. Options A and C address different actions that do not directly resolve the underlying issue, while option B pertains to publishing changes rather than addressing data integrity issues.