Roadmap to Success is a series that helps learners understand certification pathways, career options associated with them, and the next steps beyond certification.
The Microsoft Certified Solutions Associate (MCSA), SQL 2016 Database Development certification will provide learners with the essential skills needed to be SQL Server database professionals for both cloud-based and on-premises databases. This certification will equip learners with the knowledge to query data using Transact-SQL and develop SQL databases.
Microsoft Certified Solutions Associate (MCSA), SQL 2016 Database Development
The Microsoft Certified Solutions Associate (MCSA), SQL 2016 Database Development, is designed to validate a learner’s knowledge of SQL Server 2016. The MCSA: SQL 2016 Development Associate-Level Certification is composed of two exams.
70-761 – SQL 2016 Development
70-762 – Building SQL Databases
This certification requires that learners have at least two (2) years of experience in writing queries.
Learn how to become a security expert with SPOTO’s Cybersecurity Training
Get started trainingMicrosoft Certifications
Microsoft certifications are organized in a pyramid structure, with each level leading to more advanced certifications. The MTA (Microsoft Technology Associate) is the base of the Microsoft pyramid. This certification helps IT professionals build their foundation of knowledge. The MCSA (Microsoft Certified Solutions Associate), and MCSD [Microsoft Certified Solutions Developer] are the next levels. These certifications include many of the most popular IT certificates offered by Microsoft such as Windows Server 2012, Windows Server 2016 Office 365, SQL 2016 or Windows 10. The MCSE (Microsoft Certified Solution Expert), the highest level of Microsoft certification, allows learners to specialize in MCSA-level content.
To increase your professional development opportunities, you should explore other Microsoft certification and training options.
Exam Details and Prices for MCSA: SQL 2016
Exam time: 2 hours (120 mins) per exam
Number of questions per exam: 40-60
Passing score: 700 per exam
Questions: Active screen; Multiple answer/Best answer; Build a list; Drag and Drop; Hot area; Multiple answer/Single answer; Multiple answer/Multiple answer; Short AnswerLearn more about Microsoft exam formats.
Register for exams: Pearson Vue, Microsoft Learning
MCSA: SQL 2016 Database Development certification exams can be taken online by proctors.
Exam cost: $165 USD per exam
Exam day logistics: You will need to bring two forms (no photocopies), valid (unexpired), IDs on testing day. One must be a primary ID (government issued with name, signature, and photo) and one must have a secondary ID (with just your name).
An erasable marker and a note board will be provided to you for use during your exam. The testing center is not allowed to have personal items such as cell phones, watches, food, or beverages. Here are the rules and restrictions for testing centers.
Skills Measured: Each exam page at the Microsoft website contains a list of Skills measured, which lists the technical objectives for each exam. This information can be used as a guide for your study and preparation.
70-761 Skills Measured
70-762 Skills Measured
Many learners find that they need to take multiple exams to be successful. Microsoft recognizes this and offers Exam Replay which allows learners to retake exams for a fraction of the price. Exam Replay is available on all exams that are part of the MCSA: SQL Server 2016 certification. To avoid migrating, learners should investigate Exam Replay availability.