A large retail company has recently chosen SF as its CRM solution. They have the following record counts:
2500000 accounts
25000000 contacts
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.
What should a data architect do to solve the performance issue?

• A.Create a skinny table to represent account and contact objects.
• B.Limit data loading to the 2000 most recently created records.
• C.Load only the data that the users is permitted to access
• D.Add custom indexes on frequently searched account and contact objects fields

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?

• A.Write an Apex callout and populate a related list to display on the account record.
• B.Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
• C.Create a mashup page that will present the billing system records within Salesforce.
• D.Create a visual force tab with the billing system encapsulated within an iframe.

Comment: *

Name: *

Email: *

Verification: *

NTO has implemented salesforce for its sales users. The opportunity management in salesforce 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 opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the 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 overriding issue?

• A.Change PPS integration to update only opportunity amount fields when values is NULL.
• B.Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.
• C.Change opportunity amount field access to read only for sales users using field level security.
• D.Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

• A.Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
• B.Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
• C.Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
• D.Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.

Comment: *

Name: *

Email: *

Verification: *

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 Lookup to custom object ShippingStatus c.
• B.Create a picklist field, values sorted alphabetically.
• C.Create a text field and make it an external ID.
• D.Create a Master -Detail to custom object ShippingStatus c.

Comment: *

Name: *

Email: *

Verification: *