NEW
Font size
WorksheetsPower BI / PL-300 Practice Questions
Total questions: 20
Worksheet time: 10mins
What is the first step in the Power BI data workflow?
Create visualizations
Model the data
Connect to data
Publish report
Which Power BI component is mainly used to connect, clean, and transform data?
Power BI Service
Power BI Mobile
Power BI Desktop
Power BI Gateway
What does a CSV file mainly contain?
Images and charts
Unstructured text
Data separated by commas
Database connections
Which file type is commonly used for storing structured data in rows and columns and is easily imported into Power BI?
Excel
Image
Video
When importing data from a Text/CSV file, which tool is used to clean and shape the data?
Power BI Service
Power Query Editor
DAX Editor
Report View
Which pillar of data analysis focuses on explaining the reasons behind past outcomes?
Descriptive Analysis
Diagnostic Analysis
Predictive Analysis
Prescriptive Analysis
When working with semi-structured data in Power BI, which format is most commonly used?
Excel
CSV
JSON
Image
Which data source is MOST suitable for extracting tables from scanned or formatted reports?
Excel
SQL Server
JSON
Which core task of a data analyst involves cleaning, profiling, and transforming raw data?
Visualize Data
Analyze Data
Prepare Data
Manage Data
Which data source allows Power BI to connect directly to relational tables using queries?
Web
SQL Database
Image files
In Power BI, which column profiling feature helps identify the percentage of valid, error, and empty values in a column?
Column Distribution
Column Profile
Column Quality
Column Statistics
Which Power BI feature helps analyze column quality, distribution, and patterns?
DAX Studio
Data Profiling
Report View
Dashboard Tiles
13. Data profiling is important during data preparation because:
it helps identify data quality issues and inconsistencies.
it visualizes data trends for reporting.
it encrypts sensitive data automatically.
it generates random data for testing.
Which Power BI connector allows you to pull data directly from online sources using a URL?
Excel connector
Web connector
SQL Server connector
Folder connector
What does ETL stand for in data processing?
Evaluate, Test, Load
Extract, Transform, Load
Export, Transfer, Link
Edit, Translate, List
In Power BI, which stage involves cleaning and reshaping raw data?
A. Visualization
B. Modeling
C. Transformation
D. Distribution
In Power BI, what is the primary purpose of a semantic model?
To display charts on the report canvas
To store dashboards in the Service
To organize data, relationships, and calculations for analysis
To apply filters and slicers to visuals
What is the main purpose of connecting to multiple data sources in Power BI?
To reduce file size
To create animations
To combine data for better insights
To replace Excel
Which operation is part of the “Transform” step in ETL?
Publishing reports
Writing DAX measures
Removing duplicates
Sharing dashboards
During the ETL process in Power BI, which task occurs during the “Extract” phase?
Creating calculated measures
Publishing reports to the Service
Connecting to data sources
Applying filters to visuals
