Sample Questions and Answers
What does the “Relationship Cardinality” specify in Power BI?
A) The number of unique values in related columns, e.g., one-to-many
B) The data type of a column
C) The name of a table
D) The refresh frequency of the data
Answer: A) The number of unique values in related columns, e.g., one-to-many
Explanation: Cardinality defines how rows from one table relate to another (one-to-one, one-to-many, many-to-many).
What is the default storage mode when you import data into Power BI Desktop?
A) Import mode
B) DirectQuery
C) Dual mode
D) Live connection
Answer: A) Import mode
Explanation: By default, Power BI imports data into its in-memory model for fast querying.
Which visualization type would best show the proportion of sales by category?
A) Pie chart
B) Line chart
C) Scatter chart
D) Matrix
Answer: A) Pie chart
Explanation: Pie charts are used to display proportions or percentage breakdowns within a whole.
What is the effect of the “Cross filter direction” setting on relationships?
A) It determines if filtering flows from one table to another or both ways
B) It changes column data types
C) It deletes relationships
D) It refreshes data
Answer: A) It determines if filtering flows from one table to another or both ways
Explanation: Cross filter direction controls how slicers and filters affect related tables.
Which DAX function returns the current date and time?
A) NOW()
B) TODAY()
C) DATE()
D) TIME()
Answer: A) NOW()
Explanation: NOW returns the current date and time; TODAY returns only the date.
What is the purpose of calculated tables in Power BI?
A) To create new tables from DAX expressions dynamically
B) To import Excel tables only
C) To schedule data refresh
D) To create relationships
Answer: A) To create new tables from DAX expressions dynamically
Explanation: Calculated tables allow advanced data modeling by generating tables on the fly.
Which data connectivity mode allows real-time querying of Azure SQL Database?
A) DirectQuery
B) Import
C) Dual
D) Live connection
Answer: A) DirectQuery
Explanation: DirectQuery queries the data source live without data import, ideal for real-time data.
How do you hide a column from report view but keep it in the data model?
A) Right-click the column and select “Hide in report view”
B) Delete the column
C) Remove from relationships
D) Format the column
Answer: A) Right-click the column and select “Hide in report view”
Explanation: Hiding a column makes it invisible to report authors while keeping data for calculations.
Which DAX function is used to calculate the percentage of total sales by category?
A) DIVIDE(SUM(Sales[Amount]), CALCULATE(SUM(Sales[Amount]), ALL(Sales)))
B) SUM(Sales[Amount])
C) COUNT(Sales[Amount])
D) AVERAGE(Sales[Amount])
Answer: A) DIVIDE(SUM(Sales[Amount]), CALCULATE(SUM(Sales[Amount]), ALL(Sales)))
Explanation: DIVIDE safely performs division; CALCULATE with ALL removes filters to get total sales.
What is a hierarchy in Power BI?
A) A way to group related columns into levels for drill-down functionality
B) A table relationship type
C) A filter type
D) A data source type
Answer: A) A way to group related columns into levels for drill-down functionality
Explanation: Hierarchies allow users to explore data by levels (e.g., Year > Quarter > Month).
What feature allows users to export data from a Power BI report visual?
A) Export data option on the visual menu
B) Quick Measures
C) Bookmarks
D) Dataflows
Answer: A) Export data option on the visual menu
Explanation: Users can export summarized or underlying data from visuals for external analysis.
What is the difference between Power BI Desktop and Power BI Service?
A) Desktop is for report creation; Service is for sharing and collaboration in the cloud
B) Both are the same
C) Desktop is cloud-based
D) Service is used only for data refresh
Answer: A) Desktop is for report creation; Service is for sharing and collaboration in the cloud
Explanation: Power BI Desktop is a Windows app; Service is the online platform.
Which feature in Power BI helps create data alerts on tiles in dashboards?
A) Alerts
B) Bookmarks
C) Filters
D) Dataflows
Answer: A) Alerts
Explanation: Alerts notify users when data exceeds thresholds on dashboard tiles.
What does “Cross highlighting” mean in Power BI visuals?
A) Highlighting related data points in one visual based on selection in another
B) Exporting data
C) Formatting visuals
D) Importing data
Answer: A) Highlighting related data points in one visual based on selection in another
Explanation: Cross highlighting visually emphasizes related data across visuals.
Which function would you use to count distinct customers in a sales table?
A) DISTINCTCOUNT(Sales[CustomerID])
B) COUNT(Sales[CustomerID])
C) COUNTROWS(Sales)
D) COUNTBLANK(Sales[CustomerID])
Answer: A) DISTINCTCOUNT(Sales[CustomerID])
Explanation: DISTINCTCOUNT counts unique values only.
Which visual is most appropriate for showing correlation between two numerical variables?
A) Scatter chart
B) Table
C) Pie chart
D) Card visual
Answer: A) Scatter chart
Explanation: Scatter charts show relationships between two continuous variables.
What does “Row-level security” (RLS) do in Power BI?
A) Restricts data access for users based on filters defined in roles
B) Encrypts the dataset
C) Controls report access only
D) Automates refresh
Answer: A) Restricts data access for users based on filters defined in roles
Explanation: RLS limits what data users can see within reports.
What is the effect of the “Enable load” option being unchecked for a query?
A) The query won’t load data into the model but can be referenced by other queries
B) The query is deleted
C) The query is exported
D) The data is refreshed automatically
Answer: A) The query won’t load data into the model but can be referenced by other queries
Explanation: This is useful for staging or helper queries.
What is the purpose of Power BI’s Q&A feature?
A) To allow users to ask questions in natural language and get visual answers
B) To export data
C) To schedule refresh
D) To create calculated columns
Answer: A) To allow users to ask questions in natural language and get visual answers
Explanation: Q&A interprets natural language queries to generate visuals dynamically.
How does the “Dual storage mode” improve Power BI dataset flexibility?
A) Tables can switch between Import and DirectQuery modes based on user queries
B) Datasets load twice
C) Queries run on two servers
D) Data is imported twice
Answer: A) Tables can switch between Import and DirectQuery modes based on user queries
Explanation: This optimizes performance by using Import when possible and DirectQuery when needed.
What is a calculated measure in Power BI?
A) A DAX formula that computes a value dynamically based on report filters
B) A static column in a table
C) A data source
D) A relationship
Answer: A) A DAX formula that computes a value dynamically based on report filters
Explanation: Measures calculate results on demand within report context.
How do you enable drill-down capability in a Power BI visual?
A) Add a hierarchy or multiple fields to the axis and enable drill-down controls
B) Use calculated columns
C) Import data
D) Set data categories
Answer: A) Add a hierarchy or multiple fields to the axis and enable drill-down controls
Explanation: Drill-down lets users explore data at different granularity levels.
What does the ALL() function do in DAX?
A) Removes all filters from a table or column
B) Counts rows
C) Filters data by user role
D) Adds a calculated column
Answer: A) Removes all filters from a table or column
Explanation: ALL clears filters, often used in calculations like totals or percentages.
Which of the following is true about Power BI Templates (.pbit files)?
A) They save the report structure and queries without data
B) They contain embedded data only
C) They export data to Excel
D) They schedule refresh
Answer: A) They save the report structure and queries without data
Explanation: Templates allow sharing report design without sharing data.
Which visual can be used to show geographic data in Power BI?
A) Map visual
B) Pie chart
C) Table visual
D) KPI visual
Answer: A) Map visual
Explanation: Map visual plots data points based on geographical data like latitude and longitude.
Reviews
There are no reviews yet.