Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER dumps - 100% Pass Guarantee!

Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce. Which approach for data archiving is appropriate for this scenario?

A. 1. Annually export and delete order line items.

2. Store them in a zip file in case the data is needed later.

B. 1. Annually aggregate order amount data to store in a custom object.

2. Delete t

C. 1. Annually export and delete orders and order line items.

2. Store them in a zip file in case the data is needed later.

D. 1. Annually delete orders and order line items.

2. Ensure the customer has order information in another system.

Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

A. Ask support to create a skinny table for Application with the necessary reporting fields.

B. Add custom indexes to all fields on Application without a standard index.

C. Run multiple reports to get different pieces of the data and combine them.

D. Add custom indexes to the Date fields used for filtering the report.

A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

A. Import Account records first followed by order records after sorting order by OrderID.

B. Import Account records first followed by order records after sorting orders by AccountID.

C. Change the relationship to Lookup and update the relationship to master-detail after import.

D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

A. Load all data using external IDs to link to parent records.

B. Use workflow to calculate summary values instead of Roll -Up.

C. Use triggers to calculate summary values instead of Roll -Up.

D. Load all data after deferring sharing calculations.

UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing "Lock errors" consistently. What should a data architect recommend mitigate these errors?

A. Ask salesforce support for addition CPU power.

B. Enable granular locking.

C. Remove SOQL statements from APEX loops.

D. Enable sharing recalculations