Data Model - Quiz

In which Normal form, transitive dependencies are removed

• 1st Normal Form

• 3rd Normal Form

• 2nd Normal Form

If A -> B and B -> C then A->C. What does this imply in data modelling.

• A is functionally dependent on C

• C is functionally dependent on A

• A is transitively dependent on C

• C is related to A

A table can be in 3NF without being in 2NF. True OR False?

• true

• false

In which type of data model technique, there will be parent & child entity relationship ?

• Network Model

• Hierarchy Model

• Dimensional Model

• Parent-Child Model

• ER Model

Suppose there are 2 entities, "Employee" & "Employee Blood Group". What will be the relationship between these 2 entities?

• One to Many

• One to One

• Many to One

• Many to Many

Star Schema is implemented in which systems?

• OLAP

• OLTP

• OLPA

• OLPT

OLTP system is highly denormalized. True or False

• False

• True

What are the exact tasks of data modellers ?

• Requirement Gathering

  & Code Development

• Build Test Cases &

  Production Deployment

• Data Profiling &

  Build STTM

• Build Model diagram

  & enhance Data catalog

• Support DE/QA team during development & testing

_____ dimension table is attached to atleast 2 fact tables

• Conformed

• Role Based

• Junk

• Slowly Changing

Which type of schema model should be implemented if the requirement is fast writes with normalized data.

• Star Schema

• Snowflake Schema

• Either Star or Snowflake schema

• None of these