Answer: Materialized view

Materialized views (option D) consume credits during automatic background maintenance because they store pre-computed query results and require periodic refreshing to keep the data current, which involves compute resources that incur credit costs. In contrast, regular views (A) are just saved queries that execute on-demand without background maintenance, tables (B) store data but don't require automatic background processing, and external tables (C) reference data stored externally without Snowflake managing the underlying storage or requiring automatic maintenance.

Author: LeetQuiz Editorial Team