Databricks Certified Data Engineer Associate Exam Questions & Answers

All 45 questions

1. Q1 Which data type is typically involved when using the explode function?
2. Q2 You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would…
3. Q3 How do you upgrade an existing workspace managed table to a unity catalog table?
4. Q4 When building a DLT s pipeline you have two options to create a live tables, what is the main difference between CREATE…
5. Q5 A data engineer at an HR analytics company is developing a PySpark pipeline to analyze salary metrics across departments. They wrote the…
6. Q6 When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the external tables caches the data and location for…
7. Q7 Which of the following must be specified when creating a new Delta Live Tables pipeline?
8. Q8 A data analyst needs to enhance their Databricks notebook by adding complex data visualizations created with R, alongside existing Python analytics code.…
9. Q9 You are a data engineer overseeing a critical daily data processing pipeline. This pipeline includes tasks for data ingestion, transformation, and finally,…
10. Q10 A data engineer from a global logistics company needs to share specific datasets and analysis notebooks with an external analytics vendor, who…
11. Q11 In the context of Databricks workflows, which pattern would you use to handle data at different stages of refinement, from raw to…
12. Q12 The current ELT pipeline is receiving data from the operations team once a day so you had setup an AUTO LOADER process to…
13. Q13 Why would you consider restarting a Databricks cluster?
14. Q14 You are designing an analytical to store structured data from your e-commerce platform and unstructured data from website traffic and app store,…
15. Q15 Which of the following statements is Not true about CTAS statements ?
16. Q16 In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?
17. Q17 What type of table is created when you create delta table with below command?CREATE TABLE transactions USING DELTA LOCATION "DBFS:/mnt/bronze/transactions"
18. Q18 Why does AUTO LOADER require schema location?
19. Q19 What is the standard method for sharing a Databricks notebook with another user within the same Databricks workspace?
20. Q20 How long is the default retention period of the VACUUM command ?
21. Q21 How can you execute Python and SQL code within the same Databricks notebook?
22. Q22 You noticed that a team member started using an all-purpose cluster to develop a notebook and used the same all-purpose cluster to…
23. Q23 A data analyst has developed a query that runs against Delta table. They want help from the data engineering team to implement…
24. Q24 You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped…
25. Q25 The data engineering team has a Delta table called products that contains products’ details including the net price.Which of the following code…
26. Q26 Which of the following commands can a data engineer use to grant full permissions to the HR team on the table employees…
27. Q27 How does the Unity Catalog facilitate the management of data and AI assets?
28. Q28 A data science team is collaborating on a Databricks notebook. The data engineer prefers to use SQL for data extraction, while the…
29. Q29 What tool does Auto Loader utilize to process data in increments?
30. Q30 Which of the following SQL statement can be used to query a table by eliminating duplicate rows from the query results?
31. Q31 You had worked with the Data analysts team to set up a SQL Endpoint(SQL warehouse) point so they can easily query and analyze…
32. Q32 A data engineer has developed a code block to completely reprocess data based on the following if condition in Python:if process_mode =…
33. Q33 How does Automatic Liquid Clustering determine which columns to use as clustering keys in a Unity Catalog-managed Delta table?
34. Q34 You have written a notebook to generate a summary data set for reporting, Notebook was scheduled using the job cluster, but you…
35. Q35 Which statement correctly describes the difference between a Temporary View and a Global Temporary View?
36. Q36 When using the complete mode to write stream data, how does it impact the target table?
37. Q37 Which of the following code blocks can a data engineer use to create a user defined function (UDF) ?
38. Q38 A dataset has been defined using Delta Live Tables and includes an expectations clause: CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01')What is the…
39. Q39 You are currently working on a notebook that will populate a reporting table for downstream process consumption, this process needs to run…
40. Q40 What is the purpose of gold layer in Multi hop architecture?
41. Q41 Which job uses a Gold table as its source?
42. Q42 You are currently working with the second team and both teams are looking to modify the same notebook, you noticed that the…
43. Q43 A data engineer needs to run the last part of a Python script only if the variable day_of_week is 1 and review_period…
44. Q44 Which of the following Structured Streaming queries successfully performs a hop from a Silver to Gold table?
45. Q45 What syntax does Spark SQL use to query subfields within STRUCT data types?