Which data set creation strategy should a Consultant recommend?

A regional sales director wants to import all accounts in a region into a single view within Territory Planning. There are over 350,000 accounts that make up the territories in this region.

Which data set creation strategy should a Consultant recommend?
A . Split the accounts across multiple data sets.
B . Use multiple SOQL queries.
C . Use a single SOQL query and aggregate to the container level.
D . Use multiple Salesforce reports.

View Answer

Answer: C

Explanation:

According to the Trailhead module 2, this is the best strategy for creating a data set with a large number of accounts. A single SOQL query can retrieve up to 500,000 records, and aggregating to the container level can reduce the number of units in the data set. This can improve the performance and efficiency of Territory Planning.