Exam DP-500 topic 1 question 122 discussion

Actual exam question from Microsoft's DP-500

Question #: 122
Topic #: 1

DRAG DROP
-

You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time.

You use Power BI Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.

You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.

How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Martin_Nbg at July 9, 2023, 10:53 a.m.

Comments

Submit Cancel

Martin_Nbg

Highly Voted 1 year, 11 months ago

Solution should be Query and Query. Requirements say, available categories change over time and all currently available categories should be default. Thus a query is needed for both. See https://learn.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-report-builder?view=sql-server-ver16#AvailableValues

upvoted 8 times

...

hieuleo

Most Recent 1 year, 7 months ago

Could someone please help me to add some comment on question #121 and other questions without any comment so that I can access them? I can't afford Contribution Access.

upvoted 1 times

...