Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Modeling Interview Questions
Data Modelling interview questions
What is data modeling?
What does data model contain?
What is a logical data model and logical data modeling?
What is a physical data model and physical data modeling?
What is the difference between a logical and physical data model?
What is a table (entity)?
What is a column (attribute)?
What is a row?
What is ER (entity relationship) diagram or ERD?
What is a primary key constraint?
What is a composite primary key constraint?
What is a surrogate key?
What is a foreign key constraint?
What is a composite foreign key constraint?
What are the important types of Relationships in a data model?
What is identifying relationship?
What is non-identifying relationship?
What is self-recursive relationship?
What is cardinality?
What is a conceptual data model and conceptual data modeling?
What is an enterprise data model?
What is relational data modeling?
What is OLTP data modeling?
What is a constraint? What are the different types of constraint?
What is a unique constraint?
How many null values can be inserted in a column that has unique constraint?
What is a check constraint?
What is index?
What is a sequence?
What is normalization?
What are the types of normalization?
What is De-Normalization?
What is data model Meta data?
What is data model repository?
What is forward engineering in a data model?
What is reverse engineering in a data model?
What is a subtype and super type entity?
Give us a non-computer example of preemptive and non-preemptive scheduling?
What is the difference between star flake and snow flake schema?
What is data sparsity and how it effect on aggregation?
When should you consider denormalization?
What is ERD?
What is third normal form?
Why are recursive relationships are bad? How do you resolve them?
Is this statement TRUE or FALSE? all databases must be in third normal form?
What is an artificial (derived) primary key? When should it be used?
What is second normal form?
What do you understand by Data Modelling?
Explain your understanding of different data models?
Share your experience with respect to projects you have worked on till date?
What are the different design schemas in Data Modelling? Explain with the example?
Which scheme did you use in your project & why? OR Which schema is better - star or snowflake?
What do you understand by dimension and attribute?
What is a fact & a fact table?
What are the different types of dimensions you have come across? Explain each of them in detail with an example?
Give your idea regarding factless fact? And why do we use it?
Distinguish between OLTP and OLAP?
What do you understand by data mart?
What are the different types of measures?
What is a Surrogate key? How is it different from a primary key?
Is this true that all databases should be in 3NF?
Have you ever came across the scenario of recursive relationships? If yes, how did you handle it?
List out few common mistakes encountered during Data Modelling?
What is the number of child tables that can be created out from a single parent table?
Employee health details are hidden from his employer by the health care provider. Which level of data hiding is this? Conceptual, physical or external?
What is the form of fact table & dimension table?
What particulars you would need to come up with a conceptual model in a health care domain project?
If a unique constraint is applied to a column then will it throw an error if you try to insert two nulls into it?
Can you quote an example of sub-type and super-type entity?
What is the significance of metadata?
What is a Data Model?
How can you define the data modeling?
Name the possible type of a Data Model.
What is contained by the physical data model?
What is contained by the logical data model?
How will you differentiate physical data model from physical data modeling?
How will you differentiate logical data model from logical data modeling?
How the physical data model is different from the logical data model?
What is an entity (Table)?
What is an attribute (Column)?
What is a row?
How can you define the ERD (Entity Relationship Diagram)?
What do you understand by the primary key constraint in a database?
What do you understand by the composite primary key constraint?
What do you know about foreign key constraint?
Tell us something about the surrogate key.
Why composite word is added before any key constraint?
Name a few popular relationships within a data model.'
What do you mean by the identifying relationships in a data model?
Is there exists any non-identifying relationship too?
How will you define the cardinality in a data model?
What do you mean by the self-recursive relationships?
Give a quick definition to the enterprise data model.
How will define the relational data model?
What is OLTP data modeling?
What is conceptual data modeling?
What is a constraint? Why constraints are important for a database?
Define unique constraint for a database.
Define the check constraint.
What is an index in a database?
What is the sequence?
How will you define the database normalization?
What do you understand by term 'Data Modeling'?
What are the different types of data models?
What are the important types of relationships in a data model and explain them?
What is a Surrogate key?
What is Forward Engineering and Reverse Engineering in a data model?
What is Logical data model, Logical data modeling, Physical data model and Physical data modeling?
What is the main difference between Snow Flake Schema and Star Flake Schema?
Describe Data Sparsity and how does it impact on aggregation?
Describe subtype entity and supertype entity.
What are Relational data modeling, conceptual Data model, and conceptual data modeling?
What is data modelling?
What are the different types of data modelling?What are the different types of data modelling?
What is a data-modelling tool?
Which modelling type should be used for labelled data?
What is conceptual data modelling?
What are the disadvantages of a relational data model?
What is the difference between logical and conceptual data model?
What is predictive modelling analytics?
What is the disadvantage of the hierarchical data model?
What is logical data modelling?
Difference between data mapping and data modelling?
Explain the process-driven approach in data modelling?
What is dimensional modelling in the data warehouse?
What are the different types of dimension?
What is data warehouse?
What are the benefits and drawbacks of using data modelling in the data warehouse?
What is Surrogate & Foreign key in data modelling?
Define the cardinality in a data model
Define the check and unique constraint?
How do you implement Slowly Changing Dimension type 2? I am not looking for the definition, but the practical implementation e.g. table structure, ETL/loading.
How do you index a fact table? And explain why?
In the source system, your customer record changes like this: customer1 and customer2 now becomes one company called customer99. Explain a) impact to the customer dim (SCD1), b) impact to the fact tables.?
What are the differences between Kimball approach and Inmon's? Which one is better and why?
Suppose a fact row has unknown dim keys, do you load that row or not? Can you explain the advantage/disadvantages?
Please tell me your experience on your last 3 data warehouse projects. What were your roles in those projects? What were the issues and how did you solve them?
What are the advantages of having a normalised DW compared to dimensional DW? What are the advantages of dimensional DW compared to normalised DW?
What is 3rd normal form? Give me an example of a situation where the tables are not in 3rd NF, then make it 3rd NF.
Tell me how to design a data warehouse, i.e. what are the steps of doing dimensional modelling?
How do you index a dimension table?
Tell me what you know about William Inmon? Alternatively: Ralph Kimball.
How do we build a real time data warehouse?
What is the difference between a data mart and a data warehouse?
What the purpose of having a multidimensional database?
Why do you need a staging area?
How do you decide that you need to keep it as 1 dimension or split it into 2 dimensions? Take for example dim product: there are attributes which are at product code level and there are attributes which are at product group level. Should we keep them all in 1 dimension (product) or split them into 2 dimensions (product and product group)?
Fact table columns usually numeric. In what case does a fact table have a varchar column?
What kind of dimension is a "degenerate dimension"? Give me an example.
What is Data warehousing?
What are fact tables and dimension tables?
What is ETL process in data warehousing?
Explain the difference between data mining and data warehousing.
What is an OLTP system and OLAP system?
What is PDAP?
What is snow flake scheme design in database?
What is analysis service?
Explain sequence clustering algorithm.
Explain discrete and continuous data in data mining.
Explain time series algorithm in data mining.
What is XMLA?
Explain the difference between Data warehousing and Business Intelligence.
What is surrogate key? Explain it with an example.
What is the purpose of Factless Fact Table?
What is a level of Granularity of a fact table?
Explain the difference between star and snowflake schemas.
What is the difference between view and materialized view?
What is junk dimension?
What are fundamental stages of Data Warehousing?
What is Data Scheme?
What is Bit Mapped Index?
What is Data Cardinality?
What is Chained Data Replication?
What is Virtual Data Warehousing?
Explain in brief various fundamental stages of Data Warehousing.
What is active data warehousing?
What is data modeling and data mining? What is this used for?
Difference between ER Modeling and Dimensional Modeling?
What is the difference between data warehousing and business intelligence?
Describe dimensional Modeling.
What is snapshot with reference to data warehouse?
Distinguish between OLTP and OLAP?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock