SAA Data Architecture & Management 2 — Questions and Answers
Question 1: A company needs to store 500 million records in Salesforce. Which approach best addresses this volume concern?
- Enable skinny tables for all objects
- Implement a data archiving strategy using Big Objects (Correct answer)
- Increase storage by purchasing additional licenses
- Split data across multiple Salesforce orgs
Correct answer: Implement a data archiving strategy using Big Objects
Big Objects are designed to store and manage massive amounts of data natively in Salesforce, making them ideal for archiving historical records at scale.
Question 2: Which Salesforce feature allows you to define a custom index on fields that are not normally indexed to improve query performance?
- Custom compound index
- Custom index request via Salesforce Support (Correct answer)
- SOQL query hints
- Formula field indexing
Correct answer: Custom index request via Salesforce Support
Custom indexes on non-selective fields must be requested through Salesforce Support and are added by Salesforce engineers to improve query performance.
Question 3: An architect is designing a solution where data must be retrieved from Salesforce in real time by an external system. What is the most appropriate integration pattern?
- Batch data export using Data Loader
- Request-Reply using REST API (Correct answer)
- Outbound Messaging via SOAP
- Scheduled Apex jobs
Correct answer: Request-Reply using REST API
Request-Reply using REST API is the standard pattern for real-time synchronous data retrieval by external systems.
Question 4: What is the maximum number of records that a single SOQL query can return in Apex?
- 10,000
- 50,000 (Correct answer)
- 100,000
- 1,000,000
Correct answer: 50,000
A single SOQL query in Apex can return a maximum of 50,000 records; exceeding this limit throws a QueryException.
Question 5: A company wants to enforce that no two Account records can have the same combination of Name and BillingCity. Which approach accomplishes this?
- Before-insert trigger with SOQL duplicate check
- Duplicate Rules with a custom Matching Rule on Name + BillingCity (Correct answer)
- Validation rule using VLOOKUP
- Unique field constraint on a formula field
Correct answer: Duplicate Rules with a custom Matching Rule on Name + BillingCity
Duplicate Rules combined with custom Matching Rules allow you to define multi-field uniqueness criteria declaratively without code.
Question 6: Which Salesforce data storage category counts against the file storage limit rather than the data storage limit?
- Custom object records
- Attachments and Files (ContentDocument) (Correct answer)
- Task and Event records
- Big Object records
Correct answer: Attachments and Files (ContentDocument)
Attachments, Files (ContentDocument/ContentVersion), and related binary content consume file storage, not data storage.
Question 7: An org has a Master-Detail relationship where the parent has 50,000 child records. A roll-up summary field is performing slowly. What is the recommended solution?
- Convert to a Lookup relationship
- Request a skinny table on the child object (Correct answer)
- Implement a custom Apex roll-up using batch jobs
- Increase the relationship depth limit
Correct answer: Request a skinny table on the child object
Skinny tables created by Salesforce Support can dramatically speed up roll-up summary calculations on objects with large numbers of child records.
SAA Data Architecture & Management 2
A company needs to store 500 million records in Salesforce.
Which approach best addresses this volume concern?