Given a Scenario, Describe the Platform Architecture Considerations, Platform Impact and Optimization Methods Used When Working with Large Data Volumes. TECHNICAL-ARCHITECT Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A manufacturing company has a custom object 'Part__c' with 20 million records. A nightly integration job runs a SOQL query that filters on a custom field 'Part_Number__c' and takes over 30 minutes to complete. The architect suspects the query is non-selective. Which tool should the architect use to confirm this and identify the exact query plan?

   • AUse the debug logs to review the query's SOQL statements and their execution times.
   • BUse the Query Plan tool in the Developer Console to analyze the query's selectivity and index usage.
   • CUse Event Monitoring to track the query's execution time and resource consumption.
   • DUse the Salesforce Optimizer to analyze the query and recommend index creation.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which of the following is a recommended technique to avoid full table scans in SOQL queries?

   • AUsing a selective filter on an indexed field
   • BUsing a wildcard at the beginning of a LIKE pattern
   • CUsing the NOT IN operator with a subquery
   • DUsing a negative filter like 'NOT EQUALS'
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is data denormalization in the context of Salesforce data modeling?

   • AStoring redundant data to improve query performance
   • BSplitting data into multiple objects to reduce record size
   • CCreating indexes on all fields
   • DRemoving redundant data to reduce storage
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A logistics company has a custom object 'Shipment_Event__c' that stores tracking events for shipments. The object has over 1 billion records and is growing by 10 million records per day. Users need to query recent events (last 30 days) for a specific shipment, but queries are slow and storage costs are high. The architect needs to balance performance, cost, and data retention. What is the best architectural pattern?

   • AUse a BigObject to store all shipment events, including recent ones, and query them directly.
   • BArchive events older than 30 days to an external data store and keep only recent events in Salesforce.
   • CUse a custom index on the Shipment__c field to speed up the recent events query.
   • DCreate a skinny table that includes only the fields needed for the recent events query.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company has a custom object 'Order__c' with 50 million records. A synchronous Apex trigger on the Order object performs a query that returns all related Order_Item__c records for the order. The trigger fails with a 'System.LimitException: Too many SOQL queries: 101' error. The architect has already optimized the query to be selective. What is the most likely cause of the error?

   • AThe trigger is running in a loop, causing multiple SOQL queries per record.
   • BThe trigger is using a Queueable Apex job, which has a lower SOQL query limit.
   • CThe trigger is using a non-selective query, causing a full table scan.
   • DThe query is returning too many records, causing the heap size limit to be exceeded.
   Reveal Solution Discussion Select an answer first