Thank you,Arjun for watching my video and sharing your query. In my recent SnowPro videos, the question/answers are available in the same page. I would try to improve to make sure my audience better clarity and really appreciate your feedback. 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
When talking about the answers you went back and forth between the letter answers and text answers. This made it difficult to know if got the answers right.
Thanks, Rajarshi for reachmming me out. Answer to your question - Data sharing (or called share objects) can be shared across different edition but VPS has some restriction and it can not share data outside VPS (Virtual Private snowfalke) - There is another limitation on region. Cross region sharing is also not possible. My next video is on data sharing and will be released soon or later ths week. You will get notified if you have subscribed this channel.
Thanks for video. If you need to select 2 choices of below question what will be your thought process. snowflake can be used for OLAP OLTP concurrent data on-primise data
Thanks Pratima for reaching me out. The answers for your question will be 1. OLAP 2. Concurrent Data (Snowflake should not be used for OLTP and snowflake is only cloud native tool, so 4th option is also not applicable)
Thanks Much! I have couple of questions while am preparing for snowflake snowpro. I thought to discuss with you. Q1)Flatten is used for select one option 1)Semi structure data 2)Structure data 3)Both 1 and 2 4)None of them Q2) Q2)If we are converting size from x-small to medium for what purpose a)to run more queries b)for more no of users c) to accommodate fluctuation workload d) to accommodate more complex workload @@DataEngineering
for Q1- answer is semi-structure data for Q2 - to accomodate more complex workload as more complex workload need bigger machine. (to run more queries or more useor fluctuating workload, you can use elastic warehouse)
Q3) load data by batches (individual insert is not recommended by snowflake, it can be done but not an efficient way.. that's why copy command is more preferred over insert)
@@dailycryptosportsnews1545 you are right.. there is a typo mistake with option, it is true and instead of (a) true.. I mistakely put (b) true.. will take action. Thanks a lot Anmol with your feedback.
Plz. try to cover questions and correct answers for them as we go through them, going back and forth makes disconnect to link.
Thank you,Arjun for watching my video and sharing your query. In my recent SnowPro videos, the question/answers are available in the same page. I would try to improve to make sure my audience better clarity and really appreciate your feedback.
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
What is your starting package after snowflake certification and what is the average package after this certification?
I would rely on community folks to respond to your question...
When talking about the answers you went back and forth between the letter answers and text answers. This made it difficult to know if got the answers right.
Will keep it in mind and enhance it. My new series has answer then and there.
ua-cam.com/play/PLba2xJ7yxHB5X2CMe7qZZu-V4LxNE1HbF.html
Data sharing can be done across different SF editions - true/ false
Can you please answer this question?
Thanks, Rajarshi for reachmming me out.
Answer to your question
- Data sharing (or called share objects) can be shared across different edition but VPS has some restriction and it can not share data outside VPS (Virtual Private snowfalke)
- There is another limitation on region. Cross region sharing is also not possible.
My next video is on data sharing and will be released soon or later ths week. You will get notified if you have subscribed this channel.
True
Hi Sir,
Can you make one video on Cloning?
Noted. Will soon respond to you once done.
In Q8, the Question is different from the question in the Answers. Please check and correct
Thanks for pointing it out, let me validate and correct it.
yes I am agree.. in question it was asked for loading mechanism however later its asked for all the commands
Thanks for video.
If you need to select 2 choices of below question what will be your thought process.
snowflake can be used for
OLAP
OLTP
concurrent data
on-primise data
Thanks Pratima for reaching me out.
The answers for your question will be
1. OLAP
2. Concurrent Data
(Snowflake should not be used for OLTP and snowflake is only cloud native tool, so 4th option is also not applicable)
Thanks Much!
I have couple of questions while am preparing for snowflake snowpro. I thought to discuss with you.
Q1)Flatten is used for select one option
1)Semi structure data
2)Structure data
3)Both 1 and 2
4)None of them
Q2)
Q2)If we are converting size from x-small to medium for what purpose
a)to run more queries
b)for more no of users
c) to accommodate fluctuation workload
d) to accommodate more complex workload
@@DataEngineering
Q3)Snowflake prefer to load data
a)load data by batches
b)load data row by row
for Q1- answer is semi-structure data
for Q2 - to accomodate more complex workload as more complex workload need bigger machine. (to run more queries or more useor fluctuating workload, you can use elastic warehouse)
Q3) load data by batches (individual insert is not recommended by snowflake, it can be done but not an efficient way.. that's why copy command is more preferred over insert)
In 2nd question, your answer is not matching.
Thanks for pointing it out, let me validate and correct it.
@@DataEngineering Hello sir,in Q2, option has A as true but answer has B as true....
@@dailycryptosportsnews1545 you are right.. there is a typo mistake with option, it is true and instead of (a) true.. I mistakely put (b) true.. will take action.
Thanks a lot Anmol with your feedback.