No Installation Required, Instantly Prepare for the PL-300 exam and please click the below link to start the PL-300 Exam Simulator with a real PL-300 practice exam questions.
Use directly our on-line PL-300 exam dumps materials and try our Testing Engine to pass the PL-300 which is always updated.
- (Exam Topic 4)
A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
• Minimize online processing operations.
• Minimize calculation times and render times for visuals.
• include data from the current year, up to and including the previous day. What should you do?
Correct Answer:A
- (Exam Topic 4)
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Correct Answer:AD
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
- (Exam Topic 4)
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?
Correct Answer:D
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
Column quality Column distribution Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/
- (Exam Topic 4)
You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.
A one-to-many relationship exists between the tables. The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
Correct Answer:AD
- (Exam Topic 4)
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Solution:
Reference:
https://finance-bi.com/power-bi-basket-analysis/
Does this meet the goal?
Correct Answer:A