We're so confident of our products that we provide no hassle product exchange.
Passing Score, Duration & Questions For Microsoft PL-300 Exam
The passing score: 700
Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian
Time Duration: 180 minutes
Number of Questions: 40-60 questions
Microsoft PL-300 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Power BI Data Analyst |
| Exam Number: | PL-300 |
| Real Exam Qty: | 40-60 |
| Certificate Validity Period: | 12 months |
| Related Certifications: | Microsoft Certified: Data Analyst Associate Microsoft Certified: Power Platform Associate |
| Exam Price: | USD 165 |
| Passing Score: | 700 (out of 1000) |
| Exam Duration: | 180 minutes |
| Available Languages: | Chinese (Simplified), French, Portuguese (Brazil), English, Italian, Japanese, Chinese (Traditional), Russian, Indonesian, Spanish, Korean, Arabic (Saudi Arabia), German |
| Exam Format: | Multiple choice (single/multiple response), Drag and drop, Simulation, Performance-based, Case studies |
| Recommended Training: | Microsoft Official Course: PL-300T00 Microsoft Learn - PL-300 Learning Path |
| Exam Registration: | Microsoft Learn - Schedule Exam Pearson VUE Registration |
| Sample Questions: | Microsoft PL-300 Sample Questions |
| Exam Way: | Online proctored or onsite at Pearson VUE test centers |
| Pre Condition: | No mandatory prerequisites; recommended experience: proficiency in Power Query, DAX, data profiling, and understanding of data security concepts |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300 |
Skills measured
- Visualize and analyze the data (25-30%)
- Model the data (30-35%)
- Download the study guide in the preceding βTipβ box for more details about the skills measured on this exam.
- Prepare the data (15-20%)
- Deploy and maintain assets (20-25%)
Microsoft PL-300 Exam Syllabus Topics:
| Topic | Details |
|---|---|
Prepare the Data (15-20%) | |
| Get data from different data sources | - identify and connect to a data source - change data source settings - select a shared dataset or create a local dataset - select a storage mode - use Microsoft Dataverse - change the value in a parameter - connect to a data flow |
| Clean, transform, and load the data | - profile the data - resolve inconsistencies, unexpected or null values, and data quality issues - identify and create appropriate keys for joins - evaluate and transform column data types - shape and transform tables - combine queries - apply user-friendly naming conventions to columns and queries - configure data loading - resolve data import errors |
Model the Data (30-35%) | |
| Design a data model | - define the tables - configure table and column properties - design and implement role-playing dimensions - define a relationship's cardinality and cross-filter direction - design a data model that uses a star schema - create a common date table |
| Develop a data model | - create calculated tables - create hierarchies - create calculated columns - implement row-level security roles - use the Q&A feature |
| Create model calculations by using DAX | - create basic measures by using DAX - use CALCULATE to manipulate filters - implement Time Intelligence using DAX - replace implicit measures with explicit measures - use basic statistical functions - create semi-additive measures - use quick measures |
| Optimize model performance | - remove unnecessary rows and columns - identify poorly performing measures, relationships, and visuals - reduce cardinality levels to improve performance |
Visualize and Analyze the Data (25-30%) | |
| Create reports | - add visualization items to reports - choose an appropriate visualization type - format and configure visualizations - use a custom visual - apply and customize a theme - configure conditional formatting - apply slicing and filtering - configure the report page - use the Analyze in Excel feature - choose when to use a paginated report |
| Create dashboards | - manage tiles on a dashboard - configure mobile view - use the Q&A feature - add a Quick Insights result to a dashboard - apply a dashboard theme - pin a live report page to a dashboard |
| Enhance reports for usability and storytelling | - configure bookmarks - create custom tooltips - edit and configure interactions between visuals - configure navigation for a report - apply sorting - configure Sync Slicers - group and layer visuals by using the selection pane - drilldown into data using interactive visuals - export report data - design reports for mobile devices |
| Identify patterns and trends | - use the Analyze feature in Power BI - identify outliers - choose between continuous and categorical axes - use groupings, binnings, and clustering - use AI visuals - use the Forecast feature - create reference lines by using the Analytics pane |
Deploy and Maintain Assets (20-25%) | |
| Manage files and datasets | - identify when a gateway is required - configure a dataset scheduled refresh - configure row-level security group membership - provide access to datasets - manage global options for files |
| Manage workspaces | - create and configure a workspace - assign workspace roles - configure and update a workspace app - publish, import, or update assets in a workspace - apply sensitivity labels to workspace content - configure subscriptions and data alerts - promote or certify Power BI content |
For more info visit:
Microsoft Power BI Data Analyst Certification Exam Reference
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/pl-300
Microsoft Power BI Data Analyst Sample Questions:
The Sales table contains records of sales by day from the last five years up until today ' s date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.
Which DAX expression should you use?
- A. TOTALYTD(SUM(Sales[Sales]), DimDate[Date] )
- B. SUM(Sales[Sales])
- C. CALCULATE(SUM(Sales[Sales]), PREVIOUSYEAR(DimDate[Date] ))
- D. CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(DimDate[Date] ))
Correct Answer: D π³οΈ
Explanation: Only visible for BraindumpQuiz members. You can sign-up / login (it's free).
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You decrease the dashboard cache update frequency.
Does this meet the goal?
- A. Yes
- B. No
Correct Answer: B π³οΈ
Explanation: Only visible for BraindumpQuiz members. You can sign-up / login (it's free).
You are modeling data in table named SalesDetail by using Microsoft Power BI.
You need to provide end users with access to the summary statistics about the SalesDetail data. 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.
Correct Answer:
Explanation:
This is a shaping operation in Power Query. Performing it in the applied steps produces correctly typed, named, and structured columns before loading, which keeps report and model logic focused on analysis. Use the selections preserved in the answer exhibit as the supported configuration. What determines the answer is the need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This rationale is anchored to the PL-300 objective " Evaluate data, including data statistics and column properties " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Evaluate data, including data statistics and column properties " | Study guide: https://learn.microsoft.com/en- us/credentials/certifications/resources/study-guides/pl-300
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
The technical decision turns on how to define the relationship from the Customers table to the Invoice table.
The solution must optimize query performance. A lookup-to-fact design normally uses one-to-many cardinality and single-direction filtering from the unique key to the repeating key. That creates predictable propagation and avoids an unnecessary ambiguous filter path. The correct entries in the retained answer area are 1) One-to-many; 2) Single. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. Microsoft lists this skill in the current PL-300 outline as " Define a relationship ' s cardinality and cross-filter direction " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop- relationships-understand | PL-300 objective: " Define a relationship ' s cardinality and cross-filter direction "
| Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
You have a Power BI data model that contains a table named Employees. The table has the following columns:
; Employee Name
; Email Address
; Start Date
; Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
; Users must see only their own employee data
; The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
- A. [Email Address] = USERNAME()
- B. [Email Address] = USERPRINCIPALNAME()
- C. [Employee Name] = USERPRINCIPALNAME()
- D. [Employee Name] = USERNAME()
Correct Answer: B π³οΈ
Explanation: Only visible for BraindumpQuiz members. You can sign-up / login (it's free).
Viewing page 1 out of 95 pages.
Viewing questions 1-5 out of 472 questions.
By Truman
