Microsoft PL-300 Übungsprüfungen
Zuletzt aktualisiert am 26.04.2025- Prüfungscode: PL-300
- Prüfungsname: Microsoft Power BI Data Analyst
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 26.04.2025
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order.
What should you configure in Microsoft Power Bl Desktop?
- A . the bookmark order
- B . the layer order
- C . the tab order
- D . the X position
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.
What should you do?
- A . In the Weekly.Returns table, create a new calculated column named date-id in a format of
yyyymmdd and use the calculated column to create a relationship to the Date table. - B . Add the Weekly_Returns data to the Sales table by using related DAX functions.
- C . Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region
information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
- A . Create a new aggregation that summarizes by employee.
- B . Create a new group on the state column and set the Group type to List.
- C . Create a new group on the state column and set the Group type to Bin.
- D . Create a new aggregation that summarizes by state.
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
- A . video
- B . custom streaming data
- C . text box
- D . web content
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
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
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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
- A . Yes
- B . No
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.
You need to minimize me size of the dataset. The solution must meet the report requirements.
What should you do?
- A . Change lite OrderlD column in the Orders table to the text data type.
- B . Filter out discontinued products while importing the Product table.
- C . Remove the QuantityPerUnit column from the Products table
- D . Group the Categories table by the CategorylD column.
You need to create the required relationship for the executive’s visual.
What should you do before you can create the relationship?
- A . Change the data type of Sales[region_id] to Whole Number.
- B . In the Sales table, add a measure for sum(sales_amount).
- C . Change the data type of sales[sales_id] to Text.
- D . Change the data type of sales [region_id] to Decimal Number.