When studying for this particular exam, a lot of built in SQL Objects like views and functions are mentioned throughout the reference book.
The supposed to be easiest preparation turned out to be most stressful since I had to memorize a lot of those objects.
For passing this exam. I bought an e-book by Microsoft. This is the official exam reference book for this exam by Louis Davidson and Stacia Varga. I have read the book 3 times and I practice on-hand when in the mood.
Also I needed to read from these following urls:
- https://www.sqlshack.com/locking-sql-server/
My preparation lasted for 7 months. On average I dedicated about 2.5 hours a day everyday reading and practicing! It was a stressful 7 months, I had a lot of momentary pain in the head as if my skull is trying to compress. Saturdays/Sundays and holidays were dedicated to preparation. I still had the time to enjoy beer and get wasted.
This was also one out of the two exams you need to pass to attain MCSA. I finally am an MCSA. Thanks for Intelligent Touch Corporation, my employer who paid for this exam. Thanks for the continued patronage.
Posted below is the new badges I acquired. Also below I posted my score.
