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

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.

A company needs to track field history on 50 Opportunity fields.

Which two actions can be taken to accomplish this goal? (Choose two.)

A. Store a copy of the record when changed by using Analytic Snapshots.

B. Create a custom object to store the previous and new field values.

C. Select the 50 fields in the Opportunity Set History Tracking page.

D. Create a custom object to store a copy of the record when changed.

A customer needs a sales model that allows the following:

1.

Opportunities need to be assigned to sales people based on the zip code.

2.

Each sales person can be assigned to multiple zip codes.

3.

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.

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updates by users. A majority of the automation tool within UC'' org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?

A. Ensure validation rules, triggers and other automation tools are disabled.

B. Ensure duplication and matching rules and defined.

C. Import the data in smaller batches over a 24-hour period.

D. Bulkily the trigger to handle import leads.

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect

1.

The data model for Org B will drastically change with different objects, fields, and picklist values.

2.

Three million records will need to be migrated from org A to org B for compliance reasons.

3.

The migrate will need occur within the next two month, prior to be split.

Which migrate strategy should a data architect use to successfully migrate the date?

A. use as ETL tool to orchestrate the migration.

B. Use Data Loader for export and Data Import Wizard for import

C. Write a script to use the Bulk API

D. Use the Salesforces CLI to query, export, and import

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a

custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and

adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

A. Service Cloud

B. Sales Cloud

C. Light Platform Start

D. Lighting platform plus

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement?

A. Standard reports and dashboards

B. Async SOQL with a custom object

C. Standard SOQL queries D. Einstein Analytics

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.