Hi Team..... Kindly consolidated all the Mistakes/Incorrect information in the video(mostly mentioned in the comment sec) and put it at least in the description... Because its kind of scary that I will learn incorrect information and I have to scroll down the comments every time...... please do the same for all the videos....U r doing great job
Thanks for the visit Gilbert! Thank you 🙏 for watching my video and sharing your feedback and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ 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. 🌐 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 🌐 Website -> toppertips.com ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@krishna kumar, Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Thank you Janet for watching my video and sharing your feedback. your word of appreciation really means a lot to me. 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
For Question #4, can you please share why A,B both are not correct? Text from docs.snowflake.com -> "Client-side encryption provides a secure system for managing data in cloud storage. Client-side encryption means that a user encrypts stored data before loading it into Snowflake.". (docs.snowflake.com/en/user-guide/security-encryption.html#client-side-encryption) Question #5 - Answer should be True based on the docs.snowflake.com -> "At the account level, MFA requires no management. It is automatically enabled for your account and available for all your users to self-enroll. " (docs.snowflake.com/en/user-guide/security-mfa.html#managing-mfa-for-your-account-and-users)
in Que#4, it says storage layer and not cloud as storage system. So option A is most relevant. Que#5, you are right. it is enabled for self enrollment.
@@DataEngineering Hi, The benefit of client side encryption is that data is encrypted BEFORE sending it and storing it, so the correct answer is B as it englobes both the network transport and the storage.
By default snowflake maintains query history for 14 days under history tab.In your video it's seems to be little older information as it says 7 days history.
First of all, Thanks for making the videos, these are really helpful and easy to understand. In Question no. 12 , I think option B (Snowpipe) is also the correct answer along with other answers which you have given. Please correct me if I am wrong.
Thank you for watching my video Shakshi and sharing your query. SnowPipe is a severless component and provided by snowflake and MFA is not possible and that's why that option is not correct. 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
Hi Amit, Thanks for watching the entire video and reaching me out for clarification. When you say "MFA is enabled" means "Multifactor Authentication is activated for the user" and this part of the statement is not true. The 2nd part of the sentense is talks about enrollment and documentation says "Previously, users could only be enrolled in MFA by submitting a request to Snowflake Support. This is no longer required." and hence this statement is false. No enrolment is required and MFA is not activated/enabled automatically. I hope this clarifies your doubt.
@@DataEngineering Hi., here is the statement from the link that you have provided as reference to Q#5. It says and I quote "At the account level, MFA requires no management. It is automatically enabled for an account and available for all users to self-enroll." So, the answer should be true, in this case. Thanks!
Thank you for watching my video and sharing your feedback. My videos are uploaded with HD quality, can you change the youtube video quality and check again. 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
I am looking to appear for the snow pro certification, i wanted to seek guidance regarding how do we prepare for partner ecosystem and what each of them does ?
Hello, You in Quest-2 - query encryption supported by which edition . you have mentioned business critical but in another video region+edition there it is shwoing by VPS please recitfy
this content was created long back.. so need to be validated... ( I could not find the detail in latest snowflake docs.. docs.snowflake.com/en/user-guide/intro-editions).. thanks for your note.. and I will check it.. ---- and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge.. These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/
Thank you 🙏 for watching my video and sharing your query. You need to change you youtube configuration, all the videos are HD (1080p). UA-cam automatically choose right resolution based on your network speed and allows to change it. support.google.com/youtube/answer/3306741?hl=en
Thanks for this note..SSO and MFA, both are there from the day one and there is no interlink in these 2 features. Large enterprise allows user onboarding using their existing AD account via SSO or ID provider like Okta etc.
Hi Erikkk, Thank you for watching my video and sharing your query. I did not really understand your query, could you please elaborate more? MFA is enabled for all account and what does it mean that it is available for activation at user level no matter which edition you buy and it comes with no additional cost. The individual users in snowflake account can activate it for authencation via SMS or via Duo app. 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
Looks like answer for question 5 is incorrect... Automatically enabled means feature is enabled however need to perform individual setup. Earlier MFA used not to be enabled , users were supposed to call Snowflake support to enable this feature....
Hi, Question 16, the correct answer is CDE as USERADMIN can manage users : docs.snowflake.com/en/user-guide/security-access-control-overview.html#system-defined-roles
Query history maintains for 14 days not for 7 days. Please check it once in the slide begins at 12:05. Thanks !
Let me check and correct it.
You are really making a difference. Keep going 👍
Thanks Balaji, it means a lot and my purpose of sharing my knowlege and helping other making sense to me.
Hi Team..... Kindly consolidated all the Mistakes/Incorrect information in the video(mostly mentioned in the comment sec) and put it at least in the description... Because its kind of scary that I will learn incorrect information and I have to scroll down the comments every time...... please do the same for all the videos....U r doing great job
Thanks for the suggestion, I will action it and make sure all such observations are captured in description and also pin a comment so it hangs 1st.
@@DataEngineering great... Thanks a lot....
Great work !
Thanks for the visit Gilbert!
Thank you 🙏 for watching my video and sharing your feedback and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
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.
🌐 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
🌐 Website -> toppertips.com
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
VERY GOOD EXCELLENT
@krishna kumar, Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Very useful. Thank you
Glad it was helpful!
Good work Bro . My 1p findings -SSO is available in all editions
Thanks for the info
Great Information Keep up the good work
Thank you Janet for watching my video and sharing your feedback. your word of appreciation really means a lot to me.
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
For Question #4, can you please share why A,B both are not correct? Text from docs.snowflake.com -> "Client-side encryption provides a secure system for managing data in cloud storage. Client-side encryption means that a user encrypts stored data before loading it into Snowflake.". (docs.snowflake.com/en/user-guide/security-encryption.html#client-side-encryption)
Question #5 - Answer should be True based on the docs.snowflake.com -> "At the account level, MFA requires no management. It is automatically enabled for your account and available for all your users to self-enroll. " (docs.snowflake.com/en/user-guide/security-mfa.html#managing-mfa-for-your-account-and-users)
in Que#4, it says storage layer and not cloud as storage system. So option A is most relevant.
Que#5, you are right. it is enabled for self enrollment.
@@DataEngineering Hi, The benefit of client side encryption is that data is encrypted BEFORE sending it and storing it, so the correct answer is B as it englobes both the network transport and the storage.
By default snowflake maintains query history for 14 days under history tab.In your video it's seems to be little older information as it says 7 days history.
You are right Satender, let me check the content and take corrective action.
MFA can only be disabled by Account Admin,as stated in the documentation.Do let me know if I'm wrong.
Yes, it can be but it is more like by passing and for a short period of time it can be disabled so a user can logon and access the system.
First of all, Thanks for making the videos, these are really helpful and easy to understand.
In Question no. 12 , I think option B (Snowpipe) is also the correct answer along with other answers which you have given. Please correct me if I am wrong.
Thank you for watching my video Shakshi and sharing your query.
SnowPipe is a severless component and provided by snowflake and MFA is not possible and that's why that option is not correct.
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
Answer to the 5th question should be True.
MFA is automatically enabled for your account and available for all your users to self-enroll.
Hi Amit,
Thanks for watching the entire video and reaching me out for clarification.
When you say "MFA is enabled" means "Multifactor Authentication is activated for the user" and this part of the statement is not true. The 2nd part of the sentense is talks about enrollment and documentation says "Previously, users could only be enrolled in MFA by submitting a request to Snowflake Support. This is no longer required."
and hence this statement is false.
No enrolment is required and MFA is not activated/enabled automatically.
I hope this clarifies your doubt.
@@DataEngineering Hi., here is the statement from the link that you have provided as reference to Q#5.
It says and I quote "At the account level, MFA requires no management. It is automatically enabled for an account and available for all users to self-enroll."
So, the answer should be true, in this case.
Thanks!
Nice video but pls make video of better resolution.
Thank you for watching my video and sharing your feedback. My videos are uploaded with HD quality, can you change the youtube video quality and check again.
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
I am looking to appear for the snow pro certification, i wanted to seek guidance regarding how do we prepare for partner ecosystem and what each of them does ?
Hello, You in Quest-2 - query encryption supported by which edition . you have mentioned business critical but in another video region+edition there it is shwoing by VPS
please recitfy
this content was created long back.. so need to be validated...
( I could not find the detail in latest snowflake docs.. docs.snowflake.com/en/user-guide/intro-editions).. thanks for your note.. and I will check it..
----
and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge..
These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command...
1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/
2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/
I think the answer for 16 is B, C, E as user admin creates roles. Correct me if I'm wrong,
you are right. USERADMIN had been added after this video.
Who uploads video on 480p nowadays but good videos.
Thank you 🙏 for watching my video and sharing your query.
You need to change you youtube configuration, all the videos are HD (1080p). UA-cam automatically choose right resolution based on your network speed and allows to change it.
support.google.com/youtube/answer/3306741?hl=en
Now SSO and MFA both are available in all editions of snowflake
Thanks for this note..SSO and MFA, both are there from the day one and there is no interlink in these 2 features. Large enterprise allows user onboarding using their existing AD account via SSO or ID provider like Okta etc.
MFA is enabled on a per-user basis; however, at this time, users are not automatically enrolled in MFA. To use MFA, users must enroll themselves.
Hi Erikkk, Thank you for watching my video and sharing your query. I did not really understand your query, could you please elaborate more?
MFA is enabled for all account and what does it mean that it is available for activation at user level no matter which edition you buy and it comes with no additional cost. The individual users in snowflake account can activate it for authencation via SMS or via Duo app.
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
Hello, based on question 17 and 23, is data encrypted after loading into snowflake or before?, Its confusing .are both question similar scenarios?
Data is encrypted both in rest and in transition. At rest , it uses AES 256 bit encryption.
Can you please consider below comments and correct the answers...
Lete me check and correct it.
@@DataEngineering Thank you ! BTW... thanks for your sessions
Looks like answer for question 5 is incorrect... Automatically enabled means feature is enabled however need to perform individual setup. Earlier MFA used not to be enabled , users were supposed to call Snowflake support to enable this feature....
Yes, you are right. The feature is available but not activated for individual user and you don't need to call support, you can do it yourself.
Hi, Question 16, the correct answer is CDE as USERADMIN can manage users : docs.snowflake.com/en/user-guide/security-access-control-overview.html#system-defined-roles
Useradmin role was introduced later and this video was created earlier. So you are right.