Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 51:

  Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record.

  What solution should an Architect recommend to UC?

  A. Mandate the selection of a custom product for each discount request.
  B. Create a placeholder product record for the generic discount request.
  C. Remove the master-detail relationship and keep the objects separate.
  D. Change the master-detail relationship to a lookup relationship.
  D. Change the master-detail relationship to a lookup relationship.

  ---

  Explanation

  Changing the master-detail relationship to a lookup relationship is the best solution for allowing the creation of generic discount requests without the custom product object as its master record. A lookup relationship allows you to create child records without requiring a parent record. It also gives you more flexibility in defining the sharing and security settings for each object

• Question 52:

  Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:

  1. Remove outdated Information not required on a day-to-day basis.

  2. Improve Salesforce performance.

  Which solution should be used to meet these requirements?

  A. Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,
  B. Identify a location to store archived data, and move data to the location using a time- based workflow.
  C. Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.
  D. Create a full copy sandbox, and use it as a source for retaining archived data.
  A. Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

  ---

  Explanation

  Identifying a location to store archived data and using scheduled batch jobs to migrate and purge the aged data on a nightly basis can be a way to meet the requirements for an archive solution. The article provides a use case of how to use Heroku Connect, Postgres, and Salesforce Connect to archive old data, free up space in the org, and still retain the option to unarchive the data if needed. The article also explains how this solution can improve Salesforce performance and

  meet data retention policies.

• Question 53:

  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 the Account object with Person Accounts and a new B2C page layout.
  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 50 umbrella Accounts for each region, with customers as associated Contacts.
  A. Use the Account object with Person Accounts and a new B2C page layout.

  ---

  Explanation

  The recommended data model for consumer account data to be stored in Salesforce is to use the Account object with Person Accounts and a new B2C page layout. Person Accounts are a special type of accounts that allow you to store information about individual consumers who are not associated with a business account2. Person Accounts have the following advantages3: They allow you to use the same standard objects and features that you use for business accounts, such as contacts, opportunities, cases, etc. They enable you to create different page layouts and record types for B2C and B2B customers, which allows you to customize the user interface and business logic for each segment.

  They support large data volumes and can scale up to 50 million records or more, which meets the expected growth of consumers over the next five years.

• Question 54:

  Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:

  1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.

  2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.

  3. PPS is the trusted source within NTO for Opportunity Amount.

  4. NTO uses Opportunity Forecast for its sales planning and management.

  Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.

  How should a data architect address this overwriting issue?

  A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.
  B. Change PSS integration to update only Opportunity Amount field when the value is null.
  C. Change Opportunity Amount field access to Read Only for sales users field-level security.
  D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.
  C. Change Opportunity Amount field access to Read Only for sales users field-level security.

  ---

  Explanation

  Changing Opportunity Amount field access to Read Only for sales users field-level security (option C) is the best way to address the overwriting issue, as it prevents sales users from updating the field that is controlled by PPS, and ensures data consistency and accuracy. Creating a custom field for Opportunity amount that PSS updates separating the field sales user updates (option A) or creating a custom field for Opportunity amount that sales users update separating the field that PPS updates (option D) are not good solutions, as they may create confusion and inconsistency with the Opportunity Forecast feature. Changing PSS integration to update only Opportunity Amount field when the value is null (option B) is also not a good solution, as it may cause data loss or conflicts with the sales users' inputs.

• Question 55:

  During the implementation of Salesforce, a customer has the following requirements for Sales Orders:

  1. Sales Order information needs to be shown to users in Salesforce.

  2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).

  3. Sales Order information has more than 150 million records.

  4. Sales Orders will not be updated in Salesforce.

  What should a data architect recommend for maintaining Sales Orders in salesforce?

  A. Us custom objects to maintain Sales Orders in Salesforce.
  B. Use custom big objects to maintain Sales Orders in Salesforce.
  C. Use external objects to maintain Sales Order in Salesforce.
  D. Use Standard order object to maintain Sale Orders in Salesforce
  C. Use external objects to maintain Sales Order in Salesforce.

  ---

  Explanation

  Using external objects to maintain Sales Order in Salesforce is the best recommendation for maintaining Sales Orders in Salesforce, as it allows users to access large volumes of data stored outside Salesforce without copying or synchronizing it. Using custom objects, custom big objects, or standard order object may not be feasible or optimal for storing more than 150 million records that will not be updated in Salesforce.

• Question 56:

  Universal Containers has deployed Salesforce for case management.

  The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization.

  What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

  A. Enable field history tracking on the Case object.
  B. Create a report on Case analytic snapshots.
  C. Install AppExchange packages for available reports.
  D. Create Contact and Opportunity Reports and Dashboards.
  A. Enable field history tracking on the Case object.

  ---

  Explanation

  Enabling field history tracking on the Case object is the first step to implement a reporting solution to measure the support reps case closure rates. Field history tracking allows you to track changes to certain fields on the Case object, such as Status, Owner, or Priority. You can then create reports based on the field history data to analyze how long it took to close a case, how many times the case owner changed, or how many cases were escalated.

• Question 57:

  Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

  The following requirements are needed:

  A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

  The finance users will not access to any sales objects, but they will need to interact with the custom object.

  Which license type a data architect recommend for the finance team that best meets the requirements?

  A. Service Cloud
  B. Sales Cloud
  C. Light Platform Start
  D. Lighting platform plus
  D. Lighting platform plus

  ---

  Explanation

  The data architect should recommend Lighting platform plus license type for the finance team that best meets the requirements. This license type allows users to access custom objects and run reports and dashboards on them, without accessing any sales objects. Option A is incorrect because Service Cloud license type is more suitable for customer service users who need to access cases, knowledge, and other service objects. Option B is incorrect because Sales Cloud license type is more suitable for sales users who need to access accounts, contacts, opportunities, and other sales objects. Option C is incorrect because Light Platform Start license type does not allow users to run reports and dashboards on custom objects.

• Question 58:

  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
  D. Contact Salesforce to enable Defer Sharing Rules

  ---

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

  Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.

  Which solution should a data architect recommend to improve reporting performance?

  A. Create a custom object to store aggregate data and run reports.
  B. Contact Salesforce support to enable skinny table for cases.
  C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
  D. Build reports using custom Lightning components.
  B. Contact Salesforce support to enable skinny table for cases.

  ---

  Explanation

  According to the Salesforce documentation1, reporting performance can be affected by various factors, such as the volume and complexity of data, the design and configuration of reports and dashboards, the number and type of users accessing the reports, etc. To improve reporting performance, some of the recommended solutions are: Move data off of the platform and run reporting outside Salesforce, and give access to reports (option C). This means using an external service or tool that can extract, transform, and load (ETL) data from Salesforce to another system or database, such as a data warehouse or a business intelligence platform. This can improve reporting performance by reducing the load and latency on Salesforce, and enabling faster and more flexible reporting and analysis on the external system. Users can access the reports from the external system using a link or an embedded component in Salesforce.

  Contact Salesforce support to enable skinny table for cases (option B). This means requesting Salesforce to create a custom table that contains a subset of fields from the Case object that are frequently used or queried. A skinny table can improve reporting performance by avoiding joins between standard and custom fields, omitting soft-deleted records, and leveraging indexes on the fields2. Create a custom object to store aggregate data and run reports (option A). This means creating a custom object that contains summary or calculated data from the Case object, such as counts, sums, averages, etc. A custom object can improve reporting performance by reducing the number of records and fields that need to be queried and displayed.

  Build reports using custom Lightning components (option D). This means creating custom components that use Lightning Web Components or Aura Components frameworks to display report data in Salesforce. A custom component can improve reporting performance by using client-side caching, pagination, lazy loading, or other techniques to optimize data rendering and interaction.

• Question 60:

  Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information.

  Which solution should a data architect recommend to make sure lead data has both profile and location information?

  A. Ask sales people to search for populating company profile and location data
  B. Run reports to identify records which does not have company profile and location data
  C. Leverage external data providers populate company profile and location data
  D. Export data out of Salesforce and send to another team to populate company profile and location data
  C. Leverage external data providers populate company profile and location data

  ---

  Explanation

  The best solution to make sure lead data has both profile and location information is to leverage external data providers to populate company profile and location data. This is because external data providers can enrich lead data with additional information from third-party sources, such as Dun & Bradstreet, ZoomInfo, or Clearbit. This can help improve lead quality, segmentation, and conversion. Salesforce supports integrating with external data providers using Data.com Clean or other AppExchange solutions2. Asking sales people to search for populating company profile and location data is inefficient and prone to errors. Running reports to identify records which do not have company profile and location data is useful, but does not solve the problem of how to populate the missing data. Exporting data out of Salesforce and sending to another team to populate company profile and location data is cumbersome and time-consuming.