QUESTION: 5

Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.

What should an Architect do to categorize the attachments to fulfill these requirements?

Add additional options to the standard ContentType picklist field for the Attachment object.
Add a ContentType picklist field to the Attachment layout and create additional picklist options.
Create a custom picklist field for the Type on the standard Attachment object with the values.
Create a custom object related to the Invoice object with a picklist field for the Type.

Answer(s): D

Reveal Solution Next Question

QUESTION: 6

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.
Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

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

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 7

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year.
What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Use SOQL queries without WHERE conditions.
Work with Salesforce Support to enable Skinny Tables.
Reduce the number of triggers on Order _c object.
Make the queries more selective using indexed fields.

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 8

Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records.
When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.
Create a Master -Detail to custom object ShippingStatus c.
Create a Lookup to custom object ShippingStatus c.
Create a text field and make it an external I

Answer(s): A

Reveal Solution Next Question

Free Data-Architect Exam Braindumps (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

Data-Architect Discussions & Posts