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 Data Architect(Salesforce ARC?201) Mock Test Q&A | 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
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?
A. Archive records to a data warehouse and run analytics on the data warehouse
B. Leverage big objects to archive records and Einstein Analytics to run reports
C. Leverage custom objects to store aggregate data and run analytics
D. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object
View answer
Correct Answer: B
Question #2
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
A. Errors with duplicate external Id values within the same CSV file
B. Errors with records being updated and inserted in the same CSV file
C. Errors when a duplicate Contact name is found cause upsert to fail
D. Errors with using the wrong external Id will cause the load to fail
View answer
Correct Answer: A
Question #3
Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.Which two actions should Cloud Kicks take to improve data quality? (Choose two.)
A. Change each address field to require on the Page Layout
B. Write an Apex Trigger to require all fields to be populated
C. Utilize a Validation Rule with a REGEX operator on Postal Code
D. Utilize a Validation Rule with a CONTAINS operator on address fields
View answer
Correct Answer: CD
Question #4
Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
A. Use SOQL queries without WHERE conditions
B. Work with Salesforce Support to enable Skinny Tables
C. Reduce the number of triggers on Order _c object
D. Make the queries more selective using indexed fields
View answer
Correct Answer: BD
Question #5
A customer needs a sales model that allows the following:Opportunities need to be assigned to sales people based on the zip code. Each sales person can be assigned to multiple zip codes. Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.What should a data architect recommend?
A. Assign opportunities using list views using zip code
B. Add custom fields in opportunities for zip code and use assignment rules
C. Allow sales users to manually assign opportunity ownership based on zip code
D. Configure territory management feature to support opportunity assignment
View answer
Correct Answer: D
Question #6
Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?
A. Use Field Audit History to capture operational data and extract it to on-premise systems
B. Use Weekly Export to extract transactional data to on-premise systems
C. Use a custom built extract job to extract operational data to on-premise systems
D. Use Event Monitoring to extract event data to on-premise systems
View answer
Correct Answer: BD
Question #7
An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers
A. Implement a third -party validation process with translate functionality
B. Create a trigger on Contact and add an error to the record with a custom label
C. Create a workflow field update to set the standard ErrorMessage field
D. Create a validation rule and translate the error message with translation workbench
View answer
Correct Answer: BD
Question #8
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?
A. Load Contact records together using the Streaming API via the Upsert operation
B. Delete all existing records, and then load all records together via the Insert operation
C. Load all records via the Upsert operation to determine new records vs
D. Load new records via the Insert operation and existing records via the Update operation
View answer
Correct Answer: D

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.