- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2025 06:02 PM
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!