Power Bi data modelling test questions
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
20 questions
Show answers
- Q11. What is a primary function of data modeling in Power BI?To improve data entry speedTo structure data for easier analysisTo increase data storageTo simplify programming tasks30s
- Q22. Which type of relationship is commonly used between fact and dimension tables in a star schema?All-to-allMany-to-manyOne-to-manyOne-to-one30s
- Q33. What does DAX stand for?Data Analysis ExpressionsData Analytics ExtensionsDirect Access XMLData Access Express30s
- Q44. Which DAX function is used to calculate a running total?ACCUMULATECUMULATETOTALSUM30s
- Q55. What is the best practice for handling a large dimension table in Power BI?Creating aggregationsUsing a flat file formatSplitting into multiple tablesRemoving non-essential columns30s
- Q66. In a star schema, what role do dimension tables play?Logging changes over timeDescribing attributes of business entitiesStoring transactional dataAggregating metrics30s
- Q77. What is the significance of a snowflake schema?Flat data architectureDenormalized form of a star schemaNormalized form of a star schema to reduce redundancyUnstructured data format30s
- Q88. Which function in DAX is used to retrieve the last non-empty value in a column?LASTLASTNONBLANKLASTVALUEEND30s
- Q99. How do you improve query performance on a large dataset in Power BI?Reducing the number of visualsCreating indexes on columnsStoring data in a single tableIncreasing the refresh rate30s
- Q1010. Which of the following is not a type of filter in Power BI?Document level filterPage level filterReport level filterVisual level filter30s
- Q1111. What is the purpose of the RELATED function in DAX?To duplicate recordsTo perform calculations within a tableTo fetch related data from another tableTo check data validity30s
- Q1212. How is data security typically implemented in Power BI?Firewall settingsData maskingColumn encryptionRow-level security30s
- Q1313. What role does a 'Date' dimension table play in a data model?It provides context for trend analysisRecords time stamps of data entriesStores actual transaction dates onlyCalculates fiscal years30s
- Q1414. What is the primary benefit of using a many-to-many relationship in Power BI?It allows linking tables without a single unique keyImproves data load timeSimplifies the data modelReduces the need for DAX formulas30s
- Q1515. Which DAX function is crucial for creating calculated columns?DIVIDEMULTIPLYSUMCALCULATE30s