Free Certified Data Architect Exam Braindumps (page: 25)

Page 24 of 56

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? Choose2 answers

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

Answer(s): B,D



What should a dataarchitect do to provide additional guidance for users when they enter information in a standard field?

  1. Provide custom help text under field properties.
  2. Create a custom page with help text for user guidance.
  3. Add custom help text in default value for the field.
  4. Add a label field with help text adjacent to the custom field.

Answer(s): A



Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department withmissing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

  1. Change each address field to required on the Page Layout.
  2. Write an Apex Trigger to require all fields to be populated.
  3. Utilize a Validation Rule with a REGEX operator on Postal Code.
  4. Utilize a Validation Rule with a CONTAINS operator on address fields.

Answer(s): C,D



In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items.
What difficulty will an architect run into when implementing thisin Salesforce?

  1. Salesforce allows up to four objects in a single report type.
  2. Salesforce does not support Orders or Order Line Items.
  3. A report cannot contain data from Accounts and Contacts.
  4. Custom report types cannot contain Opportunity data.

Answer(s): A






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

Certified Data Architect Discussions & Posts