Practice Free PL-300 Exam Online Questions
You have a Power Bl report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.
What should you do?
- A . Add the Azure network security team as members of the RLS role.
- B . Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
- C . Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
- D . Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.
B
Explanation:
It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.
DRAG DROP
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation:
From Power BI Desktop, select Get Data, and then select Folder.
From Power Query Editor, remove the Content column.
From Power Query Editor, expand the Attributes column.
ion have a Power BI dataset that contains a table named Temperature Readings.
Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A . Split the DateTime column into separate date and time columns.
- B . Disable the Power Query load.
- C . Round the Longitude column two decimal places.
- D . Change the data type of the TempCelsius column to Integer
B
Explanation:
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load
ion have a Power BI dataset that contains a table named Temperature Readings.
Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A . Split the DateTime column into separate date and time columns.
- B . Disable the Power Query load.
- C . Round the Longitude column two decimal places.
- D . Change the data type of the TempCelsius column to Integer
B
Explanation:
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load
HOTSPOT
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report
You need to recommend a solution to improve the performance of the report.
What should you recommend?
- A . Replace the default visuals with AppSource visuals.
- B . Change any DAX measures to use iterator functions.
- C . Remove unused columns from tables in the data model.
- D . Increase the number of times that the dataset is refreshed
C
Explanation:
Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
Explanation:
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
- A . From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”
- B . Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
- C . From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”
- D . Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing
D
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
You build a Power Bi report that displays loT temperature data streaming from a refrigerator.
You publish the report to the Power BI service.
You need to be notified when the temperature rises above four degrees Celsius.
What should you do?
- A . Set an alert on a KPI visual in the report.
- B . Pin a card visual to a dashboard and create a subscription.
- C . Pin a card visual to a dashboard and set an alert on the tile.
- D . Pin a report page to a dashboard and set an alert on the page.
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
- A . Query folding is not occurring.
- B . You selected Only refresh complete periods.
- C . The data type of the column used to partition the data changed.
- D . A filter is missing on the report.
A
Explanation:
The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called “query folding”. It is not recommended that incremental refresh is used when the required query folding cannot take place.
Reference: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/