Free Certified Data Architect Exam Braindumps (page: 26)

Page 25 of 56

Which three characteristics of a Skinny table help improve report and query performance?

  1. Skinny tables can contain frequently used fields and thereby help avoid joins.
  2. Skinny tables can be used to create custom indexes on multi-select picklist fields.
  3. Skinny tables provide a view across multiple objects for easy access to combined data.
  4. Skinny tables are kept in sync with changes to data in the source tables.
  5. Skinny tables do not include records that are available in the recycle bin.

Answer(s): A,C,D



Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application.
Which two methods should be recommended to meet this requirement? Choose 2 answers

  1. Use the Force.com Workbench to export the data.
  2. Schedule a weekly export file from the Salesforce UI.
  3. Schedule jobs to export and delete using an ETL tool.
  4. Schedule jobs to export and delete using the Data Loader.

Answer(s): C,D



NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO's product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

  1. Salesforce Sales Cloud license
  2. Lightning Platform license
  3. Customer Community license
  4. Partner Community license

Answer(s): D



A customer needs a sales model thatallows the following:

Opportunities need to be assigned to sales people based on the zip code. Each sales person can be assigned to multiple zip codes. Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.
What should a data architect recommend?

  1. Assign opportunities using list views using zip code.
  2. Add custom fields in opportunities for zip code and use assignment rules.
  3. Allow sales users to manually assign opportunity ownership based on zip code.
  4. Configure territory management feature to support opportunity assignment.

Answer(s): D






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

Certified Data Architect Discussions & Posts