Online Access Free Data-Architect Practice Test

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

Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.
What are two automated approaches to fulfill this goal? (Choose two.)

• A.Third-party Business Intelligence system
• B.Third-party Integration Tool (ETL)
• C.Apex Triggers
• D.Schedulable Batch Apex

UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?

• A.Use a custom Big object to store archived case data.
• B.Archive Case data using Salesforce Archiving process
• C.Use a custom object to store archived case data.
• D.Purchase more data storage to support case object

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

• A.Load Contact records together using the Streaming API via the Upsert operation.
• B.Load all records via the Upsert operation to determine new records vs. existing records.
• C.Load new records via the Insert operation and existing records via the Update operation.
• D.Delete all existing records, and then load all records together via the Insert operation.

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.
Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

• A.Salesforce handles the assignment of orders automatically and there is no performance impact.
• B.Create a role at top of role hierarchy and assign the role to the generic user.
• C.Clear the role field in the generic user record.
• D.Create a pool of generic users and distribute the assignment of memory to the pool of users.