Practice Free PL-300 Exam Online Questions
HOTSPOT
You are profiting data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
- A . From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
- B . From the Power BI Admin portal, modify the Privacy Settings.
- C . From the properties of each dashboard, modify the Share dashboard settings.
- D . Instruct each user to install Microsoft Office 2016.
A
Explanation:
Reference: http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
You have a table named DiMCountries that contains a column named Country as shown in the following table.
You plan to use DiMCountnes as a dimension m a report.
You new to ensure that the Country column in DiMCountnes lists each country only once.
Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
- A . Replace the empty fields.
- B . Apply a clean transform.
- C . Remove duplicate values.
- D . Change Data category to Country.
- E . Apply a Capitalize Each Word transform.
HOTSPOT
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
You have a PBIX file that contains sensitive Information.
You need to secure the information to meet the following requirements:
• Only internal users must be able to open the file If the file Is shared via email.
• Once the file Is published, only Internal users must be able to open the semantic model and the report downloaded from the Power B1 service.
What should you do?
- A . Use a live function lot the file.
- B . From the Power B1 service, apply a sensitivity label.
- C . Certify the semantic model and the report.
- D . From Microsoft Power B1 Desktop, apply a sensitivity label.
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
- A . Active Directory groups
- B . tiles
- C . data classifications
- D . comments
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then “NA” else [Subcategory]
Which command should you use in Query Editor?
- A . Column From Examples
- B . Custom Column
- C . Invoke Custom Function
- D . Conditional Column
D
Explanation:
Reference: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . Column profile
- B . Column distribution
- C . Show whitespace
- D . Column quality
- E . Monospace
AB
Explanation:
B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).
A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.
Reference: https://docs.microsoft.com/en-us/power-query/data-profiling-tools
HOTSPOT
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
Reference: https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
You have a Power Bl model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])
You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.
Which DAX calculation should you use?
- A . CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))
- B . CALCULATE ([Total Sales], DATESQTD (Date[Date]))
- C . TOTALQTD ([Total Sales], Date[Date])
- D . CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))