scenario questions

A Salesforce data architect is explaining the concept of a 'golden record' to business stakeholders. Which statement best describes a golden record in a master data management context?

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?

An architect is modeling a 'Subscription' service where Customers have multiple active subscriptions. Which approach best handles the 'Current' vs 'Historical' subscription data for reporting?

Universal Containers is classifying their data based on sensitivity levels (e.g., Public, Internal, Confidential, Restricted). Which Salesforce feature allows them to record this classification directly on the field definition?

A Salesforce data architect is migrating 100,000 Opportunity records from a legacy system. The legacy data includes a custom field 'Legacy_Region__c' that must be mapped to a new picklist field 'Region__c' in Salesforce. The picklist values in Salesforce are: 'North America', 'Europe', 'Asia', 'Latin America'. The legacy data uses values like 'NA', 'EU', 'APAC', 'LATAM'. What is the most efficient way to transform the data during migration?

What is the primary architectural goal of using the Salesforce Bulk API 2.0?

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.)

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.)

Which governance component ensures that Salesforce Orgs are prepared for major feature updates and potential breaking changes?

A data architect is reviewing a custom object that has grown to 8 million records. Users report that list views and reports are slow because they sort on a text field, Priority__c, which has only three possible values. What should the architect recommend to improve performance?

The governance board at a financial services firm wants to know when critical fields on the Opportunity object were changed, who changed them, and what the previous value was, without writing custom code. Which native capability should the architect enable?

Which strategy best supports Data Governance when scaling a Salesforce implementation across multiple business units with varying data requirements?

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

Universal Containers wants to ensure that when a user updates a field on an Account record, the change is captured and stored for auditing purposes. The solution must be configurable without writing code and must retain field history for up to 18 months. What should a data architect implement?

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

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?

A global Salesforce org has implemented a data governance framework. The governance team needs to ensure that data is retained according to legal and regulatory requirements, and that it is securely deleted when no longer needed. They are evaluating Salesforce's native capabilities for data lifecycle management. Which statement accurately describes a limitation or behavior of Salesforce's native data retention and deletion features that the team must consider?

A Data Architect needs to implement a field-level security strategy where PII is visible only to the 'HR' profile. However, other profiles need to run reports on the account data without seeing the PII. What is the correct way to handle this?

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?

Refer to the exhibit. An architect is reviewing an error log from a high-volume data load. Which pattern should be implemented to resolve this limit violation?

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.)

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

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?

A company is migrating legacy data and needs to preserve the CreatedDate and CreatedById. Which feature should they enable?

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

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?

An enterprise Salesforce org has multiple business units that each maintain their own picklist values for the Industry field on Account. This has caused inconsistent reporting and integration failures. The Data Governance Council mandates a single, standardized Industry picklist across all business units. Which approach best enforces this standardization while allowing controlled local extensions?

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?

An org has a custom object 'Invoice__c' with a Lookup to Account. Users frequently complain that deleting an Account leaves orphaned Invoice records, and reports show Invoices with no Account. The business wants the platform to prevent an Invoice from being saved without a valid Account. Which change should the architect make?

Universal Containers maintains customer master data in Salesforce and a legacy ERP. The data architect needs to ensure that when a customer's address is updated in Salesforce, the change is automatically reflected in the ERP within 15 minutes. The ERP does not support outbound calls. Which Salesforce feature should be used to achieve this near real-time synchronization?

A global Salesforce org maintains an Account record that is simultaneously updated by an inbound ERP integration, a nightly Data Loader batch, and a sales rep via the Lightning UI. During a data quality audit, the governance board finds that conflicting values for the 'Annual Revenue' field have overwritten each other, and no one can determine which source was authoritative at any point in time. The board wants to ensure that future conflicts are detected, attributed to a source system, and resolved according to a documented priority order before the record is committed. Which governance mechanism should the Data Architect recommend to satisfy this requirement?

A Salesforce data architect is asked to ensure that account records created by the sales team always include a valid 15-character or 18-character Salesforce ID in a custom external identifier field used by an ERP integration. The ERP rejects records without a valid ID. Which Salesforce feature should the architect use to enforce this at the point of data entry?

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.)

