Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Questions & Answers

• Question 191:

  Northern Trail Outfitters (NTO) has multiple systems across its enterprise landscape, including Salesforce, with disparate versions of the customer record. In Salesforce, the customer is represented by the Contact object. NTO utilizes a master data management (MDM) solution with these attributes:

  1.

  The MDM solution keeps track of the Customer Master with a Master Key.

  2.

  The Master Key is a map to the record IDs from each external system that customer data is stored within.

  3.

  The MDM solution provides deduplication features, so it acts as the Single Source of Truth. How should a Data Architect implement the storage of the Master Key within Salesforce?

  A. Store the master key in Heroku postgres and use Heroku connect for synchronization.
  B. Create a custom object to store the master key with a lookup field to contact.
  C. Create an external object to store the master key with a lookup field to contact.
  D. Store the master key on the contact object as an external ID (Field for referential imports)
  A. Store the master key in Heroku postgres and use Heroku connect for synchronization.

• Question 192:

  NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error. Which 3 options should help improve the dashboard performance? Choose 3 answers:

  A. Use selective queries to reduce the amount of data being returned.
  B. De-normalize the data by reducing the number of joins.
  C. Remove widgets from the dashboard to reduce the number of graphics loaded.
  D. Run the dashboard for CEO and send it via email.
  E. Reduce the amount of data queried by archiving unused opportunity records.
  A. Use selective queries to reduce the amount of data being returned.
  B. De-normalize the data by reducing the number of joins.
  E. Reduce the amount of data queried by archiving unused opportunity records.

• Question 193:

  To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

  A. Errors with duplicate external Id values within the same CSV file.
  B. Errors with records being updated and inserted in the same CSV file.
  C. Errors when a duplicate Contact name is found cause upsert to fail.
  D. Errors with using the wrong external Id will cause the load to fail.
  A. Errors with duplicate external Id values within the same CSV file.

• Question 194:

  Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

  A. Use third-party AppExchange tools to monitor and measure data quality.
  B. Generate reports to view the quality of sample data.
  C. Use custom objects and fields to calculate data quality.
  D. Export the data to an enterprise data warehouse and use BI tools for data quality.
  A. Use third-party AppExchange tools to monitor and measure data quality.

• Question 195:

  Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

  A. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.
  B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.
  C. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.
  D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.
  D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

• Question 196:

  A large insurance provider is looking to implement Salesforce. The following exist.

  1.

  Multiple channel for lead acquisition

  2.

  Duplication leads across channels

  3.

  Poor customer experience and higher costs

  On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

  A. Build process is manually search and merge duplicates.
  B. Standard lead information across all channels.
  C. Build a custom solution to identify and merge duplicate leads.
  D. Implement third-party solution to clean and event lead data.
  E. Implement de-duplication strategy to prevent duplicate leads
  B. Standard lead information across all channels.
  D. Implement third-party solution to clean and event lead data.
  E. Implement de-duplication strategy to prevent duplicate leads

• Question 197:

  Ursa Major Solar has 4 million rows of data in Salesforce that are used in reports to assess historical trends. Both performance and data storage limits have become an issue. Which two strategies are appropriate when discussing the issue with stakeholders? (Choose two.)

  A. Utilize scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
  B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
  C. Utilize Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
  D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
  A. Utilize scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
  D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

• Question 198:

  Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purpose. What solution should a data architect recommend?

  A. Archive Case data using Salesforce Archiving process
  B. Purchase more data storage to support case object
  C. Use a custom object to store archived case data.
  D. Use a custom Big object to store archived case data.
  A. Archive Case data using Salesforce Archiving process

• Question 199:

  Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next

  stage.

  NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

  What should a data architect consider before implementing Salesforce Connect for reporting?

  A. Maximum number for records returned
  B. OData callout limits per day
  C. Maximum page size for server-driven paging
  D. Maximum external objects per org
  B. OData callout limits per day

• Question 200:

  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