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

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.

q3_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: 4

You have a dataset that has the permissions shown in the following exhibit.

q4_PL-300

AExplanation:
Answer as selected.

Show Answer

Question: 5

You have two CSV files named Products and Categories. The Products file contains the following columns:

* ProductID

* ProduetName

* SupplierID

* CategoryID

The Categories file contains the following columns:

From Power Bl Desktop, you import the files into Power Query Editor.

You need to create a Power Bl dataset that will contain a single table named Product. The Product will table includes the following columns:

q5_PL-300

AExplanation:
Answer as selected

Show Answer

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