Summer Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Salesforce Data-Architect Salesforce Certified Data Architect (SP25) Exam Practice Test

Page: 1 / 26
Total 257 questions

Salesforce Certified Data Architect (SP25) Questions and Answers

Question 1

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?

Options:

A.

Run standard reports and dashboards.

B.

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

C.

Use Einstein Analytics for multi-org.

D.

Write a Python script to aggregate and visualize the data.

Question 2

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?

Options:

A.

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

a related list.

B.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c

showing Sum of hours from VTOTime__c records.

C.

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

D.

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

Question 3

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 4

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!= NULL

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

Options:

A.

Remove description from the requested field set.

B.

Change query to SOSL.

C.

Add limit 100 to the query.

D.

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

Question 5

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?

Options:

A.

Standard reports and dashboards

B.

Async SOQL with a custom object

C.

Standard SOQL queries

D.

Einstein Analytics

Question 6

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Options:

A.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

B.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Question 7

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:

Options:

A.

Identify data elements to be persisted in salesforce.

B.

Map legacy data to salesforce objects.

C.

Map legacy data to salesforce custom objects.

D.

Work with legacy application owner to analysis legacy data model.

E.

Implement legacy data model within salesforce using custom fields.

Question 8

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Options:

A.

Remove "customize application" permissions from everyone else.

B.

Export the metadata and search it for the fields in question.

C.

Create a field history report for the fields in question.

D.

Export the setup audit trail and find the fields in question.

Question 9

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?

Options:

A.

Use DX to create big object.

B.

Use Metadata API to create big object.

C.

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

D.

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

Question 10

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Options:

A.

Set a standard profile for Data Migration user, and assign view encrypted data

B.

Create another field to copy data from encrypted field and use this field in export

C.

Leverage Apex class to decrypt data before exporting it.

D.

Set up a custom profile for data migration user and assign view encrypted data.

Question 11

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Options:

A.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

B.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

C.

The Opportunity engagement system should become the system of record for Opportunity records.

D.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

Question 12

Which two aspects of data does an Enterprise data governance program aim to improve?

Options:

A.

Data integrity

B.

Data distribution

C.

Data usability

D.

Data modeling

Question 13

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.

DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.

The Architect needs to ensure this field always contains data coming from the source system.

Which two approaches should the Architect take? Choose 2 answers

Options:

A.

Set up a Validation Rule to prevent blank values.

B.

Create a Workflow to default a value into this field.

C.

Mark the field required in setup at the field level.

D.

Blame the customer's external system for bad data.

Question 14

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 15

Which API should a data architect use if exporting 1million records from Salesforce?

Options:

A.

Bulk API

B.

REST API

C.

Streaming API

D.

SOAP API

Question 16

Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? 

Choose 2 answers

Options:

A.

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

B.

Post go -live automated page -load testing against the Salesforce Production org.

C.

Pre -go -live unit testing in the Salesforce Full sandbox.

D.

Stress testing against the web services hosted by the integration middleware.

Question 17

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Options:

A.

Use Duplicate Management.

B.

Use an Enterprise Service Bus.

C.

Use Data.com Clean

D.

Use a data warehouse.

Question 18

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 19

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

Options:

A.

validation Rule

B.

required Fields

C.

Apex Class

D.

Process Builder

Question 20

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

Options:

A.

Export in multiple batches

B.

Export Bulk API in parallel mode

C.

Use PK Chunking

D.

Limit Batch to 10K records

Question 21

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers

Options:

A.

Create a custom object to store a copy of the record when changed.

B.

Create a custom object to store the previous and new field values.

C.

Use Analytic Snapshots to store a copy of the record when changed.

D.

Select the 100 fields in the Opportunity Set History Tracking page.

Question 22

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?

Options:

A.

Use App Exchange products to classify fields based on policy.

B.

Use data classification metadata fields available in field definition.

C.

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

D.

Build reports for customer information and validate.

Question 23

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 24

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

Options:

A.

Contact each business on the list and ask them to review and update their address information.

B.

Build a team of employees that validate Accounts by searching the web and making phone calls.

C.

Integrate with a third-party database or services for address validation and enrichment.

D.

Leverage Data.com Clean to clean up Account address fields with the D&B database.

Question 25

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implemented this in Salesforce?

Options:

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Question 26

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

Options:

A.

Salesforce allows up to four objects in a single report type.

B.

Salesforce does not support Orders or Order Line Items.

C.

A report cannot contain data from Accounts and Contacts.

D.

Custom report types cannot contain Opportunity data.

Question 27

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?

Choose 2 answers

Options:

A.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

B.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

C.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

D.

Store all data in an external system and set up an integration to Salesforce for view -only access.

Question 28

Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.

Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Options:

A.

Use custom objects for cases older than 2 years and use nightly batch to move them.

B.

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

C.

Use Big objects for cases older than 2 years, and use nightly batch to move them.

D.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Question 29

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 30

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

Options:

A.

Integrate Salesforce with the ERP environment.

B.

Utilize workbench to update files within systems.

C.

Utilize an MDM strategy to outline a single source of truth.

D.

Build synchronization reports and dashboards.

Question 31

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Options:

A.

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

B.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

C.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

D.

Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Question 32

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.

Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

Options:

A.

Clear the role field in the generic user record.

B.

Salesforce handles the assignment of orders automatically and there is no performance impact.

C.

Create a role at top of role hierarchy and assign the role to the generic user.

D.

Create a pool of generic users and distribute the assignment of memory to the pool of users.

Question 33

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 architect

1. 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?

Options:

A.

use as ETL tool to orchestrate the migration.

B.

Use Data Loader for export and Data Import Wizard for import

C.

Write a script to use the Bulk API

D.

Use the Salesforces CLI to query, export, and import

Question 34

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?

Options:

A.

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

B.

Develop a process that calls an inviable web service method.

C.

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

D.

Write a custom adapter with the Apex Connector Framework.

Question 35

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 36

NTO has implemented salesforce for its sales users. The opportunity management in salesforce 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 opportunity amount field on opportunities on a daily basis.

3.PPS is the trusted source within the 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 overriding issue?

Options:

A.

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

B.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

C.

Change opportunity amount field access to read only for sales users using field level security.

D.

Change PPS integration to update only opportunity amount fields when values is NULL.

Question 37

A company wants to document the data architecture of a Salesforce organization.

What are two valid metadata types that should be included? (Choose two.)

Options:

A.

RecordType

B.

Document

C.

CustomField

D.

SecuritySettings

Question 38

As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers

Options:

A.

Review the setup audit trail for configuration changes.

B.

Put the business purpose in the Description of each field.

C.

Maintain a data dictionary with the justification for each field.

D.

Use the Force.com IDE to save the metadata files in source control.

Question 39

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

Options:

A.

Implement an archiving process for shipment records created after five years.

B.

Implement an archiving process for shipment records created after three years.

C.

Set Customer-Reference_c as an External ID (non-unique).

D.

Set Customer-Reference_c as an External ID (unique).

Question 40

Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders.

What should be used to mitigate this problem?

Options:

A.

Work Flow Rules

B.

Formatted Fields

C.

Apex Trigger

D.

Validation Rules

Question 41

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 42

NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

Options:

A.

Metadata API

B.

Tooling API

C.

Bulk API in serial mode

D.

SOAP API

Question 43

Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?

Options:

A.

Update the Opportunity page layout to mark these fields as required.

B.

Use a validation rule for each field that takes the Stage into consideration.

C.

Update these Opportunity field definitions in Setup to be required.

D.

Write an Apex trigger that checks each field when records are saved.

Question 44

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 45

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?

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 46

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

Options:

A.

Use third-party AppExchange tools to monitor and measure data quality.

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

Export the data to an enterprise data warehouse and use BI tools for data quality.

Question 47

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?

Options:

A.

Use custom fields to capture the authorization details.

B.

Create a custom object to maintain the authorization.

C.

Utilize the Authorization Form Consent object to capture the consent.

D.

Use AppExchange solution to address the requirement.

Question 48

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?

Options:

A.

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

B.

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

C.

Build a nightly sync job from ERP to Salesforce.

D.

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

Question 49

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

Options:

A.

Service Cloud

B.

Lightning platform Start

C.

Lightning Platform plus

D.

Lightning External Apps Starts

Question 50

An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution? 

Choose 2 answers

Options:

A.

Whether the systems are cloud -based or on -premise.

B.

Whether or not Salesforce replaced a legacy CRM.

C.

Whether the system of record changes for different tables.

D.

The number of systems that are integrating with each other.

Question 51

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?

Options:

A.

Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.

B.

Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

C.

Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

D.

Export legacy data into CSV files and leverage data loader to load data into Salesforce.

Question 52

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.

Which solution should a data architect recommend to solve this requirement?

Options:

A.

Implement shield platform encryption to encrypt files.

B.

Use classic encryption to encrypt files.

C.

Implement 3rd party App Exchange app to encrypt files.

D.

Store files outside of salesforce and access them to real time.

Question 53

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

Options:

A.

Use a custom auto number and formula field and use that to chunk records while extracting data.

B.

The REST API to extract data as it automatically chunks records by 200.

C.

Use ETL tool for extraction of records.

D.

