⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

1 day, 9 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

A sales dashboard runs the same SQL statement dozens of times every minute, only changing the value in the WHERE clause:

SELECT order_id, total_amount
FROM fact_sales
WHERE salesperson_id = 1043;

Performance counters show a spike in SQL Compilations/sec and CPU time consumed by query compilation. Without altering the business logic or adding new indexes, which change would most directly cut the compilation overhead and improve reuse of the execution plan?

  • Increase the server's cost threshold for parallelism to allow more parallel workers.

  • Create a nonclustered index on the total_amount column to speed up look-ups.

  • Convert the statement to a prepared, parameterized query and pass the salesperson ID as a bound parameter.

  • Add the query hint OPTION (RECOMPILE) so that the optimizer builds a fresh plan each time.

CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot