Pre-Summer Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

Data-Architecture-And-Management-Designer Sample Questions Answers

Questions 4

Northern Trail Outfitters (NTO) has the following systems:

Customer master-source of truth for customer information

Service cloud-customer support

Marketing cloud-marketing support

Enterprise data warehouse—business reporting

The customer data is duplicatedacross all these system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.

NTO is planning to implement master data management (MDM) solution across the enterprise.

Which three data will an MDM tool solve?

Choose 3 answers

Options:

A.

Data completeness

B.

Data loss and recovery

C.

Data duplication

D.

Data accuracy and quality

E.

Data standardization

Buy Now
Questions 5

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part ofthis 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 6

A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:

  • Personally, identifiable information (PII)
  • IP restrictions on profiles organized by Geographic location
  • Financial records that need to be private and accessible only by the assigned Sales associate.
  • User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Options:

A.

Event monitoring to monitor all user activities

B.

Restrict access to SF from users outside specific geography

C.

Prevent Sales users access to customer PII information

D.

Transaction security policies to prevent export of SF Data.

E.

Encrypt Sensitive Customer information maintained in SF.

Buy Now
Questions 7

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an externalsystem. NTO will need to report on this asset data weekly.

Which two native tools should a data architect recommend to achieve this reporting requirement?

Options:

A.

Standard reports and dashboards

B.

Async SOQL with a custom object

C.

Standard SOQL queries

D.

Einstein Analytics

Buy Now
Questions 8

Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Options:

A.

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

B.

Create a custom account plan objectas detail with Account as master with additional sharing rules to allow access.

C.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

D.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

Buy Now
Questions 9

Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.

What should the data architect do in order to migrate the data to Salesfoce?

Options:

A.

Create custom objects to store agent relationships.

B.

Migrate to Salesforce without a record owner.

C.

Assign record owner based on relationship.

D.

Migrate the data and assign to a non-person system user.

Buy Now
Questions 10

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 11

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 12

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 13

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 14

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 15

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Options:

A.

Use Duplicate Management.

B.

Use an Enterprise Service Bus.

C.

Use Data.com Clean

D.

Use a data wharehouse.

Buy Now
Questions 16

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect

1. The data model for Org B will drastically change with different objects, fields, and picklist values.

2. Three million records will need to be migrated from org A to org B for compliance reasons.

3. The migrate will need occur within the next two month, prior to be split.

Which migrate strategy should a data architect use to successfully migrate the date?

Options:

A.

use as ETL tool to orchestrate the migration.

B.

Use Data Loader for export and Data Import Wizard forimport

C.

Write a script to use the Bulk API

D.

Use the Salesforces CLI to query, export, and import

Buy Now
Questions 17

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 productprices 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 18

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 19

NTO has a loyalty program to reward repeat customers. The following conditions exists:

1.Reward levels are earned based on the amount spent during the previous 12 months.

2.The program will track every item a customer has bought and grant them points for discount.

3.The program generates 100 million records each month.

NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.

Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Options:

A.

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

B.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

C.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

D.

Create a custom big object to capturethe reward program data and display it on the contact record and update nightly from the point-of-scale system.

Buy Now
Questions 20

A large insurance provider is looking to implement Salesforce. The following exist.

1. Multiple channel for lead acquisition

2.Duplication leads across channels

3. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Options:

A.

Build process is manually search and merge duplicates.

B.

Standard lead information across all channels.

C.

Build a custom solution to identify and merge duplicate leads.

D.

Implement third-party solution to clean and event lead data.

E.

Implement de-duplication strategy to prevent duplicate leads

Buy Now
Questions 21

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Options:

A.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM iseventually retired.

B.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

C.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

D.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

Buy Now
Questions 22

Which two bestpractices 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 fieldsare pre-indexed.

D.

Use Find in “ALL FIELDS” for faster searches.

Buy Now
Questions 23

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 24

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.

Options:

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.

Buy Now
Questions 25

Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?

Options:

A.

Mandate the selection of a custom product for each discount request.

B.

Create a placeholder product record for the generic discount request.

C.

Remove the master-detail relationship and keep the objects separate.

D.

Change the master-detail relationship to a lookup relationship.

Buy Now
Questions 26

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.

Which license type will UC users need to fulfill UC's requirements?

Options:

A.

Sales Cloud License

B.

Lightning Platform Starter License

C.

Service Cloud License

D.

SalesforceLicense

Buy Now
Questions 27

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

Options:

A.

validation Rule

B.

required Fields

C.

Apex Class

D.

Process Builder

Buy Now
Questions 28

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 29

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updatesby users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

Options:

A.

Ensure validation rules, triggers and other automation tools are disabled.

B.

Ensure duplication and matching rules and defined.

C.

Import the data in smaller batches over a 24-hour period.

D.

Bulkily the trigger to handle importleads.

Buy Now
Questions 30

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 31

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?

Options:

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.

Buy Now
Questions 32

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

Options:

A.

Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

B.

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

C.

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

D.

Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Buy Now
Questions 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?

Options:

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.

Buy Now
Status:
Expired , and Replaced By
Exam Code: Data-Architecture-And-Management-Designer
Exam Name: Salesforce Certified Data Architect (WI23)
Last Update: Apr 14, 2023
Questions: 1
$57.75  $164.99
$43.75  $124.99
$36.75  $104.99
buy now Data-Architecture-And-Management-Designer