COF-C02 · Question #37
COF-C02 Question #37: Real Exam Question with Answer & Explanation
The correct answer is A: Bytes scanned. In the query profiler view, the components that represent areas that can be used to help optimize query performance include 'Bytes scanned' and 'Number of partitions scanned'. 'Bytes scanned' indicates the total amount of data the query had to read and is a direct indicator of th
Question
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
Options
- ABytes scanned
- BBytes sent over the network
- CNumber of partitions scanned
- DPercentage scanned from cache
- EExternal bytes scanned
Explanation
In the query profiler view, the components that represent areas that can be used to help optimize query performance include 'Bytes scanned' and 'Number of partitions scanned'. 'Bytes scanned' indicates the total amount of data the query had to read and is a direct indicator of the query's efficiency. Reducing the bytes scanned can lead to lower data transfer costs and faster query execution. 'Number of partitions scanned' reflects how well the data is clustered; fewer partitions scanned typically means better performance because the system can skip irrelevant data more
Topics
Community Discussion
No community discussion yet for this question.