Q01 - Question
An external service must connect to finance and operations apps by using data entities and OData. You already registered the service in the Microsoft Entra admin center as a single tenant application. The security team requires that the service run with only the permissions needed for its operations. What should you do next?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. In finance and operations apps, create a Microsoft Entra applications record and select an administrator account in the User ID field.
- B. In finance and operations apps, go to System administration > Setup > Microsoft Entra applications, enter the application ID in the Client ID field, and select a dedicated service account in the User ID field.
- C. In finance and operations apps, create a Microsoft Entra applications record and enter the tenant ID in the Client ID field.
- D. In Power Automate, go to Data > Connections and create a new connection for the service.
B is correct.
Explanation: After you register the service in Microsoft Entra ID, register it in finance and operations apps. Enter the registered application ID in the Client ID field and select a service account user ID. As a best practice, use a dedicated service account that has only the permissions required for the operations.
A is incorrect: An administrator account doesn't meet the requirement to limit the service to only the permissions it needs.
C is incorrect: The Client ID field requires the application ID. You use the tenant ID later to retrieve a Microsoft Entra ID authentication token.
D is incorrect: A Power Automate connection doesn't register the external service in finance and operations apps, which is required for the service to connect.
Q02 - Question
You create a Power Automate flow that uses the When a Business Event occurs trigger. The flow must run only when the business event occurs in the USMF legal entity. Which two statements are correct? Each correct answer presents part of the solution.
Domain: Integrate and manage data solutions (15–20%) Type: Multi-select
- A. Enter USMF in the Legal entity field, because a blank field subscribes to the business event in all legal entities.
- B. Activate the business event in the business event catalog before you save the flow, because saving the flow doesn't activate it.
- C. If you turn off the flow, the business event endpoint is kept so that it can be reused.
- D. When you save the flow, the required endpoint is set up and the business event is activated.
A and D are correct.
Explanation: When the When a Business Event occurs trigger is added to a flow, you specify the legal entity where the business event is being subscribed to. By default, this field is blank, and the business event is subscribed to in all legal entities. When the flow is saved, a subscription to the selected business event is added, the required endpoint is set up, and the corresponding business event is activated.
B is incorrect: When the flow is saved, the required endpoint is set up and the corresponding business event is activated automatically.
C is incorrect: If you delete the trigger or turn off the flow, the business event endpoint is automatically deleted.
Q03 - Question
You use the Data Entity Wizard in Visual Studio to create FMMyDataEntity for data integrations. The primary datasource is the FMCustomer table. The entity must have public API access and data management capabilities. Which wizard configuration should you use?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. Set Entity category to Master, clear Enable public API, and select Enable data management capabilities.
- B. Set Entity category to Master, and select both Enable public API and Enable data management capabilities.
- C. Set Entity category to Master, select Enable public API, and clear Enable data management capabilities.
- D. Set Entity category to Master, clear both check boxes, and configure the entity later in the Data management workspace.
B is correct.
Explanation: To meet both requirements, select the Enable public API check box and the Enable data management capabilities check box in the wizard. After you complete the wizard, the project contains the data entity, a staging table, and security privileges.
A is incorrect: If you clear Enable public API, the entity doesn't meet the requirement for public API access.
C is incorrect: If you clear Enable data management capabilities, the entity doesn't meet the requirement for data management capabilities.
D is incorrect: You select both settings in the Data Entity Wizard when you create the entity. You use the Data management workspace to manage entities after you create them.
Q04 - Question
A data entity is used in an import project. The configuration key of the data entity and its primary table are enabled. An administrator disables the configuration key of one child table of the data entity. What is the result?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. The child table and all its child tables aren't available in the data entity, but the data entity is available for use.
- B. The data entity isn't available for any purpose.
- C. Only the fields of the disabled child table are hidden, and its child tables remain available in the data entity.
- D. The data entity remains fully available because only the configuration key of the data entity determines availability.
A is correct.
Explanation: When the configuration key of the data entity is enabled and a child table's configuration key is disabled, that table and all its child tables aren't available in the data entity. The overall data entity is still available. After you change the configuration key, refresh the entity list and validate existing data projects and jobs.
B is incorrect: The data entity becomes unavailable for any purpose only when the configuration key of the data entity or its primary table is disabled.
C is incorrect: A disabled child table removes that table and all its child tables from the data entity, not only some fields.
D is incorrect: Availability also depends on the configuration keys of the tables, table fields, and data entity fields that the data entity uses.
Q05 - Question
An external client fails to authenticate when it calls a finance and operations apps service. You capture the HTTPS traffic in Fiddler, extract the OAuth JWT from the authorization header, and paste it into JWT.io. You need to verify that the token targets the correct Microsoft Entra ID resource and was issued for the correct Native Client App. Which two values should you verify? Each correct answer presents part of the solution.
Domain: Integrate and manage data solutions (15–20%) Type: Multiple choice
- A. upn
- B. aud
- C. The bearer segment of the authorization header
- D. appid
B and D are correct.
Explanation: The aud value corresponds to the Microsoft Entra ID resource. Check that its URI has no trailing slash and uses the correct capitalization, because these are typical issues. The appid value corresponds to the Microsoft Entra ID Native Client App ID, which is sometimes called the Service App ID.
A is incorrect: The upn value identifies the user who is authenticated through the Native Client App. It doesn't identify the resource or the client app.
C is incorrect: You remove the bearer segment to get the JWT value. It isn't part of the token contents that you verify in JWT.io.
Q06 - Question
A company is implementing finance and operations apps. Users enter records in an external application. Each record must be validated in finance and operations apps, and the user must see the result before continuing. Which integration type should you recommend?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. An asynchronous integration that runs a nightly batch import
- B. A scheduled batch process that exchanges files every hour
- C. A synchronous integration that returns a response to the caller
- D. An asynchronous integration that prioritizes throughput for high-volume data exchange
C is correct.
Explanation: Synchronous integrations are ideal for scenarios requiring immediate feedback, such as validation or real-time updates.
A is incorrect: An asynchronous integration does not provide immediate validation results to the user.
B is incorrect: A scheduled batch process delays feedback and does not meet the requirement for immediate validation.
D is incorrect: Asynchronous integrations prioritize throughput over immediacy, which does not fit a scenario requiring immediate feedback.
Q07 - Question
A company is integrating an external ordering portal with finance and operations apps. Each request creates a sales order. The order must apply pricing and discounts, enforce credit limits, and follow the same rules as interactive users. Throughput is less important than correct business behavior. Which integration pattern should you use?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. Use OData CRUD operations on a data entity and rely on basic entity validations.
- B. Use a custom service that calls X++ classes with full business logic execution.
- C. Use a batch integration with recurring scheduled imports and minimal business logic.
- D. Use the Excel add-in to publish order rows to a data entity in batches.
B is correct.
Explanation: Custom services are best when heavy domain logic is required. They let you call X++ classes with full business logic execution for transactions such as pricing and reservations. Include business logic when correct business behavior matters more than throughput. Make the integration idempotent by using external reference IDs, natural keys, or de-duplication logic so that retries do not create duplicate transactions.
A is incorrect: OData is suited to CRUD operations with basic validations. It can call business logic through actions, but it isn't ideal for deep transactional behavior.
C is incorrect: Batch integration is suited to high-volume asynchronous imports with minimal business logic. It doesn't meet the need for each order to follow interactive user rules.
D is incorrect: The Excel add-in is used to view, update, and add entity data in a workbook. Publishing is limited to batches of up to 100 rows, and it isn't an integration pattern for an external ordering portal.
Q08 - Question
A reporting system reads finance and operations data from a BYOD database. Users report inconsistent results when reports run while an export is in progress. You must make sure that the reporting system gets consistent data. Which two actions should you take? Each correct answer presents part of the solution.
Domain: Integrate and manage data solutions (15–20%) Type: Multi-select
- A. Configure the reporting system to read directly from the BYOD staging tables during the export
- B. Enable the Enable triggers in target database option for the BYOD database
- C. Schedule the BYOD export by using Manage recurring data jobs
- D. Use the SQL trigger to determine when the data sync is complete, and then hydrate the downstream reporting systems
B and D are correct.
Explanation: The Enable triggers in target database option is disabled by default. When you enable it, export jobs enable SQL triggers in the target database. Use the trigger to determine when the sync from finance and operations apps is complete, and then load the downstream reporting systems.
A is incorrect: The staging tables hold data while the sync is in progress, so they change constantly. Reading directly from them causes inconsistent results.
C is incorrect: Recurring data jobs aren't supported for BYOD. To schedule a BYOD export, use the Export in batch option.
Q09 - Question
A company synchronizes a large, frequently updated data entity to an external reporting system every night. The initial data load is complete. The external system must receive new and updated records and must also remove records that are deleted in finance and operations apps. All tables in the entity support row versioning. Which approach should you recommend?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. Run a full export of the entity every night to make sure that deleted records are excluded.
- B. Use row version change tracking for new and updated records, and implement delete handling separately, such as BYOD delete tracking or custom logic.
- C. Use row version change tracking only, because each delete operation updates the SysRowVersion value of the record.
- D. Add a custom change tracking query to the entity so that row version change tracking captures deletes.
B is correct.
Explanation: Row version change tracking is recommended for nightly or recurring syncs of large entities with frequent updates. However, row version change tracking does not capture delete operations as row version updates. Delete handling must be implemented separately.
A is incorrect: A full export is recommended for an initial data load or one-time migration. You should avoid using full exports when row version change tracking is available and appropriate.
C is incorrect: Row version change tracking does not capture delete operations as row version updates.
D is incorrect: Data entities with custom change tracking queries or range filters are not supported when using row version change tracking.
Q10 - Question
A company is building a third-party mobile app. The app must read and write customer data in finance and operations apps in real time. The customer data is stored across the DirParty, CustTable, LogisticsPostalAddress, and LogisticsElectronicAddress tables. Developers want to keep the app code isolated from changes to the physical tables between versions. What should you recommend?
Domain: Integrate and manage data solutions (15–20%) Type: Single choice
- A. Configure a recurring integration that uses the data management pipeline.
- B. Generate a data package from a data job and import it into the app on a schedule.
- C. Expose a customer data entity as an OData service.
- D. Build the app integration directly against the underlying normalized customer tables.
C is correct.
Explanation: A data entity presents the customer tables as one de-normalized view. You can expose a data entity as an OData service for synchronous integration, including third-party mobile app integrations. The entity abstraction also isolates application code from changes to the physical tables between versions.
A is incorrect: Recurring integrations use the data management pipeline for asynchronous integration. They do not meet the real-time read and write requirement.
B is incorrect: A data package is a compressed file with a manifest and data files. Use it for file-based import, export, and ALM scenarios, not for real-time app access.
D is incorrect: Working directly with the normalized tables makes reads and writes tedious. It also exposes the app code to changes in the physical tables between versions.