Question 200
A data architect recommends this approach: Have a database administrator investigate SQL performance and indexing. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Query tuning. The operational database can be tuned against its access patterns.
Incorrect Answers
The other situation is better matched to Assign ingestion and transformation pipeline development to a data engineer. Reusable data processing workflows populate the analytical platform.
The other situation is better matched to Have a data analyst work with stakeholders to define the business measure consistently. Reports share a documented metric interpretation rather than conflicting figures.
The other situation is better matched to Have the data analyst explore trends and present findings with appropriate visuals. Patterns in curated data are translated into actionable business context.