Question 260
An analytics engineering team reports this behavior: An inactive database's billed storage increases even though no warehouse currently queries it. Which remediation resolves this specific issue most directly?
Explanation
Correct Answer
The root issue is that stored data and retained historical versions incur storage costs independent of active compute. The selected fix targets that condition: Inspect storage usage and retention history before reducing warehouse size. Validate it by checking this outcome: The storage report explains active and retained bytes and identifies safe cleanup candidates.
Incorrect Answers
This action targets role based access grant, where the active role does not have the required database and table privileges. In the given incident, the decisive issue is instead that stored data and retained historical versions incur storage costs independent of active compute.
This action targets warehouse resource monitor thresholds, where the warehouse has no suitably configured resource monitor notification and action thresholds. The corrective response here is “Inspect storage usage and retention history before reducing warehouse size”; this alternative does not provide that response.
This action targets query attribution by user, where aggregate warehouse charges do not identify the specific expensive queries and users. The stem reports an inactive database's billed storage increases even though no warehouse currently queries it; this control addresses a different failure condition.