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

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

• Question 51:

  Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

  What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

  A. Run a report which shows the last time the key fields were updated.
  B. Run one report per key field, grouped by that field, to understand its data variability.
  C. Run a report that shows the percentage of blanks for the important fields.
  D. Run a process that can fill in default values for blank fields.
  A. Run a report which shows the last time the key fields were updated.
  C. Run a report that shows the percentage of blanks for the important fields.

• Question 52:

  UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data. What should a data architect recommend to reduce the performance degradation of the platform?

  A. Create a custom object to store the data.
  B. Use a standard big object defined by salesforce.
  C. Use the standard "Order" object to store the data.
  D. Implement a custom big object to store the data.
  C. Use the standard "Order" object to store the data.

• Question 53:

  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.

• Question 54:

  Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profiles 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
  B. Run reports to identify records which does not have company profile and location data

• Question 55:

  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.
  C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

• Question 56:

  A phased Salesforce rollout is planned. Three deployments will be spread out over 12 months, and the requirements have been carefully documented.

  An Architect needs to trace back configuration changes to the requirements.

  Which two approaches should the Architect use? (Choose two.)

  A. Utilize the Force.com IDE to save the metadata files in source control.
  B. Analyze the setup audit trail for configuration changes.
  C. Enter the business purpose into the Description of each field.
  D. Maintain a data dictionary with the justification for each field.
  C. Enter the business purpose into the Description of each field.
  D. Maintain a data dictionary with the justification for each field.

• Question 57:

  Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

  A. Load all data using external IDs to link to parent records.
  B. Use workflow to calculate summary values instead of Roll -Up.
  C. Use triggers to calculate summary values instead of Roll -Up.
  D. Load all data after deferring sharing calculations.
  D. Load all data after deferring sharing calculations.

• Question 58:

  Universal Containers (UC) has one Salesforce org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately, but would like to bidirectionally share Opportunities between orgs in near-real time.

  Which three options should a data architect recommend to share data between Org A and Org B? (Choose three.)

  A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
  B. Install a 3rd party AppExchange tool to handle the data sharing
  C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
  D. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
  E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
  A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
  C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
  D. Leverage middleware tools to bidirectionally send Opportunity data across orgs.

• Question 59:

  UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF. UC is concerned about SF storage limits but would still like Sales cloud to have access to the data. Which design patterns should a data architect select to satisfy the requirement?

  A. Migrate and persist the data in SF to take advantage of native functionality.
  B. Use SF Connect to virtualize the data in SF and avoid storage limits.
  C. Develop a bidirectional integration between the on-premise system and Salesforce.
  D. Build a UI for the on-premise system and iframe it in Salesforce
  B. Use SF Connect to virtualize the data in SF and avoid storage limits.

• Question 60:

  A company uses Salesforce, a cloud-based ERP system, and an on-premise Order Management System (OMS). This company requires a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts.

  Additionally, the company wants Accounts and Contacts to be able to maintain their names in each system (i.e., ""Jane Doe""; in the OMS and ""Jannie Doe""' in Salesforce), but wants to have a consolidated data store which links referenced records across the systems.

  Which suggestion should the Architect provide to the company to meet this goal?

  A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
  B. Use an integration tool to send OMS Accounts and Contacts to Salesforce.
  C. Utilize the Streaming API to send Account and Contact data from Salesforce to the OMS.
  D. Use a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
  D. Use a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.