An existing SSRS report displays the 'Total Amount' field with two decimal places. The business now requires the report to show the amount in thousands, rounded to zero decimal places. The developer must modify the report. What should the developer do?

Modify the RDP class to return the amount as a string

Change the data type of the dataset field to integer

Set the report's language property to a locale that uses no decimals

Change the Format property of the text box to 'N0' and update the expression to divide the value by 1000

A user has an Excel report that was exported from Dynamics 365 Finance and Operations. They want to add a calculated column to the data. What is the simplest way to do this?

Use Power BI to transform the data

Add a formula in a new column in Excel

Modify the data entity in Dynamics 365

You are modifying an existing SSRS report in Dynamics 365 Finance and Operations. The report currently uses a query that returns too much data, causing performance issues. You need to improve performance without changing the report's output. What should you do?

Use a data entity instead of a query

Modify the report's data source query to filter data at the database level

Increase the report's timeout value

Add a filter in the report's dataset properties

An existing Excel report uses a data entity to show customer balances. The business now wants to add a calculated column that shows the balance in a different currency. The developer must modify the Excel report. What should the developer do?

Modify the data entity to include the calculated field

Create a new Power BI report and import the Excel data

Add a calculated column in the Excel table using a formula that references the balance column and the exchange rate

Use the Excel Data Type feature to get currency rates

A company must generate an electronic invoice in a format required by the local tax authority. The format is not available in the standard Electronic Reporting configurations. The developer needs to create a new configuration. What should the developer do first?

Create a new data model configuration from scratch

Import the format from the global repository

Create a new mapping configuration and attach it to the format

Create a new Electronic Reporting format configuration that uses an existing data model

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

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 11–15

11application · medium
An existing SSRS report displays the 'Total Amount' field with two decimal places. The business now requires the report to show the amount in thousands, rounded to zero decimal places. The developer must modify the report. What should the developer do?
Select an answer first
12foundation · easy
A user has an Excel report that was exported from Dynamics 365 Finance and Operations. They want to add a calculated column to the data. What is the simplest way to do this?
Select an answer first
13expert · hard
You are modifying an existing SSRS report in Dynamics 365 Finance and Operations. The report currently uses a query that returns too much data, causing performance issues. You need to improve performance without changing the report's output. What should you do?
Select an answer first
14application · medium
An existing Excel report uses a data entity to show customer balances. The business now wants to add a calculated column that shows the balance in a different currency. The developer must modify the Excel report. What should the developer do?
Select an answer first
15application · medium
A company must generate an electronic invoice in a format required by the local tax authority. The format is not available in the standard Electronic Reporting configurations. The developer needs to 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.