DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Salesforce ARC?201 Exam Questions and Answers, Salesforce Data Architect | SPOTO

SPOTO's latest exam dumps on the homepage, with a 100% pass rate! SPOTO delivers authentic Cisco CCNA, CCNP study materials, CCIE Lab solutions, PMP, CISA, CISM, AWS, and Palo Alto exam dumps. Our comprehensive study materials are meticulously aligned with the latest exam objectives. With a proven track record, we have enabled thousands of candidates worldwide to pass their IT certifications on their first attempt. Over the past 20+ years, SPOTO has successfully placed numerous IT professionals in Fortune 500 companies.
Take other online exams
Question #1
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.What should a data architect recommend for a daily backup and restore solution?
A. Use AppExchange package for backup and restore
B. Use ETL for backup and restore from EDW
C. Use Bulk API to extract data on daily basis to EDW and REST API for restore
D. Change weekly backup process to daily backup, and implement a custom restore solution
View answer
Correct Answer: A
Question #2
Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?
A. Enable field history tracking on the Case object
B. Create a report on Case analytic snapshots
C. Install AppExchange packages for available reports
D. Create Contact and Opportunity Reports and Dashboards
View answer
Correct Answer: A
Question #3
Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes. 2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis. 3. PPS is the trusted source within NTO for Opportunity Amount. 4. NTO uses Opportunity Forecast for its sales planning and management. Sales
A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates
B. Change PSS integration to update only Opportunity Amount field when the value is null
C. Change Opportunity Amount field access to Read Only for sales users field-level security
D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates
View answer
Correct Answer: C
Question #4
Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers
A. Use a workflow to check and prevent duplicates
B. Clean data before importing to Salesforce
C. Use Salesforce matching and duplicate rules
D. Import the data concurrently
View answer
Correct Answer: BC
Question #5
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?
A. Create a picklist field, values sorted alphabetically
B. Create a Master -Detail to custom object ShippingStatus c
C. Create a Lookup to custom object ShippingStatus c
D. Create a text field and make it an external ID
View answer
Correct Answer: A
Question #6
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 informati
A. Create a custom object in salesforce to capture and store all reward program
B. 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
C. Provide a button so that the agent can quickly open the point of sales system displaying the customer history
D. 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
View answer
Correct Answer: D
Question #7
Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?
A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes
B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on- premise systems
C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed
D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc
View answer
Correct Answer: D
Question #8
UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.Which design patterns should a data architect select to satisfy the requirement?
A. Migrate and persist the data in SF to take advantage of native functionality
B. Use SF Connect to virtualize the data in SF and avoid storage limits
C. Develop a bidirectional integration between the on-premise system and Salesforce
D. Build a UI for the on-premise system and iframe it in Salesforce
View answer
Correct Answer: B
Question #9
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?
A. Create a custom object to store aggregate data and run reports
B. Contact Salesforce support to enable skinny table for cases
C. Move data off of the platform and run reporting outside Salesforce, and give access to reports
D. Build reports using custom Lightning components
View answer
Correct Answer: B
Question #10
Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers
A. Index key fields used in report criteria
B. Enable Divisions for large data objects
C. Create one skinny table per report
D. Share each report with fewer users
View answer
Correct Answer: AC
Question #11
Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.What should a data architect recommend to guarantee that records are not being updated at the same time?
A. Embed the keywords FOR UPDATE after SOQL statements
B. Disable classes or triggers that have the potential to obtain the same record
C. Migrate programmatic logic to processes and flows
D. Refactor or optimize classes and trigger for maximum CPU performance
View answer
Correct Answer: A
Question #12
A large retail company has recently chosen SF as its CRM solution. They have the following record counts:2500000 accounts 25000000 contactsWhen doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.What should a data architect do to solve the performance issue?
A. Load only the data that the users is permitted to access
B. Add custom indexes on frequently searched account and contact objects fields
C. Limit data loading to the 2000 most recently created records
D. Create a skinny table to represent account and contact objects
View answer
Correct Answer: B
Question #13
What should a data architect do to provide additional guidance for users when they enter information in a standard field?
A. Provide custom help text under field properties
B. Create a custom page with help text for user guidance
C. Add custom help text in default value for the field
D. Add a label field with help text adjacent to the custom field
View answer
Correct Answer: A
Question #14
Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.An Architect needs to determine which system is the system of record on a field level.What should the Architect do to achieve this goal?
A. Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system
B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce
C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce
D. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record
View answer
Correct Answer: B
Question #15
Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?
A. Use triggers to populate denormalized related fields on the Account
B. Use an indexed data field with bounded data filters
C. Use Formula fields to surface information I related entities on the report
D. Use unbounded date ranges to filter the report
View answer
Correct Answer: BC
Question #16
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.H
A. Store the master key in Heroku postgres and use Heroku connect for synchronization
B. Create a custom object to store the master key with a lookup field to contact
C. Create an external object to store the master key with a lookup field to contact
D. Store the master key on the contact object as an external ID (Field for referential imports)
View answer
Correct Answer: D
Question #17
A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM:Local dealers Regional distributor State distributor Service dealerThe attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.How should the different dealers be maintained in Salesforce?
A. Use Accounts for dealers, and create record types for each of the dealer types
B. Create dealers as Accounts, and build custom views for each of the dealer types
C. Use Accounts for dealers and custom picklist field for each of the dealer types
D. Create Custom objects for each dealer types and custom fields for dealer attributes
View answer
Correct Answer: A

View The Updated Salesforce Exam Questions

SPOTO Provides 100% Real Salesforce Exam Questions for You to Pass Your Salesforce Exam!

Get Salesforce Practice Test

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.