Practice Test Geeks(SAA) Salesforce Application Architect Certification Practice Test
← All SAA Flashcard Decks

Data Architecture & Management Flashcards

7 cards from real SAA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Architecture & Management flashcards as text

  1. A company needs to store 500 million records in Salesforce. Which approach best addresses this volume concern?

    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.

  2. Which Salesforce feature allows you to define a custom index on fields that are not normally indexed to improve query performance?

    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.

  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?

    Answer: Request-Reply using REST API

    Request-Reply using REST API is the standard pattern for real-time synchronous data retrieval by external systems.

  4. What is the maximum number of records that a single SOQL query can return in Apex?

    Answer: 50,000

    A single SOQL query in Apex can return a maximum of 50,000 records; exceeding this limit throws a QueryException.

  5. A company wants to enforce that no two Account records can have the same combination of Name and BillingCity. Which approach accomplishes this?

    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.

  6. Which Salesforce data storage category counts against the file storage limit rather than the data storage limit?

    Answer: Attachments and Files (ContentDocument)

    Attachments, Files (ContentDocument/ContentVersion), and related binary content consume file storage, not data storage.

  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?

    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.