Qlik Sense Data Architect Questions & Answers(RATED A+)

Cardinality - ANSWERMaximum number of time an instance in one entity can be associated with instances in another Modality - ANSWERMinimum number of time an instance in once entity can be associated with instances in another entity How to solve many to many relationship - ANSWERConcatenate Tables or Link Table Granularity - ANSWERThe level of depth represented by the data in a fact or dimension table High Granulairty - ANSWERatomic level of detail Low Granularity - ANSWERsummary view of detail Relationship between a fact table and a dimension table should - ANSWERalways be at the same granularity Concatenate Tables - ANSWER- Common fields are 100% populated - Good for many shared dimensions b/w tables Link Table - ANSWERLinks 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 - ANSWER• 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 - ANSWERevery row contains a key value and all the key values are unique Primary Key - ANSWERall key values are unique, but not every row contains a key value o subset ratio 100% o occur in dimension tables Foreign Key - ANSWERa field in one table that uniquely identifies a row of another table o Foreign keys are found in the fact table Surrogate Key - ANSWERintegers 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 - ANSWERthe 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 Information Density - ANSWER• Definition: indicates the percentage of rows than contain a non-null value • 100% = all rows are filled with a value