Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:Access to customer information based on record ownershipAbility for customers to request removal of their information from SalesforcePrevent users from accessing Salesforce from outside company network (virtual private network, or VPN)What should a data architect recommend to address these requirements?

Implement IP restrictions, sharing settings, and custom Apex to support customer requests.

Contact Salesforce support to restrict access only with VPN and other requirements

Allow users access to Salesforce through a custom web application hosted within VPN.

Implement IP restrictions, sharing settings, and custom Apex to support customer requests.

Implement Salesforce shield with Event Monitoring to address the requirement.

Universal Containers has multiple systems all containing and maintaining customer data. Although point-to-point integrations are in place, customers are complaining about consistency in the data.What solution should the data architect recommend?

An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.

Improve existing point-to-point integrations

Perform a onetime synchronization to level set the built up inconsistencies

An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:1. Customers are Person Accounts for their retail business.2. Customers are represented as Contacts for their commercial business.3. Employees are maintained as Users.4. Prospects are maintained as Leads.NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.Which option should the data architect recommend NTO to satisfy this requirement?

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

Create custom fields for contact preferences in Lead, Person Account, and Users objects.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

Universal Containers (UC) is building a Service Cloud call center application and has a multisystem support solution. UC would like or ensure that all systems have access to the same customer information.What solution should a data architect recommend?

Implement a master data management (MDM) strategy for customer data.

Make Salesforce the system of record for all data.

Implement a master data management (MDM) strategy for customer data.

Load customer data in all systems.

Let each system be an owner of data it generates.

Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.Which option does Apex provide to report errors from this Apex job?

Use Apex services to email failures to business when error occurs.

Use Custom Object to store leads, and allow unprocessed leads to be reported.

Save Apex errors in a custom object, and allow access to this object for reporting.

Use Apex services to email failures to business when error occurs.

Use AppExchange package to clean lead information before Apex job processes them.

Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.What should a data architect suggest to mitigate Issues related to lookup skew?

Create multiple similar products and distribute the skew across those products.

Change the lookup relationship to master-detail relationship.

Create a custom object to maintain the relationship between products and customers.

Select Clear the value of this field option while configuring the lookup relationship.

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:1. High Value2. Medium Value3. Low ValueWhich strategy should a data architect recommend to configure customer type?

Single-select restricted picklist with defined choices.

Lookup to a custom object with defined choices.

Single-select restricted picklist with defined choices.

Provide help text to guide users with defined choices.

Create a validation rule to limit entry to defined choices.

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:1. Remove outdated Information not required on a day-to-day basis.2. Improve Salesforce performance.Which solution should be used to meet these requirements?

Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

Identify a location to store archived data, and move data to the location using a time-based workflow.

Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

Create a full copy sandbox, and use it as a source for retaining archived data.

Northern Trail Outfitters Is planning to build a consent form to record customer authorization for marketing purposes.What should a data architect recommend to fulfill this requirement?

Utilize the Authorization Form Consent object to capture the consent.

Use custom fields to capture the authorization details.

Create a custom object to maintain the authorization.

Utilize the Authorization Form Consent object to capture the consent.

Use AppExchange solution to address the requirement.

A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following information in Service Console when a customer contacts them:1. Customer browsing activity on its website stored on its on premise system2. Customer interactions with sales associates at its retail stores maintained in Salesforce3. Contact center interactions maintained in Salesforce4. Email campaign activity to customer from its marketing systems.What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?

Build customer view in Service Console with components that show website data and marketing data as mashup.

Create web tabs in Service Console to show website and marketing activities.

Build custom components in Service Console to bring information from the marketing and website information.

Use Salesforce Connect to integrate the website and the marketing system into Service Console using external objects.

Build customer view in Service Console with components that show website data and marketing data as mashup.

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?

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:1. First Name2. Last Name3. EmailWhich option should the data architect recommend to mandate this when customers are created in Salesforce?

Create validation rules to check If the required attributes are entered.

Configure Page Layout marking attributes as required fields.

Create validation rules to check If the required attributes are entered.

Mark Fields for the attributes as required under Setup.

Build validation in Integration with MDM to check required attributes.

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.)

Use Salesforce duplicate management.

Use validation rules on new record create and edit.

Use Salesforce duplicate management.

Use validation rules on new record create and edit.

Use workflow to delete duplicate records.

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in parallel mode.

Use Salesforce Bulk API in serial mode.

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in serial mode.

Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

Modify the export job header to specify Sforce-Enable-PKChunking.

Modify the export job header to specify Export-in-Parallel.

Modify the export job header to specify Sforce-Enable-PKChunking.

Modify the export query that includes standard index fields(s).

Modify the export query with LIMIT clause with Batch size 10,000.

Salesforce Certified Data Architect Practice Test 7 - Free Online Exam Prep & Questions

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

Which solution should a data architect use to ensure successful data migrations?

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Data Architect Practice Test 7

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests