Data architect

Universal Containers has a requirement to store more than 100 million records in Salesforce and needs to create a custom big object to support this business requirement. Which two tools should a data architect use to build custom big object? Choose 2 answers

• Use Metadata API to create big object.

• Go to Big Object in Setup and select new to create big object

• Use DX to create big object

• Go to Object Manager in Setup and select new to create big object.

Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationships in a look-up table. What should the data architect do in order to migrate the data to Salesforce?

• Migrate the data and assign to a non-person system user.

• Create custom object to store agent relationships.

• Assign record owners based on relationship.

• Migrate to Salesforce without a record owner.

A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities: 1. Distributors create Sales Orders in Salesforce. 2. Sales Orders are based on Product prices applicable to their region. 3. Sales Orders are closed once they are fulfilled. 4. It is decided to maintain Sales Orders in Opportunities object. How should the data architect model this requirement?

• Configure Price Books for each region and share with distributors

• Add custom fields in Opportunity and use triggers to update prices

• Create lookup to Custom Price object and share with distributors

• Manually update Opportunities with Prices applicable to distributors.

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updated by users. A majority of the automation tools within UC's org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?

• Import the data in smaller batches over a 24-hour period.

• Bulkify the triggers to handle import loads.

• Ensure validation rules, triggers, and other automation tools are disabled.

• Ensure duplication and matching rules are defined.

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM. UC is concerned about the quality of data being entered by users and through external integrations, Which two solutions should a data architect recommend to mitigate data quality issues? Choose 2 answers

• Leverage Apex to validate the format of data being entered via a mobile device

• Leverage validation rules and workflows

• Leverage third-party AppExchange tools.

• Leverage picklist and lookup fields where possible.

Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?

• Add Notes and Attachments Related Lists to Page Layouts in Lightning Experience

• Manually upload Notes in Lightning Experience

• Migrate Notes and Attachments to Enhanced Notes and Files using a migration tool.

• Manually upload Attachments in Lightning Experience.

Northern Trail Outfitters (NTO) has the following systems:

• Customer master-source of truth for customer information

• Service cloud-customer support

• Marketing cloud-marketing communications

• Enterprise data warehouse-business reporting

The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information.

NTO is planning to implement a master data management (MDM) solution across the enterprise.

Which three data issues will an MDM tool solve? Choose 3 answers

• Data accuracy and quality

• Data loss and recovery

• Data completeness

• Data duplication

• Data standardization

The data architect for Universal Containers 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 uses 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?

• Add LIMIT 100 to the query.

• Remove description from the requested field set

• Change query to SOSL.

• Change the WHERE clause to filter by a deterministic defined value

A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:

1. Personally identifiable information (PII)

2. IP restrictions on profiles organized by geographic location

3. Financial records that need to be private and accessible only by the assigned sales associate

Enterprise Security has mandated access to be restricted to users within a specific geography with detailed monitoring of user activity. Additionally, users should not be allowed to export information from Salesforce.

Which three Salesforce Shield capabilities should a data architect recommend?

Choose 3 answers

• Encrypt sensitive customer information maintained in Salesforce.

• Prevent sales users access to customer PII information.

• Restrict access to Salesforce from users outside specific geography.

• Transaction Security policies to prevent export of Salesforce data.

• Event monitoring to monitor all user activity.

As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce. What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?

• Build reports that contain customer data and classify manually.

• Use an AppExchange product to classify fields based on policy.

• Create a custom picklist field to capture classification of information on the contact object

• Use Data Classification metadata fields available in Field definition.