DATA-ARCHITECT Online Practice Questions and Answers

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

A. Index key fields used in report criteria.

B. Enable Divisions for large data objects.

C. Create one skinny table per report.

D. Share each report with fewer users.

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

A. Review the time zones of the User loading the data.

B. Remove custom indexes on the data being loaded.

C. Determine if the legacy system is still in use.

D. Defer sharing calculations of the Salesforce Org.

E. Deactivate approval processes and workflow rules.

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.

NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

A. Metadata API

B. Tooling API

C. Bulk API in serial mode

D. SOAP API

UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?

A. Create a criteria-based sharing rule.

B. Implicit sharing will automatically handle with standard functionality.

C. Add appropriate users to the account team.

D. Create an owner-based sharing rule.

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

1.

State in which the customer is located

2.

City in which the customer is located if available

3.

Zip code In which the customer is located if available

4.

Changes to this information should have minimum code changes

What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

A. Create a custom object to maintain the pricing criteria.

B. Assign the pricing criteria within customer pricing engine.

C. Maintain require pricing criteria in custom metadata types.

D. Configure the pricing criteria in price books.

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

Which solution should a data architect use to comply with the DR policy?

A. Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

B. Leverage salesforce weekly exports, and store data in Flat files on a protected system.

C. Utilize an ETL tool to migrate data to an on-premise archive solution.

D. Write a custom batch job to extract data changes nightly, and store in an external protected system.

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) 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.

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:

1.

Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.

2.

NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.

3.

PPS is the trusted source within NTO for Opportunity Amount.

4.

NTO uses Opportunity Forecast for its sales planning and management.

Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.

How should a data architect address this overwriting issue?

A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.

B. Change PSS integration to update only Opportunity Amount field when the value is null.

C. Change Opportunity Amount field access to Read Only for sales users field-level security.

D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.