A data architect at Northern Trail Outfitters is designing a master data management solution where customer records from Salesforce and a legacy ERP must be consolidated into a single golden record. The architect must ensure that the most recent address is always used, but if the most recent address is from the legacy ERP, it should only be used if it has been verified. Which MDM concept should be implemented to achieve this?

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?

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.)

A data architect is migrating 50 million records into a custom object. To ensure optimal performance and avoid hitting governor limits, which strategy should be implemented during the initial data load?

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?

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

Universal Containers has a custom object Invoice__c with 8 million records. Users report that list views and reports filtering on the Invoice_Status__c picklist field are slow. The field is not indexed. What should the data architect do to improve query performance?

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

An architect is designing a governance framework for Master Data Management (MDM). Which approach is best for ensuring 'Golden Record' consistency in Salesforce?

A global retailer is consolidating customer master data from Salesforce, a legacy loyalty system, and an e-commerce platform. The data architect must design a matching strategy that minimizes false positives while still identifying the same customer across sources where names are spelled differently and addresses vary. Which matching approach should the architect recommend?

A Salesforce architect is designing a data integration strategy to synchronize 5 million records daily from an external ERP system into Salesforce. The integration must handle upserts, minimize API calls, and avoid governor limits. The external system can provide data in CSV format and supports REST APIs. Which approach should the architect recommend?

Cloud Kicks is ingesting 20 million Account records nightly from an external ERP into Salesforce using the Bulk API 2.0. The ERP also updates existing records. During testing, the data architect observes that some records are duplicated because the external system's unique identifier is not enforced in Salesforce. Which solution should the architect implement to prevent duplicates during the nightly load?

A company is planning to migrate legacy customer data into Salesforce. Before the load, the data architect recommends data profiling. Why is this activity mandatory for a successful MDM project?

When dealing with high-frequency updates on a parent object, what is the best practice to prevent lock contention?

An architect is building a data model for a subscription service. They need to calculate the total revenue across all related 'Invoice' records for an 'Account'. Which approach should they use?

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

A Salesforce data architect is asked to recommend a native capability for detecting and merging duplicate person accounts created by multiple intake channels. Which Salesforce feature should the architect recommend as the primary tool?

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

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?

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?

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

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.)

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

A Salesforce architect is migrating 1 million Case records with related Case Comments from a legacy system. The legacy system stores comments in a separate table linked by a legacy Case ID. The architect plans to use the Bulk API to load Cases first, then load Case Comments in a second pass. During the test, the architect realizes that the legacy Case ID is not stored in Salesforce after the first load, making it impossible to link comments to the correct Cases. What should the architect have done to enable this relationship?

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?

A Salesforce architect is migrating 2 million legacy Contact records into a new Salesforce org. The legacy system does not have email addresses for 40% of the contacts, but Salesforce's standard Email field is not required. During a test load of 10,000 records using the Bulk API in serial mode, the load succeeds but the architect notices that duplicate contacts are being created because the legacy system reused a 'legacy_id__c' external ID field for different contacts across regions. What should the architect do to prevent duplicate creation during the full migration?

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?

A data architect at a global manufacturer is defining the match strategy for a new MDM hub. Legal names vary widely across regions, so the architect needs a technique that will correctly link records such as 'Acme Corp.' and 'Acme Corporation Ltd.' even though the strings differ. Which matching approach best satisfies this requirement?

Universal Containers has a custom object Order__c with 10 million records. The object has a lookup relationship to Account. A data architect needs to create a report that shows the total order amount per account for the last fiscal year. The report must be accessible to 500 users and should load in under 10 seconds. Which solution should the architect recommend?

When dealing with LDV, what is the primary benefit of using External Objects via Salesforce Connect instead of standard Salesforce tables?

Universal Containers needs to establish a formalized Data Governance framework to manage customer data across multiple Salesforce orgs and external systems. Which foundational element must the Data Governance board define first to ensure enterprise-wide alignment and accountability?

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

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?

A data architect is implementing a data governance strategy for a Salesforce org with multiple business units. The requirement is to ensure that data stewards can define and enforce data quality rules centrally, and that users are alerted when they attempt to save records that violate these rules. Which feature should be used?

