Q01 - Question
You are building an SSRS report in Visual Studio for finance and operations apps. A query alone cannot return the required data because the report needs additional logic to run. The report also needs user-defined parameters. Which two items should you use? Each correct answer presents part of the solution.
Domain: Implement reporting (10–15%) Type: Multi-select
- A. A Query data source type that uses an existing query
- B. A report data provider (RDP) class
- C. An AX enum provider
- D. A contract class that defines the report parameters
B and D are correct.
Explanation: The evidence supports B and D because the report data provider (RDP) class data source type is used when a query cannot be used alone and additional logic is needed to run the report. Along with the RDP class, a contract class is also needed to define the report parameters.
A is incorrect: A Query data source type uses an existing query or a new query. It does not meet the requirement for additional logic beyond a query.
C is incorrect: An AX enum provider is used when a report parameter is an Enum type to filter the report view. It does not provide the additional report logic.
Q02 - Question
Operations managers want an analytical dashboard embedded in a finance and operations apps workspace. The dashboard must show near-real-time data for large volumes of transactions. Users will filter and pivot the data but don't need to print it. Which approach should you use?
Domain: Implement reporting (10–15%) Type: Single choice
- A. A Power BI report that connects to finance and operations apps data through OData endpoints
- B. A Power BI report that uses DirectQuery with the Entity store
- C. An SSRS report that runs periodically in a batch job and is sent by email
- D. An Excel workbook created by using Export to Excel from the transaction grid
B is correct.
Explanation: Power BI is useful for dashboards that don't require printing, and you can embed Power BI reports in finance and operations apps workspaces. For analytical solutions, use DirectQuery with the Entity store. DirectQuery supports near-real-time reporting for large volumes of data.
A is incorrect: OData endpoints are supported, but they are intended for legacy solutions.
C is incorrect: SSRS is suited for documents meant for email, print, archive, and bulk distribution. A scheduled batch job doesn't provide an interactive near-real-time dashboard.
D is incorrect: Export to Excel copies grid data into a workbook at a point in time. It isn't an embedded near-real-time dashboard.
Q03 - Question
A user exports application reports as Microsoft Word documents so that the documents can be edited. The user requests several reports at the same time. What should the user expect?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Each Word document downloads separately to the browser.
- B. The reports are merged into one Word document.
- C. The reports are converted to PDF because Word export supports only one report at a time.
- D. The reports are delivered in a .ZIP file that must be downloaded and uncompressed before the Word documents are used.
D is correct.
Explanation: The evidence supports D because when you request more than one report at a time, the result is a .ZIP file. You must download and uncompress the .ZIP file before you can use the Word documents.
A is incorrect: Multiple reports aren't downloaded as separate files. They're packaged in one .ZIP file.
B is incorrect: The reports aren't merged. Each report remains a separate Word document inside the .ZIP file.
C is incorrect: Word export is still available for multiple reports. The constraint is that you must uncompress the .ZIP file first.
Q04 - Question
A company has locations in several countries or regions that use different languages. You are designing one SSRS transaction report for all locations. The current draft places all fields directly on the report, and users say the layout is cluttered. Which two actions should you take? Each correct answer presents part of the solution.
Domain: Implement reporting (10–15%) Type: Multiple choice
- A. Use labels for all text on the report.
- B. Create an individual report for each country or region that uses a different language.
- C. Use groupings, such as a header and footer grouping and a table layout for transaction data.
- D. Remove all groupings so that every field appears in a single list.
A and C are correct.
Explanation: Use labels for all text on an SSRS report so that the text is automatically translated when the report runs for a country or region with a different language. This lets you maintain one report for all locations. Use groupings to organize data into a meaningful layout, such as a header and footer grouping and a table layout with columns and rows for transaction data.
B is incorrect: Labels remove the need to create and maintain an individual report for each language.
D is incorrect: Showing all data without groupings leads to a cluttered display. Groupings also let you share expressions for a data set.
Q05 - Question
A warehouse manager needs QR Code images on shipping labels that are generated by an ER format in Dynamics 365 Finance. What should you configure in the ER format?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Add a data source of the Barcode type to the ER format.
- B. Set up a default check number interval in the cash and bank management parameters.
- C. Turn on character validation for check numbers.
- D. Create a new configuration provider and set it as active.
A is correct.
Explanation: Use a data source of the Barcode type to produce bar code pictures when you configure an ER format. QR Code is one of the supported two-dimensional bar code formats, and you can use the images on shipping labels.
B is incorrect: A default check number interval is used for interval validation of check numbers. It does not generate bar code images.
C is incorrect: Character validation shows a warning when a character appears in a check number. It does not create images on labels.
D is incorrect: A configuration provider identifies the owner of an ER configuration. It does not generate bar code images.
Q06 - Question
You are the Finance manager for company USMF. Your technical team set up the NACHA (US) ER format for vendor payments. You need to test that the generated payment file matches the local requirement. What should you do?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Turn on Enable design mode in Electronic reporting parameters and open the format in the designer.
- B. Create a new configuration provider and set it as active before you generate payments.
- C. Change the Query timeout (seconds) field to a custom value and run the vendor payment journal.
- D. Verify that NACHA (US) is the Export format for the Electronic method of payment, and then generate payments from a vendor payment journal and open the file.
D is correct.
Explanation: Verify the Export format on the File formats FastTab of the Electronic method of payment. Then create vendor payment journal lines, select Generate payments with the NACHA (US) export format, and open the generated file to verify its content.
A is incorrect: Design mode enables the ER design experience. It does not create a payment file that you can compare with the requirement.
B is incorrect: The active configuration provider is stored as the configuration owner. It is not required to test a format that the technical team already set up.
C is incorrect: The default value of 0 uses the standard system timeout. Changing it does not validate the content of the payment file.
Q07 - Question
You are preparing a Dynamics 365 Finance instance so that advanced business users can design ER configurations. Which two actions should you perform? Each correct answer presents part of the solution.
Domain: Implement reporting (10–15%) Type: Multiple choice
- A. On the Runtime tab of Electronic reporting parameters, enter a custom value in the Query timeout (seconds) field.
- B. Set up the required document types in Document management, such as storage for the jobs archive and for baselines of configuration output.
- C. On the Runtime tab of Electronic reporting parameters, turn on Autofit row height.
- D. On the General tab of Electronic reporting parameters, turn on the Enable design mode option.
B and D are correct.
Explanation: Set up the required document types in Document management before you configure ER. Then turn on Enable design mode on the General tab to enable the ER design experience in the current Finance instance.
A is incorrect: The default value of 0 uses the standard system timeout. A custom value only changes the duration of queries that the ER engine runs and is not required to enable design.
C is incorrect: Autofit row height only adjusts the height of Excel template rows that contain merged cells with wrapped text at runtime. It does not enable the design experience.
Q08 - Question
A developer extended an existing SSRS report by adding a new column through a report data provider class extension. The report works in the cloud-hosted development environment. You must now make the modified report available in the UAT environment. The environment is managed in the Power Platform admin center. What should you do?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Include the report artifacts in a deployable package, build the package by using the ALM or Azure DevOps pipeline, and apply the package through the Power Platform admin center.
- B. Connect Visual Studio to the UAT environment, right-click the report, and select Deploy.
- C. Deploy the report from Visual Studio, and then run a separate publish step to the UAT report server.
- D. Deploy the report from Visual Studio in the development environment, and then refresh UAT from the development environment.
A is correct.
Explanation: Deployments beyond the developer environment must use deployable packages. Include the SSRS report artifacts in a deployable package, build it with your ALM or Azure DevOps pipeline, and apply it through the Power Platform admin center. The deployment installs the report definitions on the report server and registers the report metadata in the application.
B is incorrect: Deploying from Visual Studio is intended for development and testing only. It isn't supported for UAT or production environments.
C is incorrect: In finance and operations apps, deployment also publishes the report to the report server. There is no separate publish step.
D is incorrect: Reports deployed from Visual Studio don't persist across environment refreshes, and UAT must use deployable packages.
Q09 - Question
You are building a query object in X++ for a report. The TrainingMaster table has a TrainingType field and a TrainerID field that has a foreign key relationship to the TrainerTable table. TrainerTable has a TrainerType field. The report must return only TrainingMaster records for online trainings that technical trainers deliver. How should you build the query?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Add TrainingMaster as the data source, and add a QueryBuildRange on TrainingMaster for the TrainerType value Technical.
- B. Add TrainingMaster and TrainerTable as two separate root data sources, and add a sort field on TrainerTable.TrainerType.
- C. Add TrainingMaster as the data source, and call addSortField on TrainingType and TrainerID in ascending order.
- D. Add a range on TrainingMaster.TrainingType for Online, add TrainerTable as a child data source with relations set to true and JoinMode::ExistsJoin, and add a range on TrainerTable.TrainerType for Technical.
D is correct.
Explanation: Use QueryBuildDataSource to add TrainerTable as a child of TrainingMaster, enable relations, and set the join mode to ExistsJoin. Then use QueryBuildRange objects to filter TrainingType on TrainingMaster and TrainerType on TrainerTable. This filters TrainingMaster records based on the related table.
A is incorrect: TrainerType is a field on TrainerTable, not on TrainingMaster. You must add TrainerTable as a related data source to filter on it.
B is incorrect: Separate root data sources don't establish the relationship between the tables, and a sort field orders records but doesn't filter them.
C is incorrect: addSortField only defines sort order. Filtering requires QueryBuildRange.
Q10 - Question
You are a developer creating an aggregate measurement for a KPI that will be embedded in a workspace. Fleet managers must see real-time mileage data. The data must not depend on a periodic refresh. Which configuration should you use?
Domain: Implement reporting (10–15%) Type: Single choice
- A. Set the Usage property of the aggregate measurement to StagedEntityStore.
- B. Set the Usage property of the aggregate measurement to InMemoryRealTime.
- C. Set the Default aggregate property of the measure to Sum.
- D. Set the Goal Type property of the KPI Goal node to BasedOnMeasure.
B is correct.
Explanation: Use InMemoryRealTime when users need real-time data. This option uses Column store indexes of the SQL Server database.
A is incorrect: StagedEntityStore deploys the measure to the Entity store, and the data is refreshed periodically. This setting provides near real-time data, not real-time data.
C is incorrect: The Default aggregate property controls how the measure is calculated, such as sum, count, or average. It does not control whether the data is real-time.
D is incorrect: The Goal Type property defines how the KPI goal is determined. It does not control how the aggregate measurement retrieves data.