Data-Architect Dumps 2025 New Salesforce Data-Architect Exam Questions [Q110-Q131]

admin • September 17, 2025

Data-Architect Dumps 2025 New Salesforce Data-Architect Exam Questions [Q110-Q131]

Rate this post

Data-Architect Dumps 2025 – New Salesforce Data-Architect Exam Questions

Free Data-Architect braindumps download (Data-Architect exam dumps Free Updated)

QUESTION 110
Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

Refresh the full copy sandbox and re-run the data migration test.

Hard delete all 5 objects’ data and re-run the data migration test.

Truncate all 5 objects quickly and re-run the data migration test.

Truncate all 5 objects and hard delete before running the migration test.

QUESTION 111
A large telecommunication provider that provides internet services to both residence and business has the following attributes:
A customer who purchases its services for their home will be created as an Account in Salesforce.
Individuals within the same house address will be created as Contact in Salesforce.
Businesses are created as Accounts in Salesforce.
Some of the customers have both services at their home and business.
What should a data architect recommend for a single view of these customers without creating multiple customer records?

Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.

Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

Customer are created as individual objects and relate with Accounts for Business and Residence accounts.

Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.

Creating customers as Contacts and relating them to Business and Residential Accounts using the Account Contact Relationships (option A) is the best option to recommend for a single view of these customers without creating multiple customer records, as it allows the data architect to model complex relationships between customers and accounts using native Salesforce features and tools. Creating customers as Person Accounts and relating them to Business and Residential Accounts using the Account Contact relationship (option B) is not a good option, as it may create data redundancy and inconsistency, and it does not leverage the existing Contact object. Creating customers as individual objects and relating them with Accounts for Business and Residence accounts (option C) is also not a good option, as it may require more customization and maintenance effort, and it does not leverage the existing Account and Contact objects. Creating customers as Accounts for Residence Account and using Parent Account to relate Business Account (option D) is also not a good option, as it may create confusion and complexity with the account hierarchy, and it does not leverage the existing Contact object.

QUESTION 112
Get Cloudy Consulting is migrating their legacy system’s users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Create the users, upload all data, and then deploy the sharing rules.

Contact Salesforce to activate indexing before uploading the data.

First, load all account records, and then load all user records.

Defer sharing calculations until the data has finished uploading.

Creating the users, uploading all data, and then deploying the sharing rules will reduce the number of sharing recalculations that occur during the data load. Deferring sharing calculations until the data has finished uploading will also improve the performance by postponing the sharing rule evaluation. These are the recommended best practices for loading large data sets into Salesforce

QUESTION 113
Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?

Use a third-party backup solution to backup all data off platform.

Build a batch join move all records off platform, and delete all records from Salesforce.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

The data architect should recommend building a batch job to move two-year-old records off platform, and delete records from Salesforce as an archiving solution. A batch job is a process that runs in the background and performs operations on large volumes of data in Salesforce. By building a batch job that moves two-year-old records off platform to an external storage system, such as Amazon S3 or Google Cloud Storage, and deletes them from Salesforce, the data architect can reduce the storage consumption and improve the performance of Salesforce org. Option A is incorrect because using a third-party backup solution to backup all data off platform will not free up any storage space in Salesforce, unless the data is also deleted from Salesforce after backup. Option B is incorrect because building a batch job to move all records off platform, and delete all records from Salesforce will result in losing all the current data in Salesforce, which may not be desirable or feasible. Option D is incorrect because building a batch job to move all restore off platform, and delete old records from Salesforce does not make sense, as restore implies restoring data back to Salesforce, not moving it off platform.

QUESTION 114
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a Lookup to custom object ShippingStatus c.

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a text field and make it an external I

QUESTION 115
NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and
100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.
Which 3 options should help improve the dashboard performance?
Choose 3 answers:

Use selective queries to reduce the amount of data being returned.

De-normalize the data by reducing the number of joins.

Remove widgets from the dashboard to reduce the number of graphics loaded.

Run the dashboard for CEO and send it via email.

Reduce the amount of data queried by archiving unused opportunity records.

To improve the dashboard performance, the data architect should use selective queries to reduce the amount of data being returned, de-normalize the data by reducing the number of joins, and reduce the amount of data queried by archiving unused opportunity records. These options will help optimize the query performance, reduce the query complexity, and free up storage space. Option C is incorrect because removing widgets from the dashboard to reduce the number of graphics loaded will not affect the dashboard performance significantly, and may reduce the usability and functionality of the dashboard. Option D is incorrect because running the dashboard for CEO and sending it via email will not improve the dashboard performance, but rather shift the burden to another user.

QUESTION 116
A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
1. Payment Providers: Orgas who pay for the care 2 patients.
2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
3. Patients: They are individuals who need care.
A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts

QUESTION 117
Salesforce is being deployed in Ursa Major Solar’s disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal? (Choose two.)

Integrate Salesforce with the ERP environment.

Utilize an MDM strategy to outline a single source of truth.

Build synchronization reports and dashboards.

Utilize workbench to update files within systems.

QUESTION 118
Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

Load all data after deferring sharing calculations.

Load all data using external IDs to link to parent records.

Use triggers to calculate summary values instead of Roll -Up.

Use workflow to calculate summary values instead of Roll -Up.

QUESTION 119
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items.
The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

Option B is the most appropriate approach for data archiving in this scenario1. By aggregating order amount data at a summary level and storing it in a custom object, you can reduce data storage and still provide visibility to the Sales Reps on how much money each customer generates year-over-year. Option A is not correct because storing data in a zip file does not make it available in Salesforce. Option C is not correct because exporting and deleting orders and order line items may lose important details that are needed for analysis or reporting. Option D is not correct because deleting orders and order line items without exporting them may cause data loss or inconsistency if the customer does not have order information in another system.

QUESTION 120
A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:
Personally, identifiable information (PII)
IP restrictions on profiles organized by Geographic location
Financial records that need to be private and accessible only by the assigned Sales associate.
User should not be allowed to export information from Salesforce.
Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose
3 answers:

Event monitoring to monitor all user activities

Restrict access to SF from users outside specific geography

Prevent Sales users access to customer PII information

Transaction security policies to prevent export of SF Data.

Encrypt Sensitive Customer information maintained in SF.

The best Salesforce Shield capabilities for the customer are to restrict access to SF from users outside specific geography, implement transaction security policies to prevent export of SF data, and encrypt sensitive customer information maintained in SF. Salesforce Shield is a set of security features that help protect enterprise data on the Salesforce platform. It includes three components: Event Monitoring, Platform Encryption, and Field Audit Trail. Restricting access to SF from users outside specific geography can be done using network-based security features, such as IP whitelisting or VPN. Transaction security policies can be used to define actions or notifications based on user behavior patterns, such as exporting data or logging in from an unknown device. Platform Encryption can be used to encrypt data at rest using a tenant secret key that is controlled by the customer.

QUESTION 121
Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

Load Contact records together using the Streaming API via the Upsert operation.

Delete all existing records, and then load all records together via the Insert operation.

Load all records via the Upsert operation to determine new records vs. existing records.

Load new records via the Insert operation and existing records via the Update operation.

Loading new records via the Insert operation and existing records via the Update operation will allow using the external ID field as a unique identifier and avoid any duplication or overwriting of records. This is faster and safer than deleting all existing records or using the Upsert operation, which might cause conflicts or errors .

QUESTION 122
Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.
What solution should a data architect recommend to meet the business requirement?

Archive records to a data warehouse and run analytics on the data warehouse.

Leverage big objects to archive records and Einstein Analytics to run reports.

Leverage custom objects to store aggregate data and run analytics.

Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.

QUESTION 123
UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.
What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

Create new fields to store additional values from all the systems.

Install a 3rd party AppExchange tool to handle the merger

Analyze each system’s data model and perform gap analysis

Utilize an ETL tool to merge, transform and de-duplicate data.

Work with Stakeholders to define record and field survivorship rules

The three key steps that a data architect should take when merging data from multiple systems into Salesforce are:
Analyze each system’s data model and perform gap analysis. This step involves understanding the structure and meaning of the data in each system, identifying the common and unique data elements, and mapping the data fields between the systems. This step also involves assessing the quality and consistency of the data, and identifying any data cleansing or transformation needs.
Utilize an ETL tool to merge, transform, and de-duplicate data. This step involves using an ETL tool to connect to the source systems, extract the data, apply any data transformations or validations, and load the data into Salesforce. This step also involves applying de-duplication rules or algorithms to avoid creating duplicate records in Salesforce.
Work with stakeholders to define record and field survivorship rules. This step involves collaborating with the business users and owners of the data to determine which records and fields should be retained or overwritten in case of conflicts or discrepancies. This step also involves defining the criteria and logic for record and field survivorship, and implementing them in the ETL tool or in Salesforce.
Creating new fields to store additional values from all the systems is not a key step, but rather a possible outcome of the gap analysis. It may not be necessary or desirable to create new fields for every value from every system, as it may result in redundant or irrelevant data. Installing a 3rd party AppExchange tool to handle the merger is not a key step, but rather a possible option for choosing an ETL tool. It may not be the best option depending on the requirements, budget, and preferences of the organization.

QUESTION 124
UC has the following system:
Billing system.
Customer support system.
CRM system.
US has been having trouble with business intelligence across the different systems. Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.
Which MDM data element is needed to allow reporting across these systems?

Global unique customer number.

Email address.

Phone number.

Full name.

The correct answer is A, global unique customer number. A global unique customer number is a data element that can uniquely identify each customer across different systems. It can be used as a key to link customer records from different sources and enable reporting across these systems. Email address, phone number, and full name are not reliable or consistent identifiers for customers, as they can change over time or be shared by multiple customers.

QUESTION 125
DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.
A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.
What are two important considerations for the Data Architect in this scenario? (Choose two.)

Limitations on Org data storage.

Bulk API limitations on picklist fields.

Limitations on master-detail relationships.

Standard list view in-line editing.

QUESTION 126
North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement?

Standard SOQL queries

Einstein Analytics

Standard reports and dashboards

Async SOQL with a custom object

QUESTION 127
Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

Analytics/BI Owners

Data Domain Stewards

Salesforce Administrators

Operational Data Users

Analytics/BI Owners and Data Domain Stewards are appropriate roles as members of a team that makes decisions on enterprise-wide data governance. Analytics/BI Owners are responsible for defining the business requirements and metrics for data analysis and reporting, and Data Domain Stewards are responsible for defining and enforcing the data quality standards and rules for specific data domains. Salesforce Administrators and Operational Data Users are not suitable roles for this team, as they are more focused on the operational aspects of data management, such as configuration, maintenance, and usage.

QUESTION 128
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID’s from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?

Create a custom object to store the master key with a lookup field to contact.

Store the master key on the contact object as an external ID (Field for referential imports)

Create an external object to store the master key with a lookup field to contact.

Store the master key in Heroku postgres and use Heroku connect for synchronization.

QUESTION 129
Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project?
Choose 2 answers

Post go -live automated page -load testing against the Salesforce Production org.

Pre -go -live unit testing in the Salesforce Full sandbox.

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

Stress testing against the web services hosted by the integration middleware.

QUESTION 130
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external ID.

To improve data quality and avoid data skew, the data architect should create a picklist field with values sorted alphabetically for tracking shipping status on opportunity. A picklist field ensures that only valid values are entered and prevents typos or variations in spelling. Sorting the values alphabetically makes it easier for users to find and select the correct value. Data skew occurs when a large number of records are owned by a single user or have a single value for a field. Creating a picklist field with a limited number of values does not cause data skew, as long as the distribution of values is balanced and not skewed towards one value.

QUESTION 131
Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

Loading …