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 have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
- A . Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
- B . Remove the Subject and Body columns during the import.
- C . From Model view, set the Subject and Body columns to Hidden.
DRAG DROP
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
- A . Active Directory groups
- B . tiles
- C . data classifications
- D . comments
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?
- A . Show whitespace
- B . Column profile
- C . Column distribution
- D . Column quality
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
- A . Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
- B . Duplicate the Date query in Power Query and use active relationships between both Date tables.
- C . On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
- D . Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
What is the minimum number of datasets and storage modes required to support the reports?
- A . two imported datasets
- B . a single DirectQuery dataset
- C . two DirectQuery datasets
- D . a single imported dataset
HOTSPOT
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have the following three versions of an Azure SQL database:
✑ Test
✑ Production
✑ Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
- A . Create a JSON file that contains the database server names. Import the JSON file to the dataset.
- B . Create a parameter and update the queries to use the parameter.
- C . Create a query for each database server and hide the development tables.
- D . Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?
- A . Create a shared dataset for each standardized entity.
- B . Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
- C . For every report, create and use a single shared dataset that contains the standardized data.
- D . For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.