Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.Which solution should a data architect recommend a clean migration?

Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

Define external IDs for an object, migrate second database to first database, and load into Salesforce.

Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

Define external IDs for an object, Insert data from one database, and use upsert for a second database

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 ownerSecurity Level, such as confidentialCompliance types such as GDPR, PII, HIPPAA compliance audit would require SF admins to generate reports to manage compliance.What should a data architect recommend to address this requirement?

Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

Use metadata API, to extract field attribute information and use the extract to classify and build reports

Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

Create a custom object and field to capture necessary compliance information and build custom reports.

Build reports for field information, then export the information to classify and report for Audits.

Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.Which governance measure should a data architect recommend to solve this issue?

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Add description fields to explain why the field is used, and mark the field as required.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

Create validation rules with error messages to explain why the fields is used

Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.What should a data architect use to provide the sales team with the required functionality?

Create a mashup page that will present the billing system records within Salesforce.

Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.

Write an Apex callout and populate a related list to display on the account record.

Create a mashup page that will present the billing system records within Salesforce.

Create a visual force tab with the billing system encapsulated within an iframe.

A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM3. Customer Master Data management (MDM)4. Contract Management system5. Marketing solutionWhat should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Create a custom field as external id to maintain the customer Id from the MDM solution.

Store the salesforce id in all the solutions to identify the customer.

Create a custom object that will serve as a cross reference for the customer id.

Create a customer data base and use this id in all systems.

Create a custom field as external id to maintain the customer Id from the MDM solution.

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 object?

Use Metadata API to create big object.

Go to Big Object in setup select new to create big object.

Use Metadata API to create big object.

Go to Big Object in setup select new to create big object.

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

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.Which 3 options should help improve the dashboard performance?Choose 3 answers:

Use selective queries to reduce the amount of data being returned.

De-normalize the data by reducing the number of joins.

Reduce the amount of data queried by archiving unused opportunity records.

Use selective queries to reduce the amount of data being returned.

De-normalize the data by reducing the number of joins.

Remove widgets from the dashboard to reduce the number of graphics loaded.

Run the dashboard for CEO and send it via email.

Reduce the amount of data queried by archiving unused opportunity records.

Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.What should a data architect recommend for a daily backup and restore solution?

Use AppExchange package for backup and restore.

Use ETL for backup and restore from EDW.

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

Change weekly backup process to daily backup, and implement a custom restore solution.

A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.The company has noticed a large number of duplicate accounts in SF. 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 scalable option should a data Architect choose to implement to avoid duplicates?

Create duplicate rules in SF to validate duplicates during the account creation process

Implement a MDM solution to validate the customer information before creating Accounts in SF.

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

Customize Account creation process to search if customer exists before creating an Account.

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.Which solution should a data architect recommend as an archiving solution?

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Use a third-party backup solution to backup all data off platform.

Build a batch join move all records off platform, and delete all records from Salesforce.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.What should a data architect consider before implementing Salesforce Connect for reporting?

Maximum number for records returned

Maximum page size for server-driven paging

Maximum external objects per org

NTO has a loyalty program to reward repeat customers. The following conditions exists:1. Reward levels are earned based on the amount spent during the previous 12 months.2. The program will track every item a customer has bought and grant them points for discount.3. The program generates 100 million records each month.NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Universal Container (US) is replacing a home-grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.Which solution should a data architect recommend to meet business requirement?

Leverage mashup to display historical records in Salesforce.

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

Leverage mashup to display historical records in Salesforce.

Build a chair solution to go the legacy system and display records.

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.What are the 3 key actions that should be done when data modeling in salesforce?Choose 3 answers:

Identify data elements to be persisted in salesforce.

Map legacy data to salesforce objects.

Implement legacy data model within salesforce using custom fields.

Identify data elements to be persisted in salesforce.

Map legacy data to salesforce objects.

Map legacy data to salesforce custom objects.

Work with legacy application owner to analysis legacy data model.

Implement legacy data model within salesforce using custom fields.

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:State in which the customer is locatedCity in which the customer is located if availableZip code in which the customer is located if availableChanges to this information should have minimum code changesWhat should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Maintain require pricing criteria in custom metadata types.

Create a custom object to maintain the pricing criteria.

Assign the pricing criteria within customer pricing engine.

Maintain require pricing criteria in custom metadata types.

Configure the pricing criteria in price books.

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.What should a data architect recommend to guarantee that records are not being updated at the same time?

Embed the keywords FOR UPDATE after SOQL statements.

Disable classes or triggers that have the potential to obtain the same record.

Migrate programmatic logic to processes and flows.

Refactor or optimize classes and trigger for maximum CPU performance.

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.Which 3 recommendations should a data architect provide to prevent ownership skew?Choose 3 answers:

Keep users out of public groups that can be used as the source for sharing rules.

Assign a default user as owner of account and do not assign any role to default user.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

Assigned a default user as owner of accounts, and assign role in hierarchy.

Keep users out of public groups that can be used as the source for sharing rules.

Assign a default user as owner of account and do not assign any role to default user.

Assign ''view all'' permission on profile to give access to account.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an 'UNABLE _TO_LOCK_ROW' error.Which solution should a data architect recommend to resolve the error?

Perform a batch job in serial mode and reduce the batch size.

Defer rollup summary field calculation during data migration.

Perform a batch job in serial mode and reduce the batch size.