A nonprofit needs to record donations. Each donation is made by exactly one donor Account, and the organization wants a Donor's lifetime giving total displayed on the Account record itself, updated automatically whenever a Donation is created or edited. What should the architect configure?

Which of the following is an example of 'Probabilistic Matching' in the context of an MDM solution?

A healthcare organization is building a data governance program for its Salesforce org. The compliance officer wants a documented record of who owns each data domain, what the approved data definitions are, and how changes to those definitions are approved. Which artifact should the architect establish as the authoritative source for this information?

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

You are migrating records that contain multi-select picklist values. What is the key consideration for mapping this data from a legacy system?

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

Northern Trail Outfitters uses Salesforce as its system of entry for accounts and has a legacy ERP that remains the system of record for billing. The data architect must ensure that when an account's billing address changes in Salesforce, the ERP is updated within near real time, and when the ERP changes a credit limit, Salesforce reflects it within the same window. No middleware is currently in place. Which approach should the architect recommend?

When designing a large-scale data architecture, what is the primary consideration regarding the 'Skinny Table' feature in Salesforce?

Northern Trail Outfitters has a Salesforce org where the Account object contains 40 custom fields, many of which were created by different teams over five years. No one is certain which fields are actively used, which are populated by integrations, and which are safe to remove. The CIO asks the data architect to establish ongoing visibility into field usage and data provenance. Which approach best addresses this governance gap?

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.)

A financial services firm stores portfolio holdings in a custom object with 4 million records. Analysts frequently filter holdings by Account and by a calculated risk score derived from multiple fields on the holding record. The architect wants to minimize query time when users filter by risk score in list views and reports. Which approach should the architect take?

A retail company wants to ensure that customer email addresses are consistently formatted and that invalid values are rejected at the point of entry across web, mobile, and integration channels. The data governance lead asks the architect which Salesforce feature provides a single, reusable definition of the validation that all channels can share. Which feature should the architect recommend?

A multinational manufacturer runs a single Salesforce org for sales and service. Its governance team wants to enforce that all new custom objects created in production carry a business owner, a retention classification, and a data sensitivity label. Administrators frequently create objects ad hoc, and the team wants an automated check rather than a manual review. Which approach should the data architect recommend?

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

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

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

A multinational company uses Salesforce across multiple regions. Each region has its own data retention requirements: the EU requires customer data to be deleted after 7 years, while the US requires retention for 10 years. The company wants to implement a data lifecycle governance policy that automatically enforces these retention periods. Which solution should the data architect recommend?

A Data Architect is tasked with ensuring Data Lifecycle Management is governed. Which lifecycle stage should include a requirement for automated data archiving?

Which TWO factors should be considered when choosing between a Master-Detail and a Lookup relationship for a new custom object? (Choose two)

Universal Containers needs to provide a Full Sandbox for testing, but they must ensure that sensitive customer data like Social Security Numbers and Credit Card details are not visible to developers. Which solution is most appropriate?

A Data Architect is analyzing a legacy system migration. Which THREE factors should be evaluated before deciding between a Lookup or a Master-Detail relationship?

A Salesforce org has a data governance policy that requires all new custom objects and fields to be reviewed and approved by a data governance council before creation. A developer needs to add a new field to the Account object to support a critical business process. What should the developer do first?

Which object type is most likely to cause performance issues in an LDV environment if not managed correctly?

A Salesforce data architect is migrating 500,000 Lead records from a legacy system. The legacy data contains a field 'Lead_Status' with values such as 'New', 'Working', 'Qualified', 'Unqualified'. Salesforce's Lead Status picklist has values: 'Open - Not Contacted', 'Working - Contacted', 'Closed - Converted', 'Closed - Not Converted'. The architect needs to map the legacy values to the Salesforce picklist values. Which approach should be used to ensure a successful migration?

Refer to the exhibit. In a 50 million record Account table, why might this query perform poorly?

