ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 2

List of questions

Question 11

Report
Export
Collapse

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

Apply row-level security (RLS) to the Region table based on the sales manager username.

Apply row-level security (RLS) to the Region table based on the sales manager username.

Configure a bi-directional relationship between Region and Sales.Region.

Configure a bi-directional relationship between Region and Sales.Region.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Suggested answer: C

Explanation:

asked 05/10/2024
Jurriaan van Ingen
33 questions

Question 12

Report
Export
Collapse

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?

Create a shared dataset for each standardized entity.

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.

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

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.

Suggested answer: B
asked 05/10/2024
Winston Seedorf
31 questions

Question 13

Report
Export
Collapse

support the reports?

two imported datasets

two imported datasets

a single DirectQuery dataset

a single DirectQuery dataset

two DirectQuery datasets

two DirectQuery datasets

a single imported dataset

a single imported dataset

Suggested answer: D

Explanation:

"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed.

It is not possible with file sources and Sharepoint lists.

asked 05/10/2024
Angel Luis Cuenca Garcia
33 questions

Question 14

Report
Export
Collapse

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

• Customer ID

• CustomerName

• Address

• City

• ProvState

• Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

In the Axis field, add Country at the top, followed by ProvState, and then City.

In the Axis field, add Country at the top, followed by ProvState, and then City.

In the Value field, add Country at the top, followed by ProvState, and then City.

In the Value field, add Country at the top, followed by ProvState, and then City.

Suggested answer: C

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

asked 05/10/2024
Nezha El Fakraoui
32 questions

Question 15

Report
Export
Collapse

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

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

Suggested answer: A

Explanation:

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter. DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.

Reference:

https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

asked 05/10/2024
Christopher Adams
40 questions

Question 16

Report
Export
Collapse

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.

a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.

a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.

a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a pie chart that shows balances by account category without filters.

a pie chart that shows balances by account category without filters.

a ribbon chart that shows balances by quarter and accounts in the legend.

a ribbon chart that shows balances by quarter and accounts in the legend.

Suggested answer: A, E

Explanation:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-qand-a

asked 05/10/2024
Ksu doo Makek
45 questions

Question 17

Report
Export
Collapse

DRAG DROP

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity. How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 17 106241 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 17 106241 10052024010716000

Explanation:

Scenario: Revenue projections are set at the monthly level and summed to show projections for the quarter. Box 1: IF

Box 2: ISFILTERED

ISFILTERED returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE.

Box 3: SUM

Reference:

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

asked 05/10/2024
Stelios Mantas
27 questions

Question 18

Report
Export
Collapse

HOTSPOT

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 18 106242 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 18 106242 10052024010716000

Explanation:

Box 1: A DAX Calculated measure

Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates. The following sample formula creates a measure that returns the end of the quarter, for the current context. = ENDOFQUARTER(DateTime[DateKey])

Reference:

https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

asked 05/10/2024
Sergio Escobar
34 questions

Question 19

Report
Export
Collapse

HOTSPOT

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 19 106243 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 19 106243 10052024010716000

Explanation:

Box 1: The Viewer role to the workspace

The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.

Microsoft PL-300 image Question 8 explanation 106243 10052024010716000000

Box 2: Build

The analysts must be able to build new reports from the dataset that contains the profit and loss data. Scenario: The reports must be made available to the board from powerbi.com.

The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's dat a. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

Reference:

https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html

asked 05/10/2024
BRUNO DE BRIDA
38 questions

Question 20

Report
Export
Collapse

DRAG DROP

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Microsoft PL-300 image Question 20 106244 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 20 106244 10052024010716000

Explanation:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

asked 05/10/2024
David Powell
29 questions
Total 370 questions
Go to page: of 37
Search

Related questions