DATA-ARCHITECT Online Practice Questions and Answers

Universal Container (US) is replacing a home-grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.

Which solution should a data architect recommend to meet business requirement?

A. Leverage real-time integration to pull records into Salesforce.

B. Bring all data Salesforce, and delete it after a year.

C. Leverage mashup to display historical records in Salesforce.

D. Build a chair solution to go the legacy system and display records.

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.

Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.

First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.

What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

A. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.

B. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku's Postgres database.

C. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.

D. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.

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.

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.

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

A. Export in multiple batches

B. Export Bulk API in parallel mode

C. Use PK Chunking

D. Limit Batch to 10K records

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

A. Use third-party AppExchange tools to monitor and measure data quality.

B. Generate reports to view the quality of sample data.

C. Use custom objects and fields to calculate data quality.

D. Export the data to an enterprise data warehouse and use BI tools for data quality.

Which two statements are accurate with respect to performance testing a Force.com application?

A. All Force.com applications must be performance tested in a sandbox as well as production.

B. A performance test plan must be created and submitted to Salesforce customer support.

C. Applications with highly customized code or large volumes should be performance tested.

D. Application performance benchmarked in a sandbox can also be expected in production.

Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders.

What should be used to mitigate this problem?

A. Work Flow Rules

B. Formatted Fields

C. Apex Trigger

D. Validation Rules

An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution?

Choose 2 answers

A. Whether the systems are cloud -based or on -premise.

B. Whether or not Salesforce replaced a legacy CRM.

C. Whether the system of record changes for different tables.

D. The number of systems that are integrating with each other.