Proton Intermediate Power BI Pre-Test

What is a major disadvantage of using Many-to-Many relationships in Power BI data models?

• Improves data redundancy

• Simplifies data model creation

• Can lead to performance issues and ambiguous data

• Enables efficient filtering across multiple tables

Why is a well-designed Date table crucial in Power BI reports?

• Provides aesthetic appeal to reports

• Enables time-based calculations and analysis

• Stores all numerical data for calculations

• Not essential for most reports

What is the primary purpose of creating a Calculated Column in Power BI?

• To establish relationships between tables

• To define new data points based on existing columns

• To filter data based on specific criteria

• To summarize data for measures

What is the primary difference between Power BI Measures and Calculated Columns?

• Measures are used for data summarization and aggregation, while Calculated Columns are used for data manipulation and transformation

• Calculated Columns are visual elements, while Measures are used for detailed data analysis

• Measures are created in Power Query, while Calculated Columns are created using DAX formulas

• There is no difference between Measures and Calculated Columns in Power BI

In what scenario would you use a Combo chart in Power BI?

• To display a single data point with a target value

• To showcase trends across multiple categories using different chart types

• To create a hierarchical view of data

• To display geographical distributions of data

What kind of data visualization does a Shape Map represent in Power BI?

• Trends over time

• Relationships between variables

• Geographical distributions of data

• Part-to-whole relationships

What functionality does Forecasting offer in Power BI?

• To create time-based calculations

• To predict future trends based on historical data

• To filter data for specific date ranges

• To format data for better presentation

What is the advantage of using Quick measures in Power BI?

• They offer more complex calculations than regular measures

• They provide a faster and simpler way to create basic measures

• They are pre-built measures available in Power BI

• They cannot be edited or customized

Explain the purpose of the SWITCH function in DAX formulas for Power BI

• To perform calculations based on specific conditions

• To filter data based on multiple criteria

• To aggregate data for measures

• To create date hierarchies in the Date table

What is the difference between Merging and Appending tables in Power BI?

• Merging combines matching columns, while Appending combines all columns

• Merging creates a new table, while Appending modifies the existing table

• They achieve the same outcome, just with different terminology

• Merging is for numerical data, while Appending is for text data