[Dec-2024] Salesforce Data-Architect Exam Practice Test Questions – SurePassExams [Q72-Q91]

5/5 - (1 vote)

[Dec-2024] Salesforce Data-Architect Exam Practice Test Questions – SurePassExams

Updated Certification Exam Data-Architect Dumps – Practice Test Questions

Salesforce Data-Architect (Salesforce Certified Data Architect) Certification Exam is a challenging but rewarding certification that validates the knowledge and skills of professionals who work with Salesforce data architecture. It is a highly respected credential in the industry and is recognized by employers as a mark of excellence. If you are looking to advance your career in the Salesforce ecosystem, this certification is definitely worth considering.

NO.72 A large insurance provider is looking to implement Salesforce. The following exist.
1. Multiple channel for lead acquisition
2. Duplication leads across channels
3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Build process is manually search and merge duplicates.

Standard lead information across all channels.

Build a custom solution to identify and merge duplicate leads.

Implement third-party solution to clean and event lead data.

Implement de-duplication strategy to prevent duplicate leads

NO.73 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.

NO.74 Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.
Which Salesforce Connect procedure should a data architect use to ensure UC’s requirements are met?

Write an Apex class that makes a REST callout to the external API.

Develop a process that calls an inviable web service method.

Migrate the data to Heroku and register Postgres as a data source.

Write a custom adapter with the Apex Connector Framework.

NO.75 Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?

Update the Opportunity page layout to mark these fields as required.

Use a validation rule for each field that takes the Stage into consideration.

Update these Opportunity field definitions in Setup to be required.

Write an Apex trigger that checks each field when records are saved.

NO.76 During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in salesforce?

Us custom objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Use external objects to maintain Sales Order in Salesforce.

Use Standard order object to maintain Sale Orders in Salesforce

NO.77 NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?
Choose 3 answers:

Create a 2nd system Admin user for authentication to the external source.

Develop an object relationship strategy.

Identify the external tables to sync into external objects

Assess whether the external data source is reachable via an ODATA endpoint.

Configure a middleware tool to poll external table data

NO.78 Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?

Build a chair solution to go the legacy system and display records.

Leverage mashup to display historical records in Salesforce.

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

NO.79 Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.
First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.
What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.

Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.

Create a custom object to track shipment requests and a child custom object to track shipment items.
Implement an archiving process that moves data off-platform after three years.

Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.

NO.80 NTO has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, opportunity data and order data are available to authenticated users.
3. Authenticated users many need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which community cloud license type should a data architect recommend to meet the portal requirements?

Customer community plus.

Lightning external apps starter.

Customer community.

Partner community.

NO.81 Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.
Which solution should a data architect recommend to remediate the duplication issue?

Develop an ETL process that utilizers the merge API to merge the duplicate records

Utilize a data warehouse as the system of truth

Extract the data using data loader and use excel to merge the duplicate records

Implement duplicate rules

NO.82 Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.
What should a data architect do in order to restore the issue?

Enable parallel sharing rule calculation.

Enable granular locking

Enable defer sharing calculation

Enable implicit sharing

NO.83 Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

NO.84 Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?

Use Bulk API parallel mode for data migration

Use Bulk API serial mode for data migration

Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

Change the lookup configuration to “Clear the value of this field” when lookup record is deleted.

NO.85 DreamHouse Realty 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.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

Load all data after deferring sharing calculations.

Calculate summary values instead of Roll-Up by using workflow.

Calculate summary values instead of Roll-Up by using triggers.

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

NO.86 Universals Containers’ system administrators have been complaining that they are not able to make changes to its users’ record, including moving them to new territories without getting “unable to lock row” errors. This is causing the system admins to spend hours updating user records every day.
What should the data architect do to prevent the error?

Reduce number of users updated concurrently.

Enable granular locking.

Analyze Splunk query to spot offending records.

Increase CPU for the Salesforce org.

NO.87 Universal Containers (UC) is transitioning from Classic to Lightning Experience.
What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

Add Notes and Attachments Related List to page Layout in Lighting Experience.

Manually upload Notes in Lighting Experience.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

Manually upload Attachments in Lighting Experience.

NO.88 A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
State in which the customer is located
City in which the customer is located if available
Zip code In which the customer is located if available
Changes to this information should have minimum code changes
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Create a custom object to maintain the pricing criteria.

Configure the pricing criteria in price books.

Assign the pricing criteria within customer pricing engine.

Maintain require pricing criteria in custom metadata types.

NO.89 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.

NO.90 Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

NO.91 Which two best practices should be followed when using SOSL for searching?

Use searches against single Objects for greater speed and accuracy.

Keep searches specific and avoid wildcards where possible.

Use SOSL option to ignore custom indexes as search fields are pre-indexed.

Use Find in “ALL FIELDS” for faster searches.