Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 31:

  To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:

  Data owner

  Security Level, such as confidential

  Compliance types such as GDPR, PII, HIPPA

  A compliance audit would require SF admins to generate reports to manage compliance.

  What should a data architect recommend to address this requirement?

  A. Use metadata API, to extract field attribute information and use the extract to classify and build reports
  B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
  C. Create a custom object and field to capture necessary compliance information and build custom reports.
  D. Build reports for field information, then export the information to classify and report for Audits.
  B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

  ---

  Explanation

  The data architect should recommend using field metadata attributes for compliance categorization, data owner, and data sensitivity level. This will allow the SF admins to generate reports to manage compliance based on the field metadata attributes that are defined for each data element in SF. Option A is incorrect because using metadata API to extract field attribute information and use the extract to classify and build reports will require additional development effort and may not be up-to-date with the latest changes in SF. Option C is incorrect because creating a custom object and field to capture necessary compliance information and build custom reports will require additional configuration effort and may not be consistent with the actual data elements in SF. Option D is incorrect because building reports for field information, then exporting the information to classify and report for audits will require additional manual effort and may not be accurate or timely.

• Question 32:

  A customer wants to maintain geographic location information including latitude and longitude in a custom object.

  What would a data architect recommend to satisfy this requirement?

  A. Create formula fields with geolocation function for this requirement.
  B. Create custom fields to maintain latitude and longitude information
  C. Create a geolocation custom field to maintain this requirement
  D. Recommend app exchange packages to support this requirement.
  C. Create a geolocation custom field to maintain this requirement

  ---

  Explanation

  The correct answer is C, create a geolocation custom field to maintain this requirement. A geolocation custom field is a compound field that can store both latitude and longitude information in a single field. It also supports geolocation functions and distance calculations. Creating formula fields or custom fields for latitude and longitude separately would be inefficient and redundant. Recommending app exchange packages would not be a direct solution to the requirement.

• Question 33:

  Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics.

  What should be the recommended solution to meet this requirement?

  A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
  B. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
  C. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
  D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
  A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.

  ---

  Explanation

  Using a declarative approach by installing and configuring Data.com Clean to monitor Account data quality can help UC meet their requirement. Data.com Clean can enrich and cleanse data on an ongoing basis by comparing Salesforce records with Data.com records and providing suggestions for updates. Data.com Clean can also provide dashboards and reports to monitor key data quality metrics such as match rate, field fill rate, and record completeness

• Question 34:

  Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:

  1. First Name

  2. Last Name

  3. Email

  Which option should the data architect recommend to mandate this when customers are created in Salesforce?

  A. Configure Page Layout marking attributes as required fields.
  B. Create validation rules to check If the required attributes are entered.
  C. Mark Fields for the attributes as required under Setup.
  D. Build validation in Integration with MDM to check required attributes.
  B. Create validation rules to check If the required attributes are entered.

  ---

  Explanation

  Creating validation rules to check if the required attributes are entered is the best option to mandate this when customers are created in Salesforce. Validation rules allow you to specify criteria that must be met before a record can be saved.

  You can use validation rules to ensure that customers have a first name, last name, and email when they are created in Salesforce. This way, you can prevent incomplete or invalid data from being sent to your MDM solution.

• Question 35:

  Northern Trail Outfitters Is planning to build a consent form to record customer authorization for marketing purposes.

  What should a data architect recommend to fulfill this requirement?

  A. Use custom fields to capture the authorization details.
  B. Create a custom object to maintain the authorization.
  C. Utilize the Authorization Form Consent object to capture the consent.
  D. Use AppExchange solution to address the requirement.
  C. Utilize the Authorization Form Consent object to capture the consent.

  ---

  Explanation

  The Authorization Form Consent object is a standard object that allows you to capture customer consent for marketing purposes. It has fields such as Consent Captured Date, Consent Captured Source, Consent Description, and Consent Status. You can use this object to create consent forms and track customer responses. This is the best option to fulfill the requirement, as it does not require any custom development or external solution.

• Question 36:

  Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.

  What solution a data architect recommends to give the sales team visibility into order status?

  A. Leverage Canvas to bring the order management UI in to the Salesforce tab.
  B. Build batch jobs to push order line items to salesforce.
  C. leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.
  D. Build real-time integration to pull order line items into Salesforce when viewing orders.
  C. leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

  ---

  Explanation

  The correct answer is C, leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce. Salesforce Connect is a feature that allows you to integrate external data sources with Salesforce and access them in real time without copying or synchronizing the data. This way, the sales team can view the order status from the ERP system without having access to it. Leveraging Canvas, building batch jobs, or building real-time integration are also possible solutions, but they are more complex and costly than using Salesforce Connect.

• Question 37:

  An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

  A. Implement a third -party validation process with translate functionality.
  B. Create a trigger on Contact and add an error to the record with a custom label.
  C. Create a workflow field update to set the standard ErrorMessage field.
  D. Create a validation rule and translate the error message with translation workbench.
  B. Create a trigger on Contact and add an error to the record with a custom label.
  D. Create a validation rule and translate the error message with translation workbench.

  ---

  Explanation

  Creating a trigger on Contact and adding an error to the record with a custom label allows the architect to use the translation workbench to translate the error message based on the user's language. Creating a validation rule and translating the error message with translation workbench also achieves the same result. The other options would either not provide translation functionality or not display an error message

• Question 38:

  Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system.

  How should an Architect design the data migration solution to meet this requirement?

  A. After the data is migrated, perform an update on all records to set the original date in a standard Created Date field.
  B. Create a new field on the Contact object to capture the Created Date. Hide the standard Created Date field using Field -Level Security.
  C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
  D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard Created Date field.
  C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

  ---

  Explanation

  Enabling "Set Audit Fields" allows the user loading the data to set the value of the standard CreatedDate field to match the original date from the legacy system. This is a one-time permission that can be revoked after the migration is completed. The other options would either not work or require additional customization

• Question 39:

  Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?

  Choose 2 answers

  A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
  B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
  C. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
  D. Store all data in an external system and set up an integration to Salesforce for view - only access.
  A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
  B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

  ---

  Explanation

  Scheduling a weekly dashboard displaying records that are missing information to be sent to managers for review and using Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes are two approaches that an architect should recommend to enforce the new Data Quality Plan for UC's Salesforce data. Scheduling a weekly dashboard can provide a regular and visual way of monitoring the data quality and identifying any gaps or issues that need to be addressed by the managers or users. Using Workflow, Validation Rules, and Apex can provide various ways of enforcing data quality standards and business logic by automating actions, displaying error messages, or executing custom code when users create or edit records. The other options are not suitable or helpful for enforcing the Data Quality Plan, as they would either not provide real-time feedback, not prevent data quality issues, or not leverage the capabilities of Salesforce

• Question 40:

  The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.

  What is one reporting option Get Cloudy Consulting should consider?

  A. Case SLA performance report
  B. Sales KPI Dashboard
  C. Opportunity analytic snapshot
  D. Lead conversion rate report
  B. Sales KPI Dashboard

  ---

  Explanation

  A Sales KPI Dashboard is one reporting option that Get Cloudy Consulting should consider to understand key relevant performance figures and help managers take corrective actions where appropriate. A Sales KPI Dashboard can display various metrics that indicate the health and effectiveness of the sales team, such as quota attainment, pipeline value, win rate, average deal size, sales cycle length, and more. A Sales KPI Dashboard can also help identify trends, patterns, and areas for improvement.