Video upload date:  · Duration: PT1H46M27S  · Language: EN

A financial firm's Amazon Redshift cluster manages aws video

data-engineer video for a financial firm's Amazon Redshift cluster manages a table named FinancialRecords, which undergoes frequent data updates and deletions.

This is a dedicated watch page for a single video.

Full Certification Question

A financial firm's Amazon Redshift cluster manages a table named FinancialRecords, which undergoes frequent data updates and deletions. The table uses an interleaved sort key based on transaction types. Concerned about the growing disk space usage and diminishing query performance, the firm seeks to optimize the table's storage efficiency and maintain the sort key's effectiveness. Which Amazon Redshift command should a data engineer use to address these issues?