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:
1. Part I: Generic - • 40 Real Data Architect...
2. Part II: Data Modeling - • 40 Real Data Architect...
3. Part III: Data Warehouse & ETL - • 40 Real Data Architect...
4. Part IV: Data Governance - • 40 Real Data Architect...
Related Video:
How to become a Data Architect - • How to become a Data A...
Other Areas (Playlists):
Data Governance: • Data Architecture | Da...
Big Data Architecture: • Big Data Architecture
Cloud Computing Architecture: • Cloud Computing Archit...

[@abdulrahaman6424]

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.

[@SoftwareArchitectureAcademy]

Thanks Abdul for your kind words, it does keeps me motivated seeing such beautiful comments! The reason for making this series is simple: to promote data architecture as a community and as a profession.

[@vijayalaxmihalli7408]

​@@SoftwareArchitectureAcademy😊q¹1

[@AshutoshPandey-jj3qj]

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

[@SoftwareArchitectureAcademy]

Thanks Ashutosh, stay tuned for final 2 parts of this series!

[@user-ky9bi1yf4n]

Thank you very much for informative content

[@fahadmahmood7150]

Thanks for the great video

[@sukhdeep123ful]

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.

[@SoftwareArchitectureAcademy]

Thanks for the feedback, Sukhdeep!

[@ranjansrivastava9256]

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. :)

[@SoftwareArchitectureAcademy]

Thanks Ranjan, sure I will.

[@gaurprakashshukla385]

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 ?

[@87sanchavan]

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

[@SoftwareArchitectureAcademy]

Thanks Sanjay for the feedback

[@CodeVeda]

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

[@SoftwareArchitectureAcademy]

Thanks Anil for the feedback!

[@MuslimaArabia]

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

[@SoftwareArchitectureAcademy]

Thank you so much for your support!

[@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

[@SoftwareArchitectureAcademy]

Thanks Shailesh for your feedback. That's a nice point.

[@yashindian4233]

Can someone give answer for this question?

[@ravitejatavva7396]

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

[@ramkumarananthapalli7151]

Very very useful. Thanks a lot for making this.

[@SoftwareArchitectureAcademy]

Thank you!

[@SoftwareArchitectureAcademy]

Thank you!

[@shivabasayyahiremath6802]

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.

[@SoftwareArchitectureAcademy]

Thanks for the suggestion. I do have cloud series that I plan to start publishing next month onwards, will include Azure as well as AWS related content.

[@anushka244]

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

[@SoftwareArchitectureAcademy]

Thank you Anushka, I am certainly planning more series like these

[@top_1_percent]

Thank you so much

[@SoftwareArchitectureAcademy]

You're most welcome

[@tamralipti]

How can snowflake come under De-normalised type?

[@ramsundarmurugesan]

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

[@SoftwareArchitectureAcademy]

Hello, as of now I don't provide 1:1 coaching, but if you have any specific queries then feel free to reach out to me via email ( my email id is on the channel page), i will try my best to help

[@fahadmahmood7150]

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

[@sivapalanisamy8989]

Could you put video for brief about data lake.

[@SoftwareArchitectureAcademy]

Hi Siva - here you go! kzbin.info/www/bejne/Z6mTpn2wgslkhsk

[@sungboi]

This is not Data Architecture, it is Data Modelling, they distinct and separate.

[@SoftwareArchitectureAcademy]

Hello, thanks for the question. Agree - Data Modeling and even Data Governance are distinct and separate disciplines. But this series focuses only on technical areas and skills that are to be covered for a data architect interview, irrespective of discipline alignment.