A healthcare organization uses Salesforce to manage patient cases and must comply with HIPAA. The data governance team needs to ensure that audit trails for access to Protected Health Information (PHI) are comprehensive and tamper-evident. They are evaluating Salesforce Shield Event Monitoring and Field Audit Trail. Which combination of features should the team implement to meet the requirement for tracking who accessed PHI fields and when, while also retaining the audit data for 10 years?

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.

A company is migrating 100 million records into Salesforce. Which TWO actions should the architect take to optimize performance and prevent row locking?

A company is migrating 50 million records into Salesforce. They need to ensure data integrity while minimizing API consumption. Which strategy is most efficient for a one-time bulk data load?

What is the primary benefit of using a staging database for data migration?

Which of the following is a classic symptom of poor Master Data Management in a Salesforce ecosystem?

Which design approach is best for handling a 'Data Warehouse' requirement within Salesforce when dealing with millions of records?

A Salesforce data architect is preparing to migrate 5 million Account records from a legacy CRM. The legacy system has a field 'Legacy_Owner__c' that contains the email address of the account owner. During migration, the architect must ensure that the ownership is assigned to the correct active Salesforce User. Which approach should be used to map the legacy owner email to the Salesforce User ID?

Which platform feature is best used to move data off-platform to avoid Large Data Volume issues?

A data architect at a financial services company is designing a master data management solution for 'Product' data. The company has multiple source systems: Salesforce, a legacy ERP, and a product information management (PIM) system. The architect must ensure that the golden record for each product is always the most trusted version. Which factor is most critical when defining survivorship rules for product attributes?

Which strategy should be employed when designing a data archiving solution for a high-volume object to ensure continued system performance?

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?

Which design pattern effectively handles high-volume record updates while avoiding 'Too many SOQL queries' errors?

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

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?

When designing a system that requires frequent querying of very large objects, which approach provides the best performance while maintaining data integrity?

A bank requires a full audit trail of all record changes for compliance. What is the most effective way to track changes to sensitive fields?

Universal Containers maintains a single Salesforce org used by sales teams across North America, EMEA, and APAC. Each region has its own legal requirements for how long personal data may be retained. The VP of Sales wants one consistent retention policy applied everywhere to simplify administration. As the data architect, what should you recommend?

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?

Universal Containers wants to ensure data quality by preventing the creation of duplicate Leads from various sources. The architect recommends matching rules and duplicate rules. Which action should the architect take to ensure that users are alerted to potential duplicates during manual entry while blocking automated integrations?

A multinational corporation is migrating 2 million Account records and 5 million Contact records from a legacy CRM into Salesforce. The legacy system stores the Account's legacy ID on the Contact record as a foreign key. The target Salesforce org uses an external ID field on Account called Legacy_ID__c. What is the most efficient way to associate Contacts with their Accounts during the migration?

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.)

When designing a custom Data Model, when should an architect choose a 'Lookup' relationship over a 'Master-Detail' relationship?

A data architect needs to ensure that when a user updates a field on a custom object, a related record on another object is automatically updated to reflect the change. The architect wants to avoid writing code. Which declarative feature should be used?

A healthcare company needs to store patient consent records that must be retained for ten years and are rarely accessed after the first year. The records include sensitive data and must be queryable by compliance officers using standard reports. Which storage strategy should the architect recommend?

A Salesforce org has a custom object Log__c with 5 million records. The object has a lookup to Case. Users report that when they view a Case record, the related list of Log__c records takes a long time to load. The data architect decides to create a custom index on the Case lookup field. After the index is created, performance improves. Which statement best explains why the index improved performance?

A data architect is migrating 10 million Case records and their related Case Comments from a legacy system to Salesforce Service Cloud. The legacy system stores Case Comments in a separate table with a foreign key to the Case. The architect plans to use Bulk API 2.0 for the migration. What is the most critical consideration for maintaining referential integrity between Cases and Case Comments during the load?

Which TWO of the following are consequences of having excessive indexes on a Salesforce object with large data volumes?

Refer to the exhibit. The architect observes this error during bulk Opportunity updates. Which action resolves the issue while adhering to best practices?

