Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a pain point that there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?
A. Have the users manually clean the data in the old system prior to migration
B. Store the data in a staging database, and de-duplicate identical records
C. Hire an intern manually de-duplicate the records after migrating to Salesforce
D. Migrate the data as is, and use Salesforce's de-duplicating feature
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report time-outs.
What is the fastest and most effective way for a data architect to solve the time-out issue?
A. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
B. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
C. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
D. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, 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 strategy.
What are the three key steps that a data architect should take when merging data from multiple systems into Salesforce? (Choose three.)
A. Analyze each system's data model and perform gap analysis
B. Create new fields to store additional values from all of the systems
C. Install a third-party AppExchange tool to handle the merger
D. Utilize an ETL tool to migrate, transform, and deduplicate data
E. Work with stakeholders to define record and field survivorship rules
Universal Containers has a rollup summary field on account to calculate the count of contacts associated with an account. During the account load, Salesforce is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend to resolve the error?
A. Perform batch job in parallel mode, and reduce batch size
B. Defer rollup summary fields calculation during data migration
C. Leverage data loader platform API to load data
D. Perform batch job in serial mode, and reduce batch size
Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)
A. Keep the relationship fields populated with the source record IDs in the import file.
B. Create an external ID field for each object in the target org and map source record IDs to this field.
C. Replace source record IDs with new record IDs from the target org in the import file.
D. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
E. Use data loader to export the data from the source org and then import/upsert into the target org in sequential order.
Northern Trail Outfitters (NTO) need to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.
What should a data architect recommend in order to get around the time-out issue?
A. Ask Salesforce support to increase the query time-out value
B. Use extract transform tool (ETL) tool for extraction of records
C. Use Rest API to extract data as it automatically chunks records by 200
D. Use custom auto number and formula field and use that to chunk records while extracting data
Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:
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 discounts.
3.
The program generates 100 million records each month.
NTO Customer Support would like to see a summary of a customer's recent transactions and the reward level(s) they have attained.
Which solution should the data architect use to provide the information within Salesforce for the customer support agents?
A. Capture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.
B. 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-sale system.
C. Provide a button so that the agent can quickly open the point-of-sale system displaying the customer's history.
D. Create a custom object in Salesforce to capture and store all reward program, populate nightly from the point-of-sale system, and present on the Customer record.
Universal Containers is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be created and is concerned about the performance of the application.
Which three recommendations should the data architect make to avoid data skew? (Choose three.)
A. Limit associating 10,000 records looking up to same records
B. Assign 10,000 opportunities to one account
C. Limit assigning one user 10,000 records ownership
D. Use pick list fields rather than lookup to custom object
E. Limit associating 10,000 Opportunities to one account
Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription (fee)-based support.
Which license type will UC users need to fulfill UC's requirements?
A. Salesforce License
B. Lightning Platform Starter License
C. Service Cloud License
D. Sales Cloud License
Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?
A. Enable granular locking
B. Ask Salesforce support for additional CPU power
C. Remove SOQL statements from Apex Loops
D. Enable sharing recalculations
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Salesforce exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER exam preparations and Salesforce certification application, do not hesitate to visit our Vcedump.com to find your solutions here.