Databricks Certified Data Engineer Associate V2/V3 | Exam Preparation- Part 4 & 5

☕ 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 and Badging- Databricks
https://www.databricks.com/learn/cert...

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 #databricks #azuredatabricks #dataengineering #certification #azure #learnazuredatabricks #azuredatabrickscourse #azuredatabricksforbeginners


Link for Azure Data Factory (ADF) Playlist:
   • Azure Data Factory  

Link for Databricks:
   • Databricks  

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:30 1. A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped. Which of the following approaches can the data engineer take to identify the table that is dropping the records?

5:43 2. A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task. Which of the following approaches can the data engineer use to set up the new task?

10:02 3. An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the computing resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.

15:22 4. A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously.

20:16 5. A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

22:13 6. A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.

25:39 7. A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job’s current run. The data engineer asks a tech lead for help in identifying why this might be the case.

28:24 2. A data engineer has a Job with multiple tasks that run nightly. Each of the tasks runs slowly because the clusters take a long time to start.
Which of the following actions can the data engineer perform to improve the start-up time for the clusters used for the Job?

Data Governance
33:27 1. Which part of the Databricks Platform can a data engineer use to revoke permissions from users on tables?

35:03 2. A new data engineering team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

37:03 3. A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.