In the month of June 2017, I got a chance to appear in the Salesforce Certified Data Architecture and Management Designer exam.
About the exam
- Prerequisite: None
- Multiple-choice/multiple-select questions = 60
- Passing Score = 67%
- Time allotted to complete the exam = 90 minutes
- Minimum correct answers = 60 * 67 / 100 = 40
Preparation
- Salesforce Certified Data Architecture and Management (Study Guide)
- Read all the questions in the study guide. Few questions might come in your exam!
- Data Architecture and Management Resource Guide
- Read all the topics in the architect resource guide because this is the master guide to Pass the exam. Please do read every topic from this guide.
- Make sure you do practice at least one (1) time in Salesforce Developer edition.
- Salesforce Trailhead Modules
- Salesforce Platform Basics
- Data Modeling
- Data Management
- Developer Beginner
- Developer Intermediate
- Data Security
- Best Practices for Deployments with Large Data Volumes
- This is very important guide. Please read this thoroughly. A good number of questions come from this guide.
- Best Practices of Visualforce Performance
- Master Data Management (MDM)
- AppExchange apps for data import/export
- Data.com
- Data Duplication rules (Duplicate Rules / Matching Rules)
- Custom Objects, Custom Metadata Types, Custom Settings
- External Data Source (OData), External Objects
- Data architecture impacts on:
- Search text
- SOQL query
- List Views
- Reporting
- Import data
- Export data
- Merge Accounts / Contacts
- External Ids / Upsert
- Indexed fields
- Skinny Tables
- Delete data from standard objects (Parent Only, Parent with Child)
- Truncate custom objects
- Recycle Bin with deleted records (IsDeleted = false)
- Filter on Indexed fields in Reports
- Data Integration (Mashups)
- Force.com Canvas
- Designing Record Access for Enterprise Scale
- Defer Sharing Calculation
- Granular Locking
- Parallel Processing
- Salesforce Large Data Volumes
- Salesforce Connect (OData) vs Heroku Connect
- Data Skew (a Parent record has more than 10K child records associated to it)
- Distribute child records into multiple parent records
- Ownership Skew (a User is owner of more than 10K records in an object)
- Data Archive strategy
- SOAP API (Synchronous)
- SOAP Web Services are commonly used for: Enterprise apps that require a formal
- exchange format or stateful operations.
- getUpdated()
- getDeleted()
- Minimum and Maximum batch size
- Limitations
- Can you monitor in Salesforce setup area?
- REST API(Synchronous)
- Uniform Resource Identifier (URI) = /services/data/v36.0
- GZIP Compression
- SObject Tree
- Minimum and Maximum batch size
- Limitations
- Can you monitor in Salesforce setup area?
- Bulk API (Asynchronous)
- We obtain a session ID using the SOAP API login() call
- Uniform Resource Identifier (URI) =
- /services/async/XX.0/job/jobID/batch
- /services/async/36.0/job/75036000001xYl1AAE/batch/75136000001jSZIAA2/result
- General Guidelines for Data Loads
- Serial Mode
- Parallel Mode
- Minimum and Maximum batch size
- Limitations
- Can you monitor in Salesforce setup area?
- Metadata API
- Streaming API
- Which API should you pick?
- Outbound Messages
- Idempotence
- DML operations: Insert, Update, Upsert
- Import data tools (e.g. Data Import wizard, Apex data loader, AppExchange app etc.)
- Export data tools (e.g. Data Export, Apex data loader)
- Report and Dashboards best practices
- Schedule Report
- Email Report
- Custom Report Types
- Primary Key Chunking
- with sharing vs without sharing
Suggestions & Tips
- Take any of the new Architect Journey exam as more to get the knowledge than the certification credentials!
- In order to pass this exam or any of the new Architect Journey exam, you must have read the Architect resource guide thoroughly and as well as hands on experience.
- If you don't have any practical experience, a Salesforce Developer edition will be the best option where you will have pretty much everything you need to have for this exam.
- Salesforce Trailhead is a great source, containing full of information for each area of the Salesforce platform.
- I learnt one thing in the new Architect Journey exams Don’t judge exam questions by its length! In any of the new Architect Journey exam you will find few questions very easy straightforward but those questions are very less in numbers. You will find majority of questions complex but interesting and every question will have a clue or point to select the correct answer(s).
I hope the content here helps you to get this Certification. Best of luck!
