You have a Fabric workspace.
You need to create two reports that meet the following requirements:
* Report1: Optimized for printing and can be delivered to users via a scheduled email subscription
* Report2: Optimized for dynamic user interactivity
Which format should you use for each report? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Report1: Power BI Paginated report (.rdl)
Report2: Power BI Interactive report (.pbix)
Repor t 1: Power BI Paginated report (.rdl)
* Paginated reports are ideal for printing or generating PDFs because they are page-formatted .
* They support subscriptions , allowing automated email delivery .
Reference: Microsoft Learn - Power BI paginated vs. Power BI reports
Quoted from the verified discussion in your uploaded document:
"Paginated reports are optimized for printing and can be delivered by email subscription." - Source:
exam_120425_id_116_discussion.pdf, Page ~819-820
Report 2: Power BI Interactive report (.pbix)
Standard Power BI reports are optimized for on-screen interactivity , enabling features such as slicers, filters, and drillthrough actions.
They are built using Power BI Desktop and published as .pbix files.
These are ideal for dynamic exploration , real-time data interaction , and cross-filtering between visuals.

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report that contains a page. The page contains the following visuals:
* A card
* A matrix
* A bar chart
You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix The card and the bar chart must change when a user selects a cell in the matrix.
What should you configure? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...]) Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have a table that contains the following three columns:
City

Total Sales

Occupation

You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Comment: *

Name: *

Email: *

Verification: *