Summer Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 28522818

Home > Salesforce > Application Architect > Data-Architect

Data-Architect Salesforce Certified Data Architect (SU24) Question and Answers

Question # 4

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) – based support.

Which license type will US users need to fulfil US’s requirements?

A.

Lightning platform starter license.

B.

Service cloud license.

C.

Salesforce license.

D.

Sales cloud license

Full Access
Question # 5

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

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.

Full Access
Question # 6

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?

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

Full Access
Question # 7

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?

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.

Full Access
Question # 8

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

A.

Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

B.

Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

C.

Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

D.

Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Full Access
Question # 9

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?

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.

Full Access
Question # 10

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?

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.

Full Access
Question # 11

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?

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.

Full Access
Question # 12

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?

A.

Enable granular locking

B.

Enable parallel sharing rule calculation.

C.

Enable defer sharing calculation

D.

Enable implicit sharing

Full Access
Question # 13

Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

A.

UC can store long-term lead records in custom storage objects to avoid counting against storage limits.

B.

UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.

C.

UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.

D.

UC can leverage a “tier”-based approach to classify the record storage need.

Full Access
Question # 14

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?

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.

Full Access
Question # 15

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

A.

Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.

B.

Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

C.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

D.

Let a “system user” own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Full Access
Question # 16

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

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.

Full Access
Question # 17

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

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.

Full Access
Question # 18

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:

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.

Full Access
Question # 19

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?

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.

Full Access
Question # 20

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

A.

Embed the keywords FOR UPDATE after SOQL statements.

B.

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

C.

Migrate programmatic logic to processes and flows.

D.

Refactor or optimize classes and trigger for maximum CPU performance.

Full Access
Question # 21

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

A.

Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.

B.

Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.

C.

Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.

D.

Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.

Full Access
Question # 22

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?

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.

Full Access
Question # 23

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

A.

Review the metadata xml files for redundant fields to consolidate.

B.

Determine if any integration points create records in Salesforce.

C.

Run key reports to determine what fields should be required.

D.

Export the setup audit trail to review what fields are being used.

E.

Review the sharing model to determine impact on duplicate records.

Full Access
Question # 24

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

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

Full Access
Question # 25

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

Which solution should a data architect use to comply with the DR policy?

A.

Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

B.

Leverage salesforce weekly exports, and store data in Flat files on a protected system.

C.

Utilize an ETL tool to migrate data to an on-premise archive solution.

D.

Write a custom batch job to extract data changes nightly, and store in an external protected system.

Full Access
Question # 26

Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD’s sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

NTO’s management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

What should a data architect consider before implementing Salesforce Connect for reporting?

A.

Maximum number for records returned

B.

OData callout limits per day

C.

Maximum page size for server-driven paging

D.

Maximum external objects per org

Full Access
Question # 27

A customer needs a sales model that allows the following:

  • Opportunities need to be assigned to sales people based on the zip code.
  • Each sales person can be assigned to multiple zip codes.
  • Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.

What should a data architect recommend?

A.

Assign opportunities using list views using zip code.

B.

Add custom fields in opportunities for zip code and use assignment rules.

C.

Allow sales users to manually assign opportunity ownership based on zip code.

D.

Configure territory management feature to support opportunity assignment.

Full Access
Question # 28

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?

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.

Full Access
Question # 29

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?

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.

Full Access
Question # 30

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?

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.

Full Access
Question # 31

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

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.

Full Access
Question # 32

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

A.

Reference data policy.

B.

Data governance policy.

C.

Data sensitivity policy.

D.

Compliance categorization policy.

Full Access
Question # 33

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers

A.

AppExchange Apps

B.

Wave Analytics

C.

Weekly Snapshots

D.

Setup Audit Trails

Full Access