Perform a batch job in parallel mode and reduce the batch size.

Leverage Data Loader's platform API to load data.

A large insurance provider is looking to implement Salesforce. The following exist.1. Multiple channel for lead acquisition2. Duplication leads across channels3. Poor customer experience and higher costsOn analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Standard lead information across all channels.

Implement third-party solution to clean and event lead data.

Implement de-duplication strategy to prevent duplicate leads

Build process is manually search and merge duplicates.

Standard lead information across all channels.

Build a custom solution to identify and merge duplicate leads.

Implement third-party solution to clean and event lead data.

Implement de-duplication strategy to prevent duplicate leads

Universal Containers (UC) uses the following Salesforce products:Sales Cloud for customer management.Marketing Cloud for marketing.Einstein Analytics for business reporting.UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications;

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

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?

Leverage picklist and lookup fields where possible

Leverage validation rules and workflows.

Leverage picklist and lookup fields where possible

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

Leverage validation rules and workflows.

Leverage third-party- AppExchange tools

Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.What data extraction strategy should a data architect use for maximum performance?

Utilize PK Chunking with the Bulk API.

Install a third-party AppExchange tool.

Call the REST API in successive queries.

Utilize PK Chunking with the Bulk API.

Use the Bulk API in parallel mode.

A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities:1.Distributor create sales order in salesforce2.Sales order are based on product prices applicable to their region3. Sales order are closed once they are fulfilled4. It is decided to maintain the order in opportunity objectHow should the data architect model this requirement?

Configure price Books for each region and share with distributors.

Create lookup to Custom Price object and share with distributors.

Configure price Books for each region and share with distributors.

Manually update Opportunities with Prices application to distributors.

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

North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A middleware solution that extracts and distributes data across both the hub and spokes.

Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

Develop custom APIs to poll the spoke for change data and push into the org.

A backup and archive solution that extracts and restores data across orgs.

Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.Which solution should a data architect recommend to improve reporting performance?

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

Create a custom object to store aggregate data and run reports.

Contact Salesforce support to enable skinny table for cases.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

Build reports using custom Lightning components.

UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.What tool should a data architect use to identify why the query is taking too long?

Enable and use the query plan tool in the developer console.

Use Splunk to query the system logs looking for transaction time and CPU usage.

Enable and use the query plan tool in the developer console.

Use salesforce's query optimizer to analyze the query in the developer console.

Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard is not reliable for their real-time decision-making. On analysis, the team the following issues with data entered in Salesforce.Information in certain records is incomplete.Incorrect entry in certain fields causes records to be excluded in report fitters.Duplicate entries cause incorrect counts.Which three steps should a data architect recommend to address the issues?

Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

Explore third-party data providers to enrich and augment information entered in salesforce.

Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

Periodically export data to cleanse data and import them back into Salesforce for executive reports.

Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

Explore third-party data providers to enrich and augment information entered in salesforce.

Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

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!= NULLWhen 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?

Change the where clause to filter by a deterministic defined value.

Remove description from the requested field set.

Change the where clause to filter by a deterministic defined value.

Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:Legacy inventory data will be stored in a custom child object called Inventory_c.Inventory data should be related to the standard Account object.The Inventory object should Invent the same sharing rules as the Account object.Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.What type of relationship field should a data architect recommend in this scenario?

Master-detail relationship filed on Inventory_c, related to Account

Master-detail relationship filed on Account, related to Inventory_c

Master-detail relationship filed on Inventory_c, related to Account

Indirect lookup relationship field on Account, related to Inventory_c

Lookup relationship fields on Inventory related to Account

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

Create a geolocation custom field to maintain this requirement

Create formula fields with geolocation function for this requirement.

Create custom fields to maintain latitude and longitude information

Create a geolocation custom field to maintain this requirement

Recommend app exchange packages to support this requirement.

As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

Use data classification metadata fields available in field definition.

Use App Exchange products to classify fields based on policy.

Use data classification metadata fields available in field definition.

Create a custom picklist field to capture classification of information on customer.

Build reports for customer information and validate.

UC is planning a massive SF implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.What should a data architect do to minimize data load times due to system calculations?

Enable defer sharing calculations, and suspend sharing rule calculations

Load the data through data loader, and turn on parallel processing.

Leverage the Bulk API and concurrent processing with multiple batches

Enable granular locking to avoid ''UNABLE _TO_LOCK_ROW'' error.

Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.What solution a data architect recommends to give the sales team visibility into order status?

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

Leverage Canvas to bring the order management UI in to the Salesforce tab.

Build batch jobs to push order line items to salesforce.

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

Build real-time integration to pull order line items into Salesforce when viewing orders.

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

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

Add Notes and Attachments Related List to page Layout in Lighting Experience.

Manually upload Notes in Lighting Experience.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

Manually upload Attachments in Lighting Experience.

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that same standard and custom fields need to encrypted.Which solution should a data architect recommend to encrypt existing fields?

Implement shield platform encryption to encrypt and standard fields

Use Apex Crypto Class encrypt customer and standard fields.

Implement classic encryption to encrypt custom and standard fields.

Implement shield platform encryption to encrypt and standard fields

Expert data out of Salesforce and encrypt custom and standard fields.

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

Northern Trail outfitters in 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 Salesfoce?

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Data Architect Practice Test 5

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests