In the context of real-time data ingestion into a lakehouse from multiple sources where conflicts are likely, which technique ensures data accuracy and consistency without significantly degrading performance?

Real Exam

Stage incoming data in a raw format, employing periodic batch reconciliation jobs to resolve conflicts and merge data.

15.9%

Utilize streaming stateful operations to detect and resolve conflicts based on predefined business rules.

21.2%

Apply a last-write-wins policy, using event timestamps to resolve conflicts during ingestion.

52.2%

Implement a two-phase commit protocol across the ingestion pipeline to ensure atomicity and consistency of writes.

10.6%

Databricks Certified Data Engineer - Professional