Sample questions can be like
1. Model Data in Power BI - Design a Semantic Model
Q1: You are working with tables in Power BI and need to create a date table to support time
intelligence functions. What must the date column include for the table to be treated as a date
table?
• A) Continuous data
• B) Unique dates for every row
• C) Dates formatted in the local region's time zone
• D) No missing values
Answer: B
Q2: Which of the following is a key consideration when working with relationships between
tables in Power BI?
• A) The size of the tables does not affect performance
• B) Cross-filter direction between related tables can only be set to single
• C) One-to-many relationships are the most commonly used relationship type
• D) Circular relationships are encouraged for more complex models
Answer: C
2. Model Data in Power BI - Add Measures to Power BI Desktop Models, Use
DAX in Power BI Desktop
Q3: What is the main advantage of using DAX to create calculated columns compared to
Power Query?
• A) It updates as data is loaded into the model
• B) It calculates once when the report is run, optimizing performance
• C) It provides better support for complex aggregations
• D) It can be used with DirectQuery models
Answer: D
Q4: In Power BI, what is the use of Time Intelligence functions in DAX?
• A) To handle Date/Time data types
• B) To generate random date values for data simulation
• C) To analyze data across different time periods (e.g., YTD, QTD, MTD)
• D) To improve the performance of calculated columns
Answer: C
3. Model Data in Power BI - Optimize a Model for Performance
Q5: Which of the following techniques would most likely improve the performance of a large
Power BI model?
• A) Increasing the cardinality of table columns
• B) Using DirectQuery for all tables in the model
• C) Reducing the number of unique values in key columns (cardinality reduction)
• D) Enabling bidirectional filtering for all relationships
Answer: C
Q6: What is a common approach to optimize DirectQuery models in Power BI?
• A) Import all tables into Power BI
• B) Enable cache refresh every 5 minutes
• C) Use aggregations to summarize data and reduce the amount of query processing
• D) Increase the number of relationships in the model
Answer: C
4. Visualize Data in Power BI - Design Power BI Reports
Q7: You are designing a Power BI report and need to make it visually appealing. Which of
the following is the most effective way to ensure visual consistency?
• A) Use the default visual templates for each report
• B) Adjust the visual theme based on the data source
• C) Design a custom theme and apply it across all visuals in the report
• D) Avoid using any formatting to ensure fast loading times
Answer: C
Q8: When designing a report, which feature allows you to display metrics and performance
indicators?
• A) Bookmarks
• B) KPI Visual
• C) DAX Measures
• D) Filters
Answer: B
5. Visualize Data in Power BI - Configure Power BI Report Filters
Q9: You want to enable users to apply interactive filters directly to visuals in Power BI
reports. Which visual element is best suited for this task?
• A) Bookmark
• B) Slicer
• C) Drill-through filter
• D) Report tooltip
Answer: B
Q10: In Power BI, which of the following types of filtering allows you to filter based on the
period in which data was consumed or entered?
• A) Relative Date Filtering
• B) Top N Filtering
• C) Page-Level Filtering
• D) Advanced Text Filtering
Answer: A
6. Visualize Data in Power BI - Enhance Power BI Report Design
Q11: Which technique would improve the user experience when navigating complex reports
with multiple pages?
• A) Avoid using slicers or filters
• B) Use bookmarks to create report navigation buttons
• C) Limit the number of visuals on each page
• D) Disable drill-through to prevent confusion
Answer: B
Q12: How can you highlight values in a table or matrix visual in Power BI to make them
stand out to users?
• A) Use DAX measures to calculate new values
• B) Apply conditional formatting
• C) Sort the values in ascending order
• D) Reduce the font size for all data points
Answer: B
7. Visualize Data in Power BI - Create Dashboards in Power BI
Q13: You want to display a live feed of updated data on a Power BI dashboard. Which
feature allows for real-time data visualization?
• A) Pinning a static report to the dashboard
• B) Adding a live page from a report to the dashboard
• C) Using a static dataset
• D) Downloading data periodically
Answer: B
Q14: What is the purpose of configuring mobile views in a Power BI dashboard?
• A) To prevent dashboard access on mobile devices
• B) To allow users to view dashboards in offline mode
• C) To optimize the dashboard layout for mobile device screens
• D) To enable faster refresh rates for mobile users
Answer: C
