1What is the primary purpose of data modeling in Power BI?
A.To create colorful visualizations
B.To define relationships between tables and structure data for analysis
C.To export data to Excel
D.To write SQL queries
Correct Answer: To define relationships between tables and structure data for analysis
Explanation:
Data modeling involves organizing data into tables and defining relationships between them to enable accurate calculations and reporting.
Incorrect! Try again.
2In the context of database normalization, what is the main goal?
A.To organize data to reduce redundancy and improve integrity
B.To delete historical data
C.To increase data redundancy
D.To create a single flat table for all data
Correct Answer: To organize data to reduce redundancy and improve integrity
Explanation:
Normalization is the process of structuring a database to reduce data redundancy and improve data integrity by dividing large tables into smaller, related tables.
Incorrect! Try again.
3Which type of table typically contains quantitative values or metrics to be analyzed?
A.Fact Table
B.Dimension Table
C.Bridge Table
D.Parameter Table
Correct Answer: Fact Table
Explanation:
Fact tables contain measurable, quantitative data (facts) like sales amounts, quantities, and transactional records.
Incorrect! Try again.
4What kind of data is primarily found in a Dimension table?
A.Descriptive attributes (context)
B.Aggregated totals
C.Foreign keys only
D.Transactional records
Correct Answer: Descriptive attributes (context)
Explanation:
Dimension tables contain descriptive attributes (like Customer Name, Product Category, or Region) used to filter and group the data in fact tables.
Incorrect! Try again.
5What is a Star Schema?
A.A central fact table surrounded by denormalized dimension tables
B.A schema where every table is connected to every other table
C.A single flat table containing all data
D.A structure where dimension tables are normalized into multiple related tables
Correct Answer: A central fact table surrounded by denormalized dimension tables
Explanation:
A Star Schema consists of a central fact table directly connected to surrounding dimension tables, resembling a star shape. It is the preferred schema for Power BI.
Incorrect! Try again.
6How does a Snowflake Schema differ from a Star Schema?
A.It does not support relationships
B.It uses only one table
C.Fact tables are normalized
D.Dimension tables are normalized, branching out into further tables
Correct Answer: Dimension tables are normalized, branching out into further tables
Explanation:
In a Snowflake schema, dimension tables are normalized, meaning they are split into related tables (e.g., Product Category separate from Product), creating a branching structure.
Incorrect! Try again.
7Which column is used to uniquely identify each row in a table?
A.Secondary Key
B.Primary Key
C.Alternate Key
D.Foreign Key
Correct Answer: Primary Key
Explanation:
A Primary Key is a unique identifier for each record in a table, ensuring that no two rows are identical.
Incorrect! Try again.
8What is a Foreign Key?
A.A column that points to a Primary Key in another table
B.A hidden column in Power BI
C.A column used to sort data
D.A unique identifier in the current table
Correct Answer: A column that points to a Primary Key in another table
Explanation:
A Foreign Key is a field in a table that links to the Primary Key of another table, establishing a relationship between them.
Incorrect! Try again.
9What is the most common and recommended relationship cardinality in Power BI?
A.One-to-One
B.Many-to-One
C.Many-to-Many
D.One-to-Many
Correct Answer: One-to-Many
Explanation:
One-to-Many relationships are the standard in data modeling, connecting a unique key in a dimension table to multiple instances in a fact table.
Incorrect! Try again.
10What happens when you create a Many-to-Many relationship directly in Power BI without a bridge table?
A.It creates a One-to-One relationship automatically
B.It automatically normalizes the data
C.Power BI allows it but it may introduce ambiguity and performance issues
D.Power BI rejects the relationship
Correct Answer: Power BI allows it but it may introduce ambiguity and performance issues
Explanation:
Power BI supports Many-to-Many cardinality, but it is generally discouraged for beginners as it can lead to ambiguous filter contexts and performance degradation compared to using a bridge table.
Incorrect! Try again.
11In Power BI, what does the 'Cross-filter direction' setting determine?
A.The color of the relationship line
B.Which table is hidden
C.The format of the data dates
D.How filters propagate between related tables
Correct Answer: How filters propagate between related tables
Explanation:
Cross-filter direction (Single or Both) controls how filter context flows from one table to another across a relationship.
Incorrect! Try again.
12What is the downside of using 'Both' in Cross-filter direction?
A.It deletes data
B.It is only available for text data
C.It prevents the use of measures
D.It can cause ambiguity and performance issues
Correct Answer: It can cause ambiguity and performance issues
Explanation:
Bi-directional filtering ('Both') can create ambiguous paths for filters, leading to unpredictable results and slower model performance.
Incorrect! Try again.
13Which view in Power BI Desktop is best for managing relationships?
A.Report View
B.Data View
C.Query View
D.Model View
Correct Answer: Model View
Explanation:
Model View provides a diagrammatic representation of tables and relationships, allowing for easy creation and management of the data model.
Incorrect! Try again.
14What does a solid line between two tables in Model View represent?
A.An active relationship
B.An inactive relationship
C.A broken relationship
D.A theoretical relationship
Correct Answer: An active relationship
Explanation:
A solid line represents the active relationship used by default for calculations. A dashed line represents an inactive relationship.
Incorrect! Try again.
15How many active relationships can exist directly between two specific tables in Power BI?
A.Zero
B.Exactly one
C.Unlimited
D.Up to five
Correct Answer: Exactly one
Explanation:
There can be only one active relationship between two tables at a time. Additional relationships must be inactive.
Incorrect! Try again.
16What is a 'Surrogate Key'?
A.A text-based description
B.A key based on business logic like Social Security Number
C.An artificial, system-generated unique identifier (usually an integer)
D.A duplicate key
Correct Answer: An artificial, system-generated unique identifier (usually an integer)
Explanation:
A surrogate key is a unique identifier assigned to a record (often an incremental integer) that has no business meaning but is efficient for joining tables.
Incorrect! Try again.
17To handle a Many-to-Many relationship properly, what type of intermediate table is recommended?
A.Bridge (or Junction) Table
B.Fact Table
C.Summary Table
D.Dimension Table
Correct Answer: Bridge (or Junction) Table
Explanation:
A Bridge table contains unique keys from both sides of a Many-to-Many relationship, resolving it into two One-to-Many relationships.
Incorrect! Try again.
18What is the function of the USERELATIONSHIP DAX function?
A.To delete a relationship
B.To rename a column
C.To activate an inactive relationship for a specific calculation
D.To create a new table
Correct Answer: To activate an inactive relationship for a specific calculation
Explanation:
USERELATIONSHIP is used within measures to override the default active relationship and use an inactive one (e.g., relating OrderDate vs. ShipDate).
Incorrect! Try again.
19What is 'Filter Context'?
A.The background color of a visual
B.The connection string to the database
C.The set of filters applied to a calculation at the moment it is evaluated
D.A DAX function used to filter text
Correct Answer: The set of filters applied to a calculation at the moment it is evaluated
Explanation:
Filter context refers to the specific subset of data (filtered by slicers, rows, columns, etc.) that is active when a calculation is performed.
Incorrect! Try again.
20In a standard One-to-Many relationship (Single direction), filters flow from:
A.Neither side
B.The One side to the Many side
C.The Many side to the One side
D.The Fact table to the Dimension table
Correct Answer: The One side to the Many side
Explanation:
Filters naturally propagate from the 'One' side (Dimension) to the 'Many' side (Fact) in a standard relationship.
Incorrect! Try again.
21What is a 'Role-Playing Dimension'?
A.A dimension that filters multiple fact tables
B.A single dimension table used for multiple purposes (e.g., Order Date, Ship Date) usually via inactive relationships or copies
C.A dimension that changes data types
D.A dimension generated by AI
Correct Answer: A single dimension table used for multiple purposes (e.g., Order Date, Ship Date) usually via inactive relationships or copies
Explanation:
Role-playing dimensions occur when a single dimension (like Date) relates to a fact table on multiple keys (Order Date, Ship Date, Due Date).
Incorrect! Try again.
22When defining a Data Category for a column containing URLs to product images, which category should be selected?
A.Barcode
B.Uncategorized
C.Web URL
D.Image URL
Correct Answer: Image URL
Explanation:
Setting the Data Category to 'Image URL' tells Power BI to render the link as an actual image in visuals rather than text.
Incorrect! Try again.
23Why is it important to set the correct Data Category for geographical fields (e.g., City, Country)?
A.To reduce file size
B.To change the font
C.To allow Bing Maps to correctly locate and visualize the data
D.To convert text to numbers
Correct Answer: To allow Bing Maps to correctly locate and visualize the data
Explanation:
Data Categories (City, State, Country, etc.) provide metadata that helps map visuals specifically identify geographical locations.
Incorrect! Try again.
24What feature allows you to group Year, Quarter, Month, and Day columns together for drill-down analysis?
A.Clustering
B.Hierarchy
C.Binning
D.Concatenation
Correct Answer: Hierarchy
Explanation:
Hierarchies allow you to structure related columns in a parent-child relationship, enabling users to drill down from high-level data (Year) to granular data (Day).
Incorrect! Try again.
25What is 'Referential Integrity' in the context of data modeling?
A.Ensuring that every Foreign Key value in the child table has a matching Primary Key value in the parent table
B.Removing null values from measures
C.Connecting to cloud data sources
D.Ensuring all text is uppercase
Correct Answer: Ensuring that every Foreign Key value in the child table has a matching Primary Key value in the parent table
Explanation:
Referential integrity ensures consistency between tables; specifically, that a record referenced in one table actually exists in the related table.
Incorrect! Try again.
26If you see a dotted line between two tables in the Model View, what does it signify?
A.An inactive relationship
B.A weak relationship
C.A Many-to-Many relationship
D.A One-to-One relationship
Correct Answer: An inactive relationship
Explanation:
Dotted lines indicate inactive relationships. These exist in the model but do not pass filters unless invoked by DAX.
Incorrect! Try again.
27Which of the following is a benefit of the Star Schema over the Snowflake Schema?
A.More complex SQL queries
B.More tables to manage
C.Higher data redundancy
D.Simpler model structure and generally better performance
Correct Answer: Simpler model structure and generally better performance
Explanation:
Star Schemas require fewer joins than Snowflake schemas, generally resulting in faster query performance and a model that is easier for users to understand.
Incorrect! Try again.
28What is 'Granularity' in a data model?
A.The number of administrators
B.The level of detail represented by a single row in a table
C.The speed of data refresh
D.The color scheme of the report
Correct Answer: The level of detail represented by a single row in a table
Explanation:
Granularity defines what a single row represents (e.g., daily sales vs. monthly sales). Mixing granularities requires care in modeling.
Incorrect! Try again.
29How do you create a hierarchy in Power BI Model View?
A.Create a calculated table
B.Write a SQL script
C.Drag a column onto another column in the same table
D.Use the 'Group' function in Query Editor
Correct Answer: Drag a column onto another column in the same table
Explanation:
In Model or Report view, dragging a field onto another field within the same table initiates the creation of a hierarchy.
Incorrect! Try again.
30What is the 'Hide in Report View' option used for?
A.Deleting data permanently
B.Securing data with a password
C.Preventing users from seeing technical columns (like surrogate keys) in the fields pane
D.Filtering data out of visuals
Correct Answer: Preventing users from seeing technical columns (like surrogate keys) in the fields pane
Explanation:
Hiding columns cleans up the user interface by removing fields that are necessary for the model (like keys or sort columns) but not useful for analysis.
Incorrect! Try again.
31If a relationship is set to 'Assume Referential Integrity', what type of join does Power BI use to generate queries?
A.Inner Join
B.Cross Join
C.Left Outer Join
D.Full Outer Join
Correct Answer: Inner Join
Explanation:
Assume Referential Integrity allows Power BI to use Inner Joins (which are faster) instead of Outer Joins, provided the data integrity is perfect.
Incorrect! Try again.
32What is the risk of having 'Ambiguity' in a data model?
A.The model becomes too colorful
B.You cannot export to PDF
C.The file size increases
D.Power BI cannot determine which path to take for filtering, leading to errors or disabled relationships
Correct Answer: Power BI cannot determine which path to take for filtering, leading to errors or disabled relationships
Explanation:
Ambiguity occurs when there are multiple paths for a filter to travel between tables. Power BI may disable relationships to resolve this.
Incorrect! Try again.
33Which formatting option allows a 'Month Name' column to be sorted chronologically (Jan, Feb) rather than alphabetically (Apr, Aug)?
A.Data Category
B.Sort by Column
C.Format String
D.Group By
Correct Answer: Sort by Column
Explanation:
The 'Sort by Column' feature allows you to sort a text column (Month Name) based on the values of another column (Month Number).
Incorrect! Try again.
34In a Star Schema, the Fact table is usually:
A.Empty
B.Tall and Narrow
C.Unstructured
D.Short and Wide
Correct Answer: Tall and Narrow
Explanation:
Fact tables typically have many rows (tall) and fewer columns (narrow) consisting of keys and measures, compared to dimension tables.
Incorrect! Try again.
35Which of the following is NOT a standard aggregation type for a numeric column?
A.Concatenate
B.Average
C.Sum
D.Min
Correct Answer: Concatenate
Explanation:
Concatenate is a text operation. Sum, Average, Min, Max, and Count are standard numeric aggregations.
Incorrect! Try again.
36When importing data, Power BI automatically detects relationships based on:
A.Table names
B.The order of import
C.Column names and data types matching
D.Row counts
Correct Answer: Column names and data types matching
Explanation:
Power BI attempts to auto-detect relationships if column names and data types match between tables (though this should always be verified manually).
Incorrect! Try again.
37What is a 'Circular Dependency'?
A.A pie chart visualization
B.When Table A depends on Table B, and Table B depends on Table A
C.A chart that is shaped like a circle
D.A relationship between a date table and a sales table
Correct Answer: When Table A depends on Table B, and Table B depends on Table A
Explanation:
Circular dependency creates an infinite loop in logic where two objects rely on each other to be calculated, causing an error.
Incorrect! Try again.
38Why are 'Calculated Columns' generally less preferred than 'Measures' for aggregation?
A.They are harder to write
B.They do not support text
C.They cannot be used in charts
D.They consume memory and storage as they are computed for every row during refresh
Correct Answer: They consume memory and storage as they are computed for every row during refresh
Explanation:
Calculated columns are stored in the model (RAM), increasing file size. Measures are calculated on the fly (CPU) and are generally more efficient for aggregations.
Incorrect! Try again.
39In the 'Edit Relationship' dialog, what does the 'Make this relationship active' checkbox do?
A.Toggles whether the relationship is the primary path for filter propagation
B.Changes the cardinality
C.Reverses the direction
D.Deletes the relationship
Correct Answer: Toggles whether the relationship is the primary path for filter propagation
Explanation:
This checkbox determines if the relationship acts as the default (active) path or serves as an alternative (inactive) path.
Incorrect! Try again.
40What is the primary benefit of Denormalization in Power BI?
A.Reduced file size
B.Better data integrity
C.Improved query performance by reducing the number of joins required
D.Easier data entry
Correct Answer: Improved query performance by reducing the number of joins required
Explanation:
Denormalization (flattening data) reduces the computational cost of joining tables at query time, often improving read performance in Power BI.
Incorrect! Try again.
41Which data type is most efficient for relationship keys?
A.Date/Time
B.String / Text
C.Decimal Number
D.Integer
Correct Answer: Integer
Explanation:
Integers are the most performant data type for relationships because they are small and process faster than strings or floating-point numbers.
Incorrect! Try again.
42What is a 'Disconnected Table'?
A.A table with no relationships to other tables, often used for parameter selection
B.A table that failed to load
C.A table hidden from the report
D.A table with missing data
Correct Answer: A table with no relationships to other tables, often used for parameter selection
Explanation:
Disconnected tables are intentionally left without relationships to serve as sources for slicers or variables in DAX measures (What-If parameters).
Incorrect! Try again.
43If you have a 'Date' table and a 'Sales' table, which column in the Date table should be the Primary Key?
A.Month
B.Quarter
C.Date (unique daily value)
D.Year
Correct Answer: Date (unique daily value)
Explanation:
A Date dimension must have a unique row for every single day. The specific Date column serves as the Primary Key.
Incorrect! Try again.
44How does Power BI handle a relationship where the data types of the join columns do not match?
A.It allows the relationship but with errors
B.It creates a bridge table
C.It prevents the relationship from being created
D.It automatically converts them
Correct Answer: It prevents the relationship from being created
Explanation:
Key columns in a relationship must share the same data type (e.g., both must be Text or both must be Whole Number).
Incorrect! Try again.
45Which of the following describes a 'Parent-Child' hierarchy?
A.A structure where two columns in the same table define the hierarchy (e.g., EmployeeID and ManagerID)
B.A fixed level hierarchy like Year-Month-Day
C.A time-intelligence function
D.A relationship between two different files
Correct Answer: A structure where two columns in the same table define the hierarchy (e.g., EmployeeID and ManagerID)
Explanation:
Parent-Child hierarchies are self-referencing relationships within a single table, often handling variable depths like organizational charts.
Incorrect! Try again.
46What is the purpose of the 'Synonyms' feature in the Model View?
A.To help Q&A visual understand natural language queries by providing alternate names for fields
B.To rename columns permanently
C.To translate data into other languages
D.To create duplicate columns
Correct Answer: To help Q&A visual understand natural language queries by providing alternate names for fields
Explanation:
Synonyms allow users to ask questions in the Q&A visual using terms like 'Revenue' even if the field is named 'SalesAmount'.
Incorrect! Try again.
47When creating a relationship, what does the cardinality 'One-to-One' imply?
A.One record in Table A matches exactly one record in Table B
B.One record in Table A matches many in Table B
C.Many records in Table A match many in Table B
D.The tables are unrelated
Correct Answer: One record in Table A matches exactly one record in Table B
Explanation:
One-to-One means unique values in the key column of both tables. It often suggests the tables could be merged into one.
Incorrect! Try again.
48Why might you disable 'Auto date/time' in Power BI Options?
A.To stop the clock
B.To use the old calendar system
C.To reduce file size by preventing hidden date tables for every date column
D.To prevent date formatting
Correct Answer: To reduce file size by preventing hidden date tables for every date column
Explanation:
Auto date/time creates hidden tables for every date column. Disabling it and using a central Date dimension reduces model bloat.
Incorrect! Try again.
49What is the effect of changing a column's formatting string (e.g., to Currency)?
A.It creates a new table
B.It breaks relationships
C.It only changes how the data is displayed in visuals
D.It changes the underlying data value
Correct Answer: It only changes how the data is displayed in visuals
Explanation:
Formatting strings are cosmetic. They dictate how the number appears (e.g., adding a $ sign), but the underlying number remains unchanged.
Incorrect! Try again.
50In a 'Composite Model', what does it mean?
A.It is a 3D model
B.The model is only for composites
C.You can mix DirectQuery connections and Import data in the same model
D.All data is in Excel
Correct Answer: You can mix DirectQuery connections and Import data in the same model
Explanation:
Composite models allow the combination of different storage modes (Import and DirectQuery) within a single Power BI dataset.