Snowflake
COF-R02 · Question #214
COF-R02 Question #214: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #214. The question stem and answer options stay visible for context.
Question
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Options
- AThe explain plan output is available graphically.
- BAn explain plan can be used to conduct performance analysis without executing a query.
- CAn explain plan will handle queries with temporary tables and the query profiler will not.
- DAn explain plan's output will display automatic data skew optimization information.
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.