Free CTA-Exam sample questions

Correct answer: Adopt a Multi-Org strategy with a Master Data Management (MDM) system as the source of truth for Customer data, using Salesforce Connect (OData) to virtualize aggregated customer views in the Support org.

Given the distinct processes and IT leadership, a Multi-Org strategy is appropriate to maintain autonomy. However, replicating data (Salesforce-to-Salesforce) creates complexity and storage issues. The optimal solution uses an MDM for the 'Golden Record' and Salesforce Connect to virtualize the data for the global support team, ensuring a single view without physical data replication constraints.

Correct answer: Fire and Forget pattern using Workflow Rules with Outbound Messaging.

Since the ERP supports SOAP but cannot make outbound calls (polling) or handle REST, Outbound Messaging is the standard, declarative 'Fire and Forget' solution. It sends a SOAP message to a designated endpoint when criteria are met, handling retries automatically.

Correct answers: Encrypted fields cannot be used in criteria-based sharing rules.; Existing Apex classes using aggregate queries (GROUP BY, ORDER BY) on encrypted fields will fail.

Shield Platform Encryption limits the usage of encrypted fields in filtering and sorting functions. Specifically, encrypted fields cannot be used in criteria-based sharing rules, which can severely impact the security model if those fields define visibility.

Deterministic encryption supports some filtering, but standard Probabilistic encryption (default for high security) prevents sorting (ORDER BY) and grouping (GROUP BY) in SOQL queries, potentially breaking existing business logic.

Correct answer: Ownership Skew

Ownership Skew occurs when a single user owns a massive number of records (typically >10,000). This causes performance issues during sharing recalculations because moving that user in the role hierarchy or changing sharing rules requires recalculating access for all 5 million records.

Correct answer: JWT Bearer Token Flow

The JWT (JSON Web Token) Bearer Token Flow is ideal for server-to-server integration. It uses a certificate to sign the request, allowing the integration to authenticate securely without interactive user login or managing passwords, making it robust for automated background processes.

Correct answer: The Query Optimizer determined that the filter for 'Status' returns more than 10% of the total records, making the index ineffective.

Salesforce Query Optimizer considers an index 'selective' only if the filter targets less than 10% of the total records (for standard indexes) or 333,333 records. If the 'Status' filter returns a large portion of the 10 million records, the optimizer will perform a full table scan instead of using the index.