Salesforce Certified Data Architect — Question 48

Universal Containers developers have created a new Lightning component that leverages an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a timeout error.
What tool should a data architect use to identify why the query is taking too long?

Answer options

• A. Use Salesforce's query optimizer to analyze the query in the developer console.
• B. Use Splunk to query the system logs looking for transaction time and CPU usage.
• C. Enable and use the Query Plan tool in the developer console.
• D. Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time.

Correct answer: C

Explanation

The Query Plan tool in the developer console provides insights into the execution plan of the SOQL query, helping to identify performance bottlenecks. While the query optimizer (A) is useful, the Query Plan tool specifically addresses query performance in detail. Splunk (B) is more suited for broader system monitoring rather than specific query analysis, and opening a support ticket (D) may delay resolution without providing immediate insights.