A financial analyst needs to create a report that shows the general ledger balances for each month. The analyst wants to use Excel to perform further analysis and formatting. The data must be easily refreshed when new transactions are posted. Which approach should the developer recommend?

Create an SSRS report and export it to Excel

Use the Excel add-in with a data entity to create a linked table

Export the data to a static Excel file using the Export to Excel feature

Use Power BI to export data to Excel

What is the standard process to deploy an SSRS report in Dynamics 365 Finance and Operations?

Deploy the report project from Visual Studio to the report server

Upload the .rdl file to the document management system

Import the report through the Power Platform admin center

Copy the report to the AOS service folder

You have deployed a new SSRS report to the production environment of Dynamics 365 Finance and Operations. Users report that the report is not visible in the client. You have verified that the report is deployed to the SSRS server. What is the most likely cause?

The menu item for the report is not added to the client

The report has a data source error

The report is not included in the deployable package

The report is not published to a Power BI workspace

A company needs to generate a regulatory report in a specific format that is not available in the standard Electronic Reporting configurations. The report must be generated monthly and submitted to the government. The developer must create a new configuration. What should the developer do first?

Create a new format configuration from scratch

Create a new data model configuration

Import the format from the global repository

Check if a data model configuration exists that can be reused

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 5Objective 2

Design, Create, and Revise Dynamics 365 Reports MB-500 Practice Questions (Page 5)

Part of the Implement reporting domain, which accounts for 10–15% of the MB-500 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~4–10 in this domain), expect 1–3 from this objective — we provide 51 practice questions to prepare you well beyond it. (estimate)

51questions here

11free pages

10concepts

10–15%of the exam

Questions 21–25

21application · medium
A financial analyst needs to create a report that shows the general ledger balances for each month. The analyst wants to use Excel to perform further analysis and formatting. The data must be easily refreshed when new transactions are posted. Which approach should the developer recommend?
Select an answer first
22foundation · easy
What is the standard process to deploy an SSRS report in Dynamics 365 Finance and Operations?
Select an answer first
23foundation · easy
What is the primary component of an Electronic Reporting (ER) configuration that defines the data structure and format of the output?
Select an answer first
24expert · hard
You have deployed a new SSRS report to the production environment of Dynamics 365 Finance and Operations. Users report that the report is not visible in the client. You have verified that the report is deployed to the SSRS server. What is the most likely cause?
Select an answer first
25expert · hard
A company needs to generate a regulatory report in a specific format that is not available in the standard Electronic Reporting configurations. The report must be generated monthly and submitted to the government. The developer must create a new configuration. What should the developer do first?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MB-500

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MB-500” is a trademark of its owner, used for identification only.