First, you take a written exam, mostly program tracing - line/s of code are given and you select a choice based on the question. And part two is about SQL server queries.
Next, you take a hands-on exam in which you will create a program (.NET - VB or C#) where you will show CRUD operations to be performed in a database.