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

• Question 191:

  DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the

  query times out.

  What should be considered to address this issue?

  A. Tooling API

  B. PK Chunking

  C. Metadata API

  D. Streaming API

  Correct Answer: B

• Question 192:

  An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

  A. Create indexes on Opportunity object text fields.

  B. Group batches by the AccountId field.

  C. Sort batches by Name field values.

  D. Order batches by Auto -number field.

  Correct Answer: D

• Question 193:

  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.

  Correct Answer: D

• Question 194:

  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.

  Correct Answer: ACD

• Question 195:

  Cloud Kicks has the following requirements:

  1.

  Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).

  2.

  A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.

  What are two approaches for fulfilling these requirements? (Choose two.)

  A. A set to determine which fields to send in an HTTP callout.

  B. An Outbound Message to determine which fields to send to the OMS.

  C. A Field Set that determines which fields to send in an HTTP callout.

  D. Enable the field -level security permissions for the fields to send.

  Correct Answer: BC

• Question 196:

  Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

  Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

  Which two approaches will accomplish this goal? (Choose two.)

  A. Create the users, upload all data, and then deploy the sharing rules.

  B. Contact Salesforce to activate indexing before uploading the data.

  C. First, load all account records, and then load all user records.

  D. Defer sharing calculations until the data has finished uploading.

  Correct Answer: AD

• Question 197:

  DreamHouse Realty 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. There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

  

  What should the Architect consider in this situation?

  A. Load all data after deferring sharing calculations.

  B. Calculate summary values instead of Roll-Up by using workflow.

  C. Calculate summary values instead of Roll-Up by using triggers.

  D. Load all data using external IDs to link to parent records.

  Correct Answer: A

• Question 198:

  Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

  A. Use the SOAP API to export data.

  B. Utilize the Bulk API to export the data.

  C. Use GZIP compression to export the data.

  D. Schedule a Batch Apex job to export the data.

  Correct Answer: C

• Question 199:

  A business that works directly with individual consumers (B2C) currently has a home-grown CRM system, but they are moving to Salesforce. The business has 1.2 million consumer records and wants assistance with achieving optimal use of Salesforce functionality while also avoiding data loading issues.

  What should an Architect recommend?

  A. Create a Custom Object Individual Consumer c to load all individual consumers.

  B. Load all individual consumers as Account records and avoid using the Contact object.

  C. Load one Account record and one Contact record for each individual consumer.

  D. Create one Account and load individual consumers as Contacts linked to that one Account.

  Correct Answer: C

• Question 200:

  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.

  Correct Answer: D