[Oct-2025] Data-Architect Exam Questions and Valid Data-Architect Dumps PDF [Q65-Q89]

QUESTION 65
Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.
Which option should the data architect recommend NTO to satisfy this requirement?

Create custom fields for contact preferences in Lead, Person Account, and Users objects.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

QUESTION 66
Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

Use the Excel connector to Salesforce to sync data from individual Excel files.

Define a standard mapping and train sales users to import opportunity data.

Load data in external database and provide access to database to sales users.

Create a chatter group and upload all Excel files to the group.

QUESTION 67
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

Create a custom object to store aggregate data and run reports.

Contact Salesforce support to enable skinny table for cases.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

Build reports using custom Lightning components.

According to the Salesforce documentation1, reporting performance can be affected by various factors, such as the volume and complexity of data, the design and configuration of reports and dashboards, the number and type of users accessing the reports, etc. To improve reporting performance, some of the recommended solutions are:
Move data off of the platform and run reporting outside Salesforce, and give access to reports (option C). This means using an external service or tool that can extract, transform, and load (ETL) data from Salesforce to another system or database, such as a data warehouse or a business intelligence platform. This can improve reporting performance by reducing the load and latency on Salesforce, and enabling faster and more flexible reporting and analysis on the external system. Users can access the reports from the external system using a link or an embedded component in Salesforce.
Contact Salesforce support to enable skinny table for cases (option B). This means requesting Salesforce to create a custom table that contains a subset of fields from the Case object that are frequently used or queried. A skinny table can improve reporting performance by avoiding joins between standard and custom fields, omitting soft-deleted records, and leveraging indexes on the fields2.
Create a custom object to store aggregate data and run reports (option A). This means creating a custom object that contains summary or calculated data from the Case object, such as counts, sums, averages, etc. A custom object can improve reporting performance by reducing the number of records and fields that need to be queried and displayed.
Build reports using custom Lightning components (option D). This means creating custom components that use Lightning Web Components or Aura Components frameworks to display report data in Salesforce. A custom component can improve reporting performance by using client-side caching, pagination, lazy loading, or other techniques to optimize data rendering and interaction.

QUESTION 68
A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?

Create duplicate rules in SF to validate duplicates during the account creation process

Implement a MDM solution to validate the customer information before creating Accounts in SF.

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

Customize Account creation process to search if customer exists before creating an Account.

QUESTION 69
Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.
Which two tools should a data architect use to build custom object?

Use DX to create big object.

Go to Big Object In setup select new to create big object.

Go to Object manager In setup and select new to create big object.

Use Metadata API to create big object.

QUESTION 70
NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

QUESTION 71
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week’s worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)

Workflow rule limits

Webservice callout limits

Data storage limits

API Request limits

QUESTION 72
UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:

Leverage on premise data archival and build integration to view archived data.

Create a custom object to store case history and run reports on it.

Export data out of salesforce and store in Flat files on external system.

Leverage big object to archive case data and lightning components to show archived data.

QUESTION 73
Universal Containers (UC) uses the following Salesforce products:
Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.
What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications;

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

According to the Salesforce documentation4, Marketing Cloud is a platform that allows creating and managing marketing campaigns across multiple channels, such as email, mobile, social media, web, etc. Marketing Cloud can integrate with Sales Cloud and other Salesforce products to share data and insights. One of the ways to integrate Marketing Cloud with Sales Cloud is using Marketing Cloud Connect5, which allows syncing data between the two platforms using synchronized data sources.
However, if UC occasionally gets a list of prospects from third-party sources as CSV files for marketing purposes, it may not be necessary or efficient to load them into Sales Cloud first and then sync them with Marketing Cloud. This can consume large amounts of storage in Sales Cloud, which has a limit based on the license type6. It can also cause data quality issues, such as duplicates or outdated information.
A better option for UC is to load the contacts directly to Marketing Cloud using Import Definition, which allows importing data from external files or databases into Marketing Cloud data extensions. Data extensions are custom tables that store marketing data in Marketing Cloud. This way, UC can avoid storage issues in Sales Cloud and optimize the marketing process by sending marketing communications directly from Marketing Cloud.
To track prospects that are converted to customers, UC can have a reconciliation process that compares the contacts in Marketing Cloud with the accounts or contacts in Sales Cloud. This can be done using SQL queries or API calls to access and compare data from both platforms. Alternatively, UC can use Marketing Cloud Connect to sync the converted contacts from Sales Cloud to Marketing Cloud using synchronized data sources.
Loading the CSV files in Einstein Analytics and syncing with Marketing Cloud prior to sending marketing communications (option A) is not a good option, as it can add unnecessary complexity and latency to the process. Einstein Analytics is a platform that allows creating and analyzing data using interactive dashboards and reports. It is not designed for importing and exporting data for marketing purposes.
Loading the CSV files in an external database and syncing with Marketing Cloud prior to sending marketing communications (option B) is also not a good option, as it can incur additional costs and maintenance for the external database. It can also introduce data security and privacy risks, as the data may not be encrypted or protected by Salesforce.
Continuing to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete (option D) is not a good option, as it can cause performance issues and data loss. Deleting Lead records from Sales can affect reporting and auditing, as well as trigger workflows and validations that may not be intended. It can also cause data inconsistency and synchronization errors between Sales Cloud and Marketing Cloud.

QUESTION 74
A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer
2. Salesforce; All customer service activity and sales activities for a customer
3. Mobile app: All bookings, preferences, and browser activity for a customer
4. Marketing: All email, SMS, and social campaigns for a customer
Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?

Explore external data sources in Salesforce to build a 360-degree view of the customer.

Use a customer data mart to create the 360-degree view of the customer.

Periodically upload summary information in Salesforce to build a 360-degree view.

Migrate customer activities fro, all four system into Salesforce.

QUESTION 75
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

QUESTION 76
Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., “John Doe” in the OMS and “Johnny Doe” in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

QUESTION 77
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

QUESTION 78
Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat a. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

The Opportunity engagement system should become the system of record for Opportunity records.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

QUESTION 79
Universal Container require all customers to provide either a phone number of an email address when registering for an account.
What should the data architect use to ensure this requirement is met?

validation Rule

required Fields

Apex Class

Process Builder

QUESTION 80
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 81
A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Run key reports to determine what fields should be required.

Review the metadata xml files for redundant fields to consolidate.

Review the sharing model to determine impact on duplicate records.

Determine if any integration points create records in Salesforce.

Export the setup audit trail to review what fields are being used.

QUESTION 82
UC is planning a massive SF implementation with large volumes of data. As part of the org’s implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?

Enable defer sharing calculations, and suspend sharing rule calculations

Load the data through data loader, and turn on parallel processing.

Leverage the Bulk API and concurrent processing with multiple batches

Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error.

QUESTION 83
Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.
What is the correct solution for ensuring all systems using customer data are kept up to date?

Send customer data nightly to the system of truth in a scheduled batch job.

Send customer record changes from Salesforce to each system in a nightly batch job.

Send customer record changes from Salesforce to the system of truth in real time.

Have each system pull the record changes from Salesforce using change data capture.

QUESTION 84
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 85
What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Reference data policy.

Data governance policy.

Data sensitivity level

Compliance categorization policy.

QUESTION 86
Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

Use the Excel connector to Salesforce to sync data from individual Excel files.

Define a standard mapping and train sales users to import opportunity data.

Load data in external database and provide access to database to sales users.

Create a chatter group and upload all Excel files to the group.

QUESTION 87
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Add description fields to explain why the field is used, and mark the field as required.

Create validation rules with error messages to explain why the fields is used

QUESTION 88
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 89
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.