19A customer's Delta table has 4 million small files and every query crawls. What happened, and how do you fix it?▼mediumDatabricksPalantirSnowflake1 replies○ sign inThe small-files problem is the #1 self-inflicted lakehouse wound FDEs find in the field. The causes are always the same three things, and the fix has a prevention half most candidates forget.Open full answer →
22Lakehouse vs data warehouse, and what does ACID on a data lake actually buy you?▼medium★ EssentialDatabricksSnowflakeMicrosoft1 replies◆ premiumThe architecture question both Databricks and Snowflake ask, for opposite reasons. A vendor-neutral framework, what the Delta transaction log really does, and the honest convergence story that scores with both panels.Open full answer →
33Write PySpark to read a directory of JSON files, flatten the nested schema, and write a Delta table partitioned by date.▼mediumDatabricks1 replies◆ premiumThe reported Databricks Solutions Architect live-coding staple. Working code is table stakes, the differentiators are explicit schemas, corrupt-record handling, idempotent re-runs, and knowing when explode_outer beats explode.Open full answer →