Data Modelling Interview Questions

What is granularity?

[{"selector":"#anim-7a161f4a-e1a9-4f14-b873-9326e75ac2b8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eca921a7-7eb9-4eb4-aac2-a375a3c72709","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

Explain snowflake schema database design.

[{"selector":"#anim-fd639042-e6cd-467e-853e-a6f2a2ebf6dd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9fe64d59-9484-4ea7-b271-8c69f92db687","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

Differentiate between OLTP and OLAP.

[{"selector":"#anim-52a0bccc-1fcf-4e18-a4c4-5cf0ce7e49a1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e574242f-c036-4082-a162-9354eab92065","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

What is a data mart?

[{"selector":"#anim-7f838a7c-ba2a-4252-ae65-51fc3b8bdc99","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-03f26fb6-d629-4b88-9f0e-f62953a4f750","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

What is the significance of metadata?

[{"selector":"#anim-8fa04158-8538-441e-a9e6-351fad978c4f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3ae96b65-253a-4738-bb9c-1018ddd19b53","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

What are the phases in the data modelling development cycle?

[{"selector":"#anim-1c6d22b2-b290-4a28-b02d-49142be151ac","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0db26a59-99a0-4d9d-b134-9c64b4e904dd","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

How can you relate CAP Theorem to database design?

[{"selector":"#anim-194160e2-a13e-4603-acfb-ccdda90991a0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-94234e69-01a6-4c7d-9be3-b414554781dd","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

How can you perform reverse engineering in data modelling?

[{"selector":"#anim-2812de5e-a746-416b-8244-e72fc434b964","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4152f560-3ee1-4180-a751-a777d764873f","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

What is the importance of the third normal form?

[{"selector":"#anim-6f04e32c-4e53-461c-b0fb-ceed46e3c28d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f6fb3e2c-238b-42ba-8e79-00d1ae004cf9","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

What will happen if we try inserting two nulls in a column having a unique constraint on it?

[{"selector":"#anim-3cf89ab8-5995-46b6-8dc8-7ec5b5f8fb32","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-31eb7a4d-40ff-40f3-a43a-f8b54f4d23e8","keyframes":{"transform":["translate3d(-107.56303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

Ready to take the next step in your tech career?

[{"selector":"#anim-6f5e8e41-5a38-4b26-83b3-fd01ef327332","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e87cdbf1-3740-4316-a7e3-39a71555e4cc","keyframes":{"transform":["translate3d(0px, -297.18955%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e62bd02-203a-4e2a-a222-c8d625f33d8f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6c5cbb29-00a5-4043-8fce-dab70179df8b","keyframes":{"transform":["translate3d(0px, -714.5742%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Click here

“

[{"selector":"#anim-eb53e0ec-7dee-4307-aada-b5032f1b5188","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9249eb61-818a-42d3-8b8a-977b0c117a25","keyframes":{"transform":["translate3d(0px, -211.49618%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f05f1c8f-4ec3-4d86-80e2-a8725a27026d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b94d821c-df17-4d62-b46a-cd5cb68700b6","keyframes":{"transform":["translate3d(0px, -621.00265%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Step Up Your Game with InterviewBit Web Stories SWIPE UP