Querying Data with Transact-SQL

Practice test
Contains 153 Questions, Robust Explanations.

$119


The MeasureUp 70-761: Querying Data with Transact-SQL practice test is designed to help candidates prepare 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.

Certification: This exam counts as credit toward the following certifications:

MCSA: SQL 2016 Database Development

Try a FREE Demo of this Premium Practice Test!

When you order a full Download product as your initial purchase, the 30-day online version will also be added to your Learning Locker... 2 for 1!
(Excludes "Upgrades to Download" options after initial purchase.)
All download products are licensed for single user and can be downloaded on up to three different devices.
Downloading practice test to virtual machines is prohibited.

More Information
Info

This test contains 153 questions and covers the following objectives::

  • Manage data with Transact-SQL - 58
  • Query data with advanced Transact-SQL components - 47
  • Program databases by using Transact-SQL - 48

This test includes references to the following media:

Quality test content is extremely important to us so that you will be prepared on exam day. We ensure that all objectives of the exam are covered in depth so you'll be ready for any question on the exam. Our practice tests are written by industry experts in the subject matter. They work closely with certification providers to understand the exam objectives, participate in beta testing and take the exam themselves before creating new practice tests. MeasureUp's quality content and innovative technology have earned the prestigious credential of Microsoft Official Practice Test and is the Official VMware Practice Test.

  • Practice test experience prepares you for the real exam and builds your knowledge of exam objectives.
  • Detailed explanations for both correct and distractor answers reinforce the material.
  • Practice Mode covers all objectives ensuring topics are covered.
  • Certification Mode (timed) prepares you for “exam taking” conditions.
  • Instant, drill-down score reports tell you exactly the areas to focus on.
  • Additional related Web references included.
PlatformOperating SystemBrowser
Chrome 39 Firefox 34 Internet Explorer 10 and 11 Safari 8
PC W7 x86 X X X
W7 x64 X X X
W8.1 x86 X X X
W8.1 x64 X X X
MAC OSX 10.9 X X X
OSX 10.10 X X X
LINUX Linux x86 X X
Linux x64 X X
Surface Pro Windows 8 X X X
PlatformOperating SystemBrowser
Safari 8 Android Chrome 39 Internet Explorer RT Internet Explorer 11
iPad* IOS 8 X X
iPhone 5 or higher* IOS 8 X X
iPhone 4* IOS 7 X X
Android Tablet* 4.0 or higher X X
Android Phone* 4.0 or higher X X
Lumia 920 or higher* Windows Phone 8.1 X
Surface Windows RT X

*Online use only with these devices


Download System Requeriments

  • Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
  • We no longer support XP
MeasureUp offers recommended exam preparation guidelines...
  • First, use the practice test in Practice Mode to access questions, answers explanations and reference materials. Leverage the remediation to additional learning materials to maximize study effectiveness.
  • Next, use your Score Report to identify objectives where your score is lower and more study is needed.
  • And then, refine your practice experience in Practice Mode by customizing domain objectives or selecting missed questions. Use additional study time wisely.