Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 21:

  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.
  C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

  ---

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

  As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

  What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

  A. Use App Exchange products to classify fields based on policy.
  B. Use data classification metadata fields available in field definition.
  C. Create a custom picklist field to capture classification of information on customer.
  D. Build reports for customer information and validate.
  B. Use data classification metadata fields available in field definition.

  ---

  Explanation

  The correct answer is B, use data classification metadata fields available in field definition. Data classification metadata fields are standard fields that allow you to classify the sensitivity level of your data based on your organization's policies.

  You can use these fields to indicate whether a field contains confidential, restricted, or general data. These fields are available for both standard and custom objects in Salesforce. Using app exchange products, creating a custom picklist field, or building reports would not be as effective or consistent as using data classification metadata fields.

• Question 23:

  A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance.

  Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

  A. Review the metadata xml files for redundant fields to consolidate.
  B. Determine if any integration points create records in Salesforce.
  C. Run key reports to determine what fields should be required.
  D. Export the setup audit trail to review what fields are being used.
  E. Review the sharing model to determine impact on duplicate records.
  B. Determine if any integration points create records in Salesforce.
  C. Run key reports to determine what fields should be required.
  E. Review the sharing model to determine impact on duplicate records.

  ---

  Explanation

  Determining if any integration points create records in Salesforce, running key reports to determine what fields should be required, and reviewing the sharing model to determine impact on duplicate records are three areas of Salesforce that the architect should review before proposing any design recommendation. These areas will help to identify the sources and quality of data, the business rules and validations for data entry, and the access and visibility of data across users and roles. Reviewing the metadata xml files for redundant fields to consolidate, and exporting the setup audit trail to review what fields are being used are not necessary steps for optimizing a data stewardship engagement, as they are more related to metadata management and audit tracking.

• Question 24:

  Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.

  Which two common techniques are used building a data dictionary to store information on how business entities are defined?

  A. Use Salesforce Object Query Language.
  B. Use a data definition language.
  C. Use an entity relationship diagram.
  D. Use the Salesforce Metadata API.
  C. Use an entity relationship diagram.
  D. Use the Salesforce Metadata API.

  ---

  Explanation

  A data dictionary is a document that describes the structure, format, and meaning of data entities and attributes. A common technique to build a data dictionary is to use an entity relationship diagram (ERD), which shows the logical relationships between objects and fields in a graphical way. Another technique is to use the Salesforce Metadata API, which allows you to retrieve and deploy the metadata that defines your Salesforce org

• Question 25:

  Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.

  NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.

  Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?

  A. Bidirectional integration
  B. Unidirectional integration
  C. Virtualization
  D. Persistence
  D. Persistence

  ---

  Explanation

  Persistence is the data pattern that will allow a data architect to satisfy the requirements, while also keeping limits in mind. Persistence means storing data from external sources in Salesforce objects, either standard or custom. This allows you to access the data within Salesforce and use it for reporting, analytics, workflows, and other features. Persistence also helps you avoid hitting API limits or performance issues when accessing large volumes of data from external systems.

  You can use various tools such as Data Loader, Bulk API, or Platform Events to persist IoT data from connected devices to a cloud database in Salesforce.

• Question 26:

  Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

  A. Use SOQL queries without WHERE conditions.
  B. Work with Salesforce Support to enable Skinny Tables.
  C. Reduce the number of triggers on Order _c object.
  D. Make the queries more selective using indexed fields.
  B. Work with Salesforce Support to enable Skinny Tables.
  D. Make the queries more selective using indexed fields.

  ---

  Explanation

  To improve the performance of SOQL queries that retrieve data from the Order_c object, the data architect should work with Salesforce Support to enable Skinny Tables and make the queries more selective using indexed fields. Skinny Tables are custom tables that contain frequently used fields and are kept in sync with the base tables3. They can improve performance by reducing the number of table joins and using indexes. Making the queries more selective using indexed fields can also improve performance by reducing the query execution time and avoiding query timeouts4. The other options are not effective or recommended for improving SOQL performance.

• Question 27:

  Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.

  Which option does Apex provide to report errors from this Apex job?

  A. Use Custom Object to store leads, and allow unprocessed leads to be reported.
  B. Save Apex errors in a custom object, and allow access to this object for reporting.
  C. Use Apex services to email failures to business when error occurs.
  D. Use AppExchange package to clean lead information before Apex job processes them.
  C. Use Apex services to email failures to business when error occurs.

  ---

  Explanation

  saving Apex errors in a custom object can be a way to report errors from an Apex job. The article provides an example of how to create a custom object called AsyncApexError__c and use a trigger to insert error records into it. The custom object can then be used for reporting or notification purposes.

• Question 28:

  Universal Containers keeps its Account data in Salesforce and its Invoice data in a third - party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

  A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
  B. Create a report combining data from the Account standard object and the Invoices external object.
  C. Create a Visualforce page combining Salesforce Account data and Invoice external object data.
  D. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
  A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
  C. Create a Visualforce page combining Salesforce Account data and Invoice external object data.

  ---

  Explanation

  Creating a report in an external system combining Salesforce Account data and Invoice data from the ERP, and creating a Visualforce page combining Salesforce Account data and Invoice external object data are two approaches that an architect can suggest for achieving this solution. Both of these approaches can display data from both Accounts and Invoices in one place, using either an external reporting tool or a custom web page. Creating a report combining data from the Account standard object and the Invoices external object is not possible because Salesforce does not support reporting on external objects. Creating a separate Salesforce report for Accounts and Invoices and combining them in a dashboard is not ideal because it will not show the data in one report, but rather in two separate components.

• Question 29:

  Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.

  Which two techniques should be used to achieve this goal? (Choose two.)

  A. Integrate Salesforce with the ERP environment.
  B. Utilize workbench to update files within systems.
  C. Utilize an MDM strategy to outline a single source of truth.
  D. Build synchronization reports and dashboards.
  A. Integrate Salesforce with the ERP environment.
  C. Utilize an MDM strategy to outline a single source of truth.

  ---

  Explanation

  Option A is correct because integrating Salesforce with the ERP environment is a technique to maintain data synchronization between systems1. Option C is correct because utilizing an MDM strategy to outline a single source of truth is another technique to ensure data quality and consistency across systems2. Option B is not correct because utilizing workbench to update files within systems is not a technique to maintain data synchronization, but a tool to perform data manipulation tasks3. Option D is not correct because building synchronization reports and dashboards is not a technique to maintain data synchronization, but a way to monitor and analyze data4.

• Question 30:

  Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:

  1. Customers are Person Accounts for their retail business.

  2. Customers are represented as Contacts for their commercial business.

  3. Employees are maintained as Users.

  4. Prospects are maintained as Leads.

  NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.

  Which option should the data architect recommend NTO to satisfy this requirement?

  A. Create custom fields for contact preferences in Lead, Person Account, and Users objects.
  B. Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
  C. Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
  D. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
  D. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

  ---

  Explanation

  The Individual object is a standard object that lets you store details about data privacy and protection preferences for person accounts, contacts, users, and leads. The Individual object can be used to implement a standard communication preference management model for NTO, with relationships to the other objects.