Databricks Certified Data Engineer Associate V2/V3 | Exam Preparation- Part 2

☕ Buy me a coffee:
https://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
https://www.databricks.com/learn/cert...

Databrick DBC Files Link
https://drive.google.com/file/d/1qIp7...

Databricks Certifications and Badging
   • 6. Databricks Certifications and Badg...  

All About Delta Lake | Lakehouse
   • All About Delta Lake | Databricks | L...  

Internals of Delta Lake | Databricks | Lakehouse
   • Internals of Delta Lake | Databricks ...  

Link For Databricks Playlist:
   / playlistlist=pl7s7dd8r4qdvzoyrzig2ujdcacas...  

#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 | Power BI tutor...  

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.