Use star schema design, minimize bi-directional relationships,
and optimize measures to improve performance and clarity.
Question 1: Which Power BI component is used to create data models and DAX calculations?
- A. Power BI Service
- B. Power BI Report Server
- C. Power BI Desktop ✅
- D. Power Automate
Explanation: Power BI Desktop is used to load data, transform it, create data models, and write DAX calculations.
Question 2: Which language is used in Power BI to create calculated columns and measures?
- A. SQL
- B. Python
- C. M Language
- D. DAX ✅
Explanation: DAX (Data Analysis Expressions) is used to create measures, calculated columns, and calculated tables.
Question 3: What is the primary purpose of Power Query in Power BI?
- A. Creating dashboards
- B. Writing DAX measures
- C. Data extraction, transformation, and loading (ETL) ✅
- D. Sharing reports
Explanation: Power Query is used to connect to data sources and clean, transform, and prepare data for analysis.
Question 4: Which feature allows restricting data access for users based on their role?
- A. Row-level security (RLS) ✅
- B. Dataflows
- C. Dashboards
- D. Workspaces
Explanation: Row-level security (RLS) restricts data access for users based on defined roles and filters.
Question 5: Where are Power BI reports shared and accessed by end users?
- A. Power BI Desktop
- B. Power BI Service ✅
- C. SQL Server
- D. Excel Online
Explanation: Power BI Service is the cloud platform used to publish, share, and collaborate on reports and dashboards.
Download/Practice full PL-300 exam questions..