Databricks Certified Data Engineer Professional Exam Dumps: 278 Practice Exam Questions and Answers

1. You were asked to setup a new all-purpose cluster, but the cluster is unable to start which of the following steps do you need to take to identify the root cause of the issue and the reason why the cluster was unable to start?

2. A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York.

How would you approach resolving this issue?

3. You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?

4. When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

5. Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of the Job’s schedule and configuration?

6. What is the underlying technology that makes the Auto Loader work?

7. You are currently looking at a table that contains data from an e-commerce platform, each row contains a list of items(Item number) that were present in the cart, when the customer makes a change to the cart the entire information is saved as a separate list and appended to an existing list for the duration of the customer session, to identify all the items customer bought you have to make a unique list of items, you were asked to create a unique item’s list that was added to the cart by the user, fill in the blanks of below query by choosing the appropriate higher-order function?

Note: See below sample data and expected output.

Schema: cartId INT, items Array<INT>

Fill in the blanks:

Fill in the blanks:

SELECT cartId, _(_(items)) FROM carts

8. When building a DLT s pipeline you have two options to create a live tables, what is the main difference between CREATE STREAMING LIVE TABLE vs CREATE LIVE TABLE?

9. You are tasked to set up a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department, how do you go about to setup this up in job?

10. Which of the following commands can be used to run one notebook from another notebook?

11. You have configured AUTO LOADER to process incoming IOT data from cloud object storage every 15 mins, recently a change was made to the notebook code to update the processing logic but the team later realized that the notebook was failing for the last 24 hours, what steps team needs to take to reprocess the data that was not loaded after the notebook was corrected?

12. John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?

13. Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?

14. return x

check_input(1,3)

15. Which of the following is true, when building a Databricks SQL dashboard?

16. What is the main difference between the bronze layer and silver layer in a medallion architecture?

17. You noticed that a team member started using an all-purpose cluster to develop a notebook and used the same all-purpose cluster to set up a job that can run every 30 mins so they can update un-derlying tables which are used in a dashboard.

What would you recommend for reducing the overall cost of this approach?

18. Which of the following locations hosts the driver and worker nodes of a Databricks-managed cluster?

19. Which of the following data workloads will utilize a Bronze table as its destination?

20. What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table

21. A DELTA LIVE TABLE pipelines can be scheduled to run in two different modes, what are these two different modes?

22. Which of the following developer operations in CI/CD flow can be implemented in Databricks Re-pos?

23. Identify one of the below statements that can query a delta table in PySpark Dataframe API

24. How VACCUM and OPTIMIZE commands can be used to manage the DELTA lake?

25. Which of the following statements are correct on how Delta Lake implements a lake house?

26. What are the different ways you can schedule a job in Databricks workspace?

27. Which of the following type of tasks cannot setup through a job?

28. Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?