SF-Data-Arch Practice Test 2 — 25 Questions

Question 1

Universal Containers uses Salesforce Sales Cloud as its CRM and a legacy AS/400 system for order fulfillment. Customer records exist in both systems but are keyed differently: Salesforce uses the Account ID (15-character), while the AS/400 uses a legacy customer number. The data architect must enable ongoing synchronization of customer master data between the two systems without creating duplicate records. Which approach should be used?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Create a custom external ID field on the Account object and populate it with the legacy customer number, then use that field as the matching key in the integration.. The cross-system key mapping problem is solved by storing the legacy identifier in a custom external ID field on the Salesforce Account. This field is indexed and can be used by the integration's upsert operation to match and update the correct record, preventing duplicates. It also preserves the legacy key in the source system, avoiding disruption to existing processes.

Answer

Enable Salesforce Duplicate Management with a matching rule on the Account Name and Billing Street fields, and rely on it to prevent duplicates during integration loads.

Answer

Use the Salesforce Account ID as the primary key in the AS/400 system and overwrite the legacy customer number with the 15-character Salesforce ID.

Answer

Configure a Salesforce-to-Salesforce (S2S) connection between the two systems and let Salesforce automatically reconcile customer records.

Question 2

A data architect is designing a master data management solution where customer records from Salesforce and a legacy system must be merged into a single golden record. The legacy system uses a customer ID that is a 10-digit number, while Salesforce uses a 15-character ID. The architect needs to create a unique cross-system identifier. Which approach best ensures uniqueness and traceability?

Accepted Answer

Use a composite key consisting of the source system code and the native ID, stored in an external ID field. A composite key of source system code and native ID provides a globally unique identifier that also indicates the record's origin. This is essential for master data management, as it allows the organization to trace data back to its source and perform accurate merges. It also supports upsert operations in Salesforce via an external ID field.

Answer

Use Salesforce's 15-character ID as the single identifier for all systems

Answer

Use the customer's email address as the unique identifier

Answer

Generate a random UUID for each customer and store it in a custom field

Question 3

A data architect is migrating 8 million Contact records from a legacy CRM into Salesforce Sales Cloud. The legacy system stores phone numbers as free-text strings in multiple formats (e.g., '(415) 555-1212', '415.555.1212', '4155551212'). After migration, users must be able to search for Contacts by phone number and have the numbers display consistently. Which approach should the architect use to ensure phone numbers are searchable and standardized?

Accepted Answer

Pre-process the legacy data in the ETL layer to normalize all phone numbers to a single format, then load them into the standard Phone field.. Normalizing phone numbers during the ETL process before loading them into the standard Phone field ensures that all values conform to one format. This makes the standard field's search indexing effective and provides consistent display without custom code. The other options either leave inconsistent data at rest or rely on features that do not automatically normalize free-text input.

Answer

Store the original free-text phone numbers in a Text field and create a formula field that formats the number for display.

Answer

Store phone numbers in the standard Phone field and rely on Salesforce's automatic normalization and search indexing.

Answer

Create a custom Text field with a validation rule that enforces a specific phone number format, and load the raw values.

Question 4

A financial services firm is migrating 10 million transaction records into a custom object Transaction__c. The legacy system uses a composite key of AccountNumber and TransactionDate to uniquely identify transactions. The target Salesforce org has a unique external ID field Transaction_Key__c. The architect needs to ensure that re-running the migration does not create duplicate records and that updates to existing transactions are applied. Which approach should be used?

Accepted Answer

Populate Transaction_Key__c with the concatenation of AccountNumber and TransactionDate, then use the Data Loader's Upsert operation with Transaction_Key__c as the external ID field.. Concatenating the composite key into the external ID field and using Upsert allows the migration to match existing records by that key. Upsert updates existing records and inserts new ones, preventing duplicates. This is the most efficient and standard method for handling composite keys in large migrations, as it leverages Salesforce's built-in matching and bulk processing capabilities without custom code.

Answer

Create a custom Apex trigger to check for existing transactions before insert and update them if found.

Answer

Use the Data Loader's Update operation with a SOQL query to fetch existing records and match them by AccountNumber and TransactionDate.

Answer

Use the Data Loader's Insert operation and rely on Salesforce's duplicate rules to prevent duplicates.

Question 5

What is the primary function of a skinny table in Salesforce?

Accepted Answer

To improve performance by avoiding table joins.. Skinny tables are used to optimize performance by flattening data from multiple related objects into a single table. This removes the need for joins when querying across related records, which significantly speeds up SOQL queries and reporting. They are a powerful tool for large-scale data environments where complex relationship traversal is the main bottleneck for query latency.

Answer

To provide more storage for large objects.

Answer

To automatically archive old records.

Answer

To encrypt data for security compliance.

Question 6

What is the primary architectural benefit of using 'External Objects' (Salesforce Connect) for large volumes of historical data?

Accepted Answer

To keep the local Salesforce database lean and performant.. External objects allow Salesforce to access data stored in an external system in real-time without importing it into the local database. This keeps the Salesforce storage usage low and avoids the performance impacts associated with hosting millions of records locally. It is an ideal solution for historical or secondary data that needs to be visible in the UI but does not require being in the same transactional database.

Answer

To speed up the performance of local object triggers.

Answer

To bypass the need for API callout security.

Answer

To allow for complex joins between local and external objects.

Question 7

Refer to the exhibit. An architect is reviewing a JSON configuration for a data load into a Big Object. Which statement correctly describes a requirement for successfully loading data into this specific object type?

Accepted Answer

All fields defined in the Big Object's index must be present in the CSV.. Big Objects are designed for massive data storage but have unique requirements compared to standard objects. When inserting data into a Big Object, the CSV file must include all fields that are defined in the Big Object's custom index. This index is required for querying and uniquely identifying records within the Big Object store.

Answer

The Bulk API 2.0 must be used as it is the only API supporting Big Objects.

Answer

Triggers on the Big Object will execute for each record inserted.

Answer

The operation must be set to 'upsert' to avoid duplicate index entries.

Question 8

Which of the following is the most important factor when choosing between the Bulk API 2.0 and the SOAP API for a large data migration?

Accepted Answer

The total number of records to be migrated.. The primary factor is the volume of data being moved. Bulk API 2.0 is designed specifically for large datasets (hundreds of thousands to millions of records) and operates asynchronously, reducing the likelihood of request timeouts. The SOAP API, while powerful for real-time transactional operations, is synchronous and poorly suited for large-scale data migrations due to its overhead and batch limitations.

Answer

The use of OAuth authentication protocols.

Answer

The requirement to process records synchronously.

Answer

The availability of a command-line interface.

Question 9

Which tool should an architect select to perform a one-time migration of complex, relational data while maintaining parent-child relationships?

Accepted Answer

Salesforce Data Loader.. Salesforce Data Loader is the standard tool for managing complex data migrations. Its ability to map CSV files to objects and maintain relationships via External IDs or record IDs makes it the primary choice for data architects. Using a mature, supported tool minimizes errors during migration and ensures that data integrity is preserved across relational structures, which is critical for successful implementation projects and long-term data reliability.

Answer

Data Import Wizard.

Answer

Salesforce Inspector Chrome extension.

Answer

Change Sets.

Question 10

Refer to the exhibit. What is the primary benefit of configuring a field with these settings for data integration?

Accepted Answer

It enables efficient Upsert operations.. The configuration allows the field to serve as a key for 'Upsert' operations. By marking the field as an External ID and unique, Salesforce can automatically match records from an external system to existing Salesforce records. This prevents duplicates and allows for automated, incremental data updates without needing to know the internal Salesforce record ID, which is critical for robust, scalable integration architectures.

Answer

It enables faster reporting on the Account object.

Answer

It allows for deduplication in the UI.

Answer

It increases the maximum number of records.

Question 11

A financial services firm needs to load 20 million records into an object with a complex sharing model involving many Sharing Rules and Role Hierarchy levels. To minimize the time taken for the data load and avoid performance degradation, which feature should the architect utilize?

Accepted Answer

Utilizing 'Deferred Sharing Maintenance' to pause sharing rule recalculations.. Loading massive datasets into objects with complex sharing logic triggers significant overhead as Salesforce recalculates sharing access for every record. Deferring sharing calculations allows the data load to proceed without immediate recalculation, which is then performed in a single, optimized background process once the load is complete, saving hours of processing time.

Answer

Granting 'Ignore Hierarchy' permissions to the integration user profile.

Answer

Utilizing the 'Granular Locking' feature to allow concurrent sharing updates.

Answer

Setting the Organization-Wide Defaults (OWD) to Public Read/Write for the load.

Question 12

Refer to the exhibit. An integration user is encountering record locking errors during high-volume data updates. What is the most effective technical solution to resolve this contention?

Accepted Answer

Group records by parent ID before processing to ensure serialization.. Record locking in Salesforce often occurs when multiple processes or threads attempt to update the same parent record or records with common children. To resolve this, the integration process should be serialized or partitioned to group related records together. By ensuring that transactions affecting the same parent record are processed sequentially in the same thread, the architecture prevents the 'Unable to lock row' errors, enhancing overall stability and throughput.

Answer

Increase the number of threads in the integration to process records faster.

Answer

Change the record ownership to a generic user account to avoid user locks.

Answer

Disable the 'User Audit' tracking on the affected object.

Question 13

Universal Containers requires a data model where a Child object must have exactly one Parent object that is mandatory. If the Parent is deleted, the Child must be deleted. Which relationship should the Architect select?

Accepted Answer

Master-Detail relationship. A Master-Detail relationship creates a tight coupling where the child's lifecycle is strictly governed by the parent. Deleting the parent automatically triggers a cascade delete of all associated children. This is essential for maintaining referential integrity in parent-child hierarchies where the child cannot exist in isolation, ensuring the database remains clean and logically consistent without requiring custom automation for cleanup tasks.

Answer

Lookup relationship

Answer

Self-relationship

Answer

External lookup relationship

Question 14

Which TWO strategies help manage row locking when inserting records into an object with multiple lookup relationships?

Accepted Answer

Sort the input data by the lookup field values.. High-volume loads often fail due to locking on parent records referenced by lookups. Sorting the input data by the lookup ID ensures that all children for a single parent are processed together, reducing the time a parent record remains locked. Additionally, avoiding unnecessary triggers on the parent object prevents downstream locking, significantly improving throughput for bulk data migrations.

Answer

Use the Bulk API 2.0 in serial mode.

Answer

Increase the batch size to 10,000.

Answer

Convert all lookups to master-detail.

Question 15

An architect is designing a schema to store product information. Each product has many versions, and each version has many components. What is the most efficient way to model this relationship?

Accepted Answer

Model as three separate objects with Master-Detail relationships.. Creating a hierarchical relationship using lookup or master-detail fields on 'Product', 'Version', and 'Component' objects is the most scalable way to represent this structure. By isolating each layer, the architect ensures that reporting, security, and maintenance are simplified. This hierarchical model is cleaner than attempting to flatten the data, as it preserves parent-child integrity at every level.

Answer

Flatten everything into one giant object with 100+ custom fields.

Answer

Use a JSON field to store the hierarchy as a string.

Answer

Create a separate object for every possible component.

Question 16

During a migration, you discover that the source system has a different date format than the required ISO 8601 format for Salesforce. What is the most efficient way to handle this?

Accepted Answer

Transform the data using an ETL tool or script before loading it into Salesforce.. Data transformation should ideally occur in the ETL (Extract, Transform, Load) layer before the data reaches Salesforce. By formatting dates during the extraction or transformation process, you ensure that the data conforms to Salesforce requirements before it hits the API. This is more scalable than attempting to force Salesforce to interpret varying formats, which can lead to data loss or import errors during the ingestion process.

Answer

Use an Apex trigger to format the dates after the records are inserted.

Answer

Update the Salesforce field type to 'Text' to accommodate any date format.

Answer

Manually update the records in the Salesforce UI after the migration completes.

Question 17

What is the main advantage of using an ETL tool rather than the standard Salesforce Data Loader for a large-scale enterprise migration?

Accepted Answer

It provides visual workflow orchestration and error handling.. Enterprise ETL tools provide advanced capabilities such as graphical orchestration, error logging, automated retry logic, and seamless connectivity to heterogeneous data sources. While Data Loader is sufficient for simple, smaller loads, ETL tools allow architects to manage complex migration workflows, parallel jobs, and sophisticated data transformations across multiple systems, which is required for large-scale enterprise integration projects.

Answer

It is always free to use.

Answer

It bypasses Salesforce security controls.

Answer

It allows direct database access to the Salesforce backend.

Question 18

An organization is establishing a Data Governance Council. Which THREE outcomes are primary goals of this council? (Choose Three)

Accepted Answer

Resolving data ownership and stewardship conflicts.. A Data Governance Council is a cross-functional body that aligns data strategy with business objectives. By resolving data ownership conflicts, setting enterprise-wide standards, and fostering communication between business units and IT, the council ensures that data is managed as a strategic asset. This alignment prevents silos, ensures accountability, and maximizes the value derived from data across the entire organization.

Answer

Managing daily Apex deployment cycles.

Answer

Directly configuring Salesforce security profiles.

Question 19

Why should an organization perform 'Data Cleansing' before migrating data into a master record system?

Accepted Answer

To remove inconsistencies and ensure data accuracy in the destination system.. Data cleansing identifies and fixes errors such as duplicates, invalid formats, and incomplete fields before they are propagated into a new system. If dirty data is ingested, it corrupts the new MDM environment, rendering reports unreliable and forcing developers to build complex, expensive workarounds. Cleaning first ensures the initial state of the master system is pristine, providing a reliable foundation for all future business operations and data-driven decisions.

Answer

To increase the total number of records in the Salesforce database.

Answer

To eliminate the need for any future data governance or stewardship.

Answer

To minimize the Salesforce storage cost by deleting all inactive customer accounts.

Question 20

Refer to the exhibit. As a Data Architect, what is the governance concern if this 'VAL-099' rule remains inactive in production?

Accepted Answer

Degradation of data quality over time.. The primary concern is the uncontrolled entry of corrupt data. If a governance rule is defined but not active, the system lacks the technical enforcement to maintain quality standards. This leads to 'data rot' where the system collects invalid entries, which will eventually break downstream integrations, analytics reporting, and business processes, causing significant effort for data cleansing at a later date.

Answer

Increased system storage limits.

Answer

Inability to run system reports.

Answer

Increased Apex trigger execution time.