Data Modeling Quiz
Test your knowledge and skills in OLTP/Dimensional Data Modeling!!!
Email address *
The null in the fact table’s foreign keys can be avoided by using *
1 point
Which data model is created first? *
1 point
What Is a junk dimension? *
1 point
In Kimbal’s approach, data mart data model contains? *
1 point
Outrigger table is one which is *
1 point
Which of the following is true about Cardinality and Optionality of a relationship? *
1 point
Does the numerical measures fall into any of the following categories *
1 point
A Data Mart Data Model is a subset of? *
1 point
Steps to design a Dimensional Data Model? *
1 point
Which is a data modelling tool? *
1 point
In Inmons’s approach, data ware house data model contains? *
1 point
In Data Modeling Development Life Cycle, what is the sequence in which data models are designed? *
1 point
In which data model, summarization should be applied? *
1 point
In which data model, normalization should be applied? *
1 point
Which technique is used for creating a data model from a database? *
1 point
A bridge table is used in *
1 point
What does ETL refer to? *
1 point
Which normal form is used to avoid repeating groups? *
1 point
Which technique is used for creating DDL scripts? *
1 point
In Inmons’s approach, data mart data model contains? *
1 point
Which data model is created for business perspective? *
1 point
Which data model is useful for creating database objects like tables, index? *
1 point
Which technique is to create a data model from ddl scripts? *
1 point
ETL process can be done by? *
1 point
One who designs the data model? *
1 point
Submit
This form was created inside of www.LearnHiring.com. - Terms of Service