Salesforce Certified Data Arch & Management Designer - Spring '17 Release Exam

1 of 5.	An Architect is advising a company on good practices for maintaining a high level of data quality and integrity. The company has been considering using the Salesforce Data.com integration rules to help keep Account records clean. Which three are features of Data.com integration rules that would help this use case?
	Choose 3 answers
	A. Integration rules can be configured to source data updates from the company’s custom website database of industry Accounts. B. Accounts that have been configured to use State & Country picklists can still use integration rules to populate addresses. C. Integration rules can have custom mappings configured to map source fields to specific fields on the Account object. D. Some integration rules can be configured to automatically perform a full sync of records on a regular schedule. E. Local updates to the Account records can be synchronized back to the Data.com data source for others to benefit from.

2 of 5.

An Architect is designing a Custom Metadata Type (MDT) that will be associated with specific fields on the Lead object. This MDT will be deployed in a Managed Package and will likely link to Lead object fields that don’t exist in the source org. What is the recommended strategy to link records of this MDT to Lead object fields?

A. Create a custom field that uses the Text field type and store the API name of the target Lead field. B. Create a custom field that uses the Field Definition variant of the Metadata Relationship field type. C. Create a custom field that uses the External Lookup field type and points to the Lead object field. D. Create a custom field that uses the Entity Definition variant of the Metadata Relationship field type.

3 of 5.

An Architect is advising a company that is designing how their new Salesforce org will mesh with their legacy database of several hundred million Case records. The company is discussing how best to migrate these records into Salesforce. It is especially important that Account Managers be able to report on their Salesforce Account records and include information about related Cases, however the number of related Cases is fairly small per Account. What alternate approach might the Architect recommend to avoid loading and holding this many Case records in Salesforce?

A. Use an ETL tool to do daily uploads into Salesforce of the most recently created Case records. B. Design a UI mashup where Case records from the legacy system are shown to Users alongside their Account records. C. Leverage External Objects to retrieve Case records as needed from the external legacy database. D. Load all pre existing Cases and then prune aggressively based on the ones that Account Managers use.

4 of 5.

A customer would like to archive deleted account records from Salesforce into a NoSQL datastore on a daily basis. A large amount of accounts are being deleted in Salesforce every day as part of an account merge. What is the recommended approach to leverage Salesforce platform features?

A. Make a SOAP API call with getdeleted() function and translate the XML result into JSON before writing into the datastore. B. Make a SOAP API call with getdeleted() function, store the XML result data into JSON datastore. C. Make a Bulk API call with the QueryAll() option and write the JSON result into the datastore. D. Make a REST API call to query the data from the Recycle Bin and write the JSON result into the datastore.

5 of 5.	An Architect has been brought in to advise on significant performance issues that are negatively impacting a specific SOQL query. This query targets a table with several million records. Upon further investigation, the Architect finds that the query is non-selective. Which two are strategies that could be introduced to help mitigate the performance problems?
	Choose 2 answers
	A. If negative filter conditions are used (ex: not equals), add a custom reverse index. B. If a cross-object formula is being filtered on, add a custom two-column index for it. C. If null values are being filtered on, add a custom index that includes null values. D. If a filtered field is a deterministic formula field, add a custom index for it.