You have an Excel workbook that was created from the 'Open in Excel' feature in Dynamics 365 Finance and Operations. Users are reporting that the data is not refreshing when they update the workbook. What is the likely cause?

The users do not have the Excel add-in installed

The workbook was created with a static data export and does not have a live connection

The workbook is not saved in OneDrive

The Dynamics 365 environment is not configured for Excel integration

A company needs a report that shows daily sales order totals for the last 30 days. The report must be embedded in a Power BI dashboard that refreshes hourly. The data volume is moderate, and the company uses Dynamics 365 Finance and Operations. Which reporting tool should the developer use?

SSRS report with a data provider class

Power BI with the Dynamics 365 Finance and Operations connector

Excel workbook with a data entity export

Electronic Reporting format for a sales order summary

When modifying an Electronic Reporting (ER) format, which action is necessary to ensure the changes take effect?

Deploy the report to the report server

Run the report to test the changes

You have developed a new SSRS report in a development environment and need to make it available in the production environment of Dynamics 365 Finance and Operations. What is the recommended deployment process?

Manually copy the .rdl file to the production report server

Package the model containing the report and deploy it to production via LCS

Use the report designer in the production client to import the report

Publish the report to a shared Power BI workspace and link it from the client

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 4)

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 16–20

16application · medium
You have an Excel workbook that was created from the 'Open in Excel' feature in Dynamics 365 Finance and Operations. Users are reporting that the data is not refreshing when they update the workbook. What is the likely cause?
Select an answer first
17application · medium
A company needs a report that shows daily sales order totals for the last 30 days. The report must be embedded in a Power BI dashboard that refreshes hourly. The data volume is moderate, and the company uses Dynamics 365 Finance and Operations. Which reporting tool should the developer use?
Select an answer first
18foundation · easy
When modifying an Electronic Reporting (ER) format, which action is necessary to ensure the changes take effect?
Select an answer first
19application · medium
You have developed a new SSRS report in a development environment and need to make it available in the production environment of Dynamics 365 Finance and Operations. What is the recommended deployment process?
Select an answer first
20foundation · easy
When modifying an SSRS report in Dynamics 365 Finance and Operations, which file contains the report layout and data bindings?
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.