A customer service manager wants a workspace KPI that shows the average response time for support tickets in the current month. The KPI must be based on a measure that calculates the average of the response time field. You need to design and implement this KPI. What should you do?

Create a Power BI report with a card visual that averages the response time field.

Use a SQL view to calculate the average and add it as a tile.

Add a form part that shows a grid of tickets and let users calculate the average manually.

Define a KPI in the KPI browser using the average aggregation on the response time field with a filter for the current month.

What is the purpose of creating a drill-through element in a Dynamics 365 workspace?

To automatically refresh data in the workspace

To allow users to navigate from a summary to detailed data

To change the color scheme of the workspace

To define user permissions for the workspace

A retail company wants to add a Power BI report to the Sales workspace. The report shows sales by region and is already published to the Power BI service. The workspace is in an environment that has Power BI integration enabled. What should you do to make the report available in the workspace?

Upload the .pbix file directly to the workspace as a tile.

Add a Power BI tile to the workspace and select the published report from the Power BI service.

Create a new Power BI report from within the workspace using the report designer.

Add a web content tile and paste the Power BI report's embed URL.

What is the typical way to customize a Power BI visualization to meet specific business requirements before embedding it in a Dynamics 365 workspace?

Edit the report in Power BI Desktop

Change the workspace's form template

Modify the X++ code of the workspace

A finance department wants a workspace KPI that shows the total amount of approved purchase orders for the current fiscal period. The KPI must be based on a query that sums the amount from the purchase order lines. You need to implement this KPI. What should you do?

Use a form part to show a grid of purchase order lines and let users manually sum the amounts.

Create a SQL view that sums the amount and then add a tile that displays the view's result.

Add a Power BI report with a card visual that sums the purchase order line amount.

Create a KPI using the KPI browser and define the measure as a sum of the purchase order line amount field with a filter for approved status.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 5Objective 3

Design, Create, and Revise Dynamics 365 Workspaces MB-500 Practice Questions (Page 2)

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 18 practice questions to prepare you well beyond it. (estimate)

18questions here

4free pages

6concepts

10–15%of the exam

Questions 6–10

6application · medium
A customer service manager wants a workspace KPI that shows the average response time for support tickets in the current month. The KPI must be based on a measure that calculates the average of the response time field. You need to design and implement this KPI. What should you do?
Select an answer first
7foundation · easy
What is the purpose of creating a drill-through element in a Dynamics 365 workspace?
Select an answer first
8application · medium
A retail company wants to add a Power BI report to the Sales workspace. The report shows sales by region and is already published to the Power BI service. The workspace is in an environment that has Power BI integration enabled. What should you do to make the report available in the workspace?
Select an answer first
9foundation · easy
What is the typical way to customize a Power BI visualization to meet specific business requirements before embedding it in a Dynamics 365 workspace?
Select an answer first
10application · medium
A finance department wants a workspace KPI that shows the total amount of approved purchase orders for the current fiscal period. The KPI must be based on a query that sums the amount from the purchase order lines. You need to implement this KPI. What should you do?
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.