PL-300 Mock Exam :Microsoft PL-300 Exam Preparation and Practice (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Scheduled refresh using Microsoft 365 credentials (flat files)

✅ OneDrive for business
✅ SharePoint – Team sites
❌ Personal OneDrive account
❌ Local file

Explanation:
Only OneDrive for Business and SharePoint Team Sites support scheduled refresh with Microsoft 365 credentials.

Question 2

External users access data source

❌ Common data services
✅ SQL Server
❌ OneDrive
❌ SharePoint

Explanation:
SQL Server can be securely exposed for external access.

Question 3

Create custom connector for third-party API

❌ Power Automate
❌ Power BI
❌ Power Apps
✅ Power Query

Explanation:
Custom connectors are created using Power Query SDK.

Question 4

Change Azure SQL connection with minimum effort

✅ Modify the data source settings.
❌ Create a Power BI file and change source when prompted
❌ Modify each query source
❌ Create new queries

Explanation:
Data source settings update all connections at once.

Question 5

Create month column without DAX

❌ Group By
❌ Extract
✅ Date
❌ Trim

Explanation:
Date transformations allow Month extraction.

Question 6

Separate city, state, postal code

❌ Modify data type
❌ Replace values
❌ Modify data category
✅ Split column

Explanation:
Split column separates combined fields.

Question 7

Keep all rows from first table + matches from second

✅ Left outer join
❌ Left inner join
❌ Right inner join
❌ Right outer join

Explanation:
Left outer join keeps all rows from left table.

Question 8

DimDate storage mode for mixed fact tables

❌ DirectQuery
✅ Dual
❌ None
❌ Import

Explanation:
Dual works efficiently with both Import and DirectQuery.

Question 9

Create aggregations for DirectQuery

❌ Page view
✅ Model view
❌ Data view
❌ Power Query editor

Explanation:
Aggregations are configured in Model view.

Question 10

Dimension table data

✅ Descriptive information
❌ Detailed performance data
❌ Transactional data
❌ Aggregated metrics

Explanation:
Dimensions store descriptive attributes.

Question 11

Identify data anomalies

❌ Data view
✅ Power query editor
❌ Advanced editor
❌ Model view

Explanation:
Power Query editor is used for data profiling.

Question 12

View & modify full M code

❌ Model view
❌ Power query editor
❌ Formula bar
✅ Advanced editor

Explanation:
Advanced editor shows full M code.

Question 13

Create & manage dataflows

❌ Power BI Desktop
❌ Power Query
❌ Data modeler
✅ Power BI Service

Question 14

Duplicate query without repeating steps

❌ Duplicate PBIX file
✅ Reference query
❌ Duplicate data model
❌ Duplicate query

Explanation:
Reference query reuses transformation steps.

Question 15

Analyze sales per employee (1-to-many)

❌ Both
❌ None
✅ Single

Explanation:
Single direction is sufficient.

Question 16

Use inactive relationship in DAX

✅ USERRELATIONSHIP
❌ KEEPFILTERS
❌ CROSSFILTER
❌ Manage relationship window

Question 17

M code for 1-year date table

✅ =List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0))
❌ Others

Question 18

Default summarization of numeric column

❌ Count
❌ Average
✅ SUM
❌ MIN

Question 19

Validate RLS

❌ Conditional column
❌ DAX filter
❌ What-if parameter
✅ View as feature

Question 20

Total Sales measure (Quantity × Price)

❌ CALCULATE and SUM
✅ SUMX
❌ SUM
❌ CALCULATE

Question 21

Benefits of variables (Select all)

❌ Additional functions
✅ Improve readability
❌ Change data source
✅ Improve performance

Question 22

Non-additive profit margin

❌ SUMX
❌ FIRSTNONBLANK
✅ DIVIDE
❌ AVERAGE

Question 23

Add using DAX (Select all)

✅ Calculated tables
✅ Measures
❌ Display folder
❌ Hierarchies

Question 24

Correct DAX function

❌ FILTER
❌ CALCULATETABLE
✅ CALCULATE
❌ TOPN

Question 25

Benefit of measures

✅ Dynamic, not stored
❌ Used in calculated columns
❌ Assist data load
❌ Data transformation

Question 26

Store pre-aggregated data

✅ Aggregated tables
❌ Measures
❌ Calculated columns
❌ Calculated tables

Question 27

Optimize real-time performance (Select all)

❌ Reduce data via import
❌ Query all requirements
✅ DirectQuery mode
✅ Create aggregations

Question 28

Performance Analyzer helps by

❌ Replace visuals
✅ Showing impact of interactions
❌ Reduce data size
❌ Refresh frequency

Question 29

Running total visualization

❌ Combo chart
❌ Funnel
✅ Waterfall
❌ Scatter

Question 30

Group customers by age similarity

✅ Scatter plot
❌ Waterfall
❌ Card
❌ KPI

Question 31

Theme changes in Service dashboard

❌ True
✅ False

Question 32

Sync slicers requirement

✅ Same column
❌ Same type
❌ Visible
❌ Same title

Question 33

Prevent viewing Year level

✅ Remove Year from hierarchy
❌ Modify range
❌ Filter Quarter/Month/Day
❌ Filter Year

Question 34

Update bookmark after page changes

❌ Auto sync
❌ Button reorder
✅ Update bookmark settings
❌ No formatting needed

Question 35

Drill-through vs Drill-down

❌ Visual vs tabular
❌ Reverse definition
✅ Drill-through = detailed page, drill-down = hierarchy
❌ Interchangeable

Question 36

Dynamic navigation button (Select all)

❌ Page navigation + conditional destination
✅ Bookmark + conditional destination
✅ DAX measure for page name
✅ Conditional formatting for text

Question 37

Multiple managers per employee

❌ Separate reports
✅ PATH function
❌ Ignore relationships
❌ PATHLENGTH only

Question 38

Group visuals (Select all)

❌ Right-click single visual
✅ Format ribbon → Group
❌ Drag & drop
✅ Right-click after multi-select

Question 39

Category breakdown in tooltip

✅ Tooltip visual
❌ Category slicer
❌ Separate page
❌ Separate visual

Question 40

Analytics line from DAX single value

✅ Constant line
❌ Average
❌ Min
❌ Max

Question 41

Q&A configurable features (Select all)

❌ Visual formatting
✅ Review questions
❌ Relationships
✅ Synonyms
❌ Modeling

Question 42

Break down revenue into components

❌ Q&A
❌ Key influencer
❌ Waterfall
✅ Decomposition tree

Question 43

Least privilege to update workspace metadata

❌ Admin
❌ Contributor
❌ Viewer
✅ Member

Question 44

Not supported in dashboards (Select all)

✅ Slicers & filters
✅ Multiple pages
❌ Data alerts
❌ Natural language

Question 45

Alerts on live streaming custom tile

✅ True
❌ False

Question 46

Apply sensitivity labels (Select all)

✅ Semantic models
❌ Dataflows
✅ Workbooks
✅ Paginated reports

Question 47

Troubleshoot data flow

❌ Query caching
❌ Usage metrics
✅ Lineage view
❌ Quick insights

Question 48

Gateway decision factors

❌ Same features
❌ Data center location
❌ Type of data sources
✅ Users & centralized management

Question 49

Refresh requiring parameters

✅ Incremental refresh
❌ On-demand
❌ Scheduled

Question 50

Sensitivity labels (Select all)

✅ Confidential
❌ Personal
❌ Certified
✅ Highly confidential

🧾 Summary Table