Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.What should a data architect do in order to restore the issue?

Enable parallel sharing rule calculation.

Enable defer sharing calculation

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.

Ensure the lead data is preprocessed for quality before loading into salesforce.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

Allow validation rules to be activated during the load of leads into salesforce.

Develop custom APEX batch process to improve quality once the load is completed.

Ensure the lead data is preprocessed for quality before loading into salesforce.

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.Which 3 options should a data architect recommend to share data between Org A and Org B?Choose 3 answers.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

Install a 3rd party AppExchange tool to handle the data sharing

Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.Which three recommendations should a data architect make is order to reduce the number of records from the org?Choose 3 answers

Use hard delete in Bulk API to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Use hard delete in Bulk API to permanently delete records from Salesforce.

Use hard delete in batch Apex to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Use Rest API to permanently delete records from the Salesforce org.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:1. Point of sales system: All purchases for a customer.2. Salesforce: All customer service activity and sales activity for a customer.3. Mobile app: All bookings, preferences and browser activity for a customer.4. Marketing: All email, SMS and social campaigns for a customer.Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.What strategy should the data architect implement to satisfy this requirement?

Explore external data sources in salesforce to build 360 view of customer.

Use a customer data mart to view the 360 view of customer.

Migrate customer activities from all 4 systems into salesforce.

Periodically upload summary information in salesforce to build 360 view.

During the implementation of Salesforce, a customer has the following requirements for Sales Orders:1. Sales Order information needs to be shown to users in Salesforce.2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).3. Sales Order information has more than 150 million records.4. Sales Orders will not be updated in Salesforce.What should a data architect recommend for maintaining Sales Orders in salesforce?

Use external objects to maintain Sales Order in Salesforce.

Us custom objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Use external objects to maintain Sales Order in Salesforce.

Use Standard order object to maintain Sale Orders in Salesforce

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 updates by users. A majority of the automation tool within UC'' 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?

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

Ensure duplication and matching rules and defined.

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

Bulkily the trigger to handle import leads.

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect1. The data model for Org B will drastically change with different objects, fields, and picklist values.2. Three million records will need to be migrated from org A to org B for compliance reasons.3. The migrate will need occur within the next two month, prior to be split.Which migrate strategy should a data architect use to successfully migrate the date?

use as ETL tool to orchestrate the migration.

Use Data Loader for export and Data Import Wizard for import

Write a script to use the Bulk API

Use the Salesforces CLI to query, export, and import

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.Which two native tools should a data architect recommend to achieve this reporting requirement?

Async SOQL with a custom object

Standard reports and dashboards

Async SOQL with a custom object

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?

Implicit sharing will automatically handle with standard functionality.

Create a criteria-based sharing rule.

Implicit sharing will automatically handle with standard functionality.

Add appropriate users to the account team.

Create an owner-based sharing rule.

Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.Which two solutions should a data architect recommend to resolve the complaints?

Integrate Salesforce with ERP, and make ERP as system of truth.

Implement a de-dupe solution and establish account ownership in Salesforce

Build a nightly batch job to de-dupe data, and merge account records.

Integrate Salesforce with ERP, and make ERP as system of truth.

Build a nightly sync job from ERP to Salesforce.

Implement a de-dupe solution and establish account ownership in Salesforce

Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.The following conditions exist within its system:NTO has a total of five million customers.Duplicate records exist, which is replicated across many systems, including Salesforce.Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.Which three option should a data architect perform to resolve the issues with the customer data?

Create a unique global customer ID for each customer and store that in all system for referential identity.

Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

Create a unique global customer ID for each customer and store that in all system for referential identity.

Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

Duplicate customer records across the system and provide a two-way sync of data between the systems.

Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription-based support.Which license type will UC users need to fulfill UC's requirements?

Lightning Platform Starter License

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.Which option should a data architect choose to implement to avoid duplicates?

leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

