Thannks for the detailed yet pointed information. Regarding, Q9 - How is B is correct. Stream does not create a new table instead it just adds 3 columns to existing table right. Hence, ideally stream is not duplicating the source table correct?
Congratulation on your success Kush. Thank you for watching my video and sharing your feedback. your word of appreciation really means a lot to me. I would love to hear a contructive feedback if you have any? I would also love to hear the stream and task related question if they are very different or more scenario based. Your input will surely help the snowflake community folks who are preparing for the exam.
Thanks for detailed video. Qq. on Que 9. B.) Stream duplicates source table. How this option is correct ? As per earlier discussion, Stream adds new columns in existing table.
Thanks, @Raghav Kulkarni for watching the video and reaching out with your queries. When we say duplicate, means stream looks like a separate table having a same number of the column as a source table in the same order and with same data type along with 3 additional columns on the top of it. Hope this clarifies.
Thank you for your video! All videos are amazing. Just one comment with regard to question number 9, the option B gives a different meaning like 'stream creates a duplicate table like source table' which is clearly not the case. May be the wording can be different to avoid this confusion.
Regarding Q2. If the stream is not consumed, it becomes stale based on the timetravle configuartion right. It will only be extended if the time travel is configured to be less than 14 days based on the material you covered. It was confusing. Can you please clarify
@Data Engineering Simplified Thanks for your detail course, is your current playlist "Snowflake SnowPro Certification - Tutorial" will be enough for appearing the SnowPro Certification exam ?
Thanks for watching the content. My content is more about revision content and you must refer the snowflake documentation as well as snowflake university stuff. My vidoes helps you to understand if you have missed any important point or you are fully covered. You can check this question playlist having 300 questions and validate your knowledge. bit.ly/3kl5Jzj
I am working on it but it will take some time, fow now I have not seen any such content available. If you come across any such, please share with community.
Thank you Pooja for watching my video and reaching me out with your query. I would request to follow below tutorial which covers almost everything. "Snowflake/SnowPro Core Certification | Preparation Tips & Success Strategy" -> bit.ly/3n0piyj I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. And please share your contructive feedback so I can improvise my content and help 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
Check this part of the video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-14SWHz4_G0Q.html There are 2 different limitations, not sure which one you are looking for. 1) A simple tree of tasks is limited to a maximum of 1000 tasks total (including the root task) in a resumed state 2) A task can have a maximum of 100 child tasks Thank you 🙏 @kullbocks131209 for watching my video and sharing your query.
Hi, I m bit confused between Q13, Q14. Could you please clarify the things. Also as per video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-me4chjq0JCQ.html , at 46:57 it was suggested to have execute privilege. Please help.
When we create a task, it is in suspended more and to make it active, it has to be resume and for that you need to have a grant to do that. If you logged in with accountadmin role, you can do it or your role must have manage and execute priviledge on task. If you need more clarity, I would say watch my following videos Ch-17 Stream - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DXI0GDSwE_E.html Ch-28 - Task - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-165hXZ_o4Vk.html Quiz - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-re3Vn1C3yOc.html