Prepare for the Microsoft Certified: Power BI Data Analyst Associate Certification with our extensive set of Microsoft PL-300 practice questions. Enhance your knowledge with realistic exam scenarios and expert solutions designed to boost your chances of success.
Note: All questions and answers are based on my experience, research, and self-study.
1.) You have a report in Power Bl Desktop.
you add key influencers visually as shown in the exhibit. (Click the Exhibit tab.)
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic
Note: Each correct selection is worth one point.
A. Identifying additional factors that increase attrition can be achieved by [answer choice].
turning on Cross-report drill throughÂ
adding more fields to the Explain byÂ
adding more fields to the Expand by
moving fields from Explain to Expand by
answer __________________
B. Employee attrition is [answer choice] times greater when employees work overtime.
0.11
.2
1
3
answer _____________________
2.) You have a Power Bl report that contains the visual shown in the following exhibit.
To change the column spacing:
Decrease the space between categones.
Enable overlap for every series.
Enable overlap for the Plan series.
Increase the space between categories.
To add the percent change labels:
Enable data labels for every series.
Enable data labels for the Plan series.
Enable the title on the X-axis.
Enable the title on the Y-axis.
3.) You are building a Power Bl report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?
A. Q&A
B. tunnel chart
C. key influencers
D. decomposition tree
4.) You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries.
You add a slicer named Country to each page of the report
You need to configure the report to meet the following requirements:
*When a user selects a country on the first page, the report must filter the other pages.
*The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task
Answer Area
When a user selects a country on the first page, the report must filter the other pages:_____________________.
The second and third pages must display only the filtered results:________________
5.) The chart will be updated with new data each week.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
A. Add a measure to the Y-axis of the visual that uses the following DAX expression. Measurel = PERCENTILEX.EXC (Sales, Sales (Total Sales],0.40)
B. Create a horizontal line that has a fixed value of 24,000.
C. Add a measure to the Y-axis of the visual that uses the following DAX expression. Measure – PERCENTILEX. ING (Sales, Sales [Total Sales), 0.40)
D. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
6.) You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit .
Which type of visual should you use?
- decomposition tree
- Q&A
- smart narrative
- key influencers
7.) You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Create a bookmark for each slicer value.
B. Sync the slicers across the pages.
C. Repiace the slicers with visual-level filters.
D. Replace the slicers with report-level filters.
E. Replace the slicers with page level filters.
8.) You need to create a visual as shown in the following exhibit.
Answer Area
Conditional formatting: Background color
Data bars
Font color
Icons
Web URL
Format by: Color scale
Field value
Rules
9.) You must enable managers to review the data in a format that meets the following requirements.
- Is optimized for printing.
- Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?
A. a dashboard
B. an interactive report
C. a paginated report
D. template app
10.) You have a Power Bl tenant that contains a workspace named WS1. WSt contains the following items:
- A semantic model named SM1.
- A report named RPT1 that is connected to SM1.
- A report named RPT2 that is connected to SM1.
- A report named RPT3 that is connected to SM1.
- A dashboard named DB1 that contains content from RPT1 and RPT2.
You need to grant workspace access to a group named Group1. The solution must meet the following requirements:
- Group must be able to view RPT1, RPT2, and DB1.
- Group must be prevented from viewing RPT3.
- Group must be prevented from creating new reports and dashboards by using SM1.
- Group must be prevented from sharing the reports and dashboards with other users.
- Administrative effort must be minimized.
What should you do?
A. Share each item individually.
B. Assign Group1 the Viewer role for WS1.
C. Store PBIX files in a shared folder in Microsoft OneDrive.
D. Publish an app.
Related Post:
Microsoft PL-300 Questions Set-1
microsoft pl-300 microsoft pl-300 microsoft pl-300 pl-300 pl-300 microsoft pl-300 exam