Free Data-Architecture-And-Management-Designer Braindumps Download Updated on Oct 30, 2021 with 215 Questions
Salesforce Data-Architecture-And-Management-Designer Exam Practice Test Questions
NEW QUESTION 109
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?
- A. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
- B. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
- C. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
- D. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
Answer: C
NEW QUESTION 110
Ursa Major Solar is performance testing a Lightning Platform application.
Which two statements are true about this testing? (Choose two.)
- A. A performance test plan must be created and submitted to Salesforce customer support.
- B. Applications with highly customized code or large volumes should be performance tested.
- C. Every Lightning Platform application must be performance tested in a sandbox as well as production.
- D. Application performance benchmarked in a sandbox can also be expected in production.
Answer: A,B
NEW QUESTION 111
Which three characteristics of a Skinny table help improve report and query performance?
- A. Skinny tables do not include records that are available in the recycle bin.
- B. Skinny tables provide a view across multiple objects for easy access to combined data.
- C. Skinny tables can contain frequently used fields and thereby help avoid joins.
- D. Skinny tables are kept in sync with changes to data in the source tables.
- E. Skinny tables can be used to create custom indexes on multi-select picklist fields.
Answer: B,C,D
NEW QUESTION 112
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 third-party AppExchange tools to monitor and measure data quality.
- C. Generate reports to view the quality of sample data.
- D. Use custom objects and fields to calculate data quality.
Answer: B
NEW QUESTION 113
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 Apex to validate the format of data being entered via a mobile device.
- C. Leverage validation rules and workflows.
- D. Leverage third-party- AppExchange tools
Answer: A,C
NEW QUESTION 114
UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.
- A. Use picklist fields rather than lookup to custom object.
- B. Limit associating 10000 opportunities to one account.
- C. Limit assigning one user 10000 records ownership.
- D. Limit associating 10000 records looking up to same records.
- E. Assign 10000 opportunities to one account.
Answer: B,C
NEW QUESTION 115
Universal Containers has a rollup summary field on account to calculate the count of contacts associated with an account. During the account load, Salesforce is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend to resolve the error?
- A. Perform batch job in parallel mode, and reduce batch size
- B. Leverage data loader platform API to load data
- C. Defer rollup summary fields calculation during data migration
- D. Perform batch job in serial mode, and reduce batch size
Answer: D
Explanation:
Explanation/Reference: https://salesforce.stackexchange.com/questions/181798/roll-up-summary-implications-and-behind- the-scenes-calculations
NEW QUESTION 116
Universal Containers wants 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 methods should be recommended to meet this requirement? Choose 2 answers
- A. Schedule a weekly export file from the Salesforce UI.
- B. Schedule jobs to export and delete using an ETL tool.
- C. Use the Force.com Workbench to export the data.
- D. Schedule jobs to export and delete using the Data Loader.
Answer: B,D
NEW QUESTION 117
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. Limitations on master -detail relationships.
- B. Standard list view in-line editing.
- C. Bulk API limitations on picklist fields.
- D. Org data storage limitations.
Answer: C,D
NEW QUESTION 118
Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)
- A. Performing large loads and deletions.
- B. Using NOT and != operators.
- C. Using leading % wildcards.
- D. Using a custom index on a deterministic formula field.
- E. Using trailing % wildcards.
Answer: B,C,D
NEW QUESTION 119
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. Share each report with fewer users.
- C. Create one skinny table per report.
- D. Index key fields used in report criteria.
Answer: C,D
NEW QUESTION 120
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 achieve this goal? (Choose two.)
- A. Acquire an AppExchange Lead de-duplication application.
- B. Run the Salesforce Lead Mass de-duplication tool.
- C. Create a Workflow Rule to check for duplicate records.
- D. Implement Salesforce Matching and Duplicate Rules.
Answer: A,D
NEW QUESTION 121
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?
- A. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
- B. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
- C. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.
- D. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
Answer: A
NEW QUESTION 122
Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
- A. Add description fields to explain why the field is used, and mark the fields as Required.
- B. Create validation rules with error messages to explain why the field is used.
- C. Create and manage a data dictionary, and use a governance process for changes made to common objects.
- D. Create reports to identify which fields users are leaving blank, and use external data sources to augment the missing data.
Answer: C
NEW QUESTION 123
UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.
What are the 3 key actions that should be done when data modeling in salesforce?
Choose 3 answers:
- A. Work with legacy application owner to analysis legacy data model.
- B. Identify data elements to be persisted in salesforce.
- C. Map legacy data to salesforce custom objects.
- D. Implement legacy data model within salesforce using custom fields.
- E. Map legacy data to salesforce objects.
Answer: B,D,E
NEW QUESTION 124
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
- A. Use the Force.com IDE to save the metadata files in source control.
- B. Put the business purpose in the Description of each field.
- C. Review the setup audit trail for configuration changes.
- D. Maintain a data dictionary with the justification for each field.
Answer: B,D
NEW QUESTION 125
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. Maintain required pricing criteria in custom metadata types.
- B. Create a custom object to maintain the pricing criteria.
- C. Assign the pricing criteria within custom pricing engine.
- D. Configure the pricing criteria in price books.
Answer: A
NEW QUESTION 126
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?
- A. Create custom fields to maintain latitude and longitude information
- B. Create a geolocation custom field to maintain this requirement
- C. Recommend AppExchange packages to support this requirement
- D. Create formula fields with geolocation function for this requirement
Answer: B
Explanation:
Explanation/Reference: https://help.salesforce.com/articleView?id=custom_field_geolocate_overview.htm&type=5
NEW QUESTION 127
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. Implement an Apex Trigger on Account that queries a third-party data quality API 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. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
Answer: D
NEW QUESTION 128
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. Limitations on master -detail relationships.
- B. Bulk API limitations on picklist fields.
- C. Standard list view in -line editing.
- D. Org data storage limitations.
Answer: B,C
NEW QUESTION 129
The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:
Select id, description, Subject from Task where WhatId != NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?
- A. Change the where clause to filter by a deterministic defined value.
- B. Remove description from the requested field set.
- C. Change query to SOSL. ??
- D. Add limit 100 to the query.
Answer: A
NEW QUESTION 130
......
Updated Verified Data-Architecture-And-Management-Designer dumps Q&As - Pass Guarantee or Full Refund: https://www.easy4engine.com/Data-Architecture-And-Management-Designer-test-engine.html
Updated Certification Exam Data-Architecture-And-Management-Designer Dumps - Practice Test Questions: https://drive.google.com/open?id=17AGnndymAHcp6Vo8wT9n5Vpvy5nioIbk
