Live Recorded Interview For Snowflake Data Engineer || Infosys-2022 II KSR Datavizon

[@KSRDatavizon]

Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our KZbin channel 👉Please ping on WhatsApp wa.me/9916961234

[@PradeepKumar-wi4ws]

Great work

[@ramramaraju2221]

You have explained about copy command when interviewer asked for stages...I think you should have explained about external stages and snowpipe alerts to explain whether file has received or not. Result cache stored in cloud services layer not in storage layer. Correct me if I am wrong. Time travel - maximum retention period is 90 days, fail safe is 7 days. Default retention period is 1 day. Maximum retention period is 1 day for standard edition. No fail safe. We can customise retention period between 0 to 90 days for higher editions than standard edition.

[@KSRDatavizon]

"Thank you for your detailed feedback! 🙏 You're absolutely right about the stages-external stages and Snowpipe alerts play a crucial role in tracking file uploads, and I should have elaborated more on that. Regarding the result cache, great point-it's stored in the cloud services layer as you mentioned, not the storage layer. For Time Travel, I appreciate the detailed explanation about the retention periods. I'll make sure to clarify the maximum and customizable retention periods based on the edition in future content. Your input helps improve the quality of my videos-thanks again for sharing this!"

[@yamunau.yamuna5189]

Very useful, please provide some more interviews on snowflake

[@KSRDatavizon]

sure, will make more, please subscribe our channel for regular updates.

[@varunjain2645]

this is a good share ..snowflake learners will be exposed to the line of questioning and have an idea before hand and prepare .

[@KSRDatavizon]

Thanks Varun

[@venkatathum]

It’s really awesome . Great work guys. Appreciate for your efforts!!!

[@KSRDatavizon]

Thank you so much 😀, please do share

[@PremKumar-wy3mx]

Nice detailed video👍 is there any short and quick course to learn snowflake with AWS within 2 months?

[@KSRDatavizon]

Thank you so much, for more details contact us: at 8951796123,9353107498

[@ckarkhan]

Good answers by the candidate except for two things. One, he should have underscored the fact that materialized views can be built only on a single table, not multiple tables. I am not sure if that has changed now but I doubt it. Second, why did he pass up the opportunity to ask questions to the interviewer? That's a big no no! He should have inquired about the project, the tech stack or the current challenges etc. with the interviewer. My two cents.

[@KSRDatavizon]

Your feedback is valuable, and I will definitely keep these points in mind for future interviews. Thank you for taking the time to share your thoughts.

[@spandananathi16]

Very helpful 😊 thanq so much

[@KSRDatavizon]

Welcome 😊, please subscribe our channel it will motivates us

[@kommabalaji4845]

Power bi + Azure Data Factory+ Snowflake is it a good combination?

[@KSRDatavizon]

first 3 is enough for Data analyst, if you want to choose career in Cloud choose Snowflake

[@shanmugaraj8931]

make many related to snowflake

[@KSRDatavizon]

Sure

[@sujatasbhosale]

Very nice..really appreciate your efforts

[@KSRDatavizon]

Thanks a lot

[@jayakumarjj]

good attempt, but it doesnt feel like a real one! the interviewer did not explore anything in detail of the candidate answers.

[@KSRDatavizon]

Thank you for your comment, will make good video in future

[@rockytelkar9906]

Hi there! i have a question . when the interviewer asked about the bottom layer you told about the database storage layer , so in the documentation it is mentioned that database storage layer is the innermost layer so does innermost mean bottom layer in specific? and outermost layer means top layer?

[@SakethRRRRRrrrrr]

Answer to this kind of questions, they donot answer 🤣🤣🤣🤣, that's KSR

[@KSRDatavizon]

Yes that’s correct. In depth the 3rd layer ( bottom layer) - Database Storage and top layer - metadata/cloud Services layer

[@KSRDatavizon]

Yes that’s correct. In depth the 3rd layer ( bottom layer) - Database Storage and top layer - metadata/cloud Services layer

[@amanshukla1126]

got offer ??? how much is it ?? I lie in the same experience frame as yours just want to know how much I can expect in terms of CTC,current is 15 lpa.

[@KSRDatavizon]

Hi Aman, it depends - Upto 22 Lakh, we have seen candidates being placed.

[@amanshukla1126]

@@KSRDatavizon thanks brother

[@Raghavareddymekala]

Krishna sir scalable will be in query processing layer not in storage layer

[@KSRDatavizon]

thanks

[@raghunaidukalvapalli]

He didn't ask you at least one question in SQL?

[@KSRDatavizon]

Thank you for your comment, Please share and like and subscribe our channel for updates.

[@jonron3805]

Seems like a fake interview. Normally infosys has 2 interviewers in the room. One Interviewer interview are very rare in Infosys.

[@KSRDatavizon]

hope this video helps you to gain some knowledge

[@jonron3805]

@@KSRDatavizon how? It does not seem genuine

[@m.s.krishnamurthykitta]

Put some projects for resumes sir..!!

[@KSRDatavizon]

Already uploaded 3 videos in KZbin.. you can utilize for your resume

[@ananya17verma]

@@KSRDatavizon can u share the link for projects?

[@vinodhiremani8604]

Put some projects for resumes sir.

[@buchibabu1904]

Please call this as mock interview. Don't name it as Real interview.

[@KSRDatavizon]

its realtime interview

[@dhanushkumar7335]

1:55

[@KSRDatavizon]

Thank you for your comment, Please like,share and subscribe our channel for regular updates and it motivates us a lot

[@rajinikanthgudimalla5454]

How many years of experience he has ?

[@KSRDatavizon]

Hi RajiniKanth, he has 5+ yrs of experience

[@rajinikanthgudimalla5454]

@@KSRDatavizon can you provide questions for 2years exp .... If it's available....

[@prakashjai9057]

This is not a real vedio interview.

[@KSRDatavizon]

we considered only the voice, cant upload with video. sorry for that. will try infuture with a mock interview with video. Please subscribe our channel for regular updates, its motivate us

[@adiandniyu2078]

Fake Interv

[@KSRDatavizon]

It is not a fake interview...

[@Gunjan2393]

this is a mock inteview ....

[@rahulsadawarte3846]

This is very helpful.

[@KSRDatavizon]

Thank You