SF-Data-Arch Multiple Select — 20 Questions

Question 1

An enterprise architect is evaluating data storage strategies for a telecommunications client experiencing rapid data growth of fifty million call detail records annually. Which TWO strategies should the architect implement to maintain database query performance and platform data limits? Choose 2 answers.

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

Accepted Answer

Utilize Salesforce Big Objects to store historical call records asynchronously and index primary lookup keys.. When dealing with massive data volumes exceeding standard transactional limits, traditional custom objects will quickly degrade platform performance and storage capacity. Offloading historical analytical data to Salesforce Big Objects or external systems via Salesforce Connect preserves core transactional limits. Additionally, implementing strict data archiving strategies prevents data skew and maintains query optimization.

Answer

Store the call detail records in standard custom objects with indexes applied to all foreign keys.

Answer

Create hierarchical custom object structures linking every call record directly to the Account master object.

Answer

Rely on standard Salesforce report archives to automatically move historical records out of reporting tables.

Question 2

A firm is implementing a data stewardship program. Which TWO activities are primary responsibilities of a Data Steward? (Choose Two)

Accepted Answer

Identify and document data quality issues.. Data stewards bridge the gap between technical IT teams and business users. They are responsible for the daily management, quality, and definition of data assets. By ensuring metadata is documented and data quality issues are remediated, they maintain the integrity of the data assets, which is critical for trustworthy analytics and regulatory reporting within the Salesforce ecosystem.

Answer

Define the overarching corporate data strategy.

Answer

Design the technical Salesforce architecture.

Answer

Approve all system-level security access.

Question 3

Universal Containers is implementing a data retention strategy for a custom object called Invoice__c that stores 120 million records. They need to archive records older than seven years to an external system while keeping the most recent records immediately accessible in Salesforce. Compliance requires that archived records remain queryable for audit purposes without impacting Salesforce performance. Which two Salesforce features should the architect recommend to meet these requirements? (Choose two.)

Accepted Answer

Big Objects with a custom index and asynchronous SOQL queries. Big Objects provide native, scalable storage for massive data volumes and support asynchronous queries, making them ideal for long-term archival within Salesforce. Salesforce Connect allows real-time access to external data without replication, so archived records remain queryable for audits. Together, they satisfy retention, performance, and compliance requirements without overloading the transactional object.

Answer

Standard Salesforce Recycle Bin retention policies

Answer

Field Audit Trail and Data Retention policies for standard objects

Answer

Salesforce Data Loader with a scheduled export to a local database

Question 4

A Data Architect is designing a data governance strategy for a Salesforce org that integrates with multiple external systems. The architect needs to ensure data quality and consistency across systems. Which two practices should be implemented? (Choose two.)

Accepted Answer

Define a master data management (MDM) strategy to establish a single source of truth.. The two correct practices are defining an MDM strategy and implementing validation and duplicate rules. MDM establishes a single source of truth, while validation and duplicate rules enforce data quality at the point of entry. Together, they ensure data consistency and accuracy across integrated systems, which is essential for effective data governance.

Answer

Schedule nightly full data exports to a data warehouse for backup purposes.

Answer

Configure field-level security to restrict access to sensitive fields.

Answer

Use Salesforce Data Loader to manually reconcile data discrepancies on a weekly basis.

Question 5

A global insurer is preparing for a data privacy audit. The architect must demonstrate that the Salesforce org can identify where personal data lives and prove who accessed it. Which two capabilities should the architect include in the governance solution? (Choose two.)

Accepted Answer

Data Classification metadata on fields, using the Data Classification feature to tag fields as personal or sensitive.. The audit asks two distinct questions: where personal data resides and who accessed it. Data Classification metadata answers the first by tagging fields with sensitivity categories, and Event Monitoring answers the second by retaining access and API logs for analysis. Field history, bulk exports, and platform encryption do not provide classification inventory or access evidence.

Answer

A nightly Data Loader job that exports all records for offline retention.

Answer

Field History Tracking enabled on every field in the org to record old and new values.

Answer

Enabling Shield Platform Encryption on all text fields to mask values at rest.

Question 6

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 7

A company is implementing a Customer Data Platform (CDP) to consolidate data from Salesforce, a web store, and an email marketing tool. Which TWO steps are critical for successful identity resolution?

Accepted Answer

Define deterministic and probabilistic matching rules.. Identity resolution is the process of linking data points from disparate sources to create a unified profile. By defining clear matching rules and prioritizing data attributes, the CDP can accurately identify unique individuals even when they use different identifiers across channels. This is vital for personalized marketing and accurate customer analytics, ensuring that the organization does not treat the same individual as multiple distinct records.

Answer

Migrate all Salesforce CRM data into the marketing tool's database.

Answer

Remove all personally identifiable information from the incoming data streams.

Answer

Automate the deletion of all records that do not contain a phone number.

Question 8

A data architect is planning to implement a Skinny Table for a custom object with 10 million records to improve query performance. Which two considerations are critical when designing the Skinny Table? (Choose two.)

Accepted Answer

The Skinny Table requires a synchronization mechanism to keep data current with the main object.. A Skinny Table is a denormalized copy of a subset of fields from a large object, used to accelerate specific queries. The two critical considerations are selecting only the fields needed for common queries to minimize row size, and implementing a synchronization mechanism to keep the copy up to date. Without these, the Skinny Table would either be too large to be effective or become inconsistent with the source data.

Answer

The Skinny Table can be used as the primary data source for all reporting to replace the main object.

Answer

The Skinny Table should be indexed on all fields to maximize query flexibility.

Answer

The Skinny Table must include all fields from the original object to maintain data integrity.

Question 9

An architect is choosing between storing a new data domain in a custom object versus using Big Objects in Salesforce. The dataset is expected to reach billions of records with append-only writes and infrequent, key-based reads. Which two characteristics make Big Objects the appropriate choice for this scenario? (Choose two.)

Accepted Answer

Big Objects provide an indexed, query-optimized access path for retrieving records by defined key fields.. Big Objects exist to handle data volumes beyond what custom objects can practically store, and they add an architect-defined index that makes key-based retrieval efficient at that scale. Together, scalability and indexed async query access are the two defining reasons to choose Big Objects for this append-only, high-volume domain.

Answer

Big Objects support full DML operations including update and delete through the standard user interface.

Answer

Big Objects replicate data across every Salesforce instance for real-time reporting in standard reports.

Answer

Big Objects allow roll-up summary fields and validation rules on the object.

Question 10

A data architect is designing a data governance program for a Salesforce MDM implementation that spans Sales Cloud, Service Cloud, and an external data warehouse. Which two capabilities are essential to include in the governance model? (Choose two.)

Accepted Answer

A defined data stewardship role with authority to resolve match exceptions and approve merges.. A functioning MDM governance model needs both accountability and measurement. Stewardship assigns human ownership for resolving exceptions and approving merges, while defined quality dimensions and thresholds give the program objective success criteria. Integration patterns, UI standardization, and administrator-only editing are technical or operational choices that do not by themselves establish governance over master data.

Answer

Enabling Lightning Experience for all users to standardize the interface used for master data entry.

Answer

A nightly full refresh of all Salesforce records into the data warehouse using Bulk API 2.0.

Answer

Configuring field-level security so that only system administrators can edit any master data attribute.

Question 11

A data architect is designing a master data management strategy for customer data in Salesforce. The company wants to ensure data quality and consistency across systems. Which two practices should the architect recommend to maintain a single source of truth? (Choose two.)

Accepted Answer

Establish a data governance council to define policies and standards. A data stewardship program and a data governance council are both strategic practices that establish accountability and policies for master data. They ensure that data is managed consistently, which is essential for a single source of truth. The other options are either tactical tools or unrelated to data quality management.

Answer

Use Salesforce's duplicate management rules to prevent duplicate records

Answer

Schedule nightly data backups of Salesforce

Answer

Enable field history tracking on all customer fields

Question 12

A Salesforce org is implementing a data governance program to manage data quality for a large volume of customer records. The architect must recommend tools and features to monitor and improve data quality on an ongoing basis. Which two Salesforce features should be used to proactively identify and address data quality issues? (Choose two.)

Accepted Answer

Duplicate Management with Matching Rules and Duplicate Rules. Duplicate Management and Validation Rules are proactive features that identify and prevent data quality issues. Duplicate Management detects and manages duplicate records, while Validation Rules enforce data quality at entry by blocking invalid saves. Data Loader, Salesforce Optimizer, and Reports/Dashboards are not proactive data quality tools; they serve other purposes like data loading, org optimization, or monitoring.

Answer

Data Loader with batch size optimization

Answer

Salesforce Optimizer

Answer

Reports and Dashboards with custom report types

Question 13

A Salesforce architect is planning a migration of 2 million custom object records from a legacy Oracle database. The legacy system has a field 'Status' with values like 'Active', 'Inactive', 'Pending', and 'Archived'. In Salesforce, the Status field is a picklist with values 'Active', 'Inactive', and 'Pending' only. The architect needs to migrate the data while preserving as much information as possible and ensuring data quality. Which two actions should the architect take? (Choose two.)

Accepted Answer

Create a custom text field to store the original legacy status value for audit purposes, in addition to mapping to the picklist.. The architect should map the unsupported 'Archived' value to a valid picklist value like 'Inactive' to maintain data integrity and avoid load failures. Additionally, storing the original legacy status in a separate text field preserves the exact source information for auditing. This combination ensures data quality, traceability, and compliance with Salesforce picklist constraints.

Answer

Add 'Archived' as a new picklist value in Salesforce to accommodate the legacy data without transformation.

Answer

Use a validation rule to prevent 'Archived' from being loaded, and manually update those records after migration.

Answer

Exclude records with 'Archived' status from the migration to avoid picklist conflicts.

Question 14

A data architect at a global manufacturer is designing a master data management solution in Salesforce for customer accounts sourced from Salesforce, a legacy mainframe, and a partner portal. The business requires that the golden record reflect the most trusted source per attribute and that conflicts be resolved deterministically. Which two capabilities should the architect implement to meet these requirements? (Choose two.)

Accepted Answer

Define source ranking and attribute-level survivorship rules so that the highest-ranked source wins per field, with documented tie-breakers.. Deterministic, attribute-level golden records require two foundations: a consistent identity across sources and explicit trust ranking with survivorship rules. A global identifier and cross-reference table group all source records for the same entity, while source ranking with field-level survivorship and documented tie-breakers decides which value wins. Together they deliver the required trust and determinism; duplicate management, manual review, and external read-only access do not.

Answer

Use Salesforce Duplicate Management with matching rules and duplicate rules to identify and block duplicate accounts at entry.

Answer

Configure an external object via Salesforce Connect to read mainframe customer data in real time without replication.

Answer

Implement a data steward approval workflow that routes every field-level conflict to a human for manual selection before the golden record is written.

Question 15

A data architect is preparing to migrate 20 million Opportunity records from a legacy CRM into Salesforce. The source data includes Opportunities with related OpportunityLineItem records and historical StageName values. The architect must ensure that the migration preserves data integrity and avoids common Bulk API pitfalls. Which TWO actions should the architect take before initiating the load? (Choose two.)

Accepted Answer

Load Opportunity records first, then load OpportunityLineItem records using the parent Opportunity's External ID to establish the relationship.. Loading parents before children using an External ID preserves referential integrity, and marking the External ID as Unique supports upsert and prevents duplicates. Together, these actions address the core data integrity concerns for a large Opportunity migration with related line items.

Answer

Disable all validation rules, workflow rules, and triggers on Opportunity during the load to improve performance.

Answer

Set the Batch Size to 1 record to avoid governor limit issues and ensure maximum error isolation.

Answer

Enable AllOrNone on all Bulk API batches to guarantee that no partial data is committed if a single record fails.

Question 16

Universal Containers is implementing a data governance framework. They need to ensure that data quality is maintained across multiple business units. Which two practices should the data architect recommend to enforce data quality at the point of entry? (Choose two.)

Accepted Answer

Implement duplicate rules to block or alert on duplicate records.. To enforce data quality at the point of entry, the architect should implement validation rules to reject invalid data and duplicate rules to prevent duplicates. These are proactive controls that operate when records are created or updated. They are standard Salesforce features that can be configured declaratively and apply across all entry points, including UI, API, and integrations, ensuring consistent data governance.

Answer

Enable field history tracking on all fields to audit changes.

Answer

Use Data Loader to perform a nightly update to correct inconsistencies.

Answer

Schedule a weekly report to identify records with missing values.

Question 17

A Salesforce architect is designing a data model for a custom object 'Invoice__c' that will have a master-detail relationship to 'Account'. The architect needs to ensure that the data model supports efficient reporting and aggregation. Which two considerations are critical when designing this master-detail relationship? (Choose two.)

Accepted Answer

The child object inherits the sharing settings of the parent object.. Master-detail relationships enforce sharing inheritance from parent to child and enable roll-up summary fields on the parent for aggregation. These two features are critical for designing efficient reporting and security. The other options describe limitations or incorrect behaviors, such as independent sharing rules or ease of conversion, which do not apply to master-detail relationships.

Answer

The master-detail relationship can be converted to a lookup relationship at any time without restrictions.

Answer

The child object can have its own sharing rules independent of the parent.

Answer

The child object must have a lookup relationship to the parent instead of master-detail for roll-up summaries.

Question 18

When designing a master data management (MDM) strategy for Salesforce, which THREE factors are critical to preventing duplicate data across the enterprise? (Select THREE)

Accepted Answer

Implementing standard and custom Matching Rules.. Effective MDM strategies require a combination of automated matching rules, robust integration standards, and consistent data governance. These factors ensure that data entered through various channels is normalized and deduped at the point of entry. By implementing these controls, organizations maintain a single source of truth, improve data quality, and reduce the operational costs associated with manual data cleansing and conflicting records within their Salesforce environment.

Answer

Enforcing data entry through API-only integrations.

Answer

Regularly increasing the Data Storage capacity.

Question 19

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 20

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.