Microsoft Power BI Data Analyst358 questions across 36 pages are complete and free, with no account or card.
358 questions in this bank
Free access · progress saved on this device
In Power BI Desktop, you have a dataset that contains a table. You create a table visual on a Power BI report page as shown in the following exhibit.
You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?
Answer: D
DRAG DROP - You have a Microsoft Excel spreadsheet named Excel1 that contains survey results. You have a Power BI dashboard named DashboardA that has Q&A enabled. You need to ensure that users who can access DashboardA can ask questions based on the contents of Excel1 and pin visuals based on their queries to DashboardA. The solution must minimize development time. 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. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Step 1: From powerbi.com, upload Excel1. Upload your Excel file to the Power BI service. The Power BI service connects to many data sources, including Excel files that live on your computer. 1. Sign in to the Power BI service. 2. In My workspace, select New > Upload a file. 3. Select Local File, browse to where you saved the Financial Sample Excel file, and select Open. 4. On the Local File page, select Import. Now you have a Financial Sample dataset. Power BI also automatically created a blank dashboard. If you don't see the dashboard, refresh your browser. Step 2: From powerbi.com, import Excel1 as a dataset. Step 3: From powerbi.com, add a tile for the Excel1 dataset to DashboarA. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-from-excel-to-stunning-report
Source: Adapted from community discussion — RickyAnd
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 have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a constant line and set the value to .5. Does this meet the goal?
Answer: B
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 have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create an average line by using the Salary measure. Does this meet the goal?
Answer: B
We need to set a constant line using the median value of the salary and the average is not the median (in some cases it could be match but they are not the same)
Source: Adapted from community discussion — jaume
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 have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a percentile line by using the Salary measure and set the percentile to 50%. Does this meet the goal?
Answer: A
I have to correct my previous statement. Median line and percentile line are different options in Power BI. But it turns out that the 50th percentile is the same as the median. I think that this hasn't something to do with Power BI anymore, but I have to recall my previous choice. So the answer must be A.
Source: Adapted from community discussion — Hoeishetmogelijk
HOTSPOT - You are profiling 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.
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. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: are 20 values that occur - There are 20 unique values. Box 2: Elm, American - Elm, American is below Peer, flowering species in the graphic.
Source: Adapted from community discussion — Mati_123
You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?
Answer: A
The correct answer is C. Option A, enabling report readers to personalize visuals, allows users to customize the look of visuals but does not provide the option to switch between different types of visuals. Option B, creating a separate report page for users to view the column chart, requires additional development effort and maintenance to maintain two separate pages with similar data. Option D, creating a mobile report that contains a column chart, is not necessary for the given scenario and may not provide an optimal experience for desktop users. Option C, adding a column chart, a bookmark, and a button for users to choose a visual, is the best solution to enable users to switch between different visualizations. This solution minimizes development and maintenance effort by using existing report elements and only requires the addition of a button and bookmark to toggle between visuals.
Source: Adapted from community discussion — Loesf
You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power BI dashboard that will include two visuals from each report. You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Answer: CD
Answer is correct. I guess, with the requirement "The solution must preserve the original colors of the reports." they only want to point out, that the colors must not be changed FOR the reports to achieve the goal, but only change the theme for the dashboard. A little misleading, IMHO. B is wrong, because the dark mode is a personal setting on the user's computer and has nothing to do with the dashboard theme, which is required to be dark.
Source: Adapted from community discussion — fred92
HOTSPOT - You have a dataset that contains revenue data from the past year. You need to use anomaly detection in Power BI to show anomalies in the dataset. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: Line - Anomaly detection is only supported for line chart visuals containing time series data in the Axis field. Box 2: Populate the axis with a date field Incorrect: * Anomaly Explanations doesn't work with 'Show Value As' options. * Drilling down to go to the next level in the hierarchy isn't supported. Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection
You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What should you do?
Answer: C
C is correct. Only in the explanation the most essential part is not clearly explained. I's best to look it up for yourself: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
Source: Adapted from community discussion — Hoeishetmogelijk
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
PL-300 practice, question 211. 358 questions available.
Version 1.0.0. How we source questions