
Ultimate access to all questions.
In a scenario where you are working with a large Delta Lake table that is frequently queried for analytics, you notice that query performance is not meeting the expected benchmarks. After analyzing the situation, you consider implementing Z-Ordering to optimize the data layout. Given the constraints of minimizing storage costs while maximizing query performance, and the requirement to comply with data governance policies, which of the following best describes the role of Z-Ordering and its impact on the query execution process? Choose the best option from the four provided.
A
Z-Ordering is a method of sorting data that improves query performance by reducing the number of files that need to be scanned, without increasing storage costs.
B
Z-Ordering is a technique used to compress data files, resulting in smaller file sizes and faster query performance, but it may increase CPU usage during queries.
C
Z-Ordering is a method of partitioning data that allows for parallel processing of queries, improving overall query performance, but it requires additional storage space.
D
Z-Ordering is a feature that enables real-time data processing and streaming, allowing for faster query results, but it is not suitable for batch processing scenarios.