Full Access Microsoft PL-300 Tutorials

Page: 11 / 12

Question 44

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

Options:

From each report in powerbi.com. select Refresh visuals

From Power Bl Desktop, download the PBIX file and refresh the data.

Configure a scheduled refresh without using an on-premises data gateway.

Configure a scheduled refresh by using an on-premises data gateway

Question 45

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Options:

Create a shared dataset for each standardized entity.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

For every report, create and use a single shared dataset that contains the standardized data.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Question 46

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Options:

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

Question 47

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.