UC has a variety of systems across its technology landscape, including SF, 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 (MDM) strategy. What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:
A. Create new fields to store additional values from all the systems.
B. Install a 3rd party AppExchange tool to handle the merger
C. Analyze each system's data model and perform gap analysis
D. Utilize an ETL tool to merge, transform and de-duplicate data.
E. Work with Stakeholders to define record and field survivorship rules
NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records. What should a data architect recommend in order to get around the time out issue?
A. Use a custom auto number and formula field and use that to chunk records while extracting data.
B. The REST API to extract data as it automatically chunks records by 200.
C. Use ETL tool for extraction of records.
D. Ask SF support to increase the query timeout value.
Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purpose.
What solution should a data architect recommend?
A. Archive Case data using Salesforce Archiving process
B. Purchase more data storage to support case object
C. Use a custom object to store archived case data.
D. Use a custom Big object to store archived case data.
A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:
1.
2,500,000 Accounts
2.
25,000,000 Contacts
When 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 issues?
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.
Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profiles and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?
A. Ask sales people to search for populating company profile and location data
B. Run reports to identify records which does not have company profile and location data
C. Leverage external data providers populate company profile and location data
D. Export data out of Salesforce and send to another team to populate company profile and location data
Universal Containers has a classic encryption for custom fields and is leveraging weekly data export for data backups. During the data validation of exported data, UC discovered that encrypted field values are still being exported as part of the data export.
What should a data architect recommend to make sure decrypted values are exported during data export?
A. Set up a custom profile for data migration user, and assign View Encrypted Data
B. Set up a standard profile for data migration user, and assign View Encrypted Data
C. Create another field to copy data from encrypted field, and use this field in export
D. Leverage Apex class to decrypt data before exporting it
A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. 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?
A. Create duplicate rules in SF to validate duplicates during the account creation process
B. Implement a MDM solution to validate the customer information before creating Accounts in SF.
C. Build Custom search based on fields on Accounts which can be matched with customer when they visit the store
D. Customize Account creation process to search if customer exists before creating an Account.
Universal Containers has been using Salesforce for 10 years. Lately, users have noticed that the pages
load slowly when viewing customer and account list views.
To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.
Which two tasks are required to define the strategy? (Choose two.) Which 2 tasks are required to define
the strategy? Choose 2 answers:
A. Identify the recovery point objective.
B. Identify how the archive data will be accessed and used.
C. Identify the recovery time objective.
D. Identify the data retention requirements
Northern Trail Outfitters (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 Salesforce.
The sales team at NTO is 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 Salesforce Connect and the concept of data virtualization.
Which three key considerations are needed prior to a Salesforce Connect implementation? (Choose three.)
A. Identify the external tables to sync into external objects.
B. Assess whether the external data source is reachable via an OData endpoint.
C. Configure a middleware tool to poll external table data.
D. Develop an object relationship strategy.
E. Create a second system admin user for authentication to the external source.
To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following:
1.
Data owner
2.
Security level, such as confidential
3.
Compliance type such as GDPR, PII, HIPAA
A compliance audit would require Salesforce admins to generate reports to manage compliance.
What should a data architect recommend to address his requirement?
A. Use metadata API, to extract field attribute information and use the extract to classify and build reports
B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
C. Create a custom object and field to capture necessary compliance information and build custom reports.
D. Build reports for field information, then export the information to classify and report for Audits.
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.