Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 91:

  Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

  What should a data architect recommend to guarantee that records are not being updated at the same time?

  A. Embed the keywords FOR UPDATE after SOQL statements.

  B. Disable classes or triggers that have the potential to obtain the same record.

  C. Migrate programmatic logic to processes and flows.

  D. Refactor or optimize classes and trigger for maximum CPU performance.

  Correct Answer: A

  Explanation: According to the How to avoid row lock or race condition in Apex blog post, one of the ways to prevent race condition in Apex is to use the FOR UPDATE keyword in SOQL statements. The blog post states that "We need to lock the records on which we are working such that other batches or threads will not be having any effect on them. How can we lock a record, then? We need to make use of FOR UPDATE keyword in the SOQL query." Therefore, a data architect should recommend this solution to guarantee that records are not being updated at the same time by different processes.

• Question 92:

  A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity:

  1.

  Point-of-sale system: All purchases for a customer

  2.

  Salesforce; All customer service activity and sales activities for a customer

  3.

  Mobile app: All bookings, preferences, and browser activity for a customer

  4.

  Marketing: All email, SMS, and social campaigns for a customer

  Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.

  What strategy should the data architect implement to satisfy this requirement?

  A. Explore external data sources in Salesforce to build a 360-degree view of the customer.

  B. Use a customer data mart to create the 360-degree view of the customer.

  C. Periodically upload summary information in Salesforce to build a 360-degree view.

  D. Migrate customer activities fro, all four system into Salesforce.

  Correct Answer: A

  Explanation: Exploring external data sources in Salesforce to build a 360 degree view of the customer (option A) is the best strategy to satisfy this requirement, as it allows customer service agents to view the activities from all four systems in real time without storing or replicating the data in Salesforce. Using a customer data mart to create the 360 degree view of the customer (option B) is not a good strategy, as it may introduce additional complexity and cost, and it does not leverage the native Salesforce features. Periodically uploading summary information in Salesforce to build a 360 degree view (option C) is also not a good strategy, as it may cause data latency and inconsistency, and it does not provide real-time information. Migrating customer activities from all four systems into Salesforce (option D) is also not a good strategy, as it may cause data redundancy and conflicts, and it does not scale well with large volumes of data.

• Question 93:

  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.

  Correct Answer: B

  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 94:

  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. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

  C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

  D. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

  Correct Answer: C

  Explanation: Using an AppExchange package for Data Quality is a good way to match Salesforce data against a trusted source, such as an MDM system. You can use tools like Cloudingo, DupeCatcher, or DemandTools to identify and merge duplicate records, standardize data formats, and enrich data with external sources

• Question 95:

  In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

  A. Salesforce allows up to four objects in a single report type.

  B. Salesforce does not support Orders or Order Line Items.

  C. A report cannot contain data from Accounts and Contacts.

  D. Custom report types cannot contain Opportunity data.

  Correct Answer: A

  Salesforce allows up to four objects in a single report type. This means that if an architect wants to create a report that compiles data from Accounts, Contacts, Opportunities, Orders, and Order Line Items, they will run into a difficulty because that would require five objects in a single report type. To overcome this limitation, the architect can either create two separate report types and join them in a joined report, or use an external reporting tool that can access data from multiple objects.

• Question 96:

  Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

  A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

  B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on- premise systems.

  C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

  D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

  Correct Answer: D

  Explanation: Evaluating a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes is the best approach to address the requirement of having a one-day SLA for any data loss. These apps can provide automated backups, granular restores, and compliance features that can help UC recover from any data loss or corruption scenarios.

• Question 97:

  Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

  A. Ensure invoice line items simply reference existing Opportunity line items.

  B. Ensure the account product vendor includes Wave Analytics in their offering.

  C. Ensure the account product vendor provides a sound data archiving strategy.

  D. Ensure the accounting product runs 100% natively on the Salesforce platform.

  Correct Answer: C

  Explanation: A sound data archiving strategy is essential for ensuring scalability and performance of any application that deals with large volumes of data. You need to consider factors like data retention policies, storage limits, backup and recovery options, and data access requirements when designing a data archiving solution2. You can use tools like OwnBackup, Odaseva, or ArchiveIt to archive your data from Salesforce to external systems

• Question 98:

  Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

  A. Create a picklist field, values sorted alphabetically.

  B. Create a Master -Detail to custom object ShippingStatus c.

  C. Create a Lookup to custom object ShippingStatus c.

  D. Create a text field and make it an external ID.

  Correct Answer: A

  Explanation: To improve data quality and avoid data skew, the data architect should create a picklist field with values sorted alphabetically for tracking shipping status on opportunity. A picklist field ensures that only valid values are entered and prevents typos or variations in spelling. Sorting the values alphabetically makes it easier for users to find and select the correct value. Data skew occurs when a large number of records are owned by a single user or have a single value for a field. Creating a picklist field with a limited number of values does not cause data skew, as long as the distribution of values is balanced and not skewed towards one value.

• Question 99:

  Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

  A. Implement data archiving for old Shipment records.

  B. Contact Salesforce to create Skinny tables on Shipment.

  C. Configure shipment OWD to Public Read/Write.

  D. Contact Salesforce to enable Defer Sharing Rules

  Correct Answer: D

  Explanation: Contacting Salesforce to enable Defer Sharing Rules is the feature that would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements. Defer Sharing Rules allows you to defer sharing rule recalculation when you make changes to public groups or roles that are used in sharing rules. This can improve performance and avoid locking issues when you move users between groups or roles2. Implementing data archiving for old Shipment records will not help with the performance issue related to sharing rules. Contacting Salesforce to create Skinny tables on Shipment will not help with the performance issue related to sharing rules. Configuring shipment OWD to Public Read/Write will not meet the existing requirements of having a Private sharing model.

• Question 100:

  Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:

  1.

  High Value

  2.

  Medium Value

  3.

  Low Value

  Which strategy should a data architect recommend to configure customer type?

  A. Lookup to a custom object with defined choices.

  B. Single-select restricted picklist with defined choices.

  C. Provide help text to guide users with defined choices.

  D. Create a validation rule to limit entry to defined choices.

  Correct Answer: B

  Explanation: single-select restricted picklist with defined choices can be a way to configure customer type. The article states that picklists are fields that allow users to select one or more predefined values from a list, and restricted picklists ensure that users can only select from the defined values. This can help to limit the choices for customer type and ensure data quality.