Start your Data-Architecture-And-Management-Designer Exam Questions Preparation with Updated 224 Questions
A Fully Updated 2023 Data-Architecture-And-Management-Designer Exam Dumps - PDF Questions and Testing Engine
Data-Architecture-And-Management-Designer Exam topics
Candidates must know the exam topics before they start of preparation. Because it will really help them in hitting the core. Our Salesforce Data-Architecture-And-Management-Designer exam dumps will include the following topics:
1. Data Modeling/ Database Design 20%
- Compare and contrast the different reasons for implementing Big Objects vs Standard/Custom objects within a production instance, alongside the unique pros and cons of utilizing Big Objects in a Salesforce data model.
- Compare and contrast various techniques and considerations for designing a data model for the Customer 360 platform. (e.g. objects, fields & relationships, object features).
- Given a scenario, recommend approaches and techniques to design a scalable data model that obeys the current security and sharing model.
- Given a customer scenario, recommend approaches and techniques to avoid data skew (record locking, sharing calculation issues, and excessive child to parent relationships).
- Compare and contrast various techniques, approaches and considerations for capturing and managing business and technical metadata (e.g. business dictionary, data lineage, taxonomy, data classification).
2. Master Data Management: 5%
- Given a customer scenario, recommend appropriate approaches and techniques to capture and maintain customer reference & metadata to preserve traceability and establish a common context for business rules
- Compare and contrast the various techniques, approaches and considerations for implementing Master Data Management Solutions (e.g. MDM implementation styles, harmonizing & consolidating data from multiple sources, establishing data survivorship rules, thresholds & weights, leveraging external reference data for enrichment, Canonical modeling techniques, hierarchy management.)
- Given a customer scenario, recommend approaches and techniques for consolidating data attributes from multiple sources. Discuss criteria and methodology for picking the winning attributes.
- Given a customer scenario, recommend and use techniques for establishing a “golden record” or “system of truth” for the customer domain in a Single Org
3. Salesforce Data Management: 25%
- Given a scenario with multiple systems of interaction, describe techniques to represent a single view of the customer on the Salesforce platform.
- Given a customer scenario, recommend appropriate combination of Salesforce license types to effectively leverage standard and custom objects to meet business needs.
- Given a customer scenario, recommend a design to effectively consolidate and/or leverage data from multiple Salesforce instances.
- Given a customer scenario, recommend techniques to ensure data is persisted in a consistent manner.
4. Data Governance: 10%
- Given a customer scenario, recommend an approach for designing a GDPR compliant data model. Discuss the various options to identify, classify and protect personal and sensitive information.
- Compare and contrast various approaches and considerations for designing and implementing an enterprise data governance program.
5. Large Data Volume considerations: 20%
- Given a customer scenario, decide when to use virtualised data and describe virtualised data options.
- Given a customer scenario, design a data model that scales considering large data volume and solution performance.
- Given a customer scenario, recommend a data archiving and purging plan that is optimal for customer's data storage management needs.
6. Data Migration: 15%
- Given a customer scenario, recommend appropriate techniques and methods for ensuring high data quality at load time.
- Compare and contrast various techniques and considerations for exporting data from Salesforce.
- Compare and contrast various techniques for improving performance when migrating large data volumes into Salesforce.
NEW QUESTION 40
Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers
- A. Third -party Business Intelligence system
- B. Third -party Integration Tool (ETL)
- C. Apex Triggers
- D. Schedulable Batch Apex
Answer: B,D
NEW QUESTION 41
Which two methods should be used when importing Leads into Salesforce to ensure there are no duplicate records? Choose 2 answers
- A. Run the Salesforce Lead Mass de -duplication tool.
- B. Purchase an AppExchange Lead de -duplication application.
- C. Implement Salesforce Matching and Duplicate Rules.
- D. Create a Workflow Rule to check for duplicate records.
Answer: B,C
NEW QUESTION 42
Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?
- A. Duplicate Activity records on a Contact.
- B. Duplicate Contact records exist in the system.
- C. Missing phone number on the Contact record.
- D. Customer phone number has changed on the Contact record.
Answer: B
NEW QUESTION 43
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
- A. Errors with records being updated and inserted in the same CSV file.
- B. Errors with duplicate external Id values within the same CSV file.
- C. Errors with using the wrong external Id will cause the load to fail.
- D. Errors when a duplicate Contact name is found cause upsert to fail.
Answer: B
NEW QUESTION 44
NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:
- A. Finalize an extract transform load (ETL) tool for data migration
- B. Measure data completeness and accuracy
- C. Measure data timeliness and consistency
- D. Define data duplication standards and rules
- E. Define key fields in staging database for data cleansing
Answer: B,C,D
NEW QUESTION 45
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA in APAC orgs after the products are approved.
Which two features should a data architect recommend to share records between Salesforce orgs? (Choose two.)
- A. Salesforce Connect
- B. Change Data Capture (CDC)
- C. Salesforce 2 Salesforce
- D. Federated Search
Answer: A,B
NEW QUESTION 46
A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out?
(Choose two.)
- A. Create custom indexes on the fields used in the filter criteria.
- B. Create a formula field instead of having multiple filter criteria.
- C. Modify the integration users' profile to have View All Data.
- D. Make sure the query doesn't contain NULL in any filter criteria.
Answer: A,D
NEW QUESTION 47
Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g.,
"ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs.
"White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?
- A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.
- B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.
- C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
- D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.
Answer: C
NEW QUESTION 48
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
- A. Create a validation rule and translate the error message with translation workbench.
- 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. Implement a third -party validation process with translate functionality.
Answer: A,B
NEW QUESTION 49
Cloud Kicks has the following requirements:
- They want to automatically archive all inactive Account data that is older than 3 years.
- The information does not need to remain accessible within the application.
Which two approaches should the Architect recommend to meet this requirement? (Choose two.)
- A. Schedule jobs to export and delete using an ETL tool.
- B. Schedule a weekly export file from the Salesforce UI.
- C. Export the data by using the Force.com Workbench.
- D. Schedule jobs to export and delete using the Data Loader.
Answer: A,D
Explanation:
Explanation/Reference:
NEW QUESTION 50
Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solution should a data architect recommend to mitigate data quality issues?
- A. Leverage picklist and lookup fields where possible
- B. Leverage third-party- AppExchange tools
- C. Leverage Apex to validate the format of data being entered via a mobile device.
- D. Leverage validation rules and workflows.
Answer: A,D
NEW QUESTION 51
Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records.
What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?
- A. Load all individual consumers as Account records and avoid using the Contact object.
- B. Create a Custom Object Individual Consumer c to load all individual consumers.
- C. Create one Account and load individual consumers as Contacts linked to that one Account.
- D. Load one Account record and one Contact record for each individual consumer.
Answer: D
NEW QUESTION 52
Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce 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 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?
- A. Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates.
- B. Create a custom field for Opportunity amount that PPS updates separating the field sales user updates.
- C. Change PPS integration to update only Opportunity Amount field when the value is null.
- D. Change Opportunity Amount field access to Read Only for sales users using field-level security.
Answer: A
NEW QUESTION 53
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. Create Contact and Opportunity Reports and Dashboards.
- B. Create a report on Case analytic snapshots.
- C. Install AppExchange packages for available reports.
- D. Enable field history tracking on the Case object.
Answer: D
NEW QUESTION 54
Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- A. Bulk API limitations on picklist fields.
- B. Org data storage limitations.
- C. Limitations on master -detail relationships.
- D. Standard list view in -line editing.
Answer: A,D
NEW QUESTION 55
A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
1. Payment Providers: Orgas who pay for the care 2 patients.
2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
3. Patients: They are individuals who need care.
A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?
- A. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts
- B. Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts
- C. Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts
- D. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account
Answer: C
NEW QUESTION 56
Which two statements are accurate with respect to performance testing a Force.com application?
- A. Application performance benchmarked in a sandbox can also be expected in production.
- B. Applications with highly customized code or large volumes should be performance tested.
- C. All Force.com applications must be performance tested in a sandbox as well as production.
- D. A performance test plan must be created and submitted to Salesforce customer support.
Answer: B,D
NEW QUESTION 57
Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, Opportunity data, and Order data are available to authenticated users.
3. Authenticated users may need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which Community Cloud license type should a data architect recommend to meet the portal requirements?
- A. Customer Community Plus
- B. Lightning External Apps Starter
- C. Partner Community
- D. Customer Community
Answer: C
NEW QUESTION 58
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?
- A. Create lookup to Custom Price object and share with distributors.
- B. Manually update Opportunities with Prices application to distributors.
- C. Configure price Books for each region and share with distributors.
- D. Add custom fields in Opportunity and use triggers to update prices.
Answer: C
NEW QUESTION 59
Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers
- A. Create a Visualforce page combining Salesforce Account data and Invoice external object data.
- B. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
- C. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
- D. Create a report combining data from the Account standard object and the Invoices external object.
Answer: A,B
NEW QUESTION 60
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?
- A. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
- B. Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION 61
Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO'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 license does NTO need to provide these features to the franchisees?
- A. Salesforce Sales Cloud License
- B. Lighting Platform License
- C. Partner Community License
- D. Customer Community License
Answer: A
NEW QUESTION 62
......
Certification Path
Salesforce Administrator Certification is a prerequisite for this exam.
Easy Success Salesforce Data-Architecture-And-Management-Designer Exam in First Try: https://torrentpdf.validvce.com/Data-Architecture-And-Management-Designer-exam-collection.html
