Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A data engineer has multiple Unity Catalog-managed Delta tables that require regular maintenance.

A data engineer has multiple Unity Catalog-managed Delta tables that require regular maintenance. Currently, the engineer manually schedules OPTIMIZE and VACUUM jobs for each table, adjusting their frequency according to how often each table is queried and updated.

The engineer needs to eliminate this manual maintenance overhead and allow Databricks to determine automatically when and how to run these operations.

Which action should the engineer take?

A.

Enable predictive optimization at the account, catalog, or schema level so Databricks automatically identifies and runs maintenance operations on managed tables.

B.

Configure Auto Loader with schema evolution enabled so it automatically triggers OPTIMIZE and VACUUM after each ingestion batch.

C.

Enable liquid clustering with CLUSTER BY on each table so it automatically compacts files and removes stale files on a schedule.

D.

Set delta.autoOptimize.autoCompact and delta.autoOptimize.optimizeWrite table properties to trigger automatic VACUUM and file compaction.

Databricks-Certified-Data-Engineer-Associate PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Databricks-Certified-Data-Engineer-Associate pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"