Labour Day 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

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 5

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 6

UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.

What should a data architect recommend to reduce the performance degradation of the platform?

Options:

A.

Create a custom object to store the data.

B.

Use a standard big object defined by salesforce.

C.

Use the standard “Order” object to store the data.

D.

Implement a custom big object to store the data.

Buy Now
Questions 7

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

Options:

A.

AppExchange Apps

B.

Wave Analytics

C.

Weekly Snapshots

D.

Setup Audit Trails

Buy Now
Questions 8

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

Options:

A.

Analytics/BI Owners

B.

Data Domain Stewards

C.

Salesforce Administrators

D.

Operational Data Users

Buy Now
Questions 9

NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

Which solution should the data architect use to reduce the amount of returned mails?

Options:

A.

Use a 3rd-party data source to update contact information in salesforce.

B.

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

C.

Delete contacts when the mail is returned to save postal cost to NTO.

D.

Have the sales team to call all existing customers and ask to verify the contact details.

Buy Now
Questions 10

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?

Options:

A.

Lightning platform starter license.

B.

Service cloud license.

C.

Salesforce license.

D.

Sales cloud license

Buy Now
Questions 11

UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

Options:

A.

Consolidate the data from each org into a centralized datastore

B.

Use Salesforce Connect’s cross-org adapter.

C.

Build a bidirectional integration between all orgs.

D.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

Buy Now
Questions 12

Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

What should an Architect do to meet these requirements?

Options:

A.

Set the profile of the users to remove delete permission from the Contact object.

B.

Check if the current user is NOT the owner by creating a "before delete" trigger.

C.

Set the Sharing settings as Public Read Only for the Contact object.

D.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

Buy Now
Questions 13

NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.

In salesforce, the customer is represented by the contact object.

NTO utilizes an MDM solution with these attributes:

1.The MDM solution keeps track of customer master with a master key.

2.The master key is a map to the record ID’s from each external system that customer data is stored within.

3.The MDM solution provides de-duplication features, so it acts as the single source of truth.

How should a data architect implement the storage of master key within salesforce?

Options:

A.

Store the master key in Heroku postgres and use Heroku connect for synchronization.

B.

Create a custom object to store the master key with a lookup field to contact.

C.

Create an external object to store the master key with a lookup field to contact.

D.

Store the master key on the contact object as an external ID (Field for referential imports)

Buy Now
Questions 14

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Options:

A.

Reduce data storage by purging old data.

B.

Implement an AppExchange package.

C.

Review projected data storage needs.

D.

Schedule a weekly export file.

Buy Now
Questions 15

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

Options:

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.

Buy Now
Questions 16

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.

Buy Now
Questions 17

NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

Options:

A.

Salesforce Sales Cloud license

B.

Lightning Platform license

C.

Customer Community license

D.

Partner Community license

Buy Now
Questions 18

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?

Options:

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

Buy Now
Questions 19

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 20

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 21

The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.

What is one reporting option Get Cloudy Consulting should consider?

Options:

A.

Case SLA performance report

B.

Sales KPI Dashboard

C.

Opportunity analytic snapshot

D.

Lead conversion rate report

Buy Now
Questions 22

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 23

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 24

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

Options:

A.

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

B.

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

C.

Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

D.

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

Buy Now
Questions 25

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

Options:

A.

Tooling API

B.

PK Chunking

C.

Metadata API

D.

Streaming API

Buy Now
Questions 26

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.

Buy Now
Questions 27

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?

Options:

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.

Buy Now
Questions 28

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

Options:

A.

Use a field audit trail to capture field changes.

B.

Use a custom object and trigger to capture changes.

C.

Use Event Monitoring to capture these changes.

D.

Use a third-party AppExchange app to capture changes.

Buy Now
Questions 29

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 30

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.

Buy Now
Questions 31

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

Options:

A.

Standard list view in-line editing.

B.

Limitations on Org data storage.

C.

Bulk API limitations on picklist fields.

D.

Limitations on master-detail relationships.

Buy Now
Questions 32

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

Which two approaches will accomplish this goal? (Choose two.)

Options:

A.

Create the users, upload all data, and then deploy the sharing rules.

B.

Contact Salesforce to activate indexing before uploading the data.

C.

First, load all account records, and then load all user records.

D.

Defer sharing calculations until the data has finished uploading.

Buy Now
Questions 33

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.

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SP24)
Last Update: May 5, 2024
Questions: 257
$64  $159.99
$48  $119.99
$40  $99.99
buy now Data-Architect