Book Image

Salesforce Data Architect Certification Guide

By : Aaron Allport
Book Image

Salesforce Data Architect Certification Guide

By: Aaron Allport

Overview of this book

The Salesforce Data Architect is a prerequisite exam for the Application Architect half of the Salesforce Certified Technical Architect credential. This book offers complete, up-to-date coverage of the Salesforce Data Architect exam so you can take it with confidence. The book is written in a clear, succinct way with self-assessment and practice exam questions, covering all the topics necessary to help you pass the exam with ease. You’ll understand the theory around Salesforce data modeling, database design, master data management (MDM), Salesforce data management (SDM), and data governance. Additionally, performance considerations associated with large data volumes will be covered. You’ll also get to grips with data migration and understand the supporting theory needed to achieve Salesforce Data Architect certification. By the end of this Salesforce book, you'll have covered everything you need to know to pass the Salesforce Data Architect certification exam and have a handy, on-the-job desktop reference guide to re-visit the concepts.
Table of Contents (23 chapters)
1
Section 1: Salesforce Data Architect Theory
9
Section 2: Salesforce Data Architect Design
15
Section 3: Applying What We've Learned – Practice Questions and Revision Aids

LDV performance mitigation strategies

There are several tools available to us as data architects when it comes to working with data and keeping things running as optimally as possible. Of course, we should first question what data needs to reside in Salesforce. How often should we consider moving data off-platform to reduce performance impacts due to having large amounts of data available? Typically, data of a certain age (determined by business requirements or regulatory requirements in some instances) should be archived regularly to ensure that users are only interacting with the data that makes sense to be hosted on the Salesforce platform.

With data that may need to reside on Salesforce, some other techniques are available that can improve performance:

  • Custom indexes
  • Skinny tables
  • Selective filter conditions
  • Divisions

Let’s take a look at them.

Custom indexes

To speed up query performance, Salesforce supports the creation of custom indexes...