Q31
Q31 A Power BI report using DirectQuery is slow to load. What could be the reason?
The database has too many connections
Power BI cache is full
The query is inefficient
Too many visuals are being used
Q32
Q32 What is the primary purpose of Power Query in Power BI?
To visualize data
To transform and clean data
To store large datasets
To create DAX formulas
Q33
Q33 What does "Applied Steps" in Power Query Editor represent?
A history of data transformations
Data sources used in the report
Power BI visualization settings
Database queries used
Q34
Q34 Which of the following data transformations is NOT possible in Power Query?
Removing duplicates
Changing data types
Writing DAX formulas
Merging queries
Q35
Q35 Which function in Power Query is used to combine multiple queries into one?
Merge Queries
Append Queries
Group By
Transpose
Q36
Q36 What happens when you "Remove Columns" in Power Query?
The column is deleted permanently
The column is hidden
The column is removed only in the query
The data type changes
Q37
Q37 What is the purpose of the "Unpivot Columns" feature in Power Query?
Convert multiple rows into columns
Convert multiple columns into rows
Group data
Merge tables
Q38
Q38 Which Power Query function is used to remove duplicate rows?
RemoveColumns
RemoveRows
DistinctRows
Table.Distinct
Q39
Q39 How do you change the data type of a column using M code in Power Query?
ChangeColumnType
Table.TransformColumns
Table.ChangeType
Modify.ColumnType
Q40
Q40 Which M function in Power Query is used to extract text between two delimiters?
Text.Middle
Text.BetweenDelimiters
Text.Split
Text.Extract
Q41
Q41 A user applied a transformation but does not see the changes in Power BI report view. What is the likely reason?
The transformation was not applied in Power BI
The dataset is too large
The applied steps were deleted
The data type is incorrect
Q42
Q42 After merging two queries, a user finds missing values in the result. What could be the issue?
Incorrect join type
Column formatting error
Data source connection issue
Query execution error
Q43
Q43 A Power Query step is causing an error, and the error message states "Expression.Error:
The column does not exist".
What should the user check?
Column names in the dataset
Database permissions
Visual filters
Query refresh settings
Q44
Q44 What is the purpose of relationships in Power BI data modeling?
To merge queries
To connect tables based on common fields
To create new tables
To improve visual formatting
Q45
Q45 Which type of relationship is most commonly used in Power BI?
One-to-One
One-to-Many
Many-to-Many
Self-Join
Q46
Q46 What is the purpose of cardinality in Power BI relationships?
It defines table size
It determines the relationship type between tables
It improves data performance
It filters query results
Q47
Q47 What happens if you create a Many-to-Many relationship in Power BI?
Data duplication
Performance optimization
Ambiguous relationships
Faster query execution
Q48
Q48 What does a dotted line indicate in Power BI’s Model View?
An active relationship
An inactive relationship
A primary key
A calculated column
Q49
Q49 What should you do if a circular dependency occurs in Power BI relationships?
Delete tables
Use DAX to resolve dependencies
Change data types
Increase storage
Q50
Q50 Which DAX function is used to create a calculated column that combines two fields?
CONCATENATE
MERGE
APPEND
UNION
Q51
Q51 How do you filter one table based on another using DAX?
RELATED
LOOKUPVALUE
FILTER
CALCULATE
Q52
Q52 Which DAX function is used to create a dynamic Many-to-Many relationship?
CROSSJOIN
TREATAS
UNION
INTERSECT
Q53
Q53 A relationship is created, but no data appears in visuals. What could be the issue?
The relationship is inactive
The table is hidden
The dataset is too large
Data types mismatch
Q54
Q54 After creating a relationship, filtering is not working as expected. What could be the problem?
Incorrect relationship direction
Too many visuals
Unformatted data
Missing fields
Q55
Q55 A Many-to-Many relationship causes incorrect totals in a report. What could be a possible solution?
Create an intermediate table
Delete unnecessary columns
Change visuals
Use Import Mode
Q56
Q56 What is DAX primarily used for in Power BI?
Data transformation
Data modeling and calculations
Data storage
Visual formatting
Q57
Q57 Which of the following is NOT a valid DAX function category?
Aggregation
Logical
Security
Date and Time
Q58
Q58 What is the purpose of the CALCULATE function in DAX?
To apply filters and modify the context of a calculation
To merge two tables
To create a new column
To generate random values
Q59
Q59 What is the difference between a calculated column and a measure in DAX?
Measures are evaluated on the fly, while calculated columns are stored in the data model
Measures are stored permanently, while calculated columns are not
Calculated columns update dynamically, while measures do not
There is no difference
Q60
Q60 How does the FILTER function in DAX operate?
It modifies row context
It changes table relationships
It creates a new table based on filter criteria
It sorts the table
