Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 71:

  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 data. 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?

  A. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.
  B. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.
  C. The Opportunity engagement system should become the system of record for Opportunity records.
  D. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.
  D. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

  ---

  Explanation

  The recommended course of action to appropriately integrate the new Opportunity engagement system with Salesforce is to bring the stakeholders together to discuss the appropriate data strategy moving forward. This is because there may be valuable data in both systems that need to be reconciled and harmonized, and the Master Data Management (MDM) strategy may need to be revised or updated to accommodate the new system. The other options are not recommended, as they may result in data loss, inconsistency, or duplication

• Question 72:

  Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

  An Architect needs to determine which system is the system of record on a field level.

  What should the Architect do to achieve this goal?

  A. Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.
  B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
  C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
  D. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
  B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

  ---

  Explanation

  Key stakeholders from both systems should collaborate with the Architect to determine which system is the system of record on a field level is what the Architect should do to achieve this goal of integrating two different systems with customer records into the Salesforce Account object using Master Data Management. The system of record is the authoritative source of truth for a given entity or field in a given context. Different systems may have different levels of accuracy, completeness, timeliness, or relevance for different fields. Therefore, it is important to involve key stakeholders from both systems who have knowledge and expertise about their data quality and business needs to decide which system should be the system of record for each field. The Architect should facilitate this collaboration and document the decisions and rationale for each field. The other options are not correct or feasible, as they would either delegate or abdicate the responsibility of determining the system of record, ignore or disregard the input from key stakeholders, or assume or impose a default system of record without considering the data quality and business needs.

• Question 73:

  NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO'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 licenses does NTO need to provide these features to the Franchisees?

  A. Salesforce Sales Cloud license
  B. Lightning Platform license
  C. Customer Community license
  D. Partner Community license
  D. Partner Community license

  ---

  Explanation

  The best license to provide these features to the franchisees is the Partner Community license. Partner Community licenses are designed for external users who collaborate with your sales team on deals, such as resellers, distributors, or brokers. Partner Community users can access standard CRM objects, such as accounts, contacts, leads, opportunities, campaigns, and reports. They can also access custom objects and run dashboards12. Salesforce Sales Cloud license is not a good option because it is intended for internal users who need full access to standard CRM and custom apps. Lightning Platform license is not a good option because it is intended for users who need access to custom apps but not to standard CRM functionality. Customer Community license is not a good option because it is intended for external users who need access to customer support features, such as cases and knowledge articles, but not to sales features

• Question 74:

  Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

  What should an Architect do to meet these requirements?

  A. Set the profile of the users to remove delete permission from the Contact object.
  B. Check if the current user is NOT the owner by creating a "before delete" trigger.
  C. Set the Sharing settings as Public Read Only for the Contact object.
  D. Check if the current user is NOT the owner by creating a validation rule on the Contact object.
  B. Check if the current user is NOT the owner by creating a "before delete" trigger.

  ---

  Explanation

  Checking if the current user is NOT the owner by creating a "before delete" trigger can meet the requirement of allowing only the owner of a contact record to delete that contact. A trigger is a piece of Apex code that can execute before or after a record is inserted, updated, deleted, or undeleted. A "before delete" trigger can prevent the deletion of a record by using the addError() method.

• Question 75:

  Universal Containers (UC) is building a Service Cloud call center application and has a multi-system support solution. UC would like or ensure that all systems have access to the same customer information.

  What solution should a data architect recommend?

  A. Make Salesforce the system of record for all data.
  B. Implement a master data management (MDM) strategy for customer data.
  C. Load customer data in all systems.
  D. Let each system be an owner of data it generates.
  B. Implement a master data management (MDM) strategy for customer data.

  ---

  Explanation

  A master data management (MDM) strategy for customer data can help UC ensure that all systems have access to the same customer information, without loading or duplicating data in all systems. An MDM strategy can also help UC avoid data conflicts and inconsistencies that may arise from having multiple systems as owners of data.

