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

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

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

q4_PL-300

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

q4_PL-300

AOption A

BOption B

COption C

DOption D

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