Databricks Certified Data Engineer Associate | Exam Preparation- Part 2

☕ Buy me a coffee:
buymeacoffee.com/navalyemul
Follow me on LinkedIn:
/ naval-yemul-a5803523
This video helps you to crack the Databricks Certified Data Engineer Associate Exam V2/ V3. These are all real questions.
Databricks Certification Link
www.databricks.com/learn/cert...
Databrick DBC Files Link
drive.google.com/file/d/1qIp7...
Databricks Certifications and Badging
• 6. Databricks Certific...
All About Delta Lake | Lakehouse
• All About Delta Lake |...
Internals of Delta Lake | Databricks | Lakehouse
• Internals of Delta Lak...
Link For Databricks Playlist:
/ playlistlist=pl7s7dd8r...
#lakehouse #DataEngineeringAssociateExam #databricks #databricksforfree #databricks #azuredatabricks #dataengineering #certification #azure #learnazuredatabricks #azuredatabrickscourse
Link for Azure Data Factory (ADF) Playlist:
• Azure Data Factory
Link for Snowflake Playlist:
• Snowflake
Link for SQL Playlist:
• MySQL
Link for Power BI Playlist:
• Power BI Full Course |...
Link for Python Playlist:
• Python
Link for Azure Cloud Playlist:
• Azure Cloud
Link for Big Data: PySpark:
• Big Data with PySpark
1:31 Q1. A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
3:53 Q2. Which of the following commands will return the location of database customer360?
4:46 Q3. A data engineer wants to create a new table containing the names of customers that live in France.
8:08 Q4. Which of the following benefits is provided by the array functions from Spark SQL?
9:05 Q5. Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?
10:40 Q6. A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).
15:02 Q7. A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.
16:28 Q8. A data engineer runs a statement every day to copy the previous day’s sales into the table transactions. Each day’s sales are in their own file in the location "/transactions/raw". Today
19:56 Q9. A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database.
21:08 Q10. A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables.
23:46 Q11. The data engineering team has a Delta table called employees that contains the employees personal information including their gross salaries.
24:48 Q12. A data engineer wants to create a relational object by pulling data from two tables. The relational object must be used by other data engineers in other sessions on the same cluster only.
27:48 Q13. A data engineer has developed a code block to completely reprocess data based on the following if-condition in Python
29:50 Q14. Fill in the below blank to successfully create a table in Databricks using data from an existing PostgreSQL database:
30:20 Q15. A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
31:44 Q16. A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data. DROP TABLE IF EXISTS my_table - While the object no longer appears when they run SHOW TABLES, the data files still exist.
33:44 Q17. A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions.

[@GrowthMindset_J]

@naval’s videos helped me understand Databricks concepts better. I passed the exam with 95% with no prior experience! Thanks heaps Naval. Keep up the great work in educating!

[@user-fm4tl8ok6f]

Indeed very useful for the exam prep! Cheers

[@hadihairi1622]

Thank you Naval! You are doing a gold work here!

[@thedatamaster]

Thanks a ton! Glad to be of help!

[@pradeepthanniru2602]

Explained very well and very useful certification preparation

[@user-sw5wd2yq9b]

Can’t wait for part 3

[@sky4223]

Thanks bro keep uploading

[@thedatamaster]

Thank you so much for your kind words! 😊 We're thrilled to hear that you're enjoying our content.

[@user-kl2mj3ko2e]

Great video. Please do more

[@harikrishnan7897878]

Thank you, waiting for the 3rd part........

[@thedatamaster]

I hear you! Your eagerness for the third part is well noted. Just a quick heads up, I've already uploaded the next video. Feel free to check it out using the link provided here. Your enthusiasm is appreciated, and I hope the new content meets your expectations. Happy learning! kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@bobbyvenky9860]

Thanks bro for the wonderful explanation

[@thedatamaster]

Thank you so much for your kind words! 😊 We're thrilled to hear that you're enjoying our content. Your support means the world to us, and it motivates us to keep creating and sharing more videos. Stay tuned for more exciting content, and if you have any suggestions or requests, feel free to let us know. We appreciate you being a part of our community! 🙌🎉

[@suyogkadam]

Just saw the videos very thorough.......better than my Udemy course. eagerly waiting for part 3....keep up the good work, it does helps us a lot

[@thedatamaster]

I hear you! Your eagerness for the third part is well noted. Just a quick heads up, I've already uploaded the next video. Feel free to check it out using the link provided here. Your enthusiasm is appreciated, and I hope the new content meets your expectations. Happy learning! kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@peternan4814]

Thank you sir for sharing your knowledge! I passed the exam today, most of the questions are the same with your video. However, the two parts differ: 1) the total number of questions increases to 50. 2). The number of options is ABCD without E.

[@arunkumarmurugan2704]

Hi bro, I am also applying for the certification exam; how was the assessment for you?

[@aslamnaturalfarming2128]

Thank you

[@thedatamaster]

You're most welcome! If you have any more questions or need assistance in the future, don't hesitate to ask. I'm here to help. Your appreciation is greatly valued, and I'm always happy to be of service. Wishing you all the best in your learning and endeavors. Feel free to reach out anytime you need support or information. Have a wonderful day!

[@sanooosai]

thank you sir

[@thedatamaster]

Most welcome

[@satwiksharma4359]

Informative

[@thedatamaster]

I'm glad you found the video informative! If you have any more questions or if there's a specific topic you'd like to learn more about, please don't hesitate to ask. Your feedback is important, and I'm here to assist you with any information you need. Thanks for watching! 😊📚🎥

[@RajibMostafiz]

Thank you so much for creating all these content. I successfully passed the exam with 93.33% following your channel mostly. Thanks a lot for your service.

[@thedatamaster]

You're very welcome! I'm so glad my content helped you pass your exam with such a high score. Congratulations on your accomplishment!

[@sirisha8182]

Great content. But sharing them fast would help the learners as each parts has two months difference. Expecting more videos soon

[@thedatamaster]

Thank you for appreciating the content! I completely understand the value of timely updates for learners like you. Your feedback is crucial, and I'm committed to delivering more frequent videos. In fact, I've just uploaded the next video, so please do check it out using the link provided here. Your enthusiasm fuels the momentum for more content. Stay tuned for more updates! kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@sirisha8182]

@@thedatamaster thank you

[@mayurnanda4604]

please share the link of Databricks repo .... couldn't find in the descriptions as you mentioned in the video ... thanks

[@learnwithfunandenjoy3143]

Thanks naval for making so powerful questioners and their answers explanation for Databricks Associate exam. I'm planning to appear in Databricks Associate exam by next week. Is same questions are coming in exam. Could someone please confirm for the same ? Or questions are different, please share new questions sets with me. Thanks in advance.

[@learnwithfunandenjoy3143]

Dear Naval, did you prepared such questions and answers videos for Databricks Professional Exam? If yes, could you please share link for the same. I'm also planning to clear Professional exam soon. Your videos will help me a lot to pass the exam with excellent score. thanks in advance.

[@MrKoolatul]

Thanks for this wonderful video. I have completed part 1 & 2 now and confident for my exam scheduled on 20th August 2023 on first 2 parts. I hope you will complete remaining topics and upload before my exam so that I can pass :) Thanks once again for this wonderful video and spreading easy learning. god bless you and keep doing this !!

[@thedatamaster]

Thank you so much for your kind words and for sharing your progress! I'm thrilled to hear that you've completed parts 1 and 2 and are feeling confident about your exam on August 20th, 2023. Your encouragement means a lot, and I truly appreciate your positive feedback about the content and teaching style. I apologize for not being able to upload the video before your exam due to other commitments. However, I've just uploaded the next video now. You can find the link right here. I'm dedicated to supporting your learning journey, and I wish you all the best in your upcoming exam. Keep up the great work, and stay focused on your goals! 🌟 kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@MrKoolatul]

@@thedatamaster Thanks for your kind words. I have cleared my exam yesterday and got Databricks certified Data Engineer. I must say your videos helped me a lot. I will still go through your 3rd video to enhance my knowledge. Thanks and happy learning !!

[@ARULJERALDJ]

​@@MrKoolatulhii how was your exam? How to prepare? Did you study any course? Could you please help me clear the exam?

[@hongxiachen4948]

Hi, I hope that you have passed your exam, I am wondering if these questions come up in the exam?🙂

[@MrKoolatul]

@@hongxiachen4948 Yeah I passed my exam with 822 marks. these questions didnt came but the concept came in the exam. if we cover these 4-5 videos we will get enough understanding to clear the exam. let me know in case of any query.

[@truthUntold99]

I was having difficulties in understanding the databricks concepts initially but finally I found your channel. You explain each concept in a very simple way which makes it very easy to understand. Thank you so much for making these videos for the Databricks Certified Data Engineer Associate Exam. I am planning to take the exam this month. I am waiting for the next parts. Thank you for your hard work. Also are there any videos where you have explained scd1 and scd2?

[@krishnachaitanyareddy2781]

can u give this all questions in pdf format for preparation

[@tusharhatwar]

For question 11 answer should be A ( greater than 3000)

[@user-tc6yt7lm3t]

Read the question careful😂😂...

[@kanwal4805]

they want to keep the employees whose salary is greater than 3000, so delete the other ones whose salary has less than equal to 3000, Hence answer is E

[@thiruvenkadams6865]

Please upload 3 part soon

[@thedatamaster]

I hear you! Your eagerness for the third part is well noted. Just a quick heads up, I've already uploaded the next video. Feel free to check it out using the link provided here. Your enthusiasm is appreciated, and I hope the new content meets your expectations. Happy learning! kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@joshuadanielmendoza312]

A data engineer wants to create a relational object by pulling data from two tables. The relational object must be used by other data engineers in other sessions on the same cluster only. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data. The correct answer is Global Temporary view? or VIEW only?

[@RakeshKumar-dq3db]

View only. Here, the keyword is other sessions. GlobalTemlViews are restricted to that particular session only that means if the cluster is restarted it won't be available any more but the VIEW will remain even in the other sessions.

[@Imran-sz7wf]

Good

[@thedatamaster]

You're most welcome! If you have any more questions or need assistance in the future, don't hesitate to ask. I'm here to help.

[@Imran-sz7wf]

@@thedatamaster sure.. I have scheduled my exam on 20th August 2023. Please post next video soon 😊

[@user-sw5wd2yq9b]

@@thedatamastercan’t wait for part 3 and 4

[@Imran-sz7wf]

As per Databricks web site, they have changed syllabus for associate exam, please check and guide

[@Imran-sz7wf]

@@subbutan779 I rescheduled exam on 1st Sept

[@madeshwaranr3936]

Do you have share the detail for free voucher or percentage discount

[@thedatamaster]

I apologize, but I don't have any free vouchers or percentage discount coupons to share. For such offers, I recommend checking the official Databricks Academy website. They might have promotions or discounts available for their courses. Be sure to keep an eye on their website or subscribe to their newsletter to stay updated on any special deals they may offer.

[@madeshwaranr3936]

@@thedatamaster thank yoy

[@GrowthMindset_J]

Please load the third part soon

[@thedatamaster]

I hear you! Your eagerness for the third part is well noted. Just a quick heads up, I've already uploaded the next video. Feel free to check it out using the link provided here. Your enthusiasm is appreciated, and I hope the new content meets your expectations. Happy learning! kzbin.info/www/bejne/h6fHeayZnKtnmLM

[@GrowthMindset_J]

Can I email you some more practice tests?

[@thedatamaster]

Thank you for your offer! Feel free to send them to [e-mail]. Appreciate your help!

[@Gopismart555]

Any one dumps

[@akbarmulla2893]

Q:17. - Answer should be option C i.e. VIEW. (35:08) @thedatamaster

[@benim1917]

the key words here are : It also must be saved to a ohysical location. View can't be the answer

[@Babayagaom]

@@benim1917 view can be saved to physical location

[@nitropan]

I think it should be Database - the question specifies "Create a data entity from a couple of Tables"

[@user-sw5wd2yq9b]

Can’t wait for part 3

[@user-sw5wd2yq9b]

Can’t wait for part 3

[@thedatamaster]

I hear you! Your eagerness for the third part is well noted. Just a quick heads up, I've already uploaded the next video. Feel free to check it out using the link provided here. Your enthusiasm is appreciated, and I hope the new content meets your expectations. Happy learning! kzbin.info/www/bejne/h6fHeayZnKtnmLM