Ask SF support to increase the query timeout value.

Question 54

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

Options:

A.

Load Contact records together using the Streaming API via the Upsert operation.

B.

Delete all existing records, and then load all records together via the Insert operation.

C.

Load all records via the Upsert operation to determine new records vs. existing records.

D.

Load new records via the Insert operation and existing records via the Update operation.

Question 55

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total

hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external

system into Salesforce.com?

Options:

A.

Load all data using external IDs to link to parent records.

B.

Use workflow to calculate summary values instead of Roll -Up.

C.

Use triggers to calculate summary values instead of Roll -Up.

D.

Load all data after deferring sharing calculations.

Question 56

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

Options:

A.

Use Streaming API to get the current status from the ERP and display on the Opportunity page.

B.

Create an external object Invoice _x with a Lookup relationship with Opportunity.

C.

Create a custom object Invoice _c with a master -detail relationship with Opportunity.

D.

Create a custom object Invoice _c with a Lookup relationship with Opportunity.

Question 57

A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.

What standard feature should be selected in this scenario?

Options:

A.

Individual Accounts

B.

Account Contact

C.

Contacts

D.

Person Accounts

Question 58

Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

Options:

A.

Implement a Master Data Management system to determine system of record.

B.

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

C.

Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

D.

Implement an hourly integration to send Salesforce Opportunities to the ERP system.

Question 59

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.

Options:

A.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

B.

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

C.

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

D.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

E.

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

Question 60

Which two best practices should be followed when using SOSL for searching?

Options:

A.

Use searches against single Objects for greater speed and accuracy.

B.

Keep searches specific and avoid wildcards where possible.

C.

Use SOSL option to ignore custom indexes as search fields are pre-indexed.

D.

Use Find in “ALL FIELDS” for faster searches.

Question 61

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?

Options:

A.

Ask support to create a skinny table for Application with the necessary reporting fields.

B.

Add custom indexes to all fields on Application without a standard index.

C.

Run multiple reports to get different pieces of the data and combine them.

D.

Add custom indexes to the Date fields used for filtering the report.

Question 62

Which two statements are accurate with respect to performance testing a Force.com application?

Options:

A.

All Force.com applications must be performance tested in a sandbox as well as production.

B.

A performance test plan must be created and submitted to Salesforce customer support.

C.

Applications with highly customized code or large volumes should be performance tested.

D.

Application performance benchmarked in a sandbox can also be expected in production.

Question 63

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

Options:

A.

Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

B.

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

C.

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

D.

Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Question 64

Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Options:

A.

Enable field history tracking on the Case object.

B.

Create a report on Case analytic snapshots.

C.

Install AppExchange packages for available reports.

D.

Create Contact and Opportunity Reports and Dashboards.

Question 65

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Options:

A.

Run a report which shows the last time the key fields were updated.

B.

Run one report per key field, grouped by that field, to understand its data variability.

C.

Run a report that shows the percentage of blanks for the important fields.

D.

Run a process that can fill in default values for blank fields.

Question 66

Cloud Kicks has the following requirements:

• Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).

• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

• Each custom object must have separate sharing models.

What should an Architect do to fulfill these requirements?

Options:

A.

Associate the Shipment to each parent record by using a VLOOKUP formula field.

B.

Create a required Lookup relationship to each of the three parent records.

C.

Create a Master-Detail relationship to each of the three parent records.

D.

Create two Master-Detail and one Lookup relationship to the parent records.

Question 67

UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.

Which object model should a data architect configure within SF?

Options:

A.

Leverage person account object in Salesforce

B.

Leverage custom person account object in SF

C.

Leverage custom account and contact object in SF

D.

Leverage standard account and contact object in SF

Question 68

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 69

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?

Options:

A.

Enable defer sharing calculations, and suspend sharing rule calculations

B.

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

C.

Leverage the Bulk API and concurrent processing with multiple batches

D.

Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error.

Question 70

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 71

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?

Options:

A.

Enable granular locking

B.

Enable parallel sharing rule calculation.

C.

Enable defer sharing calculation

D.

Enable implicit sharing

Question 72

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Options:

A.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

B.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

C.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

D.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Question 73

Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Options:

A.

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

B.

Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.

C.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

D.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

Question 74

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

Options:

A.

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

B.

Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

C.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

D.

Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Question 75

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

Options:

A.

Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place

B.

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

C.

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

D.

Suggest MDM solution and link MDM to salesforce and SAP

Question 76

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?

Options:

A.

Sales Cloud License

B.

Lightning Platform Starter License

C.

Service Cloud License

D.

Salesforce License

Question 77

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

Options:

A.

Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

B.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

C.

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

D.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Page: 1 / 26
Total 257 questions