Microsoft PL-300 Practice Test - Questions Answers, Page 2
List of questions
Question 11
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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.
In the Region table, create a hierarchy that has the manager name, and then the sales manager name.
Explanation:
Question 12
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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 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 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.
Question 13
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
support the reports?
two imported datasets
a single DirectQuery dataset
two DirectQuery datasets
a single imported dataset
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.
Question 14
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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 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 Value field, add Country at the top, followed by ProvState, and then City.
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
Question 15
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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] ),
LASTDATE( 'Date'[Date] )
)
FIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
)
CALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( 'Date' [Date] )
)
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
Question 16
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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 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 pie chart that shows balances by account category without filters.
a ribbon chart that shows balances by quarter and accounts in the legend.
Explanation:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-qand-a
Question 17
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question 18
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question 19
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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”.
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
Question 20
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question