The MeasureUp 70-761: Querying Data with Transact-SQL assessment is designed to help candidates test for and pass the Microsoft 70-761 exam.

Candidates should be SQL Server database administrators, system engineers, and developers with two or more years of experience. The exam tests skills and knowledge in writing queries. Candidates should be able to use Transact-SQL to aggregate and modify data and program database.

Candidates should also be able to use advanced Transact-SQL components such as subqueries, expressions, and APPLY to query databases, group and pivot data, and query temporal and nonrelational data.

This assessment contains 30 questions from the MeasureUp associated practice test. It does not include explanations or references as this is an assessment only product.

This exam counts as credit toward the following certifications:

MCSA: SQL 2016 Database Development

"This exam was retired in January 2021. MeasureUp will not update this practice test and any purchases of it will not be refundable."