Microsoft PL-300 Quiz 3 Topic 10 Questions 11-15

Question: 1

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.

You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.

What should you recommend?

ACreate production reports in a separate workspace that uses a shared dataset from the development
workspace. Grant the end users access to the production workspace.

BCreate one workspace for development. From the new workspace, publish an app for production.

CCreate a workspace for development and a workspace for production. From the production workspace,
publish an app.

DIn one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

Show Answer

Question: 2

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

ACALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
DATESQTD( 'Date'[Date] )
)

BCALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
LASTDATE( 'Date'[Date] )
)

CFIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
)

DCALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( 'Date' [Date] )
)

Show Answer

Question: 3

You have the visual shown in the exhibit. (Click the Exhibit tab.)

q3_PL-300

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

AAdd a play axis.

BAdd a slicer for the year.

CFrom the Analytics pane, add an Average line.

DCreate a DAX measure that calculates year-over-year growth.

Show Answer

Question: 4

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.

From Power Query Editor, you profile the data shown in the following exhibit.

q4_PL-300

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. solution must improve dataset performance.

Solution: You change the IOT DateTime column to the Date data type.

Does this meet the goal?

AYes

BNo

Show Answer

Question: 5

You need to create a visualization to meet the reporting requirements of the sales managers.

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are

AExplanation:
Answer is as below:

Show Answer

Microsoft PL-300 Quiz:3 Topic:10 Questions:11-15