This past weekend, I passed the 70-462 exam which completes the requirements for achieving the MCSE Business Intelligence certification. This exam had been lingering for quite some time and I continued to put it off because, to be completely honest, I just don’t find the material as interesting and would prefer spending my free time digging deeper into SSAS and Hadoop 😉
This was by far the most difficult exam for me since it was mostly focused on material which I, as BI developer, rarely deal with on a day to day basis. It was also the most beneficial exam for me because it forced me to wrap my head around concepts before which I’d only scratched the surface. To put it another way, I actually had to study and learn for this one…while the rest of the exams were simply review.
For example, before this exam, I’d only understood AlwaysOn Availability Groups from a feature level…but I’d never actually created one and performed a backup off of the active secondary. Same with TDE – I can now say that I’ve migrated an encrypted database from one instance to another. Mirroring, check. Replication, check. Backup and recovery options, check check. This exam forced me to finally setup a lab environment and run through a variety of build-break-fix scenarios until things clicked…which by the way was the perfect excuse to buy more RAM for my laptop 😉
Am I ready to architect a complex production database environment…no, of course not. Am I capable of having a detailed discussion with a DBA regarding index maintenance, statistics, partitioning, and recovery models for the various databases in the client’s environment…hell yes!