Skip to main content

Posts

Showing posts with the label 10 Multiple Choice Questions (MCQs) related to Data Modeling in Power BI

10 Multiple Choice Questions (MCQs) related to Data Modeling in Power BI

10 Multiple Choice Questions (MCQs) related to Data Modeling in Power BI 1. What is the primary purpose of data modeling in Power BI? A) To create visualizations only B) To structure relationships between tables for efficient analysis C) To import data from external sources D) To replace the need for SQL databases ✅ Answer: B) To structure relationships between tables for efficient analysis 2. Which statement is true about fact tables and dimension tables? A) Fact tables store descriptive attributes, while dimension tables store numeric data B) Dimension tables store descriptive attributes, while fact tables store numeric data C) Both fact and dimension tables store only numerical data D) Fact tables store unstructured data ✅ Answer: B) Dimension tables store descriptive attributes, while fact tables store numeric data 3. What is the key advantage of using a Star Schema in Power BI? A) Reduces data redundancy but increases query complexity B) Improves query performance and simplifie...