DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Answers

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.

Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

A. Implement a Master Data Management system to determine system of record.

B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.

C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.

A company wants to document the data architecture of a Salesforce organization. What are two valid metadata types that should be included? (Choose two.)

A. RecordType

B. Document

C. CustomField

D. SecuritySettings

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records. An Architect has been tasked with optimizing the data load time. What should the Architect consider to achieve this goal?

A. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

B. Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C. Load the data in multiple sets using Bulk API parallel processes.

D. Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

A. Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

C. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

D. Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Which three characteristics of a Skinny table help improve report and query performance?

A. Skinny tables can contain frequently used fields and thereby help avoid joins.

B. Skinny tables can be used to create custom indexes on multi-select picklist fields.

C. Skinny tables provide a view across multiple objects for easy access to combined data.

D. Skinny tables are kept in sync with changes to data in the source tables.

E. Skinny tables do not include records that are available in the recycle bin.

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

A. Contact each business on the list and ask them to review and update their address information.

B. Build a team of employees that validate Accounts by searching the web and making phone calls.

C. Integrate with a third-party database or services for address validation and enrichment.

D. Leverage Data.com Clean to clean up Account address fields with the DandB database.

Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

A. Use the Account object with Person Accounts and a new B2C page layout.

B. Use the Account object with a newly created Record Type for B2C customers.

C. Create a new picklist value for B2C customers on the Account Type field.

D. Use 50 umbrella Accounts for each region, with customers as associated Contacts.

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 Container (UC) is migrating data from legacy system to Salesforce. UC would like to preserve the following information on records being migrated:

1.

Date time stamps for created date and last modified date.

2.

Ownership of records belonging to inactive users being migrated to Salesforce.

Which two solutions should a data architect recommend to preserve date timestamps and ownership on records? (Choose two.)

A. Log a case with SF to update these fields

B. Enable update records with Inactive Owners Permission

C. Enable Set Audit fields upon Record Creation Permission

D. Enable modify all and view all permission.

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA in APAC orgs after the products are approved.

Which two features should a data architect recommend to share records between Salesforce orgs? (Choose two.)

A. Change data capture (CDC)

B. Salesforce connect.

C. Federation search D. Salesforce 2 Salesforce

Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information stored in Salesforce.

Which solution should the data architect use to reduce the amount of returned mail?

A. Use a 3rd party data source to update contact information in salesforce.

B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

C. Delete contacts when the mail is returned to save postal cost to NTO.

D. Have the sales team to call all existing customers and ask to verify the contact details.

UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data. What should a data architect recommend to reduce the performance degradation of the platform?

A. Create a custom object to store the data.

B. Use a standard big object defined by salesforce.

C. Use the standard "Order" object to store the data.

D. Implement a custom big object to store the data.

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have

an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out

of Salesforce.

Which solution should a data architect recommend as an archiving solution?

A. Use a third-party backup solution to backup all data off platform.

B. Build a batch join move all records off platform, and delete all records from Salesforce.

C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

D. Build a batch job to move all restore off platform, and delete old records from Salesforce.

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