The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatID field:
Select id, description, Subject from Task where WhatId!= NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

• A.Remove description from the requested field set.
• B.Change query to SOSL.
• C.Add limit 100 to the query.
• D.Change the where clause to filter by a deterministic defined value.

Comment: *

Name: *

Email: *

Verification: *

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project__ c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.
3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record.
4. Managers must see total hours volunteered while viewing the Project__ c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

• A.Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.
• B.Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.
• C.Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
• D.Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

• A.Create a custom object Invoice _c with a master -detail relationship with Opportunity.
• B.Create a custom object Invoice _c with a Lookup relationship with Opportunity.
• C.Use Streaming API to get the current status from the ERP and display on the Opportunity page.
• D.Create an external object Invoice _x with a Lookup relationship with Opportunity.

Comment: *

Name: *

Email: *

Verification: *

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 those orders and order line items.
• 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.

Comment: *

Name: *

Email: *

Verification: *

DreamHouse Realty 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.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

• A.Load all data after deferring sharing calculations.
• B.Calculate summary values instead of Roll-Up by using workflow.
• C.Calculate summary values instead of Roll-Up by using triggers.
• D.Load all data using external IDs to link to parent records.

Comment: *

Name: *

Email: *

Verification: *