Sunday 9 July 2017

Data Architecture and Management Designer


How I studied?
  • Went through the ebook and all its recommended activities.
  • Followed flash cards and quizelts.
  • Played around in an org. eg. query optimisation and bulk api.
What kind of questions to expect:

  • Few questions in data quality and master data management area. Including questions such as How to identify what is the "system of record"?
  • Data Migration - How to optimise SOQL queries, using indexes and what are the best practices.
  • Usage of skinny tables, standard indexes / custom indexes. No questions regarding index thresholds though.
  •  Improve performance - When to use bulk api?
  • Even though PK chunking and parallel execution of bulk api were widely discussed, I didn't get any questions in those topics.
  • Also there were questions on scenarios where outbound messages were used to send information 3rd parties.  
Useful links: