DAA-C01 Question #34: Real Exam Question with Answer & Explanation

Question

What attributes of the Query Profile are typically assessed to understand query performance in Snowflake?

Options

• AQuery history and user access logs
• BExecution time and query complexity
• CNumber of user sessions and database objects accessed
• DHardware configuration and system resources

Explanation

Execution time and query complexity (B) are the core attributes assessed in Snowflake's Query Profile because it is a diagnostic tool designed to break down how a query executes - showing operator trees, time spent per node, bytes scanned, partitions pruned, and spillage to disk, all of which directly reveal performance bottlenecks.

• A is wrong because query history and user access logs live in QUERY_HISTORY and Access History views, not the Query Profile itself - those are audit/governance tools, not performance diagnostics.
• C is wrong because session counts and database object inventory are metadata-level concerns tracked elsewhere (e.g., SESSIONS view, Information Schema), unrelated to how a specific query runs.
• D is wrong because Snowflake is a fully managed cloud service - users have no visibility into or control over underlying hardware; the Query Profile abstracts all of that away.

Memory tip: Think of Query Profile as an X-ray for a single query - it shows how long each step took (execution time) and how hard the work was (complexity like joins, aggregations, partitions scanned). If it doesn't describe "what happened inside this query," it doesn't belong in the Query Profile.

No community discussion yet for this question.