Exam Dumps Data-Architecture-And-Management-Designer Practice Free Latest Salesforce Practice Tests
Data-Architecture-And-Management-Designer Exam Questions | Real Data-Architecture-And-Management-Designer Practice Dumps
For more info visit:
Data-Architecture-And-Management-Designer Exam Reference
How much Data-Architecture-And-Management-Designer Exam Cost
The price of the Salesforce Data-Architecture-And-Management-Designer exam is $400 USD and exam retake fee is $200 USD.
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.
- 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).
- Compare and contrast various techniques and considerations for designing a data model for the Customer 360 platform. (e.g. objects, fields & relationships, object features).
2. Master Data Management: 5%
- 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 and use techniques for establishing a “golden record” or “system of truth” for the customer domain in a Single Org
- 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
- Given a customer scenario, recommend approaches and techniques for consolidating data attributes from multiple sources. Discuss criteria and methodology for picking the winning attributes.
3. Salesforce Data Management: 25%
- 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.
- Given a scenario with multiple systems of interaction, describe techniques to represent a single view of the customer on the Salesforce platform.
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, recommend a data archiving and purging plan that is optimal for customer's data storage management needs.
- 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.
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 108
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 a formula field instead of having multiple filter criteria.
- B. Modify the integration users' profile to have View All Data.
- C. Create custom indexes on the fields used in the filter criteria.
- D. Make sure the query doesn't contain NULL in any filter criteria.
Answer: C,D
NEW QUESTION 109
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. Enable Divisions for large data objects.
- B. Create one skinny table per report.
- C. Index key fields used in report criteria.
- D. Share each report with fewer users.
Answer: B,C
NEW QUESTION 110
Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?
- A. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
- B. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
- C. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
- D. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
Answer: C
NEW QUESTION 111
Members of DreamHouse Realty sales team are reporting that searches are yielding too many irrelevant, outdated records. Management requires that data for historical reporting. DreamHouse Realty has enough data storage.
In this situation, which strategy should a data architect use to ensure a better user experience for the Sales Reps?
- A. Hide old data from Sales Reps by creating a Permission Set.
- B. Hide old data from Sales Reps by setting data access to Private.
- C. Use Batch Apex to archive old data on a rolling nightly basis.
- D. Archive and purge old data from Salesforce on a monthly basis.
Answer: D
NEW QUESTION 112
UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.
What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:
- A. Create new fields to store additional values from all the systems.
- B. Utilize an ETL tool to merge, transform and de-duplicate data.
- C. Work with Stakeholders to define record and field survivorship rules
- D. Install a 3rd party AppExchange tool to handle the merger
- E. Analyze each system's data model and perform gap analysis
Answer: B,C,E
NEW QUESTION 113
NTO uses salesforce to manage relationships and track sales 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 3 answers:
- A. Reduce the amount of data queried by archiving unused opportunity records.
- B. De-normalize the data by reducing the number of joins.
- C. Run the dashboard for CEO and send it via email.
- D. Use selective queries to reduce the amount of data being returned.
- E. Remove widgets from the dashboard to reduce the number of graphics loaded.
Answer: A,B,D
NEW QUESTION 114
Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?
- A. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
- B. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
- C. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
- D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
Answer: B
NEW QUESTION 115
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.)
- A. Limitations on Org data storage.
- B. Standard list view in-line editing.
- C. Bulk API limitations on picklist fields.
- D. Limitations on master-detail relationships.
Answer: A,C
NEW QUESTION 116
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. Partner Community
- B. Customer Community
- C. Lightning External Apps Starter
- D. Customer Community Plus
Answer: A
NEW QUESTION 117
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
- A. Limit Batch to 10K records
- B. Export in multiple batches
- C. Use PK Chunking
- D. Export Bulk API in parallel mode
Answer: B,C
NEW QUESTION 118
Universal Containers (UC) 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. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
- A. Load all data after deferring sharing calculations.
- B. Use workflow to calculate summary values instead of Roll -Up.
- C. Use triggers to calculate summary values instead of Roll -Up.
- D. Load all data using external IDs to link to parent records.
Answer: A
NEW QUESTION 119
Ursa Major Solar has 4 million rows of data in Salesforce that are used in reports to assess historical trends.
Both performance and data storage limits have become an issue.
Which two strategies are appropriate when discussing the issue with stakeholders? (Choose two.)
- A. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
- B. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
- C. Utilize scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
- D. Utilize Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
Answer: B,C
NEW QUESTION 120
Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?
- A. Do client-side validation of phone number and email field formats.
- B. Ensure the website visitor is browsing using an HTTPS connection.
- C. Prefer picklist form fields over free text fields, where possible.
- D. Use cookies to track when visitors submit multiple forms.
Answer: A,C
NEW QUESTION 121
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?
- A. Use AppExchange package for backup and restore.
- B. Change weekly backup process to daily backup, and implement a custom restore solution.
- C. Use ETL for backup and restore from EDW.
- D. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
Answer: A
NEW QUESTION 122
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. Export the data to an enterprise data warehouse and use BI tools for data quality.
- B. Use custom objects and fields to calculate data quality.
- C. Generate reports to view the quality of sample data.
- D. Use third-party AppExchange tools to monitor and measure data quality.
Answer: D
NEW QUESTION 123
Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?
- A. Update these Opportunity field definitions in Setup to be required.
- B. Use a validation rule for each field that takes the Stage into consideration.
- C. Write an Apex trigger that checks each field when records are saved.
- D. Update the Opportunity page layout to mark these fields as required.
Answer: B
NEW QUESTION 124
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 de-normalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- A. Org data storage limitations.
- B. Limitations on master -detail relationships.
- C. Standard list view in-line editing.
- D. Bulk API limitations on picklist fields.
Answer: A,D
NEW QUESTION 125
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this?
Choose two answers.
- A. Limit Batch to 10K records
- B. Export in multiple batches
- C. Use PK Chunking
- D. Export Bulk API in parallel mode
Answer: B,C
NEW QUESTION 126
NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?
- A. Use ETL tool for extraction of records.
- B. Use a custom auto number and formula field and use that to chunk records while extracting data.
- C. Ask SF support to increase the query timeout value.
- D. The REST API to extract data as it automatically chunks records by 200.
Answer: A
NEW QUESTION 127
Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
- A. Use the SOAP API to export data.
- B. Use GZIP compression to export the data.
- C. Utilize the Bulk API to export the data.
- D. Schedule a Batch Apex job to export the data.
Answer: B
NEW QUESTION 128
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:
- A. Event monitoring to monitor all user activities
- B. Transaction security policies to prevent export of SF Data.
- C. Restrict access to SF from users outside specific geography
- D. Encrypt Sensitive Customer information maintained in SF.
- E. Prevent Sales users access to customer PII information
Answer: B,C,D
NEW QUESTION 129
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
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. Maintain required pricing criteria in custom metadata types.
- C. Assign the pricing criteria within custom pricing engine.
- D. Configure the pricing criteria in price books.
Answer: B
NEW QUESTION 130
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. Schedule jobs to export and delete using the Data Loader.
- D. Export the data by using the Force.com Workbench.
Answer: A,C
NEW QUESTION 131
UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.
Which object model should a data architect configure within SF ?
- A. Leverage standard account and contact object in SF
- B. Leverage custom person account object in SF
- C. Leverage custom account and contact object in SF
- D. Leverage person account object in Salesforce
Answer: D
NEW QUESTION 132
Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
- A. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
- B. Implement a Master Data Management system to determine system of record.
- C. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
- D. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.
Answer: C
NEW QUESTION 133
......
Verified Data-Architecture-And-Management-Designer Exam Dumps Q&As - Provide Data-Architecture-And-Management-Designer with Correct Answers: https://www.exam4labs.com/Data-Architecture-And-Management-Designer-practice-torrent.html
Pass Your Data-Architecture-And-Management-Designer Dumps Free Latest Salesforce Practice Tests: https://drive.google.com/open?id=1-hKoK8C8dtDDL9ebi5mUh7Vc9BHH9vsL