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. An architect is evaluating whether to use an External Object or replicate data into Salesforce custom objects. What is the PRIMARY advantage of External Objects?

    Answer: Data remains in the external system and is accessed in real time without storage costs

    External Objects use Salesforce Connect to access data in real time from external systems, eliminating the need to replicate data into Salesforce storage.

  2. What is the significance of 'selectivity' in SOQL query optimization?

    Answer: A selective query filters on indexed fields and returns less than 10% of total records, enabling index use

    A SOQL query is considered selective when it filters on indexed fields and the result set is small relative to total records, allowing Salesforce to use indexes instead of full table scans.

  3. A company wants to prevent duplicate Account records during both manual creation and API imports. Which combination of features should be implemented?

    Answer: Matching Rules and Duplicate Rules with block action

    Matching Rules define how duplicates are identified, while Duplicate Rules define the action (block, alert, or allow) and apply to both UI and API operations.

  4. What is the maximum number of Master-Detail relationships a single custom object can have?

    Answer: 2

    A custom object can have up to 2 Master-Detail relationships, which allows it to serve as a junction object in a many-to-many relationship.

  5. A batch Apex job processes 10 million records nightly. The job is timing out. Which architectural change best resolves this?

    Answer: Chain multiple batch jobs with reduced scope and use stateful processing

    Chaining smaller batch jobs with a stateful interface distributes processing across multiple transactions, preventing governor limit timeouts on large datasets.

  6. Which Salesforce feature enables an architect to query across a parent-child relationship in a single SOQL statement?

    Answer: Relationship query (nested SELECT)

    SOQL supports relationship queries that allow you to traverse parent-child relationships using nested SELECT statements in a single query.

  7. An external system needs to identify Salesforce records reliably after a data migration. What field type should be used as the integration key?

    Answer: External ID field with Unique and indexed settings

    External ID fields that are unique and indexed allow external systems to reference Salesforce records by their own system's identifier and enable efficient upsert operations.