Exam Prep For
Qlik Sense Data
Architect
** Expert-Verified Explanation
** Questions with Verified Answer
** New Edition | 2026-2027 Updated
** 100% Guaranteed Pass
** 100% Correct Answers | Graded A+
, Cardinality Maximum number of time an instance in one entity can be associated with
instances in another
Modality Minimum number of time an instance in once entity can be associated with
instances in another entity
How to solve many to many relationship Concatenate Tables or Link Table
Granularity The level of depth represented by the data in a fact or dimension table
High Granulairty atomic level of detail
Low Granularity summary view of detail
Relationship between a fact table and a dimension table always be at the same granularity
should
Concatenate Tables - Common fields are 100% populated
- Good for many shared dimensions b/w tables
Link Table Links two or more fact tables by taking all common fields out of the original tables
and placing them into a new one
- Contains all possible combination of values for that set of fields
Dimensionality • If the requirement is like "a user wants to see a daily report of the tickets closed
by the technicians working under each region and district" then the
dimensionality would be 5 - region, district, supervisor, locator and date (locator=
technician)`
Perfect Key every row contains a key value and all the key values are unique
Primary Key all key values are unique, but not every row contains a key value
o subset ratio < 100%
o occur in dimension tables
Foreign Key a field in one table that uniquely identifies a row of another table
o Foreign keys are found in the fact table
Surrogate Key integers that are assigned sequentially as needed to populate a key field
o Ex: ProductID = 1,2,3,4...
o Solution to non-numeric keys
o Optimizes calculation time
o Created using AUTONUMBER function
Subset Ratio the percentage of all distinct values for a field in a table compared to all the
distinct values for that field in the entire data model
Qlik Sense Data
Architect
** Expert-Verified Explanation
** Questions with Verified Answer
** New Edition | 2026-2027 Updated
** 100% Guaranteed Pass
** 100% Correct Answers | Graded A+
, Cardinality Maximum number of time an instance in one entity can be associated with
instances in another
Modality Minimum number of time an instance in once entity can be associated with
instances in another entity
How to solve many to many relationship Concatenate Tables or Link Table
Granularity The level of depth represented by the data in a fact or dimension table
High Granulairty atomic level of detail
Low Granularity summary view of detail
Relationship between a fact table and a dimension table always be at the same granularity
should
Concatenate Tables - Common fields are 100% populated
- Good for many shared dimensions b/w tables
Link Table Links two or more fact tables by taking all common fields out of the original tables
and placing them into a new one
- Contains all possible combination of values for that set of fields
Dimensionality • If the requirement is like "a user wants to see a daily report of the tickets closed
by the technicians working under each region and district" then the
dimensionality would be 5 - region, district, supervisor, locator and date (locator=
technician)`
Perfect Key every row contains a key value and all the key values are unique
Primary Key all key values are unique, but not every row contains a key value
o subset ratio < 100%
o occur in dimension tables
Foreign Key a field in one table that uniquely identifies a row of another table
o Foreign keys are found in the fact table
Surrogate Key integers that are assigned sequentially as needed to populate a key field
o Ex: ProductID = 1,2,3,4...
o Solution to non-numeric keys
o Optimizes calculation time
o Created using AUTONUMBER function
Subset Ratio the percentage of all distinct values for a field in a table compared to all the
distinct values for that field in the entire data model
