You work for MDFT Pro, a well-known training agency with an Azure SQL database that contains a large table named StudentAssessments. Mark, the Storage Optimization Architect, needs to optimize storage costs while maintaining query performance. The StudentAssessments table uses partitioned columnstores to efficiently store millions of historical assessment records and quiz results. Mark has specific requirements: each partition must be compressed to reduce storage costs, the compression ratio must be maximized to achieve the greatest space savings possible, and the compressed data must remain fully indexable and queryable for reporting and analytics workloads. He has asked you to recommend the most appropriate compression method that meets all these requirements.
What should you use?
Choose the correct answer from the options below.
Explanations for each answer: