Which statement is true about scaling a data warehouse on demand?

The statement that both resizing occurs instantly and is fully online, as well as the ability to independently scale compute or storage resources, accurately reflects the capabilities of modern data warehouse systems. Cloud-based data warehouses are designed to provide on-demand scalability, allowing organizations to adjust their resources dynamically based on their workload requirements.

When resizing occurs instantly and is fully online, it means that users can increase or decrease their resource allocation without significant downtime or interruption to ongoing processes. This is crucial for maintaining operational efficiency and ensuring that users can access data as needed without delays.

Additionally, the ability to scale compute independently from storage (or vice versa) allows organizations to optimize performance and cost. For example, if a workload suddenly requires more computational power for data analysis, users can increase compute resources without needing to scale storage resources simultaneously. This flexibility is a significant advantage in resource management, allowing businesses to tailor their data infrastructure according to specific use cases and operational needs.

In contrast, limiting scaling to predefined options restricts the ability to adapt to changing demands efficiently. Thus, both capabilities highlight the modern approach to data warehouse scalability that supports agile data management practices.