SF-Data-Arch Practice Test 14 — 15 Questions

Question 1

A Data Architect is designing a high-volume data model where an Account has millions of Child records. Which TWO strategies should be implemented to ensure optimal performance and avoid data skew?

Accepted Answer

Ensure that the owner of the parent records is not a single user or small group.. Performance issues in Salesforce often arise from data skew, where a small number of parent records own a vast majority of child records. Implementing strategies like record ownership distribution and utilizing indexing on high-cardinality fields prevents row-level locking contention. These design patterns are critical for maintaining query performance and ensuring that API operations do not time out during large-scale data processing or complex analytical reporting cycles.

Answer

Convert all Lookup relationships to Master-Detail relationships to improve query speed.

Answer

Avoid using custom indexes on fields that have high cardinality.

Answer

Avoid creating parent-child relationships where the parent is a 'Person Account'.

Question 2

What is a 'Selective Query' in the context of Salesforce LDV?

Accepted Answer

A query that utilizes indexed fields to filter within defined thresholds.. A selective query is one that hits an index and returns a small, efficient subset of records. Salesforce imposes selectivity thresholds; if a query exceeds these (e.g., usually 30% of the first million records), it is considered non-selective. Ensuring queries are selective is the single most important factor in maintaining performance for large datasets, as it allows the database to avoid exhaustive scanning of rows.

Answer

A query that uses exactly five fields in the WHERE clause.

Answer

A query that returns fewer than 100 records total.

Answer

A query that uses only SOQL and no Apex logic.

Question 3

An organization wants to use 'Person Accounts' to manage B2C relationships. Which consideration is most important for a Data Architect when evaluating this change?

Accepted Answer

They fundamentally change the object model and are non-reversible.. Person Accounts merge the Account and Contact models into a single entity, which has long-term implications for the data schema. Once enabled, this change cannot be reversed, and it impacts existing integrations, custom code, and reporting. A Data Architect must ensure that all third-party systems are updated to handle the new object structure, as the standard Account-Contact hierarchy is fundamentally altered, potentially breaking legacy processes that expect distinct objects.

Answer

Person Accounts can be disabled by contacting Salesforce Support.

Answer

They replace the need for custom objects for B2C data.

Answer

They require a Business Account for every Person Account.

Question 4

Refer to the exhibit. A batch job is failing consistently with the provided error message. The job updates child records that have a Master-Detail relationship with a parent Account. What is the primary cause of this error?

Accepted Answer

Multiple concurrent threads are updating child records pointing to the same parent.. This error occurs due to row-level locking when multiple threads attempt to update records associated with the same parent simultaneously. In Salesforce, updating a child record in a Master-Detail relationship implicitly locks the parent record. When high-volume parallel batches attempt to update children of the same parent, they contend for this single lock, causing transaction failures. Architecturally, you must serialize these updates or reduce parallel threads to avoid collision.

Answer

The batch job is exceeding the heap size limit.

Answer

The sharing rules on the Account object are too complex.

Answer

The batch job is processing records in an incorrect order.

Question 5

A financial services firm is implementing Salesforce and must ensure PII data is managed according to strict regional privacy regulations. Which data governance framework component is most essential for tracking data lifecycle stages from collection to deletion?

Accepted Answer

Establishment of a Data Lifecycle Management policy.. A comprehensive Data Lifecycle Management (DLM) policy is critical for regulatory compliance. It provides the structured approach necessary to define how data is acquired, stored, processed, and eventually purged. By enforcing these stages, the organization ensures it does not retain PII longer than legally permitted, mitigating risk and satisfying audit requirements. This governance component is the foundation for operationalizing privacy by design within the Salesforce ecosystem.

Answer

Implementation of Einstein Data Insights for automated trend analysis.

Answer

Data Stewardship assignment to the IT department only.

Answer

Deployment of a Data Warehouse for all Salesforce logs.

Question 6

Which object must be loaded first in a standard Salesforce migration involving Accounts, Contacts, and Opportunities?

Accepted Answer

Accounts, to establish the parent records for children.. Accounts must be loaded first because they are the parent objects for both Contacts and Opportunities in the standard data model. Without the Account records present, the foreign key lookups for Contacts and Opportunities will fail, as they have no valid parent ID to link to. Establishing the hierarchy is the fundamental requirement for data referential integrity.

Answer

Opportunities, because they drive revenue reporting.

Answer

Contacts, to ensure the primary contact is defined.

Answer

It does not matter if you use the Bulk API.

Question 7

Refer to the exhibit. Why might 'Parallel' concurrency mode cause errors during a large migration?

Accepted Answer

It leads to record locking contention on parent objects.. Refer to the exhibit. The JSON configuration shows a Bulk API 2.0 job using 'Parallel' concurrency mode. The Data Architect must be aware that parallel processing increases the risk of record locking when parent records have many children being processed simultaneously. This configuration requires careful monitoring of record contention to prevent failures, even though it provides the fastest throughput for independent records.

Answer

It causes the API to exceed the daily limit for API calls.

Answer

It prevents the data from being loaded in a specific order.

Answer

It forces the data to be processed in a single thread.

Question 8

A large enterprise is struggling with inconsistent data quality across multiple business units. They want to establish a Data Governance Council. Who should lead this council to ensure the initiative receives adequate executive sponsorship and alignment with corporate strategy?

Accepted Answer

The Chief Data Officer or a senior business executive.. Executive sponsorship is the single most important factor for the success of a Data Governance initiative. By appointing a Chief Data Officer or a senior business leader, the organization signals that data is a strategic asset rather than just an IT concern. This alignment ensures that funding, resources, and cross-departmental cooperation are prioritized, effectively breaking down silos that often impede data quality projects.

Answer

The Lead Salesforce Administrator.

Answer

The Vice President of IT Infrastructure.

Answer

The external Salesforce Implementation Partner.

Question 9

During a large data migration, a developer notices that existing Apex triggers are causing severe performance degradation. What is the most effective way to prevent trigger execution without deleting the code?

Accepted Answer

Use a Custom Setting to control trigger execution.. The most effective method to mitigate trigger-related performance issues during high-volume loads is to implement a 'Bypass' or 'Switch' pattern using Custom Settings or Custom Metadata. By checking this flag at the start of the trigger, logic can be conditionally skipped. This preserves code integrity while allowing the migration to proceed at maximum speed without the overhead of complex validation or automated process logic.

Answer

Comment out the trigger logic and redeploy the code.

Answer

Disable the triggers in the Setup menu under 'Manage Triggers'.

Answer

Remove user permissions for the integration user.

Question 10

Refer to the exhibit. An organization uses the provided JSON policy to manage PII fields. As a Data Architect, what is the primary governance risk if this policy is not integrated with Salesforce's internal security controls?

Accepted Answer

Inconsistent enforcement of privacy compliance.. The primary risk is the discrepancy between the documented policy and the actual system implementation. If the JSON policy dictates partial masking but the Salesforce configuration allows full view access via profiles or permission sets, the policy becomes ineffective. This gap compromises compliance, as the organization cannot guarantee that data protection rules are actually enforced at the application layer where users interact.

Answer

Increased latency in database query execution.

Answer

Loss of data due to automated purging.

Answer

Increased storage consumption in the Org.

Question 11

A company is defining its Data Stewardship model. Which THREE responsibilities are typically assigned to a Data Steward within a Salesforce-centric data governance framework? (Choose three.)

Accepted Answer

Managing daily data quality issues and resolving duplicates.. Data Stewards act as the bridge between technical implementation and business utility. Their roles involve maintaining data accuracy, defining standards, and acting as the subject matter experts for specific data domains. By focusing on these areas, they ensure that the data stored in Salesforce remains reliable, compliant, and useful for stakeholders. These actions prevent the degradation of data quality over time and support ongoing compliance with organizational data policies.

Answer

Configuring Salesforce Org-wide defaults and sharing rules.

Answer

Writing APEX triggers to automate data cleanup.

Question 12

A Data Architect is tasked with cleaning up duplicate records in a large Salesforce organization. The duplicates have been identified across multiple objects. What is the most effective approach to maintain data integrity during this process?

Accepted Answer

Merge duplicate records using the native Salesforce Merge feature.. Using Duplicate Management rules alongside the Data Import Wizard or API-based deletion is the standard approach. By identifying duplicates through native features and merging them, the architect preserves related records (like child objects) that would otherwise be deleted during a manual record deletion. This ensures that the parent-child relationships remain intact, preventing data orphans and maintaining the overall integrity of the relational database structure.

Answer

Use Data Loader to export all records, delete them from Salesforce, and re-import unique records.

Answer

Delete records using a hard-delete command to ensure they are permanently removed.

Answer

Update the records to a dummy state and hide them from all user profiles.

Question 13

Refer to the exhibit. During a high-volume migration, the team encounters the provided error frequently. What is the most likely cause?

Accepted Answer

Multiple threads are updating child records that share the same parent account.. The 'UNABLE_TO_LOCK_ROW' error indicates that multiple threads or processes are attempting to update the same record or its parent records simultaneously. In data migration, this usually happens when records sharing the same parent are processed in parallel. By reordering the data or reducing the concurrency in the bulk load, architects can prevent these deadlocks and ensure successful completion without constant retries or system instability.

Answer

The batch size is too small, causing excessive commits to the database.

Answer

The API user does not have sufficient permissions to modify the account records.

Answer

The Salesforce database is experiencing a scheduled maintenance window.

Question 14

A company needs to migrate data into a custom object while maintaining the original CreatedDate from a legacy system. Which of the following is required?

Accepted Answer

Enable 'Set Audit Fields upon Record Creation' permission.. Maintaining the original CreatedDate requires the 'Set Audit Fields upon Record Creation' user permission. Without this, Salesforce ignores the provided CreatedDate and assigns the current server time upon insertion. This permission is a highly sensitive setting and must be enabled specifically for the integration user through the user record or the appropriate permission set, ensuring audit traceability for historical records.

Answer

A custom Apex trigger to overwrite the CreatedDate field.

Answer

Use the Salesforce Import Wizard with mapped headers.

Answer

Create a formula field to store the legacy date.

Question 15

Which THREE factors are essential to consider when performing a multi-org data migration consolidation?

Accepted Answer

Handling duplicate record IDs across source orgs.. Consolidating multiple Salesforce orgs requires meticulous planning around unique ID collisions, metadata differences (such as custom field mapping), and security model alignment. Since each org has its own unique record IDs and potentially overlapping data, an intermediary mapping strategy is vital to ensure that relationships are preserved correctly in the new, unified environment without creating duplicate records or data conflicts.

Answer

Enabling the 'Set Audit Fields' for every user.

Answer

Using only the standard Import Wizard for migrations.