Practice Free PL-300 Exam Online Questions
HOTSPOT
You create a Power Bl dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type In Microsoft Excel.
How should you configure the properties of the table? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.
You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.
Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.
HOTSPOT
You have a folder that contains 50 JSON files.
You need to use Power 81 Desktop to make the metadata of the files available as a single semantic model. The solution must NOT store the data of the JSON files.
Which type of data source should you use. and which transformation should you perform? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are configuring a Power BI report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.
Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . First-level elements colors
- B . Theme colors
- C . Divergent colors
- D . Sentiment colors
You need to minimize the size of the semantic model. The solution must meet the report requirements.
What should you do?
- A . Filter out discontinued products while importing the Products table.
- B . Group the Categories table by the CategorylD column.
- C . Change the OrderlD column in the Orders table to the Text data type.
- D . Remove the QuantityPerUnit column from the Products table.
What should you do to address the existing environment data concerns?
- A . a calculated column that uses the following formula: ABS(Sales[sales_amount])
- B . a measure that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales'[sales_amount] > 0)),[sales_amount])
- C . a measure that uses the following formula: SUM(Sales[sales_amount])
- D . a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
- A . Yes
- B . No
B
Explanation:
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . Text/CSV
- B . Folder
- C . Excel Workbook
- D . SharePoint folder
- E . Web
C, D
Explanation:
– Copy and edit Path of the Excel file then use "Web" Connector: Option E
– Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D
Source: https://www.youtube.com/watch?v=GGHbbg6yi-A
DRAG DROP
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
- B . Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
- C . For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
- D . Create one role for each country.
- E . For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
AC
Explanation:
In Power BI Service the username and userprincipalname both return the email address, it’s only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.