Summer Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! Data-Architecture-And-Management-Designer has been withdrawn. The new exam code is Data-Architect

Data-Architecture-And-Management-Designer Practice Exam Questions with Answers Salesforce Certified Data Architect (WI23) Certification

Question # 6

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?

A.

Case SLA performance report

B.

Sales KPI Dashboard

C.

Opportunity analytic snapshot

D.

Lead conversion rate report

Full Access
Question # 7

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 thesame record.

C.

Migrate programmatic logic to processes and flows.

D.

Refactor or optimize classes and trigger for maximum CPU performance.

Full Access
Question # 8

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

A.

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

B.

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

C.

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

D.

Suggest MDM solution and link MDM to salesforce and SAP

Full Access
Question # 9

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

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

A.

Service Cloud

B.

Lightning platform Start

C.

Lightning Platform plus

D.

Lightning External Apps Starts

Full Access
Question # 10

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?

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.

Developcustom 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.

Full Access
Question # 11

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 thisteam? Choose 2 answers

A.

Analytics/BI Owners

B.

Data Domain Stewards

C.

Salesforce Administrators

D.

Operational Data Users

Full Access
Question # 12

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?

A.

Use StreamingAPI 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.

Full Access
Question # 13

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
Question # 14

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

State in which the customer is located

City in which the customer is located if available

Zip code In which the customer is located if available

Changes to this information should have minimum code changes

What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

A.

Create a custom object to maintain the pricing criteria.

B.

Assign the pricing criteria within customer pricing engine.

C.

Maintain require pricing criteria in custom metadata types.

D.

Configure the pricing criteria in price books.

Full Access
Question # 15

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

A.

Log a case with salesforce to make sharing rule changes.

B.

Enable Defer Sharing Calculation prior to making sharing rule changes.

C.

Delete old sharing rules and build new sharing rules

D.

Log out all users and make changes to sharing rules.

Full Access
Question # 16

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?

A.

Create a custom object to store the data.

B.

Use a standard big objectdefined by salesforce.

C.

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

D.

Implement a custom big object to store the data.

Full Access
Question # 17

DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.

Whatshould be considered to address this issue?

A.

Tooling API

B.

PK Chunking

C.

Metadata API

D.

Streaming API

Full Access
Question # 18

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”-basedapproach to classify the record storage need.

Full Access
Question # 19

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

A.

Index key fields used in report criteria.

B.

Enable Divisions for large data objects.

C.

Create one skinny table per report.

D.

Share each report with fewer users.

Full Access
Question # 20

Universal containers is implementing Salesforce lead management.  UC Procure lead data from multiple sources and would like to make surelead 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 profileand location data

Full Access
Question # 21

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

A.

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

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

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

Full Access
Question # 22

Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-outfailure. What is the recommended solution?

A.

Modify the export job header to specify Export-in-Parallel.

B.

Modify the export job header to specify Sforce-Enable-PKChunking.

C.

Modify the export query that includes standard index fields(s).

D.

Modify the export query with LIMIT clause with Batch size 10,000.

Full Access
Question # 23

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?

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.

Full Access
Question # 24

Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

What data extraction strategy should a data architect use for maximum performance?

A.

Install a third-party AppExchange tool.

B.

Call the REST API in successive queries.

C.

Utilize PK Chunking with the Bulk API.

D.

Use the Bulk API in parallel mode.

Full Access
Question # 25

UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality?

Choose 2 answers.

A.

Use custom objectsand fields to identify issues.

B.

Review data quality reports and dashboards.

C.

Install and run data quality analysis dashboard app

D.

Export data and check for data completeness outside of Salesforce.

Full Access
Question # 26

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.

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

Full Access
Question # 27

Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at GetCloudy Consulting need access to up to one week's worth of these status reports with all of their details.

An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.

Which two limits should the Architect be aware of? (Choose two.)

A.

Data storage limits

B.

Workflow rule limits

C.

API Request limits

D.

Webservice callout limits

Full Access
Question # 28

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?

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.

Full Access
Question # 29

(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.

A.

Change data capture (CDC)

B.

Salesforce connect.

C.

Federation search

D.

Salesforce 2 Salesforce

Full Access
Question # 30

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to thesefields, 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 thisrequirement? 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, thenschedule the report to run once a day and send email to the admin.

Full Access
Question # 31

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 # 32

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?

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.

Full Access
Question # 33

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

An Architect needs to determine which system is the system of record on afield level.

What should the Architect do to achieve this goal?

A.

Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

B.

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

C.

The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

D.

Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Full Access