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.Run multiple reports to get different pieces of the data and combine them.
• B.Ask support to create a skinny table for Application with the necessary reporting fields.
• C.Add custom indexes to all fields on Application without a standard index.
• D.Add custom indexes to the Date fields used for filtering the report.

Comment: *

Name: *

Email: *

Verification: *

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in salesforce.

• A.Activate validation rules once the leads are loaded into salesforce to maintain quality.
• B.Develop custom APEX batch process to improve quality once the load is completed.
• C.Allow validation rules to be activated during the load of leads into salesforce.
• D.Ensure the lead data is preprocessed for quality before loading into salesforce.

Comment: *

Name: *

Email: *

Verification: *

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

• A.Defer sharing calculations until the data has finished uploading.
• B.Create the users, upload all data, and then deploy the sharing rules.
• C.First, load all account records, and then load all user records.
• D.Contact Salesforce to activate indexing before uploading the data.

Comment: *

Name: *

Email: *

Verification: *

Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

• A.Ask sales people to search for populating company profile and location data
• B.Run reports to identify records which does not have company profile and location data
• C.Leverage external data providers populate company profile and location data
• D.Export data out of Salesforce and send to another team to populate company profile and location data

Comment: *

Name: *

Email: *

Verification: *

To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:
Data owner
Security Level, such as confidential
Compliance types such as GDPR, PII, HIPPA
A compliance audit would require SF admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?

• A.Create a custom object and field to capture necessary compliance information and build custom reports.
• B.Use metadata API, to extract field attribute information and use the extract to classify and build reports
• C.Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
• D.Build reports for field information, then export the information to classify and report for Audits.

Comment: *

Name: *

Email: *

Verification: *