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's Salesforce org is experiencing slow page loads on the Account object with 10 million records. Which strategy most directly improves query performance without reducing record count?

    Answer: Create skinny tables on the Account object via Salesforce Support

    Skinny tables contain a subset of fields and exclude soft-deleted records, enabling faster queries on large objects like Account.

  2. Which of the following is NOT a valid Salesforce data migration strategy?

    Answer: Use SOQL queries to push data from source org to target org directly

    SOQL is a query language for reading data within Salesforce and cannot directly push data to another org; data migration requires extract, transform, and load tools.

  3. A Salesforce architect needs to retain 10 years of transaction history for compliance without impacting org performance. What is the best solution?

    Answer: Use Big Objects to store historical transaction data

    Big Objects provide a scalable way to store billions of compliance records natively in Salesforce without affecting performance of standard objects.

  4. What happens when a record lock conflict occurs during a Salesforce DML operation in Apex?

    Answer: A DmlException is thrown immediately

    When a record lock cannot be obtained, Salesforce throws a DmlException with the UNABLE_TO_LOCK_ROW error, and the entire transaction must handle the exception.

  5. Which field type in Salesforce is automatically indexed by the platform?

    Answer: External ID fields

    External ID fields are automatically indexed by Salesforce, which is why they are commonly used as upsert keys and in WHERE clause filters for performance.

  6. A company needs real-time data synchronization between Salesforce and an external ERP system. Both systems can initiate changes. Which integration pattern handles this best?

    Answer: Publish-Subscribe using Platform Events in both directions

    Platform Events support bidirectional, real-time event-driven integration, allowing both Salesforce and the ERP to publish and subscribe to changes.

  7. Which of the following is a key consideration when designing a data model with many-to-many relationships in Salesforce?

    Answer: Create a junction object with Master-Detail relationships to both parent objects

    A junction object with two Master-Detail relationships to the parent objects is the standard Salesforce pattern for implementing many-to-many relationships.