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

q3_PL-300

AExplanation:
Answer as selected

Show Answer

Question: 4

You need to provide a user with the ability to add members to a workspace. The solution must use the

principle of least privilege.

Which role should you assign to the user?

AViewer

BContributor

CMember

DAdmin

Show Answer

Question: 5

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

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