Q91
Q91 A report is slow due to large datasets. What optimization can improve performance?
Reduce visuals on the page
Enable query folding
Use fewer colors in charts
Disable drillthrough
Q92
Q92 What is the primary function of Power BI Service?
Data transformation
Cloud-based report sharing and collaboration
Data storage
Query execution
Q93
Q93 What is a workspace in Power BI Service?
A dataset storage area
A collaborative environment for reports and dashboards
A data transformation tool
A DAX formula editor
Q94
Q94 What is the difference between Power BI Free and Power BI Pro?
Power BI Free allows sharing reports, while Pro does not
Power BI Pro includes sharing and collaboration features
Power BI Free supports unlimited datasets, while Pro has limits
There is no difference
Q95
Q95 How can users schedule automatic data refresh in Power BI Service?
By using DAX formulas
By configuring dataset refresh settings
By manually refreshing data
By modifying visualization properties
Q96
Q96 What is the purpose of Power BI Premium?
To provide AI-based visualizations
To offer dedicated cloud capacity and advanced analytics
To replace Power BI Desktop
To provide free access to all users
Q97
Q97 How can a user publish a Power BI report to Power BI Service?
By using Power BI Desktop's "Publish" button
By uploading an Excel file
By writing a DAX script
By modifying the dataset manually
Q98
Q98 What Power BI Service feature enables sharing reports with external users?
Publish to Web
Export to PDF
Export to Excel
Direct Query
Q99
Q99 How can you embed a Power BI report into a web application?
By using the Power BI API
By exporting as CSV
By using Power Query
By copying a report screenshot
Q100
Q100 Which authentication method is commonly used for Power BI Service?
API Keys
OAuth
Basic Authentication
FTP
Q101
Q101 A user is unable to share a report in Power BI Service. What could be the issue?
The user has a Free license
The dataset is too large
The report is unpublished
The user is offline
Q102
Q102 A dataset refresh in Power BI Service failed. What should the user check first?
Power Query settings
Data gateway configuration
Dashboard layout
Visual filters
Q103
Q103 A report published in Power BI Service is displaying outdated data. What could be the cause?
The dataset refresh schedule is not configured
The report has too many visuals
The workspace is full
The report theme is incorrect
Q104
Q104 What is the purpose of Row-Level Security (RLS) in Power BI?
To improve report performance
To restrict data access based on user roles
To speed up data refresh
To encrypt Power BI files
Q105
Q105 How does dynamic RLS differ from static RLS?
Dynamic RLS applies user-based filtering, while static RLS applies fixed filters
Static RLS is more flexible than dynamic RLS
Both work the same way
Static RLS requires SQL authentication
Q106
Q106 In Power BI, which function is commonly used to implement dynamic RLS?
FILTER
USERPRINCIPALNAME
LOOKUPVALUE
CALCULATE
Q107
Q107 What happens if a user without RLS access tries to view restricted data?
The report will display an error
The user will see all data
The report will show only allowed data
The report will not load
Q108
Q108 How do you assign RLS roles in Power BI Service?
By modifying DAX expressions
By creating security groups in Power BI Service
By setting permissions in Power Query
By adding roles in SQL Server
Q109
Q109 Which DAX function is commonly used to filter data dynamically based on user roles?
USERNAME
USERPRINCIPALNAME
FILTER
ROLE
Q110
Q110 What is required to implement RLS in a Power BI dataset?
SQL database integration
DAX expressions defining role-based filters
Power Automate workflow
External API authentication
Q111
Q111 A user assigned to an RLS role reports they can still see all data. What could be the issue?
RLS is not applied correctly in Power BI Service
The dataset is too large
The report is in DirectQuery mode
The user is an admin
Q112
Q112 A dataset with RLS is not working as expected. What should be checked?
Whether the dataset is published to Power BI Service
Whether the report is using Import Mode
Whether the roles are properly assigned
Whether DirectQuery is enabled
Q113
Q113 What is the primary benefit of using Import Mode over DirectQuery for performance?
Faster query execution
Real-time data updates
Requires less memory
No need for data modeling
Q114
Q114 How can reducing the number of visuals in a report improve performance?
It reduces CPU usage
It minimizes background queries
It optimizes DAX calculations
It reduces report size
Q115
Q115 How does using aggregations improve Power BI performance?
It reduces the dataset size
It eliminates unnecessary relationships
It optimizes DirectQuery operations
It improves data accuracy
Q116
Q116 What is the impact of enabling "Auto Date/Time" in Power BI?
Improves performance
Reduces dataset refresh speed
Increases memory usage
Optimizes DAX calculations
Q117
Q117 Which DAX function can be used to optimize measure performance?
SUMX
CALCULATE
VAR
ALLSELECTED
Q118
Q118 How does Query Folding help improve Power BI performance?
It pushes transformations to the data source
It increases dataset size
It speeds up DAX execution
It removes redundant queries
Q119
Q119 Which of the following methods can improve DAX performance?
Using SUMX instead of SUM
Minimizing filter context
Reducing calculated columns
Using variables
Q120
Q120 A report is taking too long to load. What should be checked first?
The number of visuals
The use of calculated columns
The dataset size
Data model complexity
