Ultimate access to all questions.
In the context of managing a large-scale data pipeline that processes time-series data stored in a Delta table, you are tasked with optimizing both the performance of data queries and the efficiency of data management. The solution must adhere to cost constraints, ensure compliance with data retention policies, and support scalability as data volume grows. Considering these requirements, which of the following strategies is the BEST approach to efficiently manage and query this time-series data using Delta Lake's features? Choose the single best option.