Develop an Apex class that searches for duplicates and removes them nightly.

Implement an MDM solution to validate the customer information before creating Salesforce.

Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.3. PPS is the trusted source within NTO for Opportunity Amount.4. NTO uses Opportunity Forecast for its sales planning and management.Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.How should a data architect address this overwriting issue?

Change Opportunity Amount field access to Read Only for sales users field-level security.

Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.

Change PSS integration to update only Opportunity Amount field when the value is null.

Change Opportunity Amount field access to Read Only for sales users field-level security.

Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing 'lock errors' consistently.What should a data architect recommend to mitigate these errors?

Remove SOQL statements from Apex Loops.

Ask Salesforce support for additional CPU power.

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.What is the fastest and most effective way for a data architect to solve the time-out issue?

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.What should the data architect do for a successful migration to mitigate the pain point?

Store the data in a staging database, and de-duplicate identical records.

Hire an intern manually de-duplicate the records after migrating to Salesforce.

Migrate the data as is, and use Salesforce's de-duplicating feature.

Have the users manually clean the data in the old system prior to migration.

Store the data in a staging database, and de-duplicate identical records.

A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer2. Salesforce; All customer service activity and sales activities for a customer3. Mobile app: All bookings, preferences, and browser activity for a customer4. Marketing: All email, SMS, and social campaigns for a customerCustomer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.What strategy should the data architect implement to satisfy this requirement?

Explore external data sources in Salesforce to build a 360-degree view of the customer.

Use a customer data mart to create the 360-degree view of the customer.

Periodically upload summary information in Salesforce to build a 360-degree view.

Migrate customer activities fro, all four system into Salesforce.

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.Which solution should a data architect recommend to remediate the duplication issue?

Develop an ETL process that utilizers the merge API to merge the duplicate records

Utilize a data warehouse as the system of truth

Extract the data using data loader and use excel to merge the duplicate records

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.What is the correct solution for ensuring all systems using customer data are kept up to date?

Have each system pull the record changes from Salesforce using change data capture.

Send customer data nightly to the system of truth in a scheduled batch job.

Send customer record changes from Salesforce to each system in a nightly batch job.

Send customer record changes from Salesforce to the system of truth in real time.

Have each system pull the record changes from Salesforce using change data capture.

Universal Containers (UC) plans to implement consent management for its customers to be compliant with General Data Protection Regulation (GDPR). UC has the following requirements:UC uses Person Accounts and Contacts in Salesforce for its customers.Data Protection and Privacy is enabled in Salesforce.Consent should be maintained in both these objects.UC plans to verify the consent provided by customers before contacting them through email or phone.Which option should the data architect recommend to implement these requirements?

Use the Consent Management Feature to validate consent provide under the person Account and Contact that is provided by the customer.

Configure custom fields in Person Account and Contact to store consent provided by customers, and validate consent against the fields.

Build Custom object to store consent information in Person Account and Contact, validate against this object before contacting customers.

Use the Consent Management Feature to validate consent provide under the person Account and Contact that is provided by the customer.

Delete contact information from customers who have declined consent to be contacted.

A large telecommunication provider that provides internet services to both residence and business has the following attributes:A customer who purchases its services for their home will be created as an Account in Salesforce.Individuals within the same house address will be created as Contact in Salesforce.Businesses are created as Accounts in Salesforce.Some of the customers have both services at their home and business.What should a data architect recommend for a single view of these customers without creating multiple customer records?

Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.

Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

Customer are created as individual objects and relate with Accounts for Business and Residence accounts.

Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.

Universals Containers' system administrators have been complaining that they are not able to make changes to its users' record, including moving them to new territories without getting ''unable to lock row'' errors. This is causing the system admins to spend hours updating user records every day.What should the data architect do to prevent the error?

Reduce number of users updated concurrently.

Analyze Splunk query to spot offending records.

Increase CPU for the Salesforce org.

Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:Data will be used to drive marketing and product development initiatives.NTO estimates that the program will generate 100 million rows of date monthly.NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions.What should the Data Architect do to store, collect, and use the reward program data?

Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.

Have Einstein connect to the point of sales system to capture the Reward Program data.

Create a big object in Einstein Analytics to capture the Loyalty Program data.

Create a custom object in Salesforce that will be used to capture the Reward Program data.

Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.What should a data architect recommend to solve these performance issues?

Create multiple dummy user and assign leads to them

Assign dummy user last role in role hierarchy

Create multiple dummy user and assign leads to them

Assign dummy user to highest role in role hierarchy

Periodically delete leads to reduce number of leads

Northern Trail Outfitters is concerned because some of its data is sensitive and needs to be identified for access.What should be used to provide ways to filter and identify the sensitive data?

Define data classification metadata.

Implement field-level security.

Custom checkbox denoting sensitive data.

Define data classification metadata.

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.What should a data architect recommend to increase Salesforce adoption?

Define a standard mapping and train sales users to import opportunity data.

Use the Excel connector to Salesforce to sync data from individual Excel files.

Define a standard mapping and train sales users to import opportunity data.

Load data in external database and provide access to database to sales users.

Create a chatter group and upload all Excel files to the group.

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) andService History (Service-History__ c) are both custom objects related through a lookup relationship.Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.What should a data architect recommend to avoid locking issues without affecting performance of data migration?

Use Bulk API serial mode for data migration

Use Bulk API parallel mode for data migration

Use Bulk API serial mode for data migration

Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

Change the lookup configuration to 'Clear the value of this field' when lookup record is deleted.

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.As a data architect, which action is recommended to avoid data sync issues?

Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.

Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.

Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.

Implement a manual process to update the products from an extract from the products master on a weekly basis.

Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.

Universal Containers (UC) has 50 million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support.In order to provide seamless customer support, UC would like to see the customer's order history when viewing the customer record during a sales or support call.What should a data architect do in order to provide this functionality, while preserving the user experience?

Use Salesforce Connect and an external object to display the order history in Salesforce

Use an Apex callout to populate a text area field for displaying the order history.

Use Salesforce Connect and an external object to display the order history in Salesforce

Import the order history into a custom Salesforce object, update nightly

Embed the ERP system in an iframe and display on a custom tab.

A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM:Local dealersRegional distributorState distributorService dealerThe attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.How should the different dealers be maintained in Salesforce?

Use Accounts for dealers, and create record types for each of the dealer types.

Create dealers as Accounts, and build custom views for each of the dealer types.

Use Accounts for dealers and custom picklist field for each of the dealer types

Create Custom objects for each dealer types and custom fields for dealer attributes.

Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.

Placing 20 batches on the queue for upset jobs.

Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.

Leveraging a controlled feed load with 10 batches per job.

Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.

Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?

Write a custom adapter with the Apex Connector Framework.

Write an Apex class that makes a REST callout to the external API.

Develop a process that calls an inviable web service method.

Migrate the data to Heroku and register Postgres as a data source.

Write a custom adapter with the Apex Connector Framework.

Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.What solution should a data architect recommend to meet the business requirement?

Leverage big objects to archive records and Einstein Analytics to run reports.

Archive records to a data warehouse and run analytics on the data warehouse.

Leverage big objects to archive records and Einstein Analytics to run reports.

Leverage custom objects to store aggregate data and run analytics.

Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.Which tool should a data architect recommend to accomplish this reporting requirement?

Use Einstein Analytics for multi-org.

Run standard reports and dashboards.

Install a third-party AppExchange tool for multi-org reporting.

Use Einstein Analytics for multi-org.

Write a Python script to aggregate and visualize the data.

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

A large retail company has recently chosen SF as its CRM solution. They have the following record counts:

2500000 accounts

25000000 contacts

When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

What should a data architect do to solve the performance issue?

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Data Architect Practice Test 6

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests