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

The Chief Technology Officer (CTO) of Ursa Major Solar wants error messages to appear when a future date is detected in a custom AnniversaryDate_c field on the Contact object. Additionally, the CTO wants the ability to translate the error messages.

Which two approaches should an Architect use to fulfill this requirement? (Choose two.)

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.

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bidirectional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

A. Use Streaming API to get the current status from the ERP and display on the Opportunity page.

B. Create an external object Invoice _x with a Lookup relationship with Opportunity.

C. Create a custom object Invoice _c with a master -detail relationship with Opportunity.

D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

A. Salesforce allows up to four objects in a single report type.

B. Salesforce does not support Orders or Order Line Items.

C. A report cannot contain data from Accounts and Contacts.

D. Custom report types cannot contain Opportunity data.

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?

A. Missing phone number on the Contact record.

B. Customer phone number has changed on the Contact record.

C. Duplicate Contact records exist in the system.

D. Duplicate Activity records on a Contact.

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 (UC) has the following systems:

1.

Billing system

2.

Customer support system

3.

CRM system

UC has been having trouble with business intelligence across the different systems. Recently UC implemented a master data management (MDM) solution that will be the system of truth for the customer records.

Which MDM data element is needed to allow reporting across these systems?

A. Global unique customer number.

B. Email address.

C. Phone number.

D. Full name.

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. Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

B. Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

C. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

D. 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-scale system.

Universal Containers (UC) has built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the Single Source of Truth for both customers and orders. UC has asked a data architect to replicate this data into Salesforce so that Salesforce can now act as the System of Record.

What are the three considerations that a data architect should weigh before implementing this requirement? (Choose three.)

A. Consider whether the data is required for sales reports, dashboards and KPI's.

B. Determine if the data is driver of key process implemented within salesforce.

C. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

D. Ensure the data is CRM center and able to populate standard of custom objects.

E. A selection of the tool required to replicate the data.

F. -Heroku Connect is required but this is confusing

Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent

relationships in a look-up table.

What should the data architect do in order to migrate the data to Salesfoce?

A. Create custom objects to store agent relationships.

B. Migrate to Salesforce without a record owner.

C. Assign record owner based on relationship.

D. Migrate the data and assign to a non-person system user.