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

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

• Question 171:

  What makes Skinny tables fast? Choose three answers.

  A. They do not include soft-deleted records
  B. They avoid resource intensive joins
  C. Their tables are kept in sync with their source tables when the source tables are modified
  D. They can contain fields from other objects
  E. They support up to a max of 100 of columns
  A. They do not include soft-deleted records
  B. They avoid resource intensive joins
  C. Their tables are kept in sync with their source tables when the source tables are modified

• Question 172:

  An Architect needs to assist Get Cloudy Consulting to maintain Lead data, even after Lead records are deleted and the Recycle Bin emptied. What should the Architect do to implement this solution?

  A. Use a Lead standard report and filter on the IsDeleted standard field.
  B. Use a Converted Lead report to display data on Leads that have been deleted.
  C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
  D. Send data to a Data Warehouse and mark Leads as deleted in that system.
  D. Send data to a Data Warehouse and mark Leads as deleted in that system.

• Question 173:

  An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation. Which two key artifacts should the Architect use? (Choose two.)

  A. User stories
  B. Data model
  C. Integration specification
  D. Non-functional requirements
  B. Data model
  C. Integration specification

• Question 174:

  A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:

  1.

  2,500,000 Accounts

  2.

  25,000,000 Contacts

  When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

  What should a data architect do to solve the performance issues?

  A. Load only the data that the users is permitted to access
  B. Add custom indexes on frequently searched account and contact objects fields
  C. Limit data loading to the 2000 most recently created records.
  D. Create a skinny table to represent account and contact objects.
  C. Limit data loading to the 2000 most recently created records.

• Question 175:

  Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?

  A. Mandate the selection of a custom product for each discount request.
  B. Create a placeholder product record for the generic discount request.
  C. Remove the master-detail relationship and keep the objects separate.
  D. Change the master-detail relationship to a lookup relationship.
  D. Change the master-detail relationship to a lookup relationship.

• Question 176:

  A company needs to track field history on 50 Opportunity fields.

  Which two actions can be taken to accomplish this goal? (Choose two.)

  A. Store a copy of the record when changed by using Analytic Snapshots.
  B. Create a custom object to store the previous and new field values.
  C. Select the 50 fields in the Opportunity Set History Tracking page.
  D. Create a custom object to store a copy of the record when changed.
  B. Create a custom object to store the previous and new field values.
  D. Create a custom object to store a copy of the record when changed.

• Question 177:

  Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records.

  What should the architect recommend to reduce data load processing time?

  A. Load Contact records together using the Streaming API via the Upsert operation.
  B. Delete all existing records, and then load all records together via the Insert operation.
  C. Load all records via the Upsert operation to determine new records vs. existing records.
  D. Load new records via the Insert operation and existing records via the Update operation.
  D. Load new records via the Insert operation and existing records via the Update operation.

• Question 178:

  Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

  A. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
  B. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
  C. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
  D. UC can leverage a "tier"-based approach to classify the record storage need.
  D. UC can leverage a "tier"-based approach to classify the record storage need.

• Question 179:

  Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

  Which three recommendations should a data architect make is order to reduce the number of records from the org?

  Choose 3 answers

  A. Use hard delete in Bulk API to permanently delete records from Salesforce.
  B. Use hard delete in batch Apex to permanently delete records from Salesforce.
  C. Identify records in objects that have not been modified or used In last 3 years.
  D. Use Rest API to permanently delete records from the Salesforce org.
  E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
  A. Use hard delete in Bulk API to permanently delete records from Salesforce.
  C. Identify records in objects that have not been modified or used In last 3 years.
  E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

• Question 180:

  The leadership team at Get Cloudy Consulting has identified a total of ten text fields on the Contact object as critical. The team wants to capture any changes made to these fields, including the following:

  1.

  who made the change

  2.

  when they made the change

  3.

  what is the old value

  4.

  what is the new value

  Get Cloudy Consulting needs to be able to report on these field data changes within Salesforce for the past 3 months.

  Which two approaches will meet this requirement? (Choose two.)

  A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
  B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
  C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
  D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
  B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
  C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.