Snowflake Stream & Task Concept | 20 Mock Questions | Snowflake Certification Exam

[@madhunavi]

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?

[@modikush]

Thanks for making amazing videos . This helped a lot after studying everything. I have cleared snowflake exam with 95% today.

[@DataEngineering]

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.

[@raghavkulkarni8744]

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.

[@DataEngineering]

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.

[@tapanpradhan8649]

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.

[@HSahadev]

@@DataEngineering Question should be reworded or answer should be A and D

[@samihussain-bc6uf]

Q9 - B ( streams duplicate the source table to track the change) i think this is not true. please clarify

[@madhunavi]

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

[@TusharKale9]

Very useful information regards CDC/Streams. Thank you for sharing, Regards, Tushar

[@DataEngineering]

Thanks for liking and really appreciate your feedback.

[@shayankabasi160]

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

[@DataEngineering]

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

[@shayankabasi160]

@@DataEngineering Actually I am working in Snowflake for last 3 years but I was looking for some content for preparing focused on exam

[@DataEngineering]

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.

[@bhumikalalchandani321]

not avalaible@@DataEngineering

[@b123786]

At 42.05 sec stream duplicates the source table ... this is not correct right ? I mean it just add the 3 metadata column

[@DataEngineering]

you are right.. but it duplicates the column the base table has and then add 3 extra column.

[@poojadhole2803]

Hello , I am new to snowflake and studying for snowpro certification . Planning to give exam in may ,please advice learning material

[@DataEngineering]

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

[@poojadhole2803]

@@DataEngineering Thank you so much !!!

[@skullbocks131209]

Task limit is 100 task I suppose

[@DataEngineering]

Check this part of the video - kzbin.info/www/bejne/Z2W2iHuwacR6ZrM 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.

[@mukeshims09]

Hi, I m bit confused between Q13, Q14. Could you please clarify the things. Also as per video kzbin.info/www/bejne/o5aXlJugppV9ebM , at 46:57 it was suggested to have execute privilege. Please help.

[@DataEngineering]

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 - kzbin.info/www/bejne/eomsYXp6iNx4lac Ch-28 - Task - kzbin.info/www/bejne/Z2eYmYuQlNRnjM0 Quiz - kzbin.info/www/bejne/qJaWh6FneJishcU

[@samihussain-bc6uf]

@@DataEngineering

[@samihussain-bc6uf]

so Q14 the anser should be A(EXECATE) not B(USAGE) - correct