🔥 3-day streak
AWS Certified Data Engineer - Associate134 / 159
Question 134 of 159
A data engineering team runs an Amazon Redshift cluster that stores a large fact table. Each night an ETL job deletes several million expired rows and inserts new rows. Over the past few weeks, analysts report that queries against this table have become progressively slower, and storage usage keeps growing even though the total row count is stable. The team confirms the sort keys and distribution keys are already well designed. What is the MOST likely cause and appropriate remediation?
Reviewed for accuracy · Report an issueNext question