Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system.
They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

• A.Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
• B.Create a report combining data from the Account standard object and the Invoices external object.
• C.Create a Visualforce page combining Salesforce Account data and Invoice external object data.
• D.Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

Comment: *

Name: *

Email: *

Verification: *

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.Bring all data Salesforce, and delete it after a year.
• B.Leverage mashup to display historical records in Salesforce.
• C.Build a chair solution to go the legacy system and display records.
• D.Leverage real-time integration to pull records into Salesforce.

Comment: *

Name: *

Email: *

Verification: *

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

• A.Use SOQL queries without WHERE conditions.
• B.Work with Salesforce Support to enable Skinny Tables.
• C.Reduce the number of triggers on Order _c object.
• D.Make the queries more selective using indexed fields.

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

• A.Review projected data storage needs.
• B.Reduce data storage by purging old data.
• C.Implement an AppExchange package.
• D.Schedule a weekly export file.

Comment: *

Name: *

Email: *

Verification: *