Which Snowflake component creates and maintains the search access path in the background?

• A. Maintenance service.
• B. Query planner.
• C. Data loader.
• D. User.

Answer: (A)

The key idea here is which background component in Snowflake handles building and keeping the search access path up to date. Snowflake runs automated maintenance tasks behind the scenes, and the maintenance service is responsible for creating and maintaining structures that speed data access, such as the search access path. The query planner is the part that decides how to execute a given query, using statistics and metadata, but it doesn’t create or maintain persistent access paths. The data loader simply ingests data, and the user is the entity issuing queries rather than a system component. So, the maintenance service is the component that creates and maintains the search access path in the background.