Implement Delta tables optimized for Databricks SQL service

[joseph_sf]

This question is on  the Databricks Certified Data Engineer Professional exam in section 1: "Implement Delta tables optimized for Databricks SQL service"

I do not understand what is being asked by this question. i would assume that their different ways to optimize a delta table as stated in the prior question. Please clarify.

[koji_kawamura]

Hi @joseph_sf , I assume you are referring to the exam guide PDF file.

As you assumed, there are different techniques to optimize a Delta table. Some of them are already mentioned in the other bullet points in the same section 1, such as partitioning, zorder, bloom
filters, and file sizes. And I agree with you; compared to other points, the "Implement Delta tables optimized for Databricks SQL service" sounds like a broader, more generic phrase to me.

Having said that here are some useful links I can think of:

• Delta Lake - Best practices
• Delta Lake - Optimization & Performance
• Photon
• Comprehensive Guide to Optimize Databricks, Spark and Delta Lake Workloads

Also, the Databricks product keeps rapidly evolving. For example, I cannot find "Liquid clustering" on the exam guide, but Liquid clustering is the recommended technique over Hive style partitioning nowadays. It's worth to explorer the latest docs.

I've passed the exam before, but didn't get 100 score. So please take it as one of possible views. I hope it helps and good luck with your exam!