Exam Details

  • Exam Code
    :DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER
  • Exam Name
    :Salesforce Certified Data Architecture and Management Designer
  • Certification
    :Salesforce Certifications
  • Vendor
    :Salesforce
  • Total Questions
    :246 Q&As
  • Last Updated
    :Apr 06, 2025

Salesforce Salesforce Certifications DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Questions & Answers

  • Question 151:

    Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

    A. Implement an archiving process for shipment records created after five years.

    B. Implement an archiving process for shipment records created after three years.

    C. Set Customer-Reference_c as an External ID (non-unique).

    D. Set Customer-Reference_c as an External ID (unique).

  • Question 152:

    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?

    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"-based approach to classify the record storage need.

  • Question 153:

    Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

    A. Contact each business on the list and ask them to review and update their address information.

    B. Build a team of employees that validate Accounts by searching the web and making phone calls.

    C. Integrate with a third-party database or services for address validation and enrichment.

    D. Leverage Data.com Clean to clean up Account address fields with the DandB database.

  • Question 154:

    Which two best practices should be followed when using SOSL for searching?

    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 fields are pre-indexed.

    D. Use Find in "ALL FIELDS" for faster searches.

  • Question 155:

    Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

    A. Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

    B. Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

    C. Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

    D. Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

  • Question 156:

    Which three characteristics of a Skinny table help improve report and query performance?

    A. Skinny tables can contain frequently used fields and thereby help avoid joins.

    B. Skinny tables can be used to create custom indexes on multi-select picklist fields.

    C. Skinny tables provide a view across multiple objects for easy access to combined data.

    D. Skinny tables are kept in sync with changes to data in the source tables.

    E. Skinny tables do not include records that are available in the recycle bin.

  • Question 157:

    Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

    A. How many fields are defined on the custom objects that need to be archived?

    B. Which profiles and users currently have access to these custom object records?

    C. If reporting is necessary, can the information be aggregated into fewer, summary records?

    D. Will the data being archived need to be reported on or accessed in any way in the future?

    E. Are there any regulatory restrictions that will influence the archiving and purging plans?

  • Question 158:

    Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

    A. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

    B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

    C. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.

    D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

  • Question 159:

    For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

    A. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.

    B. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

    C. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

    D. Let a "system user" own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

  • Question 160:

    Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat

    A. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

    B. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

    C. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

    D. The Opportunity engagement system should become the system of record for Opportunity records.

    E. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Salesforce exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER exam preparations and Salesforce certification application, do not hesitate to visit our Vcedump.com to find your solutions here.