ExamDumpster

70-762

Developing SQL Databases practice test

50 Microsoft 70-762 practice questions with explanations, in study, timed and flashcard modes. 8 sample questions are free.

Full access

$99

  • All 50 questions, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
  • 2 packages, bundle from $148.99
Try the free samples first
Microsoft logo
Questions
50
Free samples
8
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.

Open the full exam guide

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

70-762 questions, answered