Integrating and managing application data →hardMultiple ChoiceObjective-mapped

SNOW-CAD Integrating and managing application data Practice Question

A customer reports that a scheduled data synchronization job takes longer than expected. The job queries the 'cmdb_ci' table and updates records based on an external source. The DBA suggests adding an index on the 'source' field. After adding the index, performance does not improve. What is the most likely reason?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The job uses a condition that filters on a different field.

Indexes only improve performance when the query condition uses the indexed field. If the job filters on a different field, the index on 'source' will not be used.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The index was not created correctly.
Why it's wrong here
Even if created correctly, it won't help if not used in the query.
✗
The job runs during peak hours.
Why it's wrong here
Peak hours affect overall performance, but the index should still improve the query if used.
✓
The job uses a condition that filters on a different field.
Why this is correct
Correct: The index on 'source' is not utilized if the query filters on another field.
✗
The database is replicated to a secondary site.
Why it's wrong here
Replication does not prevent index usage.

Go deeper

SNOW-CAD Integrating and managing application data Practice Question

Why each option matters

Option-by-option breakdown

Related to this question