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

Note! The Data-Architecture-And-Management-Designer Exam is no longer available. Get in touch with our Live Chat or email us for more information about the Data-Architect Exam.

Data-Architecture-And-Management-Designer Salesforce Certified Data Architect (WI23) Questions and Answers

Questions 4

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 5

Universal Containers (UC) is planning to moveaway from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Options:

A.

Afterthe data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.

B.

Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.

C.

Enable"Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

D.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Buy Now
Questions 6

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an “Unable to locka row” error.

Which solution should a data architect recommend, to resolve the error?

Options:

A.

Leverage data loader platform API to load data.

B.

Perform Batch job in parallel mode and reduce Batch size

C.

Perform Batch job in serial mode and reduce batch size

D.

Defer roll-up summary fields calculation during data migration.

Buy Now
Questions 7

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achievethis goal? (Choose two.)

Options:

A.

Acquire an AppExchange Lead de-duplication application.

B.

Implement Salesforce Matching and Duplicate Rules.

C.

Run the Salesforce Lead Mass de-duplication tool.

D.

Create a Workflow Rule to check for duplicate records.

Buy Now
Questions 8

UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

Options:

A.

Archive Case data using Salesforce Archiving process

B.

Purchase more data storage to support case object

C.

Use a custom object to store archived case data.

D.

Use a custom Big object to store archived case data.

Buy Now
Questions 9

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department withmissing 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 required 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 10

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 11

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

Options:

A.

Review the setup audit trail for configuration changes.

B.

Put the business purpose in the Description of each field.

C.

Maintain a data dictionary with the justification for each field.

D.

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

Buy Now
Questions 12

To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) andothers, a SF customer decided to categorize each data element in SF with the following:

  • Data owner
  • Security Level, such as confidential
  • Compliance types such as GDPR, PII, HIPPA

A compliance audit would require SF admins to generate reports to manage compliance.

What should a data architect recommend to address this requirement?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 13

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

Options:

A.

Create formula fields with geolocation function for this requirement.

B.

Create custom fields to maintain latitude and longitude information

C.

Create a geolocation custom field to maintain this requirement

D.

Recommend app exchange packages to support this requirement.

Buy Now
Questions 14

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

Data-Architecture-And-Management-Designer Question 14

What should the Architect consider in this situation?

Options:

A.

Load all data after deferring sharing calculations.

B.

Calculate summary values instead of Roll-Up by using workflow.

C.

Calculate summary values instead of Roll-Up by using triggers.

D.

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

Buy Now
Questions 15

A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Options:

A.

Import Account records first followed by order records after sorting order by OrderID.

B.

Import Account records firstfollowed by order records after sorting orders by AccountID.

C.

Change the relationship to Lookup and update the relationship to master-detail after import.

D.

Import Order records and Account records separately and populate AccountID in orders using batchApex.

Buy Now
Questions 16

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B).UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.

Which 3 options should a data architect recommend to share data between Org A and Org B?

Choose 3 answers.

Options:

A.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

B.

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

C.

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

D.

Leveragemiddleware tools to bidirectionally send Opportunity data across orgs.

E.

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

Buy Now
Questions 17

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for upto 7 years.

Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?

Choose 2 answers:

Options:

A.

Export data out of salesforce and store in Flat files on external system.

B.

Create a custom object to store case history and run reports on it.

C.

Leverage on premise data archival and build integration to view archived data.

D.

Leverage big object to archive case data and lightning components to show archived data.

Buy Now
Questions 18

NTO uses salesforce to manage relationships and tracksales 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 3answers:

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 itvia email.

E.

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

Buy Now
Questions 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 addingad-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.

Createa 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 Dashboardusing Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Buy Now
Questions 20

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

Options:

A.

Query only indexed ID field values on the imported order to import related order lines.

B.

Leverage an External ID from source system orders to import related order lines.

C.

Leverage Batch Apex to update order ID on related order lines after import.

D.

Leverage a sequence of numbers on the imported orders to import related order lines.

Buy Now
Questions 21

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:

  • Date time stamps for created date and last modifieddate.
  • Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Options:

A.

Log a case with SF to update these fields

B.

Enable update records with Inactive Owners Permission

C.

Enable Set Audit fields upon Record Creation Permission

D.

Enable modify all and view all permission.

Buy Now
Questions 22

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?

Options:

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.

Buy Now
Questions 23

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 24

Universal Containers (UC) is migrating from an on-premise homegrown customer relationshipmanagement (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 25

The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and helpmanagers 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 26

Northern Trail Outfitters has these simple requirements for a data export process:

File format should be in CSV.

Process should be scheduled and run once per week.

The expert should be configurablethrough the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

Options:

A.

Bulk API

B.

Data export wizard

C.

Third-party ETL tool

D.

Data loader

Buy Now
Questions 27

An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.

Which two key artifacts should the Architect use? (Choose two.)

Options:

A.

User stories

B.

Data model

C.

Integration specification

D.

Non-functional requirements

Buy Now
Questions 28

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTOusing Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?

Choose 3 answers:

Options:

A.

Create a 2nd system Admin user for authentication to the external source.

B.

Develop an object relationship strategy.

C.

Identify the external tables to sync into external objects

D.

Assess whether the external data source is reachable via an ODATA endpoint.

E.

Configure a middleware tool to poll external table data

Buy Now
Questions 29

An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

Options:

A.

Implement a third -party validation process with translate functionality.

B.

Create a trigger on Contact and add an error to the record with a custom label.

C.

Create a workflow field update to set the standard ErrorMessage field.

D.

Create a validation rule and translate the error message with translation workbench.

Buy Now
Questions 30

Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are twoautomated approaches to fulfill this goal? (Choose two.)

Options:

A.

Third-party Integration Tool (ETL)

B.

Schedulable Batch Apex

C.

Third-party Business Intelligence system

D.

Apex Triggers

Buy Now
Questions 31

Cloud Kicks has the followingrequirements:

• 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 ofthe 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 32

UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.

To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.

Which 2 tasks are required to define the strategy? Choose 2 answers:

Options:

A.

Identify the recovery point objective.

B.

Identify how the archive data will be accessed and used.

C.

Identify the recovery time objective.

D.

Identify the data retention requirements

Buy Now
Questions 33

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

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 thecontacts 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 thesync is complete.

Buy Now
Exam Name: Salesforce Certified Data Architect (WI23)
Last Update: Nov 29, 2023
Questions: 1
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 28 Mar 2024