Certified Data Engineer Associate Practice Test

Certified Data Engineer Associate Practice Test practice questions, page 11 of 12, with answer review and explanations.

Question 51

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance. Which of the following keywords can be used to compact the small files?

  1. REDUCE
  2. OPTIMIZE
  3. COMPACTION
  4. REPARTITION
  5. VACUUM

Question 52

In which of the following file formats is data from Delta Lake tables primarily stored?

  1. Delta
  2. CSV
  3. Parquet
  4. JSON
  5. A proprietary, optimized format specific to Databricks

Question 53

Which of the following is stored in the Databricks customer's cloud account?

  1. Databricks web application
  2. Cluster management metadata
  3. Repos
  4. Data
  5. Notebooks

Question 54

Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

  1. None of these
  2. Data lake
  3. Data warehouse
  4. All of these
  5. Data lakehouse

Question 55

A data architect has determined that a table of the following format is necessary: Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?