SF-Data-Arch Practice Test 17 — 15 Questions

Question 1

During a migration, you encounter an error stating that the record exceeds the maximum character limit for a field. What is the most robust way to handle this?

Accepted Answer

Evaluate the data and request business approval for truncation or re-mapping.. Truncating data without business approval is a data integrity risk. The architect should analyze the source data to determine why it exceeds the limit and work with stakeholders to either shorten the source text, map it to a larger field, or confirm if truncation is acceptable. Simply truncating in the ETL layer may result in the loss of critical information, which can lead to compliance or business issues down the line.

Answer

Automatically truncate the text in the ETL process to fit the limit.

Answer

Increase the Salesforce field length to the maximum possible.

Answer

Skip the records that exceed the character limit.

Question 2

A Data Architect is designing a strategy to manage 'soft-deleted' data in a Salesforce instance. The requirement is to maintain data for seven years, but only show active records in standard views. What is the most recommended approach?

Accepted Answer

Use an 'Active' checkbox and filtered list views to hide inactive records.. Using a combination of a status field and optimized list views/reports provides a flexible, low-impact solution. By setting an 'IsActive' flag, data remains available for historical reporting and audits without cluttering the UI for operational users. This pattern is easily scalable and avoids the complexities of moving data to external systems or utilizing custom objects, while adhering to organizational data retention policies without compromising standard Salesforce object relationships.

Answer

Use the 'Archive' custom object to store all inactive records.

Answer

Create a daily batch job that deletes records older than one year.

Answer

Change the sharing settings to 'Private' for all inactive records.

Question 3

Universal Containers wants to track complex relationships between Accounts where one Account can be a subsidiary of many others, and an Account can have many parent companies. Which modeling approach should the Architect recommend?

Accepted Answer

Implement a custom junction object with two lookup fields to the Account object.. Many-to-many relationships are best handled using a junction object in Salesforce. By creating a custom object, you can link two Account records while storing additional metadata like the nature or duration of the relationship. This approach overcomes the limitations of standard lookup fields, which only support one-to-many structures, ensuring data integrity and allowing for robust reporting across complex corporate hierarchies.

Answer

Add multiple self-lookup fields on the Account object.

Answer

Create a Text field to store a comma-separated list of parent IDs.

Answer

Use a master-detail relationship between the Account and a custom object.

Question 4

Which security feature should an architect use to restrict access to sensitive fields based on a user's role?

Accepted Answer

Field-Level Security (FLS).. Field-Level Security (FLS) is the correct mechanism for controlling field access by profile or permission set. It ensures that users only see and interact with data relevant to their role. By applying FLS, architects can enforce strict data access policies, which is essential for compliance and maintaining the 'need-to-know' principle in complex, multi-departmental Salesforce environments where data privacy is paramount.

Answer

Organization-Wide Defaults (OWD).

Answer

Sharing Rules.

Answer

Role Hierarchy.

Question 5

An organization wants to improve their data quality within Salesforce. Which THREE actions should they prioritize to establish a robust Data Governance framework?

Accepted Answer

Assign data owners for each critical data domain.. A robust governance framework requires a combination of clear ownership, standardized processes, and technical automation. Without these pillars, data quality degrades over time due to inconsistent entries and lack of accountability. Prioritizing these actions ensures that all stakeholders understand their responsibilities, data is handled consistently, and the organization has a mechanism to detect and remediate issues before they impact business operations.

Answer

Mandate that every user must manually review all records created daily.

Answer

Delete all historical data to ensure the database starts with a clean slate.

Question 6

When migrating data to Salesforce, which TWO strategies help ensure successful relationship mapping between parent and child objects?

Accepted Answer

Use External IDs to map the relationship between parent and child.. Mapping relationships is the hardest part of data migration. Using external IDs for lookups ensures that child records are connected to the correct parent regardless of the internal Salesforce ID. Furthermore, performing the load in a specific sequence (parents first, then children) eliminates 'missing parent' errors. These two strategies ensure that relational integrity is preserved from the legacy system without relying on fragile multi-step manual work or custom post-load reconciliation scripts.

Answer

Load child records first, then use Apex to link parents.

Answer

Query the Salesforce internal IDs after the load to update the child records.

Answer

Only migrate parent objects to ensure no orphan records exist.

Question 7

An organization needs to integrate Salesforce with a legacy system that does not support modern authentication. What is the most secure architectural approach?

Accepted Answer

Use a Middleware/Integration layer.. Using an intermediate middleware or Integration Hub allows the architect to encapsulate the modern authentication requirements of Salesforce while providing a secure proxy for the legacy system. This prevents the need to downgrade security settings within Salesforce and keeps sensitive credentials secure. It is the professional standard for bridging modern cloud platforms with older on-premises systems while maintaining strict security and compliance standards.

Answer

Hardcode credentials in the Apex integration code.

Answer

Disable TLS 1.2 in Salesforce settings.

Answer

Send data via unencrypted email attachments.

Question 8

A company is migrating legacy account data into Salesforce. They need to map legacy system primary keys to a new custom field to support future integrations. What is the recommended approach to ensure this field supports efficient data retrieval?

Accepted Answer

Configure the custom field as an External ID with unique constraints enabled.. Marking the custom external ID field as 'Unique' and 'External ID' ensures Salesforce automatically indexes the column. This indexing is critical for upsert operations, as it allows the platform to quickly match existing records without performing a full table scan. Proper schema design during migration prevents long-term performance degradation and simplifies the maintenance of relational integrity across interconnected systems.

Answer

Create a standard text field and create a custom index request through Salesforce Support.

Answer

Use a custom field without the External ID attribute and perform lookups via SOQL.

Answer

Store the legacy primary key in the standard Name field for each account.

Question 9

What is the consequence of having a 'non-selective' query running on an object with 50 million records?

Accepted Answer

The query will be blocked or timed out by the platform.. Non-selective queries force the system to perform a full table scan. In an environment with millions of records, this consumes massive resources, often leading to query timeouts, increased CPU usage, and potential platform instability. Preventing this is the primary goal of data architecture, as it protects the multi-tenant environment and ensures that individual system processes do not consume resources allocated for other tenants or internal tasks.

Answer

The query will fail immediately with a compilation error.

Answer

The query will run faster because it ignores indexes.

Answer

The query will automatically create an index for the fields used.

Question 10

Which TWO steps are critical when preparing to migrate sensitive PII (Personally Identifiable Information) into Salesforce?

Accepted Answer

Perform data masking on source datasets for sandboxes.. When migrating PII, Data Architects must prioritize compliance and data protection. Data masking ensures that non-production environments do not contain real sensitive data, while Field-Level Security (FLS) ensures that only authorized users can access the data within production. These steps are essential to maintaining regulatory compliance, such as GDPR or HIPAA, throughout the lifecycle of the data migration project.

Answer

Use the Bulk API for all PII data transfers.

Answer

Delete all audit logs after the migration is complete.

Answer

Export all PII to unencrypted CSV files for mapping.

Question 11

An administrator wants to convert an existing custom lookup relationship on the 'Project' object pointing to the 'Client' object into a master-detail relationship. Which precondition must be satisfied before this conversion can be completed successfully?

Accepted Answer

All existing child records must have a non-null value populated in the lookup field.. Converting a lookup relationship to a master-detail relationship requires that every existing child record currently in the database possesses a populated, valid value for the lookup field. If any orphan records exist where the lookup field is blank, the database cannot establish the mandatory parent-child integrity required by master-detail semantics, causing the conversion operation to fail.

Answer

The parent object must have fewer than 10,000 child records associated with it.

Answer

The organization-wide default for the child object must be set to Public Read/Write.

Answer

All custom reporting types referencing the objects must be temporarily deleted prior to conversion.

Question 12

A company requires real-time reporting on millions of records. Which architecture enables this while minimizing impact on production database performance?

Accepted Answer

Use Salesforce Connect for virtualized access.. Salesforce Connect with External Objects is the ideal solution for large-scale data that shouldn't live directly inside Salesforce. It fetches data in real-time from external sources without consuming Salesforce storage or affecting local database performance. This pattern is critical for architects managing massive datasets, as it keeps the core Salesforce CRM instance light and performant while still providing users with seamless access to historical or external financial data.

Answer

Import all data into custom Salesforce objects.

Answer

Copy all data into the Salesforce Big Object.

Answer

Use platform events to stream data records.

Question 13

Which document is essential to provide to a regulator to prove that the Data Governance program is active and effective?

Accepted Answer

Data Governance Charter.. The Data Governance Charter is the foundational document that outlines the authority, scope, and objectives of the program. It provides the official mandate, showing that the organization has formally recognized the importance of data governance. For regulators, this is the first proof that the organization has a structured approach to managing data quality, security, and compliance in its systems.

Answer

List of user profiles.

Answer

Salesforce Developer Guide.

Answer

Individual user training materials.

Question 14

When planning a large data migration, which TWO tasks are essential to perform before the data load? (Choose two)

Accepted Answer

Deactivate all triggers, workflow rules, and flows that could interfere with the load.. Preparing the environment by deactivating automation and establishing a clean mapping strategy are foundational steps. Deactivating automation prevents unintended side effects and performance bottlenecks during the load. A robust mapping strategy, including data cleansing and validation, ensures the migration follows business requirements. These steps minimize downtime and reduce the risk of data corruption, ensuring the system remains performant and the data remains high quality post-migration.

Answer

Increase the Salesforce API limit for the specific migration user.

Answer

Delete all existing records in the environment to ensure a fresh start.

Answer

Enable the 'Parallelize' setting on all user profiles.

Question 15

When designing a data model for a multi-region deployment, what is the best way to handle global picklist values?

Accepted Answer

Use Global Value Sets. Global Value Sets allow for centralized management of picklist values across multiple objects and regions. This ensures consistency in reporting and data entry, as the same set of values is used consistently. If a value needs to be updated, it only needs to be changed in one place, which reduces the risk of data inconsistency and makes the maintenance of global data models much more efficient.

Answer

Copy values to every object

Answer

Use a custom metadata type

Answer

Use a text field