Pre-Winter Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

Data-Architect Sample Questions Answers

Questions 4

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

Buy Now
Questions 5

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Options:

A.

Use triggers to populate denormalized related fields on the Account.

B.

Use an indexed data field with bounded data filters.

C.

Use Formula fields to surface information I related entities on the report.

D.

Use unbounded date ranges to filter the report.

Buy Now
Questions 6

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.

Buy Now
Questions 7

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.

Buy Now
Questions 8

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?

Options:

A.

Reduce number of users updated concurrently.

B.

Enable granular locking.

C.

Analyze Splunk query to spot offending records.

D.

Increase CPU for the Salesforce org.

Buy Now
Questions 9

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and

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

Options:

A.

Use Bulk API parallel mode for data migration

B.

Use Bulk API serial mode for data migration

C.

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

object.

D.

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

Buy Now
Questions 10

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.

Buy Now
Questions 11

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?

Options:

A.

Us custom objects to maintain Sales Orders in Salesforce.

B.

Use custom big objects to maintain Sales Orders in Salesforce.

C.

Use external objects to maintain Sales Order in Salesforce.

D.

Use Standard order object to maintain Sale Orders in Salesforce

Buy Now
Questions 12

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

Options:

A.

Review the time zones of the User loading the data.

B.

Remove custom indexes on the data being loaded.

C.

Determine if the legacy system is still in use.

D.

Defer sharing calculations of the Salesforce Org.

E.

Deactivate approval processes and workflow rules.

Buy Now
Questions 13

(NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

Options:

A.

Change data capture (CDC)

B.

Salesforce connect.

C.

Federation search

D.

Salesforce 2 Salesforce

Buy Now
Questions 14

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 15

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.

Buy Now
Questions 16

Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.

First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.

What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

Options:

A.

Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.

B.

Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.

C.

Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.

D.

Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.

Buy Now
Questions 17

DreamHouse Realty has a Salesforce org that is used to manage Contacts.

What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

Options:

A.

Use the private sharing model.

B.

Use Salesforce duplicate management.

C.

Use validation rules on new record create and edit.

D.

Use workflow to delete duplicate records.

Buy Now
Questions 18

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Options:

A.

Use a workflow to check and prevent duplicates.

B.

Clean data before importing to Salesforce.

C.

Use Salesforce matching and duplicate rules.

D.

Import the data concurrently.

Buy Now
Questions 19

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Options:

A.

Using leading % wildcards.

B.

Using trailing % wildcards.

C.

Performing large loads and deletions.

D.

Using NOT and != operators.

E.

Using a custom index on a deterministic formula field.

Buy Now
Questions 20

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

Buy Now
Questions 21

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.

Buy Now
Questions 22

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?

Options:

A.

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

B.

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

C.

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

D.

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.

Buy Now
Questions 23

Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

Options:

A.

Do client-side validation of phone number and email field formats.

B.

Prefer picklist form fields over free text fields, where possible.

C.

Ensure the website visitor is browsing using an HTTPS connection.

D.

Use cookies to track when visitors submit multiple forms.

Buy Now
Questions 24

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

Options:

A.

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

B.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

C.

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

D.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

Buy Now
Questions 25

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 26

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:

1.Contacts will be stored in the standard contact object.

2.Conferences will be stored in a custom conference_ c object.

3.Each contact may attend multiple conferences and each conference may be related to multiple contacts.

How should a data architect model the relationship between the contact and conference objects?

Options:

A.

Implement a Contact Conference junction object with master detail relationship to both contact and conference_c

B.

Create a master detail relationship field on the Contact object.

C.

Create a master detail relationship field on the Conference object.

D.

Create a lookup relationship field on contact object.

Buy Now
Questions 27

Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:

1. First Name

2. Last Name

3. Email

Which option should the data architect recommend to mandate this when customers are created in Salesforce?

Options:

A.

Configure Page Layout marking attributes as required fields.

B.

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

C.

Mark Fields for the attributes as required under Setup.

D.

Build validation in Integration with MDM to check required attributes.

Buy Now
Questions 28

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 29

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 30

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.

Buy Now
Questions 31

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.

Buy Now
Questions 32

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.

Buy Now
Questions 33

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.

Buy Now
Questions 34

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.

Buy Now
Questions 35

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.

Buy Now
Questions 36

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 salesforce

2.Sales order are based on product prices applicable to their region

3. Sales order are closed once they are fulfilled

4. It is decided to maintain the order in opportunity object

How should the data architect model this requirement?

Options:

A.

Create lookup to Custom Price object and share with distributors.

B.

Configure price Books for each region and share with distributors.

C.

Manually update Opportunities with Prices application to distributors.

D.

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

Buy Now
Questions 37

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.

An Architect has been tasked with optimizing the data load time.

What should the Architect consider to achieve this goal?

Options:

A.

Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

B.

Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C.

Load the data in multiple sets using Bulk API parallel processes.

D.

Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Buy Now
Questions 38

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.

Buy Now
Questions 39

Northern Trail Outfitters is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.

NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.

Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?

Options:

A.

Bidirectional integration

B.

Unidirectional integration

C.

Virtualization

D.

Persistence

Buy Now
Questions 40

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?

Options:

A.

Assign dummy user last role in role hierarchy

B.

Create multiple dummy user and assign leads to them

C.

Assign dummy user to highest role in role hierarchy

D.

Periodically delete leads to reduce number of leads

Buy Now
Questions 41

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

Buy Now
Questions 42

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.

What 3 things should a data architect do to maintain the relationship hierarchy during migration?

Choose 3 answers:

Options:

A.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

B.

Create a external id field for each object in the target org and map source record ID’s to this field.

C.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

D.

Replace source record ID’s with new record ID’s from the target org in the import file.

E.

Keep the relationship fields populated with the source record ID’s in the import file.

Buy Now
Questions 43

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

Options:

A.

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B.

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

Buy Now
Questions 44

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.

Buy Now
Questions 45

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.

Buy Now
Questions 46

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:

• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.

• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.

• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.

How should the architect determine which of these systems is the system of record?

Options:

A.

Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

B.

Whatever system updates the attribute or object should be the system of record for that field or object.

C.

Whatever integration data flow runs last will, by default, determine which system is the system of record.

D.

Data flows should be reviewed with the business users to determine the system of record per object or field.

Buy Now
Questions 47

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:

1. Remove outdated Information not required on a day-to-day basis.

2. Improve Salesforce performance.

Which solution should be used to meet these requirements?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 48

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:

Access to customer information based on record ownership

Ability for customers to request removal of their information from Salesforce

Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)

What should a data architect recommend to address these requirements?

Options:

A.

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

B.

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

C.

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

D.

Implement Salesforce shield with Event Monitoring to address the requirement.

Buy Now
Questions 49

Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?

Options:

A.

Missing phone number on the Contact record.

B.

Customer phone number has changed on the Contact record.

C.

Duplicate Contact records exist in the system.

D.

Duplicate Activity records on a Contact.

Buy Now
Questions 50

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.

Buy Now
Questions 51

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.

Buy Now
Questions 52

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

Options:

A.

Use Field Audit History to capture operational data and extract it to on-premise systems.

B.

Use Weekly Export to extract transactional data to on-premise systems.

C.

Use a custom built extract job to extract operational data to on-premise systems.

D.

Use Event Monitoring to extract event data to on-premise systems.

Buy Now
Questions 53

Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

Options:

A.

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

B.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

C.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

D.

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

Buy Now
Questions 54

Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.

Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

Options:

A.

You want real-time access to the latest data, from other systems.

B.

You have a large amount of data and would like to copy subsets of it into Salesforce.

C.

You need to expose data via a virtual private connection.

D.

You have a large amount of data that you don't want to copy into your Salesforce org.

E.

You need to small amounts of external data at any one time.

Buy Now
Questions 55

Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

Options:

A.

Use the Name field values to sort batches.

B.

Order batches by Auto-number field.

C.

Create indexes on Opportunity object text fields.

D.

Group batches by the AccountId field.

Buy Now
Questions 56

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Options:

A.

Change each address field to require on the Page Layout.

B.

Write an Apex Trigger to require all fields to be populated.

C.

Utilize a Validation Rule with a REGEX operator on Postal Code.

D.

Utilize a Validation Rule with a CONTAINS operator on address fields.

Buy Now
Questions 57

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.

Buy Now
Questions 58

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.

Buy Now
Questions 59

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.

Buy Now
Questions 60

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

Options:

A.

Use Salesforce Soap API in parallel mode.

B.

Use Salesforce Bulk API in serial mode.

C.

Use Salesforce Bulk API in parallel mode.

D.

Use Salesforce Soap API in serial mode.

Buy Now
Questions 61

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?

Options:

A.

Enable granular locking.

B.

Remove SOQL statements from Apex Loops.

C.

Enable sharing recalculations.

D.

Ask Salesforce support for additional CPU power.

Buy Now
Questions 62

Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

Options:

A.

Truncate all 5 objects quickly and re-run the data migration test.

B.

Refresh the full copy sandbox and re-run the data migration test.

C.

Hard delete all 5 objects’ data and re-run the data migration test.

D.

Truncate all 5 objects and hard delete before running the migration test.

Buy Now
Questions 63

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.

Buy Now
Questions 64

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?

Options:

A.

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

B.

Utilize a data warehouse as the system of truth

C.

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

D.

Implement duplicate rules

Buy Now
Questions 65

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?

Options:

A.

Use AppExchange package for backup and restore.

B.

Use ETL for backup and restore from EDW.

C.

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

D.

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

Buy Now
Questions 66

Universal containers is implementing Salesforce lead management.  UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Options:

A.

Ask sales people to search for populating company profile and location data

B.

Run reports to identify records which does not have company profile and location data

C.

Leverage external data providers populate company profile and location data

D.

Export data out of Salesforce and send to another team to populate company profile and location data

Buy Now
Questions 67

Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

Options:

A.

Engage with IT program managers to assess current velocity of projects in the pipeline.

B.

Engage with database administrators to assess current database performance metrics.

C.

Engage with executive sponsorship to assess enterprise data strategy and goals.

D.

Engage with business units and IT to assess current operational systems and data models.

Buy Now
Questions 68

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Options:

A.

Number of queries running at a time.

B.

Number of joins used in report query.

C.

Number of records returned by report query.

D.

Number of characters in report query.

Buy Now
Questions 69

What makes Skinny tables fast? Choose three answers.

Options:

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

Buy Now
Questions 70

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.

Buy Now
Questions 71

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?

Options:

A.

Create a criteria-based sharing rule.

B.

Implicit sharing will automatically handle with standard functionality.

C.

Add appropriate users to the account team.

D.

Create an owner-based sharing rule.

Buy Now
Questions 72

Which three characteristics of a skinny table help improve report and query performance?

Options:

A.

Skinny tables can contain frequently used fields and thereby help avoid joins.

B.

Skinny tables can be used to create custom indexes on multi-select picklist fields.

C.

Skinny tables provide a view across multiple objects for easy access to combined data.

D.

Skinny tables are kept in sync with changes to data in the source tables.

E.

Skinny tables do not include records that are available in the recycle bin.

Buy Now
Questions 73

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:

Options:

A.

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

B.

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

C.

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

D.

Run the dashboard for CEO and send it via email.

E.

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

Buy Now
Questions 74

UC has the following system:

  • Billing system.
  • Customer support system.
  • CRM system.

US has been having trouble with business intelligence across the different systems. Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.

Which MDM data element is needed to allow reporting across these systems?

Options:

A.

Global unique customer number.

B.

Email address.

C.

Phone number.

D.

Full name.

Buy Now
Questions 75

What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Options:

A.

Provide custom help text under field properties.

B.

Create a custom page with help text for user guidance.

C.

Add custom help text in default value for the field.

D.

Add a label field with help text adjacent to the custom field.

Buy Now
Questions 76

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

Options:

A.

Implement data archiving for old Shipment records.

B.

Contact Salesforce to create Skinny tables on Shipment.

C.

Configure shipment OWD to Public Read/Write.

D.

Contact Salesforce to enable Defer Sharing Rules

Buy Now
Questions 77

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Options:

A.

Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

B.

Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

C.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

D.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SU24)
Last Update: Oct 2, 2024
Questions: 253
$64  $159.99
$48  $119.99
$40  $99.99
buy now Data-Architect