• Question 76:

  Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.

  What should a data architect do in order to restore the issue?

  A. Enable granular locking
  B. Enable parallel sharing rule calculation.
  C. Enable defer sharing calculation
  D. Enable implicit sharing
  A. Enable granular locking

  ---

  Explanation

  Enabling granular locking allows concurrent sharing rule calculations and group membership updates to run without locking each other1. This can help resolve the group membership locking issues that UC is experiencing.

• Question 77:

  A company wants to document the data architecture of a Salesforce organization.

  What are two valid metadata types that should be included? (Choose two.)

  A. RecordType
  B. Document
  C. CustomField
  D. SecuritySettings
  A. RecordType
  C. CustomField

  ---

  Explanation

  Option A is correct because RecordType is a valid metadata type that should be included in documenting the data architecture of a Salesforce organization1. RecordType defines different business processes, picklist values, and page layouts for different users2. Option C is correct because CustomField is another valid metadata type that should be included in documenting the data architecture of a Salesforce organization1. CustomField defines custom attributes for standard or custom objects3. Option B is not correct because Document is not a valid metadata type, but a standard object that stores documents in folders4. Option D is not correct because SecuritySettings is not a valid metadata type, but a setup menu that allows administrators to configure various security features such as password policies, network access, session settings, etc.

• Question 78:

  Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.

  Which solution should a data architect recommend as an archiving solution?

  A. Use a third-party backup solution to backup all data off platform.
  B. Build a batch join move all records off platform, and delete all records from Salesforce.
  C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.
  D. Build a batch job to move all restore off platform, and delete old records from Salesforce.
  C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

  ---

  Explanation

  The data architect should recommend building a batch job to move two-year- old records off platform, and delete records from Salesforce as an archiving solution. A batch job is a process that runs in the background and performs operations on large volumes of data in Salesforce. By building a batch job that moves two-year-old records off platform to an external storage system, such as Amazon S3 or Google Cloud Storage, and deletes them from Salesforce, the data architect can reduce the storage consumption and improve the performance of Salesforce org. Option A is incorrect because using a third- party backup solution to backup all data off platform will not free up any storage space in Salesforce, unless the data is also deleted from Salesforce after backup. Option B is incorrect because building a batch job to move all records off platform, and delete all records from Salesforce will result in losing all the current data in Salesforce, which may not be desirable or feasible. Option D is incorrect because building a batch job to move all restore off platform, and delete old records from Salesforce does not make sense, as restore implies restoring data back to Salesforce, not moving it off platform.

• Question 79:

  Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted.

  What should the data architect consider when designing a field -level audit and recovery plan?

  A. Reduce data storage by purging old data.
  B. Implement an AppExchange package.
  C. Review projected data storage needs.
  D. Schedule a weekly export file.
  C. Review projected data storage needs.

  ---

  Explanation

  Option C is the best answer because reviewing projected data storage needs is an important step in designing a field-level audit and recovery plan1. You need to estimate how much data storage you will need in the future and plan accordingly. Option A is not correct because reducing data storage by purging old data may not be sufficient or desirable for backup purposes. Option B is not correct because implementing an AppExchange package may not be customized or compatible with your org's requirements. Option D is not correct because scheduling a weekly export file may not be frequent or granular enough for field-level audit and recovery.

• Question 80:

  Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

  What are two automated approaches to fulfill this goal? (Choose two.)

  A. Third-party Integration Tool (ETL)
  B. Schedulable Batch Apex
  C. Third-party Business Intelligence system
  D. Apex Triggers
  A. Third-party Integration Tool (ETL)
  B. Schedulable Batch Apex

  ---

  Explanation

  Both A and B are automated approaches to purge detailed transactional records from Salesforce and aggregate them at a summary level1. You can use a third- party integration tool (ETL) or schedulable batch Apex to perform these tasks.

  Option C is not correct because a third-party business intelligence system does not purge data from Salesforce, but only analyzes it. Option D is not correct because Apex triggers are not automated, but execute when a record is inserted, updated, deleted, or undeleted.