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

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

• Question 181:

  Get Cloudy Consulting has a new Chief Technology Officer (CTO), who is preparing to move the company from a legacy CRM to Salesforce. As part of a one-time migration, Get Cloudy Consulting will need to keep the original date when a contact was created in the legacy system. Which steps should an Architect take to design the data migration solution?

  A. 1. Write an Apex trigger on the Contact object. 2. Insert event to set the original value in a standard CreatedDate field.
  B. 1. Enable the "Set Audit Fields upon Record Creation" user permission. 2. Assign the permission to the user loading the data for the duration of the migration.
  C. 1. Create a new field on Contact object to capture the Created Date. 2. Hide the standard CreatedDate field using Field-Level Security.
  D. 1. Migrate the data. 2. Perform an update on all records to set the original date in a standard CreatedDate field.
  B. 1. Enable the "Set Audit Fields upon Record Creation" user permission. 2. Assign the permission to the user loading the data for the duration of the migration.

• Question 182:

  Cloud Kicks has the following requirements:

  1.

  Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).

  2.

  If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

  3.

  Each custom object must have separate sharing models. What should an Architect do to fulfill these requirements?

  A. Associate the Shipment to each parent record by using a VLOOKUP formula field.
  B. Create a required Lookup relationship to each of the three parent records.
  C. Create a Master-Detail relationship to each of the three parent records.
  D. Create two Master-Detail and one Lookup relationship to the parent records.
  B. Create a required Lookup relationship to each of the three parent records.

• Question 183:

  Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?

  A. Missing phone number on the Contact record.
  B. Customer phone number has changed on the Contact record.
  C. Duplicate Contact records exist in the system.
  D. Duplicate Activity records on a Contact.
  C. Duplicate Contact records exist in the system.

• Question 184:

  Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

  A. Analytics/BI Owners
  B. Data Domain Stewards
  C. Salesforce Administrators
  D. Operational Data Users
  A. Analytics/BI Owners
  B. Data Domain Stewards

• Question 185:

  Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.

  Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)

  A. Keep the relationship fields populated with the source record IDs in the import file.
  B. Create an external ID field for each object in the target org and map source record IDs to this field.
  C. Replace source record IDs with new record IDs from the target org in the import file.
  D. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
  E. Use data loader to export the data from the source org and then import/upsert into the target org in sequential order.
  A. Keep the relationship fields populated with the source record IDs in the import file.
  B. Create an external ID field for each object in the target org and map source record IDs to this field.
  E. Use data loader to export the data from the source org and then import/upsert into the target org in sequential order.

• Question 186:

  A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities: 1.Distributor create sales order in salesforce 2.Sales order are based on product prices applicable to their region

  3.

  Sales order are closed once they are fulfilled

  4.

  It is decided to maintain the order in opportunity object How should the data architect model this requirement?

  A. Create lookup to Custom Price object and share with distributors.
  B. Configure price Books for each region and share with distributors.
  C. Manually update Opportunities with Prices application to distributors.
  D. Add custom fields in Opportunity and use triggers to update prices.
  B. Configure price Books for each region and share with distributors.

• Question 187:

  Cloud Kicks is preparing to migrate a large amount of data from a legacy CRM system to Salesforce and wants to optimize the performance of this migration. Which three approaches should be considered? (Choose three.)

  A. Remove custom indexes on the data being loaded.
  B. Evaluate whether the legacy system is still in use.
  C. Defer sharing calculations of the Salesforce Org.
  D. Deactivate approval processes and workflow rules.
  E. Evaluate the time zones of the User loading the data.
  A. Remove custom indexes on the data being loaded.
  C. Defer sharing calculations of the Salesforce Org.
  D. Deactivate approval processes and workflow rules.

• Question 188:

  Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage. Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

  A. Number of queries running at a time.
  B. Number of joins used in report query.
  C. Number of records returned by report query.
  D. Number of characters in report query.
  B. Number of joins used in report query.
  C. Number of records returned by report query.

• Question 189:

  UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application. Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

  A. Use picklist fields rather than lookup to custom object.
  B. Limit assigning one user 10000 records ownership.
  C. Assign 10000 opportunities to one account.
  D. Limit associating 10000 opportunities to one account.
  E. Limit associating 10000 records looking up to same records.
  B. Limit assigning one user 10000 records ownership.
  D. Limit associating 10000 opportunities to one account.

• Question 190:

  Universal Containers is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be created and is concerned about the performance of the application. Which three recommendations should the data architect make to avoid data skew? (Choose three.)

  A. Limit associating 10,000 records looking up to same records
  B. Assign 10,000 opportunities to one account
  C. Limit assigning one user 10,000 records ownership
  D. Use pick list fields rather than lookup to custom object
  E. Limit associating 10,000 Opportunities to one account
  A. Limit associating 10,000 records looking up to same records
  C. Limit assigning one user 10,000 records ownership
  E. Limit associating 10,000 Opportunities to one account