*Become a Microsoft Certified: Azure Data Engineer Associate today.* . These 216 exam like Questions and 3 super important case studies will ensure high score in the exam. 👉Follow the steps for Exam Q&A Dumps in PDF file:(Sample here: thetechblackboard.com/downloads) 1. Join the channel as a Diamond member: kzread.info/dron/dEKYQhxYbVcdrp2md5yZ0A.htmljoin 2. Email us at 'connectus@thetechblackboard.com' Data engineering is one of the most lucrative career options today and Azure DP-203 is just the certification you need to get started. Become a subject matter expert in integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions. Learn how to: 1. Design and implement data storage 2. Develop data processing 3. Secure, monitor, and optimize data storage and data processing learn.microsoft.com/en-us/credentials/certifications/azure-data-engineer/?practice-assessment-type=certification Key links of this video ► Microsoft Learn: learn.microsoft.com/en-us/certifications/exams/dp-203 Our Social Handles: - Website: www.thetechblackboard.com - Email: connectus@thetechblackboard.com - LinkedIn: linkedin.com/in/thetechblackboard - Facebook: facebook.com/thetechblackboard - Instagram: instagram.com/askthetechblackboard - Twitter: twitter.com/Dtechblackboard

@shalurajpoot7182

2 ай бұрын

Can we reffer this in 2024

@peterwylie

22 күн бұрын

I would suggest you go through this video and check your suggested answers because some of them are clearly not correct.

Just passed m'y exam with a score of 840. Thanks a lot. A little advice for some one who want to pass. Do examtopics + This video many Times until your master it. The better way to pass IS to understand, don't just memorise thé answer.

Thank you so much for the detailed explanation. I have cleared the exam today 🥳

This is the recommended video before attempting the Dp-203 exam.I got my certification today and got very similar questions explained here.

Today I have passed the DP-203 exam. Your video and the tips are very helpful in the exam preparation. Appreciate your time and efforts on making such a great resource for Azure Associate exam. Really cool . Kudos 👍🙏

Sir, you have done a amazing job in these videos. Keep up the good work.

I passed my DP 203 just now. I am writing this comment from my exam hall XD I only had around 35% QS from this series. I went through all 216 QS and 3 case study. However, understanding logic behind picking the answer made me pass this. Case study QS were quite similar NOT same. I thank you sir for your help.

just passed the exam today. There are around 40-50% of questions are same/similar with the ones in the videos here. Your videos are pretty helpful.

After preparing so hard, I stumbled on your video on my exam day and spent few hours on it. Thank God I did. I passed my exam 😂. Thank you.

This series really helped me to clear the DP-203 exam. Thanks much!

Part 19, Q2: Yes, the matching is great. It is very helpful.

Just passed my DP-203 right now with a score of 917, I want to thank you for all the effort in making this video series and reiterate that it was a MASSIVE help, a lot of the questions were the same or very similar. This is how I prepared, during 3 months: - Read all the Microsoft Learning path for DP-203 - Watched all this video series while taking notes of what I considered important and my mistakes - Did about 100 questions from DP-203 in ExamTopics (would do more if I had the time) Good luck for you all!!

@TheTechBlackBoard

Жыл бұрын

Hey 👋, I am so glad that we could be your learning partner. I wish you luck ahead and pls make sure to share our videos and give us a shout out on your LinkedIn profile.

@linkrachitg

11 ай бұрын

Hi, what do you mean by : - Read all the Microsoft Learning path for DP-203 On which portal? Any link?

@achraferraji3403

10 ай бұрын

@@linkrachitgtype DP-203 microsoft doc and go down to the modules

@shubham09901

5 ай бұрын

​@@linkrachitgthere's a official documentation of every Microsoft Exam on Microsoft Learn portal. Just search Microsoft Learn dp 203 and you will get the documented course. But that's not enough for clearing dp 203 is what I've heard

@puni8869

Ай бұрын

​@@TheTechBlackBoardCould you please share pdf

Thank you for series.. I have cleared my exam with 790 .. Suggestions: 1. Go through the microsoft documentation once. 2. Understand the concepts in this video 3. Go though exam topics by searching "exam dp-203 topic 1 question 1" And then one by one 4. Prepare important concepts like file formats, table distribution and indexing , SCD type 1 2 3 dimensions, storage (hot, cool, archive), Storage (ZRS, LRS, GRS), windowing functions (trumbling, hopping,...)

@user-ye9hv3kb1e

3 ай бұрын

could you please expalin what do you mean by "Go though exam topics by searching "exam dp-203 topic 1 question 1" And then one by one"

@dhivyak5356

Ай бұрын

Can you explain 3rd point

Thank you so so much !! Passed DP-203 with almost 70% questions based on your tips and questions. Really your videos are a boon for examinations and a positive energy to crack them.Please keep this going !!

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

@TheTechBlackBoard

7 ай бұрын

@Anushree210 :Congratulations!! Great to hear that you cleared the exam.. Your certification success is a testament to the effectiveness of our KZread channel as an educational resource. Thank you for your trust and hard work." Do share videos with your family and friends so as everyone gets the opportunity to learn😊

@Anushree210

7 ай бұрын

@@SK-qm5py hi..please watch all these 21parts of videos repeatedly,almost 70% preparation will be done.

@SK-qm5py

7 ай бұрын

@@Anushree210 thanx for the reply mam .

@SK-qm5py

7 ай бұрын

​@@Anushree210mam which course did you buy (udemy/KZread/Coursera) ..Plz name it ?

Just passed the exam today thanks a ton! You are the best

@TheTechBlackBoard

Жыл бұрын

Fantastic!

Passed with the help of your content. Thanks

This video was really helpful. I passed my exam yesterday. Keep up the good work

Thank you for the excellent video. Here are the answers. 30) a) Data analytics platform 60) c) Azure 100) c) From synapse studio, select the workspace. From monitor, select Apache Spark applications. 131) b) Cluster event logs 173) c) an IDENTITY column 216) e) infer_storage_schema

Than you very much for the detailed course in Dp 203. I cleared the exam yesterday and you played a bigger role to achieve my goal I strongly recommend people to follow the topics mentioned in this video

@sahityamamillapalli6735

Жыл бұрын

is this exam for beginner level or associate

Thank you so very much for the study session! It was very comparable to the real exam. Matched with Microsoft Learn, I passed!!!!

@TheTechBlackBoard

9 ай бұрын

Watching you succeed in your certification exams after following our channel is incredibly rewarding. Thank you for making us a part of your educational journey." Do share videos with your family and friends so as everyone gets the opportunity to learn😊 Please also visit our website for free downloads: www.thetechblackboard.com/

I really appreciate your hard work sir, You are really helping plenty of people to crack this certification. Next Part 20 is coming as per the video so please provide case study pdf and other PDFs

@TheTechBlackBoard

Жыл бұрын

Hello, thanks for learning with us. Here is your PDF: drive.google.com/file/d/13C85bS2kmXPyz5lGhtzh3PKEqIvRNby0/view?usp=sharing

Q142 - For Type 2 SCD tables you use a Surrogate Key, not a Business Key. While that's something I just know, you can confirm if you reread the third sentence of the first paragraph on the Microsoft documentation for Type 2 SCD tables.

Hello, can you post few more questions? This playlist was so helpful. Thanks a lot for your awesome works.

Thank you very much Vipin Sir. I passed DP-203 yesterday and really very thankful for your great effort . more that 50% question from this playlist and your hard effort also helped me in other question. 👍👍

@TheTechBlackBoard

Жыл бұрын

Most welcome Jitin. Keep learning.

I just want to say thank you I have passed my exam

Today I have passed dp-203 with 889 score. Your channel helped me a lot to pass this test. Thank you for your support and your efforts

Thank you for helping us in this learning path and getting certified as well. Please help me with the PDF as well. Thanks alot again❤️

Thank very much for your efforts! I passed DP-203 yesterday. Continue your great work.

@TheTechBlackBoard

Жыл бұрын

We thank you for sharing your success with us, Congratulations. Please help us grow. Share videos with your family, friends & office colleagues. Share our videos on your Facebook, KZread, Instagram or Twitter. Maybe share on LinkedIn. Please use our handle @TheTechBlackBoard. It is viewers like you who can help to grow. Looking forward to your support.

@xpalmier

Жыл бұрын

Hi. Congratulations. I´ve started this way. I would like to be in contact with you to share some expirience and tales. Can you speak spanish. My english is a bit poor hahaha, Anyway I can manage it. Best Regards.

Thank you sir you are the GOAT!

I passed DP-203. Thank you. %50 of that questions .... other %50 i remember some of your explanations... so that video is really useful, i highly recommend.... Thank you again.

Thank you so much for your help. I have passed my exam.

Thank you for your efforts,

Q85 - The answer would be "C" (not "B"). When executing the statement that switches partitions, you're pushing a partition from a source, to a destination, overwriting. Therefore, the source is stg.Sales and the destination is dbo.Sales.

@akashghadage5377

Жыл бұрын

The correct option to overwrite the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales while minimizing load times is: C. Switch the first partition from stg.Sales to dbo.Sales. To do this, you can use the following T-SQL code: sql Copy code ALTER TABLE dbo.Sales SWITCH PARTITION 1 TO stg.Sales PARTITION 1; ALTER TABLE stg.Sales SWITCH PARTITION 1 TO dbo.Sales PARTITION 1; The SWITCH PARTITION command swaps the data of two table partitions quickly and efficiently without physically moving the data on disk. By using the SWITCH PARTITION command with two tables that have the same schema and partitioning scheme, you can overwrite the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales. Option A (Insert the data from stg.Sales into dbo.Sales) and Option D (Update dbo.Sales from stg.Sales) would result in the need to transfer all the data from stg.Sales into dbo.Sales, which can be time-consuming and inefficient, especially if the table size is large. Option B (Switch the first partition from dbo.Sales to stg.Sales) would move the data in the first partition of dbo.Sales to stg.Sales, effectively deleting it from dbo.Sales, which is not what is required.

@purwaupadhyay

Жыл бұрын

Yes answer should be C

@laurasscastro

Жыл бұрын

Totally agree, this is the second time I see this question responded to like this. I was starting to doubt myself

I have passed my exam with a score 770 uff :) week ago ... to be honest before the exam I hadn't completed the whole course here (only 2/3). During the exam I regreted and realized how this course is usefull. After the exam I decided to completed this course fully - today is DONE :). Strongly recommed use cases part becasue it helps to match all dots together and understand how to transfer business and technical requirements into real solution. Thank a lot for this course.

I cleared DP-203 Today, your videos really helped me, Thanks.

@shubhamjaiswal9557

9 күн бұрын

How many questions came from here ?

Thank you so much, Helped me pass DP203

Your guidance and explanation helped me very well. Thank you and appreciate your efforts!

@TheTechBlackBoard

5 ай бұрын

Most welcome Eswar. Keep learning.

903/1000. Literally all my questions/concepts were from this video, highly recommend watching it

@SK-qm5py

6 ай бұрын

Bro can we write the exam on weekends Saturday or Sunday ?

coming back here to thank you for the video tutorial , I have passed the exam yesterday and your tutorial was really helpfull :-)

@axelblaze6380

3 ай бұрын

did you get any questions from here?

I Really appreviate your hard work to help us crack this certifications Many Many thanks

@TheTechBlackBoard

Жыл бұрын

It's my pleasure

I passed my DP-203. I have received few questions from this video series :) Thanks a lot and keep covering other certs as well.

@ikigai752

Жыл бұрын

Hey buddy can you help me to let me know the valid dumps for 2023

Dear sir Thank you so much for your video with this video I passed the exam in less than one day ❤️

@TheTechBlackBoard

Жыл бұрын

Well done and congratulations.

Thank you so much I cleared my DP 203 after going through your questions series.

@ravivadadoriya8456

Жыл бұрын

Hi brother, did you just watch this video to clear 203 exam ? I am preparing for the exam too, so just wanted to know.

Thanks a lot for putting these questions together. I passed the exam with a score of 865!!!!

@TheTechBlackBoard

Жыл бұрын

We thank you for sharing your success with us, Congratulations. Please help us grow. Share videos with your family, friends & office colleagues. Share our videos on your Facebook, KZread, Instagram or Twitter. Maybe share on LinkedIn. Please use our handle @TheTechBlackBoard. It is viewers like you who can help to grow. Looking forward to your support.

Just passed dp 203 your videos really help just followed your videos and cracked it❤

