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

QWhich data model design generally provides the BEST reporting performance and maintainability?

ID: #25390 Introduction to Power BI 2 views
Question Info
#25390Q 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 Snowflake schema with excessive normalization. ✔ ✖
  • B Star schema with Fact and Dimension tables. ✔ ✖
  • C A single table containing every column from every source. ✔ ✖
  • D Multiple unrelated tables without relationships. ✔ ✖
Correct Answer

Explanation

Option B is correct because Star Schema is considered the recommended modeling approach in Power BI. It improves performance, simplifies DAX calculations, and makes reports easier to maintain. Option A can introduce unnecessary complexity. Option C may create scalability issues. Option D prevents meaningful analysis.
 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

Which of the following is a common use of Power BI? Why is data transformation important in Power BI? Which feature makes Power BI valuable for decision-making? What type of users commonly use 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 A Power BI developer notices that report performance is slow. The model contains many unnecessary columns that What is the primary purpose of an On-Premises Data Gateway? Which statement best describes filter context in DAX? Which scenario is MOST suitable for DirectQuery instead of Import Mode?