Free Certified Data Architect Exam Braindumps
Salesforce Certified Data Architecture and Management Designer Questions 46–50 (page: 11)

Updated On: 10-Feb-2026

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



A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:

Personally, identifiable information (PII)
IP restrictions on profiles organized by Geographic location Financial records that need to be private and accessible only by the assigned Sales associate.
User should not be allowed to export information from Salesforce. Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

  1. Event monitoring to monitor all user activities
  2. Restrict access to SF from users outside specific geography
  3. Prevent Sales users access to customer PII information
  4. Transaction security policies to prevent export of SF Data.
  5. Encrypt Sensitive Customer information maintained in SF.

Answer(s): B,D,E



Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

What should a data architect consider before implementing Salesforce Connect for reporting?

  1. Maximum number for records returned
  2. OData callout limits per day
  3. Maximum page size for server-driven paging
  4. Maximum external objects per org

Answer(s): B



Viewing page 11 of 46
Viewing questions 51 - 55 out of 221 questions


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

AI Tutor AI Tutor 👋 I’m here to help!