Unit 3 - Practice Quiz

INT374 50 Questions
0 Correct 0 Wrong 50 Left
0/50

1 What 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

2 In 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

3 Which type of table typically contains quantitative values or metrics to be analyzed?

A. Dimension Table
B. Parameter Table
C. Bridge Table
D. Fact Table

4 What kind of data is primarily found in a Dimension table?

A. Foreign keys only
B. Transactional records
C. Descriptive attributes (context)
D. Aggregated totals

5 What 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

6 How 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

7 Which column is used to uniquely identify each row in a table?

A. Foreign Key
B. Alternate Key
C. Secondary Key
D. Primary Key

8 What 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

9 What 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

10 What 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

11 In 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

12 What 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

13 Which view in Power BI Desktop is best for managing relationships?

A. Query View
B. Data View
C. Model View
D. Report View

14 What 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

15 How many active relationships can exist directly between two specific tables in Power BI?

A. Zero
B. Up to five
C. Unlimited
D. Exactly one

16 What 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)

17 To 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

18 What 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

19 What 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

20 In 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

21 What 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

22 When 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

23 Why 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

24 What feature allows you to group Year, Quarter, Month, and Day columns together for drill-down analysis?

A. Binning
B. Concatenation
C. Hierarchy
D. Clustering

25 What 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

26 If 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

27 Which 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

28 What 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

29 How 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

30 What 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

31 If 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

32 What 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

33 Which 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

34 In a Star Schema, the Fact table is usually:

A. Unstructured
B. Tall and Narrow
C. Short and Wide
D. Empty

35 Which of the following is NOT a standard aggregation type for a numeric column?

A. Average
B. Concatenate
C. Min
D. Sum

36 When 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

37 What 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

38 Why 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

39 In 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

40 What 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

41 Which data type is most efficient for relationship keys?

A. Date/Time
B. Integer
C. String / Text
D. Decimal Number

42 What 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

43 If 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)

44 How 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

45 Which 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

46 What 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

47 When 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

48 Why 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

49 What 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

50 In 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