A developer is optimizing a SOQL query that retrieves all Accounts with more than 100 Opportunities. The Account object has 500,000 records, and the query uses a subquery to count Opportunities. The query is slow. Which approach is most likely to improve performance?

Use a formula field on Account that counts Opportunities.

Add an index on the Opportunity's AccountId field.

Query all Opportunities and group them in Apex code.

Use a rollup summary field on Account that counts Opportunities and filter on that field.

A reporting team has a dashboard with a report that uses a custom formula field in a filter. The report is slow because the formula field is evaluated for every row. Which change is most likely to improve the report's performance?

Use a bucket field to group the formula results.

Add the formula field to a custom index.

Change the report type to a custom report type that excludes the formula field.

Replace the formula field with a workflow field that is populated at record creation.

A sales operations team reports that a dashboard with 12 components takes over 30 seconds to load. The dashboard includes several reports that filter on a custom checkbox field (Is_Priority__c) and a custom formula field that concatenates text. The underlying Opportunity records total 2 million. Which optimization will have the most direct impact on dashboard load time?

Create a custom report type that limits the report to only the necessary fields and rows.

Replace the formula field with a text field that is populated by a workflow rule.

Add the Is_Priority__c checkbox field to the list of indexed fields in the org.

Add a filter to each report that limits the data to the current fiscal year.

A company has a dashboard with a report that aggregates Opportunity data by Owner. The report is used by 500 sales managers and is refreshed every 15 minutes. The report is slow, and the company wants to reduce the load on the database. Which approach is most effective?

Use a summary formula to pre-aggregate the data in the report.

Create a custom object that stores pre-aggregated data and use it in the report.

Create a custom report type that limits the report to the current fiscal year.

Increase the dashboard refresh interval to 30 minutes.

SalesforceCertified Data Architect

Domain 9Objective 1

Compare and Contrast Various Techniques for Improving Performance When Migrating Large Data Volumes into Salesforce, Generating Reports and Dashboards, and Querying Large Data Sets in Salesforce. DATA-ARCHITECT Practice Questions (Page 2)

Part of the PERFORMANCE TUNING domain, which accounts for 10% of the DATA-ARCHITECT exam.

16questions here

4free pages

3concepts

10%of the exam

Questions 6–10

6application · medium
A developer is optimizing a SOQL query that retrieves all Accounts with more than 100 Opportunities. The Account object has 500,000 records, and the query uses a subquery to count Opportunities. The query is slow. Which approach is most likely to improve performance?
Select an answer first
7application · medium
A reporting team has a dashboard with a report that uses a custom formula field in a filter. The report is slow because the formula field is evaluated for every row. Which change is most likely to improve the report's performance?
Select an answer first
8foundation · easy
When using the Bulk API to migrate a large data volume, which parameter directly controls the number of records included in each batch sent to Salesforce?
Select an answer first
9application · medium
A sales operations team reports that a dashboard with 12 components takes over 30 seconds to load. The dashboard includes several reports that filter on a custom checkbox field (Is_Priority__c) and a custom formula field that concatenates text. The underlying Opportunity records total 2 million. Which optimization will have the most direct impact on dashboard load time?
Select an answer first
10expert · hard
A company has a dashboard with a report that aggregates Opportunity data by Owner. The report is used by 500 sales managers and is refreshed every 15 minutes. The report is slow, and the company wants to reduce the load on the database. Which approach is most effective?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ARCHITECT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “DATA-ARCHITECT” is a trademark of its owner, used for identification only.

Compare and Contrast Various Techniques for Improving Performance When Migrating Large Data Volumes into Salesforce, Generating Reports and Dashboards, and Querying Large Data Sets in Salesforce. DATA-ARCHITECT Practice Questions (Page 2)

Questions 6–10

A developer is optimizing a SOQL query that retrieves all Accounts with more than 100 Opportunities. The Account object has 500,000 records, and the query uses a subquery to count Opportunities. The query is slow. Which approach is most likely to improve performance?

A reporting team has a dashboard with a report that uses a custom formula field in a filter. The report is slow because the formula field is evaluated for every row. Which change is most likely to improve the report's performance?

When using the Bulk API to migrate a large data volume, which parameter directly controls the number of records included in each batch sent to Salesforce?

A company has a dashboard with a report that aggregates Opportunity data by Owner. The report is used by 500 sales managers and is refreshed every 15 minutes. The report is slow, and the company wants to reduce the load on the database. Which approach is most effective?

Keep studying — PERFORMANCE TUNING