@TheTechBlackBoard

9 ай бұрын

Congratulations!! Great to hear that you cleared the exam.. Your accomplishments motivate us to continue producing quality content for your learning needs." "Liking and sharing the video helps our channel grow and reach more people.Please also visit our website for free downloads: www.thetechblackboard.com/

Thank you so much for all the content 😊

@TheTechBlackBoard

Жыл бұрын

You are so welcome!

Thank you so much for the questions i just cleared my DP-203 exam like a couple of minutes back , i found your video series and i'm really thankful that i found it , it was really helpful in clearing it.

@SanthoshKumar-jg1lt

Жыл бұрын

@vasanthkumark3556 how many of the questions from this video appeared in exam bro? Any idea?

@vasanthkumark3556

Жыл бұрын

@@SanthoshKumar-jg1lt for me ,around 75-80% of the questions appeared and as you know each one will have a different set of questions so it’s impossible to say that it might be the same case for all

@SanthoshKumar-jg1lt

Жыл бұрын

Yeah I understand. Did you referred any other courses? If so suggest me

47: is a) GRS GRS (Geo-Redundant Storage) replicates data across two regions, typically hundreds of miles apart, which provides a high level of durability and read access in case of an outage in the primary region. It is a cost-effective option compared to other options like GZRS (Geo-zone-redundant storage) which replicates data across three regions or availability zones

@ezzeddinechakroun8144

Жыл бұрын

Agreed

Thanks to your brilliant explanation and problem solving skills,I scored 900 on my DP-203 exam,around 60-70% were from these videos,and for the rest of the questions,I couldn’t have solved those questions without your help.Thank you once again,will be looking forward to learning more courses from your side

@RANGANDASGUPTA

2 ай бұрын

if one goes through this dumps only , can they pass ?

Thanks a lot for this useful series! I have cleared my DP-203 exam this week and this video played an important role to help me clear my exam. I got around 30-40% of similar questions from here including the case study ones.

@TheTechBlackBoard

4 ай бұрын

Glad it helped! It is a great milestone

I wasn't as lucky as most people on here. I had less than 50% of my questions from here. However, I wouldn't have been able to pass it without this video. I put all the questions on note cards, besides the case study, and memorized everything. Thanks a great deal brother.

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

@matthewmark7224

8 ай бұрын

@@SK-qm5py yes you can. i am new to the cloud space too. give yourself two months, or more if needed to understand the concepts and study the hell out of these questions.

Passed the exam today..Your videos really helped.Thanks much

@swagatikatripathy4917

5 ай бұрын

how did you prepare and what's the question pattern?

Thanks for the series.I just passed dp203.

just cleared the exam today (25 MAR 2024) 850/1000 😀 this video series is a must! the case study is exactly the same, around 50% of the questions are from this series. Thanks a lot!

@moustaphamohamedmahmoud409

3 ай бұрын

Hey! Do you feel that the questions in the video were difficult sometimes compared to the exam or both were easy for you ?

Hi ,Today I passed in DP 203 exam only because of this video. Thank you for making this video and it is really helpful to clear the exam.

@dancinggv

Жыл бұрын

Hi is this all alone enough to get passed

30) a - Data analytics platform 60) c - Azure 100) c - from synapse studio, select the workspace. From monitor, select Apache Spark applications. 131) b - cluster event logs 173) c - an IDENTITY column 216) e - infer_storage_schema

Passed with 903 today , literally abut an hour ago :). About 35 % questions from here. Got a lot of Syntax questions. Thank you so much for making this wonderful video :)

@cOnfidentialcOrp

8 ай бұрын

what about the other 65% questions , where did those came from Thx

@TheTechBlackBoard

8 ай бұрын

Well done! Happy to have helped you. A request: Liking and sharing the video helps our channel grow and reach more people. Thank you for your support!"

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

great job! i cleared dp 203 today

Thanks @TheTechBlackBoard I passed today and I have only used your video question 1-150 and Microsoft learn . Keep up the work!

@TheTechBlackBoard

9 ай бұрын

Glad it helped! Thank you for choosing our channel to support your learning endeavors. Do share videos with your family and friends so as everyone gets the opportunity to learn😊 Please also visit our website for free downloads: www.thetechblackboard.com/

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

@samcaseybolade5368

8 ай бұрын

@@SK-qm5py Hi, I know you said you're a newbie, but I think the fundamentals exams give a good foundation if you don't have hands-on experience. Hope that helps. On average, for me, I spent 7 hours to 10 days reading before each exam.

@SK-qm5py

7 ай бұрын

​@@samcaseybolade5368sir, which course did you buy ...plz.name it ..

Cleared DP-203, Your videos really helped me clear the certificate. Thanks for your helpful content.

@3ilm_yanfa3

3 күн бұрын

Congrats brother! I will do the exam in one week, do you think this video is still relevant ?

@harshbhoyar7176

3 күн бұрын

Yes

Just passed my exam today. This video was of great help. This video + exam dump from exam topics will get you through the exam easily. Thanks for this video

@TheTechBlackBoard

9 ай бұрын

Glad it helped! Congratulations ! "Thank you for choosing our KZread channel as your learning companion.We're grateful for your trust and dedication." Please also visit our website for free downloads: www.thetechblackboard.com/

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

Q59 - If you use a hopping window, you'll be re-processing events and reporting out-of-area trucks multiple times. It should be a tumbling window set to 30 seconds. That the files are delivered every minute is a red herring. Having to report trucks as being out-of-area within 30 seconds is the key.

@chenyeyang2385

Жыл бұрын

Totally agree.

@laurasscastro

Жыл бұрын

also had the same feeling. could anyone confirm?

Thanks i just cleared the exam :)

Hello, Thanks. I have successfully completed DP-203 by following your videos. Also I have read other concepts as well. Secured 850/1000. I have received atleast 75-80% from this series. Thanks you once again.

@TheTechBlackBoard

Жыл бұрын

Well done @Mm Mm. We thank you for sharing your success with us. Congratulations on your efforts, keep learning!

Thank you Very Much to the Tech BlackBorad Team for your effort in preparing this video, it really helped me to clear the exam.🙏🙏🙏

@ikigai752

Жыл бұрын

Hi bro, do you have 2023 valid dumps for dp-203. I have a exam next week

@SivaPrasad-jj9zn

Жыл бұрын

@@ikigai752no i don't have dump

Thank you sir for this detailed video. I have passed the exam yesterday.

@aishwaryanathani4725

Ай бұрын

hi, how many questions came from this video?

30) a) Data analytics platform 60) c) Azure 100) c) from synapse studio, select the workspace. From monitor, select Apache Spark applications. 131) b) cluster event logs 173) c) an IDENTITY column 216) e) infer_storage_schema

Just passed the exam on tuesday thank you very much it helps me a lot !

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

@TheTechBlackBoard

8 ай бұрын

Great to hear!

@jeremievanbrabant4173

7 ай бұрын

@@SK-qm5pyyes it’s fair enough

@SK-qm5py

7 ай бұрын

​@@jeremievanbrabant4173 ok sir ....? Which course did you buy (udemy/coursera/KZread) ..plz name it

Thank you. Great help 😊

@TheTechBlackBoard

7 ай бұрын

Welcome! Please share our videos and help us grow.

Yay just completed dp203 thank you so much 🎉

@shrutisamal

21 күн бұрын

Hey Congrats! I am also preparing for dp203. Could u tell me to what extent was this video helpful?

@dharminsiddeshj9481

17 күн бұрын

@@shrutisamal 80% it will help. Provided you need to understand the concepts.

@shrutisamal

17 күн бұрын

@@dharminsiddeshj9481 thanks bud🤟

Cleared , 958/1000 . Thank You!!

@akashghadage5377

Жыл бұрын

WITH ONLY THIS QUESTIONS?

@vasanthasworld2948

Жыл бұрын

@santosh pradhan Can you recommend the preparation steps needs to follow to crack the exam

@santoshpradhan9822

Жыл бұрын

@@vasanthasworld2948 I did a through preparation for last 6 months because I didn't want only to get the certificate but also to gain the hands-on knowledge. But yes I practiced the questions set from here and from examtopics.

Thanks!

@TheTechBlackBoard

Жыл бұрын

Thank you so much. This contribution gives us a boost and encourage to bring more of such content. We love to hear your feedback on what more you want to see on this channel. at connectus@thetechblackboard.com

Cleared the exam! I must say, this video has been of great use. I would suggest every DP-203 aspirant to go through this video at least once. Thank you for this amazing help!

@Babyshark779

6 ай бұрын

Thanks, Planning to take exam next week. can you share some inputs..

@pratikraj223

6 ай бұрын

@kaivalyapatkar9288- congratulations 🎉 did you only follow this video or any other sources as well? Also, were the scenarios from here as well?

@swagatikatripathy4917

5 ай бұрын

Please inbox me ,had some queries in dp 203

@user-if7ud1vs8n

4 ай бұрын

Hi , I would like to take some inputs for next week. can you share some if these are the same questions

@moustaphamohamedmahmoud409

3 ай бұрын

Hey! Do you feel that the questions in the video were difficult sometimes compared to the exam or both were easy for you ?

Thanks for your great work

@TheTechBlackBoard

Жыл бұрын

Most welcome

@sergendikintum6421

Жыл бұрын

@@TheTechBlackBoard Passed my dp 203 exams with the help of your videos.

Thank you so much for these videos Yesterday, I got certified 🙌 Tips: Go through Microsoft documentation Practice exam topics dump along with this Video.

@user-kf6we1yj6c

4 ай бұрын

Can You tell me how many question were from the EXAMTOPICS DUMP ?

Q106: Round Robin, Heap and None are correct Reason: it's a STAGING TABLE => RoundRobin will speed up loading -- HEAP is faster on INSERT than CL or CCI -- Partitioning isn't needed on a STAGING-Table Your answers assumes that the table is a fact table. This isn't stated in the question. You speaking of increasing query performance, which isn't a requirement in this question

@laurasscastro

Жыл бұрын

Agree, i think partitions would help in loading the fact table (switching partitions for example), but that's not the question. Since its only regrading loading the STG table, partitions would slow down the write, i belive.

This video is very useful for people who are preparing for dp 203 ..Along with the preparation I am recommending to watch this video also ..I have cleared the exam ..Thank you so much sir

@niteshchaurasia1332

Жыл бұрын

Hi, Can you share your preparation tips?

@shwetasharma7029

Жыл бұрын

@Nitesh Chaurasia First of all, complete the syllabus there is lot of study material in youtube, udemy .. do practical for better understanding you can get free credits for that ...give mock tests as much as you can

Q106 - I'm going to have to disagree. The solution requires minimizing load time, not query time. Also, for Azure, 1 million rows is tiny. I would argue that the answer would be Round Robin, Heap, and None. Round-robin because they keep banging on about how round-robin is the fastest way to load data. Then I'd go with Heap - with either clustered options, the inserts are slowed by having to move the data around in the table so the records can be insert in the correct order - Heap will slap the records onto the end of the table. Finally, I'll say None for partitioning because using Date sounds terrible for a table that's loaded once per day. In all likelihood the data in the table will be heavily skewed to one date defeating the purpose of using partitions at all. (Side note, I know I am saying to round-robin the data into a table with one partition).

@santoshpradhan9822

Жыл бұрын

100% agreed .Hope the instructor reads this comment and make necessary correction otherwise it's confusing .

@janakilakshminarayanan2040

Жыл бұрын

Also, never to use hash distribution with date partioning.

@guices

Жыл бұрын

I was looking for a comment about it, agreed

@justwatching2960

Жыл бұрын

agree

@gurindersingh7002

10 ай бұрын

You are 100% correct..!

Hi, It is really a very helpful video for who is going to attend the certificaton. Thank you for your efforts. Can you provide the PDF file for case studies, it will be very helpful. Thanks

Here are the answers to get the free pdf : 30-c) , 60-c) , 100-c) , 131-b) , 173-c) , 216-e). Thanks in advance 🙏🏾 and for this invaluable series of questions for the exam prep.

sir the answer to question 46 should be c. ZRS replicates the data to a different availability zone within the same data center. So if a data center goes down then ZRS will not be useful. So our options are GRS and GZRS of which GRS is the one with minimum cost

Q47, The difference between GRS and RA GRS is fairly simple, GRS only allows to be read in the secondary zone in the event of a failover from the primary to secondary while RA GRS allows the option to read in the secondary whenever. In the question they state "...available for read workloads in a secondary region IF AN OUTAGE OCCURES in the primary...". Well, answer B (RA-GRS) states in Microsoft documentation that RA-GRS is for when "...your data is available to be read AT ALL TIMES, including in a situation where the primary region becomes unavailable." To me, the nature of the question is what is the cheapest solution which allows for failover to read workload, when there is an outage. Hence, I think the answer is A.

Q199 - I agree the third answer _could_ work, but I don't get the whole two queries, four outputs thing. No where were we instructed to split the data. It didn't say the Customer file should be split Online vs Offline. It didn't say to split Median Income Matches from Non-Matches. There would be one output to the Azure SQL Database and one to the Azure Data Lake Storage. IF the file needed split between has address and non-address before doing the Median Income match, I can then see two queries, but the results of both of them should be pulled back together before being output. I can't imagine a data analyst being happy the data was split into two tables on the Azure SQL Database.

Just passed DP 203 exam today by help from your course. Thanks for all your efforts. Keep ip the great work.🙏

@ashokmetha3373

Жыл бұрын

Hi bro, am going to write tomorrow Friday 09 December.. May I know if questions and case studies came from same videos?

@alekyareddy1851

Жыл бұрын

I have on dec10th plz help me

@alekyareddy1851

Жыл бұрын

@@ashokmetha3373 yaa plz tell us case studies and other questions are same or not

@mannykhan7752

Жыл бұрын

Hi everyone, 90% of questions are from this video. Memorize them all and should be good. There were 3 new questions not in this video series. I would say read a little theory to make sure you dont get stuck.

@TheTechBlackBoard

Жыл бұрын

Great work @Manny Kha, Keep up the learning.

First for all appreciate your hard work, I do passed Az 900 and Az 104 was watching your video very helpfull. Now my question I would like to go to data engineer which certificate need to take AZ 200 & AZ 201 or just go for AZ 203 please advise just need to clear my doubt, Thank you so much again Bravo!

Thank You

Thank you sir

@TheTechBlackBoard

Жыл бұрын

So nice of you

Hello! Q106 - In my opinion the given answer is wrong, because the question is telling us to minimize the LOAD time of a staging table, not to query it. Besides that, the question said tha data will be truncated every day (So, why indexes?). That Said, i think you should use Round Robin Distribution, with no indexes (HEAP) and no partitions (none). This configuration will provide much faster times to LOAD the data into a staging table. Staging tables are not meant to be queried.

@treyfromthebay

5 ай бұрын

I agree with this assessment, round robin makes the most sense and heap with no partition should follow

Thank you..💥

@TheTechBlackBoard

Жыл бұрын

You're welcome 😊

@ThetechBlackBoard Thank you for the detailed video library. Quick question below for your review. Question 106 at 2:34:13: If load time should be minimised shouldn't we use roundrobin instead?

Q3 - CREATE EXTERNAL TABLE AS SELECT (CETAS) writes the results of a query the external table (file). Therefore CETAS is for exporting data not importing. I would advise CREATE EXTERNAL TABLE for the third item.

@justwatching2960

Жыл бұрын

Agree

Passed the exam today, scored 920. Thank You for your videos. This and exam topics question dump are still valid 👍

@TheTechBlackBoard

5 ай бұрын

Well done Vinay. Keep soaring new hights.

@mounikadontha

5 ай бұрын

Hello @TheTechBlackBoard and @Vinay, I am having DP-203 exam in 5 days.. Can you please provide advice and suggestions. Thank you

@amazhobner

5 ай бұрын

@@mounikadontha Hi there, please find below things you should do. 1. Go through the video on which we are commenting multiple times till you know solution to all questions. 2. Exam topics free questions also you should know solutions to all. 3. Go through the three dp203 playlists on the channel "Studying As You Were" 4. MS docs are useful in exam if you have time left, I got 3 answere correct because of it. The first 3 points should be enough for you to pass the exam. Also try to go through documentation as 15 odd qsns will be new, most of them will be simple but you should have basic subject understanding to answer.

@mounikadontha

5 ай бұрын

Thank you, @@amazhobner

@amazhobner

5 ай бұрын

Thank Youu!!@@TheTechBlackBoard

I just passed DP-203 yesterday. Thank you for your videos. keep up the great work.

@surajpathak6378

Жыл бұрын

Hey Aditri, how you passed this exam?

@surajpathak6378

Жыл бұрын

Any suggestions on tutorial pls let me know

@aditrideshpande34

Жыл бұрын

@@surajpathak6378 try questions from microsoft document too. there is free practice test . few questions were similar to those.

137: My response is c) Compress the files. To optimize files for batch processing in a container, it is important to ensure that the files are properly partitioned and compressed. Merging files can be an option in some cases, but it may not be the most efficient solution for batch processing, especially if the files are very large. Merging files can increase the overall file size, which can lead to longer processing times and increased storage costs.

In my opinion: Q3 ⇒ Create External Table (without as select) Q50 ⇒ A Q61 ⇒ Yes Q63 ⇒ No Q80 ⇒ Raised Q85 ⇒ C Q106 ⇒ Round Robin, Heap, None Q111 ⇒ 2, 4, 1, 5 Q115 ⇒ C Q142 ⇒ Type 2, Surrogate Key Q174 ⇒ A Q178 ⇒ Binary, Preserve Hierarchy Q183 ⇒ C Q189 ⇒ P1: Dynamic Range, P2: PolyBase Q211 ⇒ Right

@TheTechBlackBoard

2 ай бұрын

Long shot.

Q71 - the answer should be a pipeline . In Azure Data Factory (ADF), a pipeline is used to orchestrate and manage data transformation and movement. A pipeline is a logical grouping of activities that together perform a task. For example, a pipeline could contain a set of activities that ingest and clean log data, and then kick off a mapping data flow to analyze the log data. A linked service is similar to a connection string, which defines the connection information needed for ADF to connect to external resources

@baoanhnguyen3485

8 ай бұрын

Thanks for your confirmation. I have a same doubt and try to find in comment ;)

@thedailyepochs338

Ай бұрын

@@baoanhnguyen3485 yeah same with me too

I started working my way though the DP-203 material on Microsoft Docs Learn and there are many labs which cannot be completed because they assume set-up that hasn't been done. I reported this several weeks ago and have seen no improvement. Can you advise?

I have passed the examination. All thanks to you for this video. It was very well illustrated to the point with Microsoft documentation for the answer which helped me how and where to find the answers.

@axelblaze6380

3 ай бұрын

did you get any questions from here?

@pranavsangole6103

3 ай бұрын

@@axelblaze6380 yess

@SukruthJayam

2 ай бұрын

How many questions did you get from this tutorial?

@axelblaze6380

2 ай бұрын

@@SukruthJayam I got 5 to 6 questions

@axelblaze6380

2 ай бұрын

But try to understand this video you will pass easily

Q191, Your two answers (sources and targets, transformations) are I believe both wrong. In ADF you don't have sources and targets, you have sources and sinks. In the question it only says you need to move data from a table in db1 to a table in db2, so no transformation is needed. In the question it says you're using a ADF pipeline. For a pipeline to work you need a linked service to the database and datasets to access the tables. I therefore believe the correct answers are: a linked service, input and output datasets.

@TheTechBlackBoard - **update, I passed the test on Monday, thanks for your hard work** thank you for making this course! This is an excellent resource. This has boosted my confidence, and I will take the test soon! Will update with pass or fail. Please be advised, you might want to review a few of your answers. As some people have said, some of them might be improved.

@TheTechBlackBoard

9 ай бұрын

Great to hear! Congratulations! "I'm thrilled that you found the video helpful! Do share videos with your family and friends so as everyone gets the opportunity to learn😊 Please also visit our website for free downloads: www.thetechblackboard.com/

@SK-qm5py

8 ай бұрын

Hi bro ...I'm an absolute newbie to azure or cloud ...Can I crack this exam by just preparing through udemy and youtube ? Or should i have experience to do this

@iPutOnForMaESC

8 ай бұрын

@SK-qm5py I never did DP-203 professionally, but have practiced the teaches with Case Studies on 80 hours of Udemy and this KZread video.

@gajendrarathore511

7 ай бұрын

@@TheTechBlackBoard can you please upload the pdf for DP-203 on your website

@SK-qm5py

7 ай бұрын

​@@iPutOnForMaESC sir , which course did you buy ..plz name it