<< Prev Question

Question 78/78

UC developers have created a new lightning component that uses 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 time-out error.
What tool should a data architect use to identify why the query is taking too long?

A. Enable and use the query plan tool in the developer console.

B. Use Splunk to query the system logs looking for transaction time and CPU usage.

C. Use salesforce's query optimizer to analyze the query in the developer console.

D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Recent Comments (The most recent comments are at the top.)

Kishore - Jan 12, 2024

A is the correct answer, you cannot use query optimizer as it is used internally by salesforce, anytime you run a query. Query plan tool allows you to run in dev console and anytime the cost is more than 1, it can cause time out issues.

Alec - Oct 25, 2023

C: this is correct. Query optimizer helps to analyze and identify why the query is taking too long.
A: this option would help to build a better query.

Reference: https://trailhead.salesforce.com/content/learn/modules/database_basics_dotnet/writing_efficient_queries

Alec - Oct 25, 2023

'C': is correct. Optimizer helps you to analyze and identify why is the query taking too long.
'A': would help to build a better query.

Question 78/78

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File