Microsoft PL-400 Exam (page: 3)
Microsoft Power Platform Developer
Updated on: 28-Jul-2025

Viewing Page 3 of 80

HOTSPOT (Drag and Drop is not supported)
You create an alternate key named AlternateKey1 on the Account entity. The definition for AlternateKey1 is shown in the following exhibit:


Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: The combination of Account Number and Account Name must be unique
With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier or unique combination of columns.
Box 2: Delete AlternateKey1 and re-create it with all three fields


Reference:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/define-alternate-keys-entity



HOTSPOT (Drag and Drop is not supported)
A delivery service uses a canvas app to track and deliver packages. The app uses SQL Server as a data store. The database includes the following tables:


The app includes the following code to save all required information. (Line numbers are included for reference only.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




The ClearCollect function deletes all the records from a collection. Syntax: ClearCollect( Collection, Item, ... )

Collection – Required. The collection that you want to clear and then add data to. Item(s) - Required. One or more records or tables to add to the data source.

Box 1: Yes
The Patch function in Power Apps modifies or creates one or more records in a data source, or merges records outside of a data source.
Use Patch with the Defaults function to create records.

Box 2: No
The return value of Patch is the record that you modified or created. If you created a record, the return value may include properties that the data source generated automatically. However, the return value doesn't provide a value for fields of a related table.

For example, you use Set(MyAccount, Patch(Accounts, First(Account), 'Account Name': "Example name"); and then MyAccount.'Primary Contact'.'Full Name'. You can't yield a full name in this case. Instead, to access the fields of a related table, use a separate lookup such as:
LookUp(Accounts, Account = MyAccount.Account).'Primary Contact'.'Full Name

Box 3: Yes

Box 4: Yes
Merge records outside of a data source.
Specify two or more records that you want to merge. Records are processed in the order from the beginning of the argument list to the end, with later property values overriding earlier ones.
Patch returns the merged record and doesn't modify its arguments or records in any data sources.


Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect



A company plans to replicate a Dynamics 365 Sales database into an Azure SQL Database instance for reporting purposes. The Data Export Service solution has been installed.
You need to configure the Data Export service.

Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. Enable auditing for all entities that must be replicated to Azure SQL Database.
  2. Create an export profile that specifies all the entities that must be replicated.
  3. Set up server-based integration.
  4. Enable change tracking for all entities that must be replicated to Azure SQL Database.
  5. Create an Azure SQL Database service in the same tenant as the Dynamics 365 Sales environment.

Answer(s): B,D,E



HOTSPOT (Drag and Drop is not supported)
A company must copy customer account data changes from a Microsoft Dataverse instance into an external system. Azure Storage Queues are used to pass the changes from Dataverse to the external system.

You have the following code. (Line numbers are included for reference only.)



For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 3: No
Either new/updated or removed/deleted.



You are creating a Power Automate flow.
You create an Azure Service Bus listener app that receives requests from a third-party application.
When the flow calls the message queue, it must delete the message as soon as it is read.
You need to ensure that the queue is cleared properly.
Which method or class should you use?

  1. ReceiveMode
  2. BrokeredMessage
  3. EventHubReceiver
  4. EventHubSender

Answer(s): A

Explanation:

ReceiveMode enumerates the values for the receive mode. The default is PeekLock.
Fields:
PeekLock: Specifies the PeekLock receive mode. This is the default value for ReceiveMode.
ReceiveAndDelete: Specifies the ReceiveAndDelete receive mode.

Note: You can specify two different modes in which Service Bus receives messages.
-Receive and delete. In this mode, when Service Bus receives the request from the consumer, it marks the message as being consumed and returns it to the consumer application.
-Peek lock.


Reference:

https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-queues-topics-subscriptions
https://docs.microsoft.com/en-us/dotnet/api/microsoft.servicebus.messaging.receivemode



Viewing Page 3 of 80



Share your comments for Microsoft PL-400 exam with other users:

Chiranthaka 9/20/2023 11:15:00 AM

very useful.
Anonymous


Jeya 9/13/2023 7:50:00 AM

its very useful
INDIA


Chiranthaka 9/20/2023 11:22:00 AM

very useful!
Anonymous