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

[@tamralipti]

How can snowflake come under De-normalised type?

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

[@ArrowAAA]

Not necessary that Snowflake schema is good for data warehouse, infact many clients dont prefer a snowflake schema.

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

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

[@patmclaughlin107]

Thank you for doing these videos, good sir!

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

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

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

[@ravitejatavva7396]

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

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

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

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

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

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

[@ramkumarananthapalli7151]

Very very useful. Thanks a lot for making this.

[@SoftwareArchitectureAcademy]

Thank you!

[@SoftwareArchitectureAcademy]

Thank you!

[@fahadmahmood7150]

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

[@arun06530]

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.

[@mustafasajid3236]

you are very right

[@sivapalanisamy8989]

Could you put video for brief about data lake.

[@SoftwareArchitectureAcademy]

Hi Siva - here you go! ua-cam.com/video/1x0uJzMd1Pg/v-deo.html

[@snehaparekh-f4m]

Thank you very much for informative content

[@top_1_percent]

Thank you so much

[@SoftwareArchitectureAcademy]

You're most welcome

[@fahadmahmood7150]

Thanks for the great video

[@anushka244]

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

[@SoftwareArchitectureAcademy]

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