Power BI – Data Analytics & Visualization › Introduction to Power BI › Question #25394
Multiple Choice Difficult

QA Power BI developer notices that report performance is slow. The model contains many unnecessary columns that are never used. What is the BEST optimization technique?

ID: #25394 Introduction to Power BI 3 views
Question Info
#25394Q ID
DifficultDifficulty
Introduction to Power BITopic
Start Quiz on This Topic
 Your Answer

Select All That Apply

Tick every correct option, then press Check Answer.

  • A Add more visualizations. ✔ ✖
  • B Increase the number of report pages. ✔ ✖
  • C Create additional calculated columns. ✔ ✖
  • D Remove unused columns from the data model. ✔ ✖
Correct Answer

Explanation

Option D is correct because removing unused columns reduces model size, decreases memory consumption, improves refresh performance, and often improves report responsiveness. This is a common Power BI optimization best practice. Option A and Option B generally increase complexity. Option C would likely make performance worse by increasing model size.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Why is data transformation important in Power BI? What type of users commonly use Power BI? Which of the following is a common use of Power BI? What is the primary purpose of Power BI? A report takes 20 seconds to load. Which Power BI tool should be used FIRST to identify which visuals or queri Which statement best describes filter context in DAX? A company wants managers to see only data from their own region in reports. Which Power BI feature should be u What does a KPI visual typically show? A company wants daily sales reports to automatically display current sales figures. Which Power BI feature sup What is the Power BI Service?