A fully updated 2021 Data-Architecture-And-Management-Designer Exam Dumps exam guide from training expert Pass4Leader
Provides complete coverage of every objective on exam and exam preparation Data-Architecture-And-Management-Designer
NEW QUESTION 101
Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?
- A. Ask Salesforce support for additional CPU power
- B. Enable sharing recalculations
- C. Enable granular locking
- D. Remove SOQL statements from Apex Loops
Answer: C
Explanation:
Explanation/Reference: https://help.salesforce.com/articleView?id=000325942&language=en_US&type=1&mode=1
NEW QUESTION 102
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. Recommend AppExchange packages to support this requirement
- B. Create custom fields to maintain latitude and longitude information
- C. Create formula fields with geolocation function for this requirement
- D. Create a geolocation custom field to maintain this requirement
Answer: D
Explanation:
Explanation/Reference: https://help.salesforce.com/articleView?id=custom_field_geolocate_overview.htm&type=5
NEW QUESTION 103
UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?
- A. Create a criteria-based sharing rule.
- B. Add appropriate users to the account team.
- C. Create an owner-based sharing rule.
- D. Implicit sharing will automatically handle with standard functionality.
Answer: D
NEW QUESTION 104
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. Recommend app exchange packages to support this requirement.
- B. Create custom fields to maintain latitude and longitude information
- C. Create formula fields with geolocation function for this requirement.
- D. Create a geolocation custom field to maintain this requirement
Answer: D
NEW QUESTION 105
Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?
- A. Extract the Salesforce data into Excel and manually compare this against the trusted source.
- B. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
- C. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
- D. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
Answer: D
NEW QUESTION 106
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries.
UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?
- A. Add custom indexes to all fields on Application without a standard index.
- B. Add custom indexes to the Date fields used for filtering the report.
- C. Run multiple reports to get different pieces of the data and combine them.
- D. Ask support to create a skinny table for Application with the necessary reporting fields.
Answer: B,D
NEW QUESTION 107
Universal Containers (UC) has a Salesforce instance with over 10.000 Account records.
They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?
- A. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
- B. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.
- C. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
- D. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
Answer: A
NEW QUESTION 108
UC is planning a massive SF implementation with large volumes of dat
a. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?
- A. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- B. Leverage the Bulk API and concurrent processing with multiple batches
- C. Load the data through data loader, and turn on parallel processing.
- D. Enable defer sharing calculations, and suspend sharing rule calculations
Answer: D
NEW QUESTION 109
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. Create one Account and load individual consumers as Contacts linked to that one Account.
- B. Load all individual consumers as Account records and avoid using the Contact object.
- C. Create a Custom Object Individual Consumer c to load all individual consumers.
- D. Load one Account record and one Contact record for each individual consumer.
Answer: D
NEW QUESTION 110
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. Leverage data loader platform API to load data
- B. Perform batch job in serial mode, and reduce batch size
- C. Defer rollup summary fields calculation during data migration
- D. Perform batch job in parallel mode, and reduce batch size
Answer: B
Explanation:
Explanation/Reference: https://salesforce.stackexchange.com/questions/181798/roll-up-summary-implications-and-behind- the-scenes-calculations
NEW QUESTION 111
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
- A. Define external IDs for an object, Insert data from one database, and use upsert for a second database
- B. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
- C. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
- D. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
Answer: A
NEW QUESTION 112
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 113
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. Lightning platform Start
- B. Service Cloud
- C. Lightning External Apps Starts
- D. Lightning Platform plus
Answer: D
NEW QUESTION 114
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 using external IDs to link to parent records.
- 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 after deferring sharing calculations.
Answer: D
NEW QUESTION 115
UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.
What should a data architect suggest to achieve this 360-degree view of the customer?
- A. Use Salesforce Connect's cross-org adapter.
- B. Consolidate the data from each org into a centralized datastore
- C. Build a bidirectional integration between all orgs.
- D. Use an ETL tool to migrate gap Accounts and Contacts into each org.
Answer: B
NEW QUESTION 116
Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this 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 the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)
- A. Create an external ID field for each object in the target org and map source record IDs to this field.
- B. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
- C. Replace source record IDs with new record IDs from the target org in the import file.
- D. Use data loader to export the data from the source org and then import/upsert into the target org in sequential order.
- E. Keep the relationship fields populated with the source record IDs in the import file.
Answer: A,D,E
NEW QUESTION 117
Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?
- A. Use 50 umbrella Accounts for each region, with customers as associated Contacts.
- B. Use the Account object with a newly created Record Type for B2C customers.
- C. Create a new picklist value for B2C customers on the Account Type field.
- D. Use the Account object with Person Accounts and a new B2C page layout.
Answer: D
NEW QUESTION 118
NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?
- A. Metadata API
- B. Tooling API
- C. SOAP API
- D. Bulk API in serial mode
Answer: A
NEW QUESTION 119
Universal Containers (UC) is planning to launch its Customer Community. The community will allow user to register shipment requests which are then processed by UC employees.
Shipment requests contain header information, and then a list of no more than 5 items being shipped. UC will initially roll out its community to 5,000 customers in Europe, and will ultimately roll out to 20,000 customers worldwide within the next two years. UC expects an average of 10 shipment requests per week per customer. UC wants customers to be able to view up to three years of shipment requests and use Saleforce reports. What is the recommended solution for UC's Data Architect to address the requirements?
- A. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.
- B. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
- C. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.
- D. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku's Postgres database.
Answer: B
NEW QUESTION 120
UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
Date time stamps for created date and last modified date.
Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.
- A. Log a case with SF to update these fields
- B. Enable Set Audit fields upon Record Creation Permission
- C. Enable update records with Inactive Owners Permission
- D. Enable modify all and view all permission.
Answer: B,C
NEW QUESTION 121
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. Limit assigning one user 10000 records ownership.
- B. Assign 10000 opportunities to one account.
- C. Use picklist fields rather than lookup to custom object.
- D. Limit associating 10000 records looking up to same records.
- E. Limit associating 10000 opportunities to one account.
Answer: A,E
NEW QUESTION 122
An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
- A. Create indexes on Opportunity object text fields.
- B. Sort batches by Name field values.
- C. Group batches by the AccountId field.
- D. Order batches by Auto -number field.
Answer: D
NEW QUESTION 123
......
Tested Material Used To Data-Architecture-And-Management-Designer: https://www.pass4leader.com/Salesforce/Data-Architecture-And-Management-Designer-exam.html
Steps Necessary To Pass The Data-Architecture-And-Management-Designer Exam: https://drive.google.com/open?id=1A8sNI2VKgRKzVrNBm5CEkif3uGniJFOL