40 Real Data Architect Interview Questions & Answers - Part II: Data Modeling

2nd of 4 part Data Architect Interview Questions & Answers series focusing on real questions that are asked. This part includes the next set of 10 question which covers Data Modeling concepts.

Data Architecture Interview Series:

Related Video:

Other Areas (Playlists):

[abdulrahaman]

Hi. I would like to thank you from bottom of my heart. I'm surprised to see how such a knowledgeable person is so polite and down to earth in sharing all his learning. I'm so excited to know the reason what made you to make this series.

[arun]

The videos are like a gem and only people in data domain can understand the value of these videos. Its not only for interview prep but for a better understanding of all the Data modeling concepts. Thanks a ton for sharing your knowledge.

[ranjansrivastava]

It's great video for the candidate who are trying to be an Architect. Appreciates for your efforts brother !!!! Keep doing the great work my dear friend. If possible please post these kind of architect Q&A for the Data Engineering architect positions like ADF, Synapse, databricks, airflow etc. as well. :)

[ShaileshDeshpandeOnGoogle]

Thanks for the video. It certainly helps. May I suggest the possible follow-up questions on, the "What challenges did you face during Data modeling? For example, a follow-up question can be how to resolve when primary keys are not available to integrate the data. Thanks in advance

[patmclaughlin]

Thank you for doing these videos, good sir!

[sukhdeepful]

Thanks for creating this video. This is so informative, helped me to preapare the interview and luckily couple of questions were same as you explained in this video.

[CodeVeda]

Most of the interview questions are around this. Good work !

[AshutoshPandey-jjqj]

Thanks a lot for publishing the next set of interview questions, really a big help, looking forward for more such videos.

[ramkumarananthapalli]

Very very useful. Thanks a lot for making this.

[sanchavan]

Really good. It's very informative and I like the way you prepared and presented it.

[ravitejatavva]

@SoftwareArchitectureAcademy, Great Content altogether! Any plans of providing mentor-ship ?

[ramsundarmurugesan]

Hi, your videos looks good. I need some 1 to 1 coaching on some data concepts . Do you provide the same ?

[MuslimaArabia]

Thank you so much for these precious videos, I give you my support likes and shares.

[gaurprakashshukla]

does this make sense to check normalization process prior to physical data modeling, because during the logical modeling we may get enough information if data is going to be redundant - any thoughts ?

[tamralipti]

How can snowflake come under De-normalised type?

[snehaparekh-fm]

Thank you very much for informative content

[shivabasayyahiremath]

Thanks again, it was great video.
Can we have one Azure cloud specific Data architect roles or questions.

These sessions not only helping folks who are interview focused, but also those who wants to move into the space of Data Architecture or upscale from Data Engineer to elevated roles, by understanding what would be the expectations from the elevated roles.

I fall into second category and inclined mainly towards azure data engineer role.

Thanks for sharing your knowledge.

[fahadmahmood]

How to handle early arriving fact and late arriving dimensions.??

[anushka]

so helpful, hope you can do more series like these!

[sivapalanisamy]

Could you put video for brief about data lake.