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 UA-cam channel 👉Please ping on WhatsApp wa.me/9916961234
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.
"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!"
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.
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.
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?
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
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 UA-cam channel 👉Please ping on WhatsApp wa.me/9916961234
Great work
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.
"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!"
It’s really awesome . Great work guys. Appreciate for your efforts!!!
Thank you so much 😀, please do share
this is a good share ..snowflake learners will be exposed to the line of questioning and have an idea before hand and prepare .
Thanks Varun
Very helpful 😊 thanq so much
Welcome 😊, please subscribe our channel it will motivates us
Very nice..really appreciate your efforts
Thanks a lot
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.
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.
Nice detailed video👍 is there any short and quick course to learn snowflake with AWS within 2 months?
Thank you so much, for more details contact us: at 8951796123,9353107498
Power bi + Azure Data Factory+ Snowflake is it a good combination?
first 3 is enough for Data analyst, if you want to choose career in Cloud choose Snowflake
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?
Answer to this kind of questions, they donot answer 🤣🤣🤣🤣, that's KSR
Yes that’s correct. In depth the 3rd layer ( bottom layer) - Database Storage and top layer - metadata/cloud Services layer
Yes that’s correct. In depth the 3rd layer ( bottom layer) - Database Storage and top layer - metadata/cloud Services layer
Krishna sir scalable will be in query processing layer not in storage layer
thanks
He didn't ask you at least one question in SQL?
Thank you for your comment, Please share and like and subscribe our channel for updates.
good attempt, but it doesnt feel like a real one! the interviewer did not explore anything in detail of the candidate answers.
Thank you for your comment, will make good video in future
make many related to snowflake
Sure
Seems like a fake interview. Normally infosys has 2 interviewers in the room. One Interviewer interview are very rare in Infosys.
hope this video helps you to gain some knowledge
@@KSRDatavizon how? It does not seem genuine
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.
Hi Aman, it depends - Upto 22 Lakh, we have seen candidates being placed.
@@KSRDatavizon thanks brother
Put some projects for resumes sir..!!
Already uploaded 3 videos in UA-cam.. you can utilize for your resume
@@KSRDatavizon can u share the link for projects?
Put some projects for resumes sir.
1:55
Thank you for your comment, Please like,share and subscribe our channel for regular updates and it motivates us a lot
Please call this as mock interview. Don't name it as Real interview.
its realtime interview
How many years of experience he has ?
Hi RajiniKanth, he has 5+ yrs of experience
@@KSRDatavizon can you provide questions for 2years exp .... If it's available....
This is not a real vedio interview.
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
Fake Interv
It is not a fake interview...
this is a mock inteview ....
This is very helpful.
Thank You