Data-Architect Practice Test

A company has 12 million records, and a nightly integration queries these records. Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

A.

Make sure the query doesn't contain NULL in any filter criteria.

B.

Create a formula field instead of having multiple filter criteria.

C.

Create custom indexes on the fields used in the filter criteria.

D.

Modify the integration users' profile to have View All Data.

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

A.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

B.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Universal Containers (UC) uses the following Salesforce products:
Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

A.

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;

B.

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

C.

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

D.

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

NTO has a loyalty program to reward repeat customers. The following conditions exists:
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 discount.
3.The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the 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) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

A.

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B.

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.