1What is the primary purpose of data modeling in Power BI?
A.To write SQL queries
B.To define relationships between tables and structure data for analysis
C.To create colorful visualizations
D.To export data to Excel
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 increase data redundancy
C.To create a single flat table for all data
D.To delete historical 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.Dimension Table
B.Parameter Table
C.Bridge Table
D.Fact 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.Foreign keys only
B.Transactional records
C.Descriptive attributes (context)
D.Aggregated totals
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 single flat table containing all data
B.A central fact table surrounded by denormalized dimension tables
C.A structure where dimension tables are normalized into multiple related tables
D.A schema where every table is connected to every other table
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 uses only one table
B.It does not support relationships
C.Dimension tables are normalized, branching out into further tables
D.Fact tables are normalized
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.Foreign Key
B.Alternate Key
C.Secondary Key
D.Primary 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-Many
B.One-to-One
C.Many-to-One
D.Many-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.Power BI allows it but it may introduce ambiguity and performance issues
B.It automatically normalizes the data
C.It creates a One-to-One relationship automatically
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.How filters propagate between related tables
B.Which table is hidden
C.The color of the relationship line
D.The format of the data dates
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 is only available for text data
B.It can cause ambiguity and performance issues
C.It prevents the use of measures
D.It deletes data
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.Query View
B.Data View
C.Model View
D.Report 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.A broken relationship
B.An active relationship
C.A theoretical relationship
D.An inactive 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.Up to five
C.Unlimited
D.Exactly one
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 duplicate key
C.A key based on business logic like Social Security Number
D.An artificial, system-generated unique identifier (usually an integer)
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.Summary Table
B.Dimension Table
C.Fact Table
D.Bridge (or Junction) 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 connection string to the database
B.A DAX function used to filter text
C.The set of filters applied to a calculation at the moment it is evaluated
D.The background color of a visual
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 Many side to the One side
C.The One side to the Many 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 changes data types
B.A dimension generated by AI
C.A dimension that filters multiple fact tables
D.A single dimension table used for multiple purposes (e.g., Order Date, Ship Date) usually via inactive relationships or copies
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.Web URL
B.Barcode
C.Image URL
D.Uncategorized
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 allow Bing Maps to correctly locate and visualize the data
B.To reduce file size
C.To change the font
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.Binning
B.Concatenation
C.Hierarchy
D.Clustering
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 all text is uppercase
B.Ensuring that every Foreign Key value in the child table has a matching Primary Key value in the parent table
C.Connecting to cloud data sources
D.Removing null values from measures
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.A One-to-One relationship
B.A Many-to-Many relationship
C.A weak relationship
D.An inactive 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 tables to manage
B.Simpler model structure and generally better performance
C.Higher data redundancy
D.More complex SQL queries
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 speed of data refresh
B.The number of administrators
C.The color scheme of the report
D.The level of detail represented by a single row in a table
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.Use the 'Group' function in Query Editor
B.Write a SQL script
C.Create a calculated table
D.Drag a column onto another column in the same table
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.Left Outer Join
B.Inner Join
C.Full Outer Join
D.Cross 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.You cannot export to PDF
B.Power BI cannot determine which path to take for filtering, leading to errors or disabled relationships
C.The file size increases
D.The model becomes too colorful
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.Unstructured
B.Tall and Narrow
C.Short and Wide
D.Empty
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.Average
B.Concatenate
C.Min
D.Sum
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.Column names and data types matching
B.The order of import
C.Row counts
D.Table names
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 relationship between a date table and a sales table
B.A pie chart visualization
C.A chart that is shaped like a circle
D.When Table A depends on Table B, and Table B depends on Table A
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 cannot be used in charts
B.They are harder to write
C.They consume memory and storage as they are computed for every row during refresh
D.They do not support text
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.Reverses the direction
B.Toggles whether the relationship is the primary path for filter propagation
C.Changes the cardinality
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.Easier data entry
C.Improved query performance by reducing the number of joins required
D.Better data integrity
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.Integer
C.String / Text
D.Decimal Number
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 hidden from the report
B.A table that failed to load
C.A table with missing data
D.A table with no relationships to other tables, often used for parameter selection
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.Year
D.Date (unique daily value)
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 creates a bridge table
B.It prevents the relationship from being created
C.It allows the relationship but with errors
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 fixed level hierarchy like Year-Month-Day
B.A time-intelligence function
C.A structure where two columns in the same table define the hierarchy (e.g., EmployeeID and ManagerID)
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 rename columns permanently
B.To help Q&A visual understand natural language queries by providing alternate names for fields
C.To create duplicate columns
D.To translate data into other languages
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.Many records in Table A match many in Table B
C.The tables are unrelated
D.One record in Table A matches many in Table B
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 prevent date formatting
C.To use the old calendar system
D.To reduce file size by preventing hidden date tables for every date column
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 only changes how the data is displayed in visuals
B.It creates a new table
C.It changes the underlying data value
D.It breaks relationships
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.All data is in Excel
C.You can mix DirectQuery connections and Import data in the same model
D.The model is only for composites
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.