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 1)

Questions 1–5

1. 1foundation · easy

   Which Salesforce feature stores a pre-joined subset of fields from an object to improve query performance on large data sets?

   • ABig object
   • BCustom index
   • CExternal object
   • DSkinny table
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A developer is optimizing a SOQL query that retrieves all Opportunities where the StageName is 'Closed Won' and the CloseDate is in the current year. The Opportunity object has 5 million records. The query is slow. Which change is most likely to improve performance?

   • AUse the 'IN' clause with a list of stage names instead of '='.
   • BUse a skinny table that includes StageName and CloseDate.
   • CAdd an index on the StageName field.
   • DAdd an index on the CloseDate field.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A data architect is planning to migrate 5 million records into Salesforce. Which tool is specifically designed to handle large data volumes efficiently by processing records in batches asynchronously?

   • ABulk API
   • BData Import Wizard
   • CWorkbench
   • DData Loader with default settings
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A sales director needs a dashboard that shows monthly revenue by region for the last 12 months. The underlying Opportunity object has 8 million records. The dashboard currently uses a report that summarizes all Opportunities without a date filter. The report takes 45 seconds to run. Which change will most effectively reduce the report runtime?

   • AUse a bucket field to group the Amount field into ranges.
   • BChange the report format from Tabular to Summary.
   • CAdd a filter on the Close Date field to limit the report to the last 12 months.
   • DAdd a custom index on the Amount field.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A data architect is migrating 2 million custom object records. The target org has a single Apex trigger on the custom object that performs a callout to an external system for each record. The migration is slow because the callouts are sequential. Which technique should the architect use to improve migration performance?

   • ADisable the trigger during the migration and run a post-migration batch to perform the callouts.
   • BUse the SOAP API instead of the Bulk API to avoid trigger execution.
   • CUse the Bulk API with the 'Serial' mode to ensure callouts are processed in order.
   • DIncrease the batch size to 10,000 records to reduce the number of trigger invocations.
   Reveal Solution Discussion Select an answer first