70-762
Developing SQL Databases practice test
50 Microsoft 70-762 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 50 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- 2 packages, bundle from $148.99
- Questions
- 50
- Free samples
- –
- Versions
- 1
- Updated
- Sep 2021
Exam simulator
Practice 70-762 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
70-762, by the numbers.
Official specifications published by Microsoft.

Exam guide
Everything about 70-762.
70-762 · Microsoft
What is 70-762?
Passing 70-762, together with 70-761, earned MCSA: SQL 2016 Database Development. It showed you could design and program SQL Server databases. It left Microsoft's catalog in January 2021, when the MCSA exams were retired. Database developers who design tables, indexes and stored procedures took it. An isolation level controls how much one transaction can see of another transaction's unfinished changes. One task is to choose an index that speeds up a slow query without slowing down inserts too much. The practice test works through database design, programmability, concurrency and performance tuning.
What you'll practise
- Design tables, schemas, views and indexes, including columnstore indexes.
- Write stored procedures, triggers and user-defined functions, and enforce constraints.
- Manage transactions, isolation levels and locking.
- Use memory-optimized tables and natively compiled stored procedures.
- Tune queries with statistics, indexes and execution plans.
- Monitor SQL Server performance and set baselines.
Requirements
- Recommended: hands-on experience designing and programming SQL Server databases.
Who it's for
- Database developers who build SQL Server schemas and stored procedures.
- Developers who tune slow queries and fix locking problems.
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator