So after going through all the study material and a lot of reading, I am pleased to announce that I have cleared my “Data Architecture And Management Designer” exam. This makes me a “Certified Application Architect” 🤩
What I believe, this was a bit tougher than my previous certifications, but if you go through the complete study material, you should be able to clear this in first attempt. With this post, I will be sharing my experience and some of the important links that you must go through before you appear for the exam.
From where to start?
As always, you need to start with official Study Guide and Resource Guide which are completely free and specially designed for this exam. You must go through Study Guide first as this has the complete outline of the exam along with 5 sample question. It will give you an idea of all the topics that you need to read before going for the exam.
Not sure from where to read about these topics? well, don’t worry!! Official Resource Guide has all the important links that you need. Resouce Guide has links of various articles, videos and white papers which are important for this exam with tags like recommended and core. You do not want to miss the links marked as ‘core’ as these are the key resources for this exam, however I would suggest you to go through all the ‘recommended’ links as well.
One more way to find all the relevant articles links is completing Architect Journey: Data Architecture and Management Trailmix. The Trailmix has three section divided as per the learning level like Beginner, Intermediate and Advanced.
You need to do as much hands-on as you can to make yourself aware about a particular topic. Give more time to those topics which are new to you. Make your own notes and not down every important point when you will be going through the study material, this will help you to take a last minute look at all the important points.
- Lookup Skew, Ownership Skew
- Manage Large Data Volume*
- Master Data Management*
- Skinny Table
- Bulk Api*
- Bulk Api vs Soap Api
- Pk Chunking
- Manage Duplicate Records (Leads, Account, Contact)
- Data Stewardship and Ownership
- ETL Tools*
- Data Quality
- Query Optimization, SOQL and SOSL*
* – Important topics
Lookup and Ownership Skew
When a single user owns more than 10,000 records of an object, we call that condition ownership skew. One of the common patterns involves customers concentrating ownership of data so that a single user or queue, or all the members of a single role or public group, owns most or all of the records for a particular object.
Similarly, association of a large number of child records (10,000 or more) with a single parent account is called lookup skew or parent-child data skew.
Skewing may result in lock contention as Salesforce locks parent record while updating child record to maintain data integrity. So while updating multiple records in parallel mode with the same parent record, may throw Record Lock errors. Read below posts for more details:
Managing Duplicate Records
Maintaining clean, accurate data is one of the most important things you can do to get the most out of Salesforce. Salesforce provides out of the box tools to avoid duplicate data. This Trailhead Module to learn about duplicate management.
Query Optimization And Skinny Table
Read my earliest post which covers this topic in depth.
Primary Key chunking is used to divide the data into chunks while extracting. When the number of records in a single query is lower than the selectivity threshold of the Salesforce Query Optimizer, the platform can process the queries more efficiently. The new PK Chunking feature of the Bulk API automates this process by using the Primary Key (Record ID) of an object to break up the data into manageable chunks and query them separately.
Sforce-Enable-PKChunking header can be used in Bulk Api to use PK Chunking. Learn more about PK Chunking header here.
The Bulk API is a RESTful API that is optimal for loading or deleting large sets of data. You can use it to query, insert, update, upsert, or delete a large number of records asynchronously by submitting batches that Salesforce processes in the background.
Apart from the topics and links gives above, follow these links as well.
- Bulk API Developer’s Guide
- Bulk API Limits
- Master Data Management Strategy for an Enterprise
- Large Data Management Strategies
- Best Practices for Data Governance & Stewardship in Salesforce
This exam completely focus on managing your data. This includes loading data in Salesforce, managing data in Salesforce and extracting data from Salesforce. There are some out of the box tools provided by Salesforce for loading, managing and extracting the data along with some third party tools and AppExchange apps.