A financial services company is migrating 5 million Account records from a legacy CRM to Salesforce. The legacy system has a field 'AnnualRevenue' stored as a string with currency symbols and commas (e.g., '$1,234,567.89'). The target Salesforce field is a Currency field with 2 decimal places. During a test load of 100,000 records using the Bulk API, the architect receives errors indicating 'Invalid currency format'. What is the most efficient way to resolve this before the full migration?

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

Why is it recommended to perform large data deletes using a soft-delete approach followed by a hard-delete during off-peak hours?

A large enterprise discovers duplicate accounts across Salesforce and their legacy system. Before importing data, they decide to implement a 'Data Stewardship' program. What is the primary role of a data steward in this context?

A Data Architect is designing a disaster recovery plan. Which data elements must be explicitly backed up outside of Salesforce to ensure business continuity?

Refer to the exhibit. The query is part of a bulk apex process. What is the potential risk with this query in a large-scale data environment?

Universal Containers maintains customer master data in Salesforce and in a legacy Oracle billing system. The data architect must define a survivorship strategy that resolves field-level conflicts when the same customer is updated in both systems during the same nightly integration window. Business rules state that the most recently modified value from the system of record for that attribute should win, and that billing-related attributes must always originate from Oracle. Which approach should the architect implement to satisfy these requirements?

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?

Refer to the exhibit. An architect is using the Salesforce CLI to perform a high-volume data upsert. What is the significance of the '-i Legacy_ID__c' parameter in this command?

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

Which TWO of the following are true regarding the impact of 'Formula Fields' on Large Data Volumes?

Universal Containers notices severe locking issues and transaction failures when updating a parent Account object that has over 15,000 child records in a master-detail relationship. What is the fundamental architectural cause of this behavior?

Refer to the exhibit. The Data Architect is tasked with ensuring that order status options are limited based on the geographic region of the order. Which feature should be used to implement this?

Universal Containers maintains a custom object, Shipment__c, that has a Master-Detail relationship to Account and a Lookup to Carrier__c. A Data Architect is asked to design a new object, Shipment_Line__c, that must always belong to exactly one Shipment__c, must inherit Shipment__c's sharing rules, and must not be independently owned by a different user. Which relationship type should be used between Shipment_Line__c and Shipment__c?

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?

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?

A Salesforce data architect at a global manufacturer is defining the master data domain for 'Customer'. The company has separate business units that each maintain their own customer records. The architect must ensure that a single, authoritative Customer record exists and is referenced by all transactional systems. Which approach best achieves this?

An organization has 50 million records in a custom object. They need to report on historical snapshots weekly. What is the best strategy to manage storage while keeping data available?

A company maintains a custom object Asset__c with 5 million records. They need to archive records older than 7 years to a Big Object for compliance. After archiving, the records must be queryable via SOQL for audits, but not editable. Which approach should an architect recommend?

Northern Trail Outfitters is preparing for a GDPR-driven data subject deletion request affecting a Contact and its related Cases, Email Messages, and custom child records. The architect must ensure the deletion is complete and evidenced. Which approach best satisfies the governance requirement?

When designing a system for LDV, what is the role of an 'Indexed Field'?

A data architect is migrating 500,000 records into a custom object that has a validation rule requiring the 'Status__c' field to be either 'Active' or 'Inactive'. The legacy data contains some records with a blank Status__c. The architect needs to ensure the migration succeeds without modifying the validation rule. What should be done?

Which document is the most critical for Data Governance to ensure that Salesforce Orgs remain compliant with regional data residency requirements?

A healthcare provider is migrating 8 million legacy Patient_Visit__c records into Salesforce. Each visit references a legacy numeric provider code, and the legacy system does not expose a stable unique identifier for each provider. The Salesforce Provider__c object already has a custom external ID field named Legacy_Provider_Code__c that is populated. The architect wants to load visits without first exporting provider Salesforce IDs. Which approach should be used?

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.)

A Salesforce org has a custom object Shipment__c with 12 million records. Users frequently run a SOQL query that filters on Status__c and Order_Date__c, and sorts by CreatedDate. The query is timing out. The org has an index on Status__c and a custom index on Order_Date__c. What is the most likely reason the query is still slow?

Universal Containers has 50 million records in a custom object. A report summarizing these records times out. Which strategy is most effective for improving report performance?

What is the primary role of a Data Dictionary in a Data Governance program?

A data architect needs to migrate 500,000 Account records from a legacy system into Salesforce. The legacy system uses a 15-digit alphanumeric string as the unique identifier. The architect must ensure that future updates can match existing Accounts without creating duplicates. Which field configuration should be used on the Account object to support this requirement?

When evaluating external data integration, which THREE architectural patterns should a Data Architect consider to minimize the impact on Salesforce governor limits?

Northern Trail Outfitters uses Salesforce as its system of entry for customer records, but the ERP remains the system of record for billing addresses. A data architect must design the MDM integration so that when a billing address changes in the ERP, Salesforce is updated, but address edits made in Salesforce do not flow back to the ERP. Which MDM pattern should the architect implement?

An architect is designing a schema for a logistics org where each 'Shipment__c' record can be linked to many 'Carrier__c' records, and each Carrier can serve many Shipments. The business also needs to store the negotiated 'Rate__c' and 'Effective_Date__c' specific to each Shipment-Carrier pairing, and report on those values. Which data modeling approach should the architect use?

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?

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?

A healthcare company must retain patient interaction records for 10 years for regulatory compliance. However, records older than 2 years are rarely accessed and are causing performance issues in the live Org. Which TWO strategies should an architect recommend?

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?

A Salesforce org has a data governance policy that requires all new custom objects to have a description and a data owner assigned before deployment to production. The architect needs to enforce this policy automatically during the development lifecycle. Which approach should the architect take?

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

A healthcare provider's Salesforce org uses a custom object 'Care_Plan__c' with a Lookup to 'Patient__c'. Compliance now requires that a Care Plan cannot exist without a Patient, that the Patient record cannot be deleted while Care Plans reference it, and that each Care Plan should inherit the Patient's sharing settings. The team also needs a roll-up summary of active Care Plans on the Patient record. Which relationship change should the architect recommend?

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

An organization is consolidating multiple legacy systems into Salesforce. They need to track the lineage of data records back to their source systems for audit purposes. What is the recommended strategy for maintaining data lineage?

A multinational Salesforce org must ensure that records created in the EU region are stored and processed only within EU-approved infrastructure, while global reporting aggregates anonymized metrics. Which governance control should the architect prioritize to satisfy data residency?

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?

A Salesforce org has a custom object Invoice__c with a Lookup relationship to Account. The business now requires that every Invoice__c record must always have a valid Account, and deleting an Account must also delete its related invoices. The architect decides to change the relationship type to Master-Detail. Which statement describes a valid consequence of this change?

A company is importing 50 million records into a custom object. Which strategy should be used to minimize record locking contention during the high-volume insert operation?

Universal Containers is building a Data Governance program for its Salesforce org. The governance lead wants a single authoritative reference that defines every custom object and field, its business definition, data owner, allowed values, and system of record. Which artifact should the architect recommend as the foundation?

A multinational financial services company uses Salesforce to manage customer interactions. Its data governance team must ensure that all data elements containing Personally Identifiable Information (PII) are consistently classified, protected, and auditable across Production and Full Sandbox environments. The team is considering using Salesforce Data Mask to anonymize PII in Full Sandboxes. However, they are concerned that masking might alter the original data in Production. What is the most accurate statement regarding Data Mask and its role in this governance strategy?

A retail company is implementing a data governance program and needs to define ownership and accountability for data quality. The company has multiple business units, each using Salesforce differently. The governance team wants to ensure that each data domain (e.g., Customer, Product, Order) has a clear owner responsible for data quality, definitions, and issue resolution. Which role should be assigned to fulfill this responsibility?

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.)

A data architect is migrating 20 million Case records from a legacy system into Salesforce. The legacy system has a 'Case_Status__c' field that must map to the standard Case Status picklist. The legacy values include 'Open', 'Closed', 'Escalated', 'Pending', and 'Resolved'. The Salesforce Case Status picklist contains 'New', 'Working', 'Escalated', 'Closed', and 'Pending'. The architect needs to ensure that the migration does not fail due to picklist value mismatches. Which approach should be taken?

A company is experiencing slow performance on reports that join multiple objects with millions of records. What architectural change should the Data Architect propose first to improve report performance?

A Salesforce architect is designing a data model for a recruiting application. A Candidate can apply to many Positions, and a Position can receive applications from many Candidates. For each application, the company needs to track the Application Date and the Source (for example, LinkedIn or Referral). Which data modeling approach should the architect use?

A healthcare company is migrating 4 million Patient__c records from a legacy system into Salesforce. The legacy extract includes a field named 'last_modified' that is populated for 99.8% of records, but the remaining 0.2% have a null value. The target external ID field requires a unique, non-null value. What should the data architect do to ensure a successful migration?

A data architect is designing a data retention policy for a custom object Event_Log__c that stores 20 million records per year. The business requires that records older than 2 years be archived but still accessible for occasional reporting. What is the most appropriate approach?

Refer to the exhibit. An architect needs to track changes to the 'Status__c' field for auditing purposes. Based on the configuration provided, what is the best way to report on the duration a record spent in each status?

A multinational retailer is consolidating customer master data from eleven country-level Salesforce orgs into a single global org. Each country org has its own account numbering scheme, and legal entities must remain distinguishable for tax reporting. Which MDM design should the architect recommend to reconcile the identifiers while preserving legal-entity separation?

A global organization uses Salesforce as its CRM and SAP as its ERP. They need to ensure that customer data remains consistent across both systems. Which approach best supports a Master Data Management strategy for this landscape?

Which field type should be used for a primary key when integrating data from an external ERP system into Salesforce?

A Data Architect is designing a data retention policy for a custom object that stores transaction records. The object has a master-detail relationship to Account and contains over 50 million records. The business requires that records older than 7 years be automatically deleted, but they must be archived first for compliance. Which approach should the architect recommend?

A Salesforce org has a custom object Invoice__c with 8 million records. The business requires a dashboard that shows the total invoice amount grouped by Account and by Fiscal Year. The dashboard must refresh quickly, even during peak usage. The Invoice__c object has a lookup to Account and a formula field Fiscal_Year__c that extracts the year from Invoice_Date__c. What is the most appropriate design to support this dashboard efficiently?

Universal Containers needs to access real-time order data stored in an external legacy ERP system within Salesforce without storing the data locally. Which Salesforce feature is most appropriate for this data management requirement?

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.)

A large university is modeling academic records in Salesforce. Each Course can be taught by multiple Instructors, and each Instructor can teach multiple Courses. The university must report on the aggregate number of Courses each Instructor is teaching per semester and enforce that an Instructor cannot be assigned to the same Course twice within the same semester. Which data modeling approach should the architect implement?

A company requires a data model to track 'Training Sessions' (which have many attendees) and 'Employees' (who attend many sessions). Which relationship is required to model this correctly?

A data architect is migrating 30 million Opportunity records into Salesforce. The legacy system has a 'Close_Date__c' field that is a date, but some records have invalid dates such as '0000-00-00' or future dates beyond 2099. The Salesforce Opportunity Close Date field is a standard Date field. The architect must ensure the migration does not fail due to these invalid dates. Which approach should be used?

You are auditing a Salesforce environment and discover a custom object with 20 million records. Users report that searching for records by a custom field 'External_ID__c' is extremely slow. What is the most appropriate action to take?

A data architect is migrating 12 million Opportunity records into a new Salesforce org. The legacy system uses a custom 'Opportunity_Key__c' that must be populated for integration purposes. During a test load using the Bulk API in parallel mode, the team observes that some records fail with 'UNABLE_TO_LOCK_ROW' errors. What is the most likely cause of these errors?

Universal Containers is importing 5 million child records into a custom object using the Bulk API in parallel mode. The load frequently fails due to UNABLE_TO_LOCK_ROW errors because many child records share the same parent account. Which strategy should the architect recommend to resolve this failure?

When designing a master data management solution in Salesforce, what is the significance of the 'Survivorship' rules?

A custom object 'Invoice__c' contains 8 million records and has a lookup to Account. A nightly batch job deletes approximately 2 million old invoices using Database.delete() in batches of 200. Users report that the batch sometimes fails with 'UNABLE_TO_LOCK_ROW' errors when running concurrently with account updates. What is the most likely cause of these lock contention errors?

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.)

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.)

Universal Containers uses a Big Object named 'Log__b' to store audit trails. They need to generate a report that aggregates this data weekly for compliance. Standard SOQL queries are failing due to the volume of records. What should the architect recommend?

A large custom object has 20 million records. A SOQL query is taking too long. What should the architect evaluate first?

A Salesforce org has a custom object Case_Comment__c with 5 million records. The object has a lookup to Case. Users frequently run SOQL queries that filter by CaseId and OrderBy CreatedDate. The queries are slow. What should be done to improve performance?

A data architect is designing a solution for a custom object Order__c that will contain 30 million records. Users need to frequently query orders by Customer__c (a lookup to Account) and Order_Date__c. The architect plans to create a composite custom index on Customer__c and Order_Date__c. Which consideration is most critical for the index to be used by the query optimizer?

Which indexing strategy is best to improve performance for queries on a field used in multiple filters?

An enterprise organization is experiencing frequent data skew issues on the Account object, leading to severe record locking and performance degradation during parallel batch updates. What is the primary architectural cause of Account data skew in Salesforce?

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

Universal Containers requires a many-to-many relationship between Projects and Consultants. They need to track specific attributes like 'Hourly Rate' and 'Assigned Role' on the relationship itself. Which approach should a Data Architect recommend?

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

A Salesforce architect is designing a data model for a custom object 'Case__c' that needs to track the priority of each case. The priority values must be limited to a predefined list: Low, Medium, High, and Critical. Users should be able to select only one value, and the values should be easily reportable. Which field type should be used?

What is the recommended approach to manage 'Skinny Tables' in an environment with Large Data Volumes?

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

A data architect is migrating 4 million legacy Customer__c records into Salesforce using the Bulk API. The source system exports a CSV with a column 'Legacy_Id__c' that must remain unique and searchable for downstream integrations. After the initial load, the architect notices duplicate Customer__c records were created because the External ID field was not marked as unique. Which Salesforce field configuration should have been applied to Legacy_Id__c to prevent duplicates during upsert?

A global organization requires that sensitive customer data be categorized, protected, and auditable across Salesforce Orgs. Which data governance framework component is most effective for ensuring consistent data classification policies?

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.)

A financial services org needs to record every change to the 'Credit_Score__c' field on Contact for regulatory audit, including the prior value, the new value, the user, and the timestamp. The data volume is moderate and auditors query the history by Contact. Which approach should the architect recommend?

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

A custom object named Invoice__c contains 15 million records. Reports and list views frequently filter on a custom date field, Invoice_Date__c, and are timing out. The field is not indexed. Which action should a data architect take to improve query performance while keeping the field available for filtering?

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

What is the primary benefit of performing a data cleansing exercise before initiating a migration to Salesforce?

Refer to the exhibit. What is the most likely reason this query fails?

A financial services company must retain Salesforce records for seven years to satisfy a regulator. Records older than two years are rarely accessed but must remain retrievable within 48 hours if requested. The org's data volume is growing 40 percent per year, and the architect wants to minimize storage cost while preserving the ability to restore records with their original Salesforce IDs and relationships. Which approach best meets these requirements?

A data architect is designing a data retention policy for a custom object Event_Log__c that stores 20 million records per year. The business requires that records older than two years be archived to an external system but remain accessible for audit purposes. What is the most appropriate approach to meet these requirements while minimizing storage costs?

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

An architect is modeling a case management system where a single Case may be linked to many Product records, and each Product may appear on many Cases. The business needs to report on the quantity and discount negotiated for each Case-Product pairing. Which design should the architect implement?

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?

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?

A Salesforce architect is designing a data model for a custom object that must support a strict one-to-many relationship where each child record must have a parent, and the parent's sharing settings should automatically control child record access. The architect also needs to ensure that deleting a parent cascades to delete all related children. Which relationship type should be used?

A data architect at a healthcare company needs to ensure that only authorized users can view sensitive patient information stored in custom fields on the Patient__c object. The organization uses a role hierarchy and profiles. Which feature should the architect use to restrict access to these fields?