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.Add limit 100 to the query.
• B.Remove description from the requested field set.
• C.Change query to SOSL. ??
• D.Change the where clause to filter by a deterministic defined value.

Comment: *

Name: *

Email: *

Verification: *

DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

• A.Use the private sharing model.
• B.Use Salesforce duplicate management.
• C.Use validation rules on new record create and edit.
• D.Use workflow to delete duplicate records.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

• A.Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
• B.Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
• C.Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
• D.Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Comment: *

Name: *

Email: *

Verification: *

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.
A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.
What are two important considerations for the Data Architect in this scenario? (Choose two.)

• A.Standard list view in-line editing.
• B.Limitations on Org data storage.
• C.Bulk API limitations on picklist fields.
• D.Limitations on master-detail relationships.

Comment: *

Name: *

Email: *

Verification: *

UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?

• A.Add appropriate users to the account team.
• B.Create an owner-based sharing rule.
• C.Implicit sharing will automatically handle with standard functionality.
• D.Create a criteria-based sharing rule.

Comment: *

Name: *

Email: *

Verification: *