PL-400: Microsoft Power Platform DeveloperDemo

By Microsoft · Question Mode

QuestionQ80

Configure Microsoft Dataverse

You are developing C# code to create an alternate key on a table using two columns: Order ID and Order Date. The table contains thousands of records.

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

You need to resolve the index-creation issue.

What should you do first?

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

An alternate key requires a unique index across its key columns. Existing rows with the same Order ID and Order Date combination prevent that unique index from being created. Remove those duplicate composite values before reactivating the failed key-creation request. Microsoft documents reactivation as the step to take after the cause of a failed alternate-key index build has been corrected.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!