Free Certified Data Architect Exam Braindumps (page: 13)

Page 12 of 56

A customer wants to maintain geographic location information including latitude and longitude in a custom object.
What would a data architect recommend to satisfy this requirement?

  1. Create formula fields with geolocation function for this requirement.
  2. Create custom fields to maintain latitude and longitude information
  3. Create a geolocation custom field to maintain this requirement
  4. Recommend app exchange packages to support this requirement.

Answer(s): B



Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Whichtwo things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

  1. Limitations on master -detail relationships.
  2. Org data storage limitations.
  3. Bulk API limitations on picklist fields.
  4. Standard list view in -line editing.

Answer(s): C,D



A large retailB2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system:

1. Salesforce CRM

2. Custom billing solution

3. Customer Master Data management (MDM)

4. ContractManagement system

5. Marketing solution

What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

  1. Store the salesforce id in all the solutions to identify the customer.
  2. Create a custom objectthat will serve as a cross reference for the customer id.
  3. Create a customer data base and use this id in all systems.
  4. Create a custom field as external id to maintain the customer Id from the MDM solution.

Answer(s): D



The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:

Select id, description, Subject from Task where WhatId != NULL

When the data architect usages the query to select values for a process a time out error occurs.

What does thedata architect need to change to make this query more performant?

  1. Remove description from the requested field set.
  2. Change query to SOSL. ??
  3. Add limit 100 to the query.
  4. Change the where clause to filter by a deterministic defined value.

Answer(s): D






Post your Comments and Discuss Salesforce Certified Data Architect exam with other Community members:

Certified Data Architect Discussions & Posts