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

Revisiting Account Skew

As introduced in Chapter 2, Data Modeling and Database Design, Account Skew is the result of an Account record containing 10,000 or more child records. This causes performance and record locking issues.

When updates are made to the child record of an Account, Salesforce locks the parent Account record to maintain record integrity in the database. Updating a large number of child records under the same Account record may cause issues since each of those child record operations will be trying to lock the parent’s Account record.

Additionally, when updates are made to an Account record that affects sharing, such as a seemingly harmless action such as changing the record owner, then all sharing for that Account will have to be recalculated. This goes for all child records of the account. This can cause many inter-connected processes to fail since sharing rules, Role Hierarchy calculations, and other sharing operations will have to take place. If any...