Hi Raghu, thanks for watching the video and reaching me out. Not all the time we want to migrate all the objects from on-prem to cloud and that's the call project lead must take. If some object, which exist but not needed to cloud, why to migrate such objects. More you migrate, more effort is neede starting from planning until you test and verify them. So technically, migrating database also migrate the all the objects undere it, however, making a list of them is important and that's why option 2 is also a correct answer (specially when you consider cost and effort)
Thanks for reaching me out with your query. When you migrated, you must know if those tools and process will work in cloud based data warehouse solution and that's why to understand its usability, it is important to list them out.
Thanks Anmol for sharing your query. In traditional databases or data warehouse system, we create FK and other kind of hard constraints and when records are inserted, database check those contraints during insert or update operations. In snoflake, you can define those FK relationship and that is only required to see the data model but snowflake will not apply then when data is inserted. Since it is distributed MPP (Massive Parallel Processing), such consistency is difficult to achive. Hope this clarifes your doubt.
Hi @Deepankar Kumar, all my videos are HD quality, and you tube allows you to choose the quality. Please check and if you still having issue, do let me know. Thank you 🙏 for watching my video and sharing your query. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Hi Sir, First of all thanks for putting tremendous effort for helping everyone for snowpro certification.I have a doubt on Q3,as far as i tried we can create stored procedures from the classic console through a worksheet so it means we can migrate or administer the procedures as well through it.But ,if we bound ourself to non -sql screen where user choose the option like create database or warehouse there also we can not run SELECT statement so we can not migrate all the SQL using UI interface but DDL statement is doable.So, in this scenario where partial functionality is possible on the SQL side, should we consider that all SQL can be migrated through UI?
Thank you 🙏 for watching my video and sharing your feedback and your word of appreciation really means a lot to me. Your point is very valid and during the snowflake core exam, they would try to confuse candidate with such wordings. When everyting is possible via SQL in snowflake, why they have asked such simple question and some of the item is not possible via WebUI features, however you can alwasy do it via SQL via any medium. 📒 📚 📒 📚 📒 📚 📒 📚 📒 📚 I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community. 🚀 Complete Guide + Question Dump + Revised Syllabus 🚀 -------------------------------------------------------------------------------------------- 🌐 SnowPro Guide -> bit.ly/35S7Rcb 🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb 🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E 🚀 You can also follow Data Engineering Channel 🚀 ------------------------------------------------------------------------------------ 🌐 Twitter -> twitter.com/de_simplified 🌐 Facebook -> fb.me/dataengineeringsimplified 🌐 GitHub -> github.com/TopperTips 🌐 Website -> toppertips.com
Hi I am going over the Snowpro certification Playlist you created, however the playlist does not have videos for all the topics in the syllabus, have you loaded those videos individually or should we have to refer to Snowflake Documentation directly for it.
I created videos for only important topics, but look like I need to cover all the topic as snowflake is also adding more and more topics. Will do it soon.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
In Q#1 wouldn't "list of databases to migrate" take care of "list of database objects to migrate"? Thanks for your efforts great videos
Hi Raghu, thanks for watching the video and reaching me out.
Not all the time we want to migrate all the objects from on-prem to cloud and that's the call project lead must take. If some object, which exist but not needed to cloud, why to migrate such objects. More you migrate, more effort is neede starting from planning until you test and verify them. So technically, migrating database also migrate the all the objects undere it, however, making a list of them is important and that's why option 2 is also a correct answer (specially when you consider cost and effort)
Q1: why option C is correct ?
Thanks for reaching me out with your query.
When you migrated, you must know if those tools and process will work in cloud based data warehouse solution and that's why to understand its usability, it is important to list them out.
Hi sir, we can create constraints in snowflake but cannot enforce them. Can you please elaborate?
Thanks Anmol for sharing your query.
In traditional databases or data warehouse system, we create FK and other kind of hard constraints and when records are inserted, database check those contraints during insert or update operations.
In snoflake, you can define those FK relationship and that is only required to see the data model but snowflake will not apply then when data is inserted. Since it is distributed MPP (Massive Parallel Processing), such consistency is difficult to achive.
Hope this clarifes your doubt.
Please increase the video Quality...
Hi @Deepankar Kumar, all my videos are HD quality, and you tube allows you to choose the quality. Please check and if you still having issue, do let me know.
Thank you 🙏 for watching my video and sharing your query.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
snowflake enforces not null constraints right ? Q5 should be false then.
Yes, you are right, snowflake enforces not null constaints...
Hi Sir,
First of all thanks for putting tremendous effort for helping everyone for snowpro certification.I have a doubt on Q3,as far as i tried we can create stored procedures from the classic console through a worksheet so it means we can migrate or administer the procedures as well through it.But ,if we bound ourself to non -sql screen where user choose the option like create database or warehouse there also we can not run SELECT statement so we can not migrate all the SQL using UI interface but DDL statement is doable.So, in this scenario where partial functionality is possible on the SQL side, should we consider that all SQL can be migrated through UI?
Thank you 🙏 for watching my video and sharing your feedback and your word of appreciation really means a lot to me.
Your point is very valid and during the snowflake core exam, they would try to confuse candidate with such wordings. When everyting is possible via SQL in snowflake, why they have asked such simple question and some of the item is not possible via WebUI features, however you can alwasy do it via SQL via any medium.
📒 📚 📒 📚 📒 📚 📒 📚 📒 📚
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community.
🚀 Complete Guide + Question Dump + Revised Syllabus 🚀
--------------------------------------------------------------------------------------------
🌐 SnowPro Guide -> bit.ly/35S7Rcb
🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb
🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E
🚀 You can also follow Data Engineering Channel 🚀
------------------------------------------------------------------------------------
🌐 Twitter -> twitter.com/de_simplified
🌐 Facebook -> fb.me/dataengineeringsimplified
🌐 GitHub -> github.com/TopperTips
🌐 Website -> toppertips.com
Hi I am going over the Snowpro certification Playlist you created, however the playlist does not have videos for all the topics in the syllabus, have you loaded those videos individually or should we have to refer to Snowflake Documentation directly for it.
I created videos for only important topics, but look like I need to cover all the topic as snowflake is also adding more and more topics. Will do it soon.
Plz upload snowflake interview answers pdf
Which interview answers? Could you pls elaborate .. or share your query to my insta account (instagram.com/learn_dataengineering/)