What is the 70-761: Querying Data with Transact-SQL exam?

70-761: Querying Data with Transact-SQL is a Microsoft certification exam. Judging by the questions in our bank, it concentrates on query, table, join, records and clause.

What topics does the 70-761: Querying Data with Transact-SQL exam cover?

Questions in our 70-761: Querying Data with Transact-SQL bank cluster around query, table, join, records, clause, null, sales and products. Working through the full set is the quickest way to find which of these you are weakest on.

How should I prepare for 70-761: Querying Data with Transact-SQL?

Work through the 70-761: Querying Data with Transact-SQL practice questions here, checking your answer on each one, then sit the practice test to rehearse the exam under timed conditions before the real thing.

Are these real 70-761: Querying Data with Transact-SQL exam questions?

They are drawn from officially released past questions and from community members who have sat 70-761: Querying Data with Transact-SQL. Answers are verified and updated weekly.

Where do I register for the 70-761: Querying Data with Transact-SQL exam?

Register through Microsoft directly at https://learn.microsoft.com/en-us/credentials/. Exampractice is not affiliated with Microsoft and does not administer the exam.

Is there a free 70-761: Querying Data with Transact-SQL sample?

Yes. Every 70-761: Querying Data with Transact-SQL page shows a free sample of real questions. Upgrading opens the full bank and the practice test.

1. A database administrator needs to find all employees with the same job title as "Manager". Which query would correctly filter this data?

SELECT * FROM Employees WHERE JobTitle = 'Manager';

SELECT * FROM Employees WHERE JobTitle != 'Manager';

SELECT * FROM Employees WHERE JobTitle IS NOT NULL;

2. In a sales database, how would you calculate the total sales for each product category?

SELECT Category, SUM(Sales) FROM SalesData GROUP BY Category;

SELECT SUM(Sales) FROM SalesData;

SELECT Category FROM SalesData;

SELECT Category, COUNT(Sales) FROM SalesData GROUP BY Category;

3. You need to write a query that retrieves customer names but excludes any customers who have not made a purchase. Which query would achieve this?

SELECT CustomerName FROM Customers WHERE Purchases > 0;

SELECT CustomerName FROM Customers;

SELECT CustomerName FROM Customers WHERE Purchases IS NOT NULL;

SELECT DISTINCT CustomerName FROM Customers;

4. A table contains transaction details with a timestamp. How can you fetch all transactions from the last month?

SELECT * FROM Transactions WHERE TransactionDate >= GETDATE() - 30;

SELECT * FROM Transactions WHERE MONTH(TransactionDate) = MONTH(GETDATE()) - 1;

SELECT * FROM Transactions WHERE TransactionDate BETWEEN GETDATE() AND GETDATE() - 30;

6. You need to retrieve the names of employees who have not completed mandatory training. Which query should you use?

SELECT Name FROM Employees WHERE TrainingCompleted = 0;

SELECT Name FROM Employees WHERE TrainingCompleted = 1;

SELECT Name FROM Employees WHERE TrainingCompleted IS NULL;

7. How can you count the number of distinct customers who made purchases last year?

SELECT COUNT(DISTINCT CustomerID) FROM Sales WHERE YEAR(SaleDate) = YEAR(GETDATE()) - 1;

SELECT DISTINCT CustomerID FROM Sales;

SELECT COUNT(CustomerID) FROM Sales;

SELECT CustomerID FROM Sales WHERE SaleDate = YEAR(GETDATE()) - 1;

8. What SQL statement can retrieve the top 5 products by sales?

SELECT TOP 5 ProductName FROM Products ORDER BY Sales DESC;

SELECT ProductName FROM Products LIMIT 5;

SELECT FIRST 5 ProductName FROM Products;

SELECT ProductName FROM Products ORDER BY Sales;

9. When joining multiple tables, what result will you get with an INNER JOIN if no rows match?

The result will be an empty set;

You'll see NULL values for all fields;

It will return all rows from both tables;

10. If you need to get a list of all products that have been sold in the last month, which statement is correct?

SELECT ProductID FROM Sales WHERE SaleDate > GETDATE() - 30;

SELECT DISTINCT ProductID FROM Sales;

SELECT ProductID FROM Products WHERE LastSoldDate > GETDATE() - 30;

SELECT ProductID FROM Sales WHERE SaleDate < GETDATE();

11. To find customers who bought more than 10 items, which query would be appropriate?

SELECT CustomerID FROM Sales GROUP BY CustomerID HAVING COUNT(ItemID) > 10;

SELECT CustomerID FROM Sales WHERE COUNT(ItemID) > 10;

SELECT CustomerID FROM Sales GROUP BY CustomerID;

SELECT DISTINCT CustomerID FROM Sales;

Free 70-761: Querying Data with Transact-SQL Exam Questions and Answers

Querying Data with Transact-SQL is exam 70-761, part of Microsoft Certifications. Microsoft exam codes name the solution area rather than the level — AZ for Azure, DP for data, MS for Microsoft 365, PL for Power Platform, SC for security, AI for Azure AI — with one reliable rule: any exam numbered 900 or 901 is Fundamentals. Every technical exam is scored from 1 to 1000 with 700 to pass, a scaled score Microsoft notes is explicitly not 70% of the marks.

The first 10 questions on this page are free to read, answers included — no account and no card. A plan opens the rest of the bank, the full timed practice test and your weak-topic reporting.

Other Microsoft certifications

All 209 Microsoft exams →

Reviews

★★★★★
This platform is a lifesaver. The practice questions and explanations are so detailed. It’s the best study tool I’ve ever used.
Hannah Smith
USA
★★★★★
I highly recommend Exam Practice. The feedback after each test helped me improve significantly, and I passed my exams easily.
Oscar Nyström
Sweden
★★★★★
Exam Practice is worth every penny. The mock exams are realistic, and the feedback helped me focus on key areas.
Amit Sharma
India

See more reviews

FAQ

Learn More: https://learn.microsoft.com/en-us/credentials/

Q1: What is the 70-761: Querying Data with Transact-SQL exam?: A: 70-761: Querying Data with Transact-SQL is a Microsoft certification exam. Judging by the questions in our bank, it concentrates on query, table, join, records and clause.
Q2: What topics does the 70-761: Querying Data with Transact-SQL exam cover?: A: Questions in our 70-761: Querying Data with Transact-SQL bank cluster around query, table, join, records, clause, null, sales and products. Working through the full set is the quickest way to find which of these you are weakest on.
Q3: How should I prepare for 70-761: Querying Data with Transact-SQL?: A: Work through the 70-761: Querying Data with Transact-SQL practice questions here, checking your answer on each one, then sit the practice test to rehearse the exam under timed conditions before the real thing.
Q4: Are these real 70-761: Querying Data with Transact-SQL exam questions?: A: They are drawn from officially released past questions and from community members who have sat 70-761: Querying Data with Transact-SQL. Answers are verified and updated weekly.
Q5: Where do I register for the 70-761: Querying Data with Transact-SQL exam?: A: Register through Microsoft directly at https://learn.microsoft.com/en-us/credentials/. Exampractice is not affiliated with Microsoft and does not administer the exam.
Q6: Is there a free 70-761: Querying Data with Transact-SQL sample?: A: Yes. Every 70-761: Querying Data with Transact-SQL page shows a free sample of real questions. Upgrading opens the full bank and the practice test.
Q7: What are Microsoft Certification Exams?: A: Microsoft Certification Exams validate your expertise in using and managing Microsoft’s technologies and solutions, including Azure, Office 365, Windows, and more. These certifications demonstrate your proficiency in deploying, configuring, and optimizing Microsoft products to support business operations and IT infrastructure.
Q8: Why should I pursue Microsoft Certification?: A: Microsoft Certification enhances your professional credibility, showcasing your skills and knowledge in Microsoft technologies. This can lead to better job opportunities, higher salaries, and career advancement in IT, cloud computing, software development, and related fields.
Q9: What are the benefits of Microsoft Certification?: A: Benefits include recognition as a certified Microsoft professional, improved job performance, access to exclusive resources, continuing education opportunities, and staying current with the latest Microsoft technologies and best practices.
Q10: Who should take Microsoft Certification Exams?: A: IT professionals, system administrators, developers, cloud engineers, data analysts, and anyone involved in managing and implementing Microsoft solutions should consider these certifications to validate their expertise and advance their careers.
Q11: What types of Microsoft Certification Exams are available?: A: Microsoft offers various certification paths, including:
Q12: How do I prepare for Microsoft Certification Exams?: A: Preparation can include official Microsoft training courses, study guides, practice exams, online tutorials, and hands-on experience with Microsoft products and solutions.
Q13: Where can I take Microsoft Certification Exams?: A: Microsoft Certification Exams can be taken online with remote proctoring or at authorized Pearson VUE testing centers worldwide, providing flexibility to fit your schedule and location.
Q14: How do Microsoft Certifications impact my career?: A: Microsoft Certifications significantly boost your career by demonstrating your expertise to employers, making you a more competitive candidate for advanced roles and promotions in IT, cloud computing, software development, and other tech-related fields.
Q15: Are there any prerequisites for Microsoft Certification Exams?: A: Some exams may have prerequisites, such as foundational knowledge or prior experience with Microsoft products. Check the specific requirements for each certification path on the Microsoft Learn website.
Q16: How often do I need to recertify for Microsoft Certifications?: A: Microsoft Certifications typically require renewal every year or two, depending on the certification, to ensure that certified professionals stay updated with the latest technologies and industry practices.

Free 70-761: Querying Data with Transact-SQL Exam Questions and Answers

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

Question #1

Question #2

Question #3

Question #4

Question #5

Question #6

Question #7

Question #8

Question #9

Question #10

Unlock the full question bank

Other Microsoft certifications

Reviews

FAQ