I have faced total 60 questions. Unlike Sharing and Visibility exam there are no additional questions. It has taken around 100 hours of preparation mostly one and half months time frame.
The Salesforce Certified Data Architecture and Management Designer exam has the following characteristics:
- Content: 60 multiple-choice/multiple-select questions* (2-5 unscored questions may be added)
- Time allotted to complete the exam: 90 minutes (time allows for unscored questions)
- Passing Score: 67%
- Registration fee: USD 400, plus applicable taxes as required per local law
- Retake fee: USD 200, plus applicable taxes as required per local law
- Delivery options: Proctored exam delivered onsite at a testing center or in an online proctored environment. Click here for information on scheduling an exam.
- References: No hard-copy or online materials may be referenced during the exam.
- Prerequisite: None
Before I started my preparation, I have prepared a document and noted down all the points and advice mentioned by these guys. Thanks to all of them.
- How to Prepare For and PASS Data Architecture and Management Designer Exam - By Maciej Jozwiak
- Tips for Passing the Three New Salesforce Architecture Designer Exams - By Lars Malmqvist
- Study Guides for Salesforce Certified Data Architecture and Management Designer Exam Winter'17 - By Suthikiet Boonyakumanon
- Preparing For The Salesforce ‘Data Architecture & Management Designer’ Exam - By Mayank Srivastava
Topics I have received on Exam
- Strategies for data migration, data archieval
- How to resolve timeout issues
- Skinny table
- PK Chunking
- Use of Bulk API
- Use of rollup summary
- Different types of locking and how to overcome those
- Master data management
- Reports and Dashboards
- Integration with external system
- Validation rule, workflow rule, outbound message.
- Use of External Ids
- Use of AppExchange product and third party ETL tool
- Field History tracking
- Metadata API.
- Analytic snapshot.
By the way, Salesforce recommended training guide doesn't cover 100% areas of the exam. Around 10-15% of the questions were outside of the material which I could assume so far.