There is no waiting for a shipment when you order from ActualCollection. About a minute after payment, the Microsoft Querying Data with Transact-SQL package, all 205 practice questions included, lands in your inbox as an instant download.
Microsoft 070-761 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Related Certifications: | MCSA: SQL 2016 BI Development MCSA: SQL 2016 Database Development 70-762 |
| Exam Price: | $165 USD |
| Available Languages: | Traditional Chinese, Russian, Brazilian Portuguese, Japanese, German, Simplified Chinese, French, English |
| Exam Format: | Build list, Code completion, Drag and drop, Short answer, Multiple response, Hot area, Multiple choice, Active screen |
| Certificate Validity Period: | MCSA certification valid for 2 years; exam retired since January 2021 |
| Passing Score: | 700 / 1000 |
| Real Exam Qty: | 40–60 |
| Exam Duration: | 90–180 |
| Recommended Training: | Course 20761: Querying Data with Transact-SQL Exam Ref 70-761 Querying Data with Transact-SQL |
| Exam Registration: | Microsoft Exam Page Pearson VUE (archived) |
| Sample Questions: |  |
| Exam Way: | Retired; previously delivered via Pearson VUE test centers or online proctored |
| Pre Condition: | No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016 |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/certifications/exams/70-761 |
Microsoft 070-761 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage data with Transact-SQL | 40–45% | - Create Transact-SQL SELECT queries
|
| Topic 2: Program databases by using Transact-SQL | 20–25% | - Implement functions and error handling
|
| Topic 3: Query data with advanced Transact-SQL components | 30–35% | - Use set operators and grouping
|
Common Questions About the Microsoft Querying Data with Transact-SQL Exam
The Microsoft Querying Data with Transact-SQL exam is the official Microsoft test registered under exam code 070-761. Passing it earns you the MCSA: SQL 2016 Database Development / MCSA: SQL 2016 Business Intelligence Development certification, a credential at the Associate level. It is also linked to the related certifications: 70-762, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 BI Development. Microsoft exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The Microsoft Querying Data with Transact-SQL exam includes 40–60 questions to be completed within 90–180. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the Microsoft Querying Data with Transact-SQL exam you need 700 / 1000, and the official registration fee is $165 USD. A retake is not discounted: a failed attempt means paying the full $165 USD again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Registration for the Microsoft Querying Data with Transact-SQL exam goes through the official channels below.
As for the delivery format, the exam is taken Retired; previously delivered via Pearson VUE test centers or online proctored.
Microsoft points candidates toward the following training options for Microsoft Querying Data with Transact-SQL.
Course work builds the foundation; question practice makes it stick. The 205 practice questions in the ActualCollection 070-761 package let you rehearse each topic under exam-style pressure before the real thing.
Yes. ActualCollection offers a free PDF demo of the Microsoft Querying Data with Transact-SQL material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the Microsoft Querying Data with Transact-SQL exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and emailed to you within one minute of payment. If nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you may install the software on.
The official Microsoft Querying Data with Transact-SQL syllabus is organized into 3 domains. Key areas include Query data with advanced Transact-SQL components (30–35%), Manage data with Transact-SQL (40–45%), and Program databases by using Transact-SQL (20–25%). The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
Microsoft Querying Data with Transact-SQL Sample Questions:
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:
The tables include the following records:
Customer_CRMSystem
Customer_HRSystem
Records that contain null values for CustomerCode can be uniquely identified by CustomerName.
You need to display distinct customers that appear in both tables.
Which Transact-SQL statement should you run?
- A. Option H
- B. Option E
- C. Option B
- D. Option G
- E. Option F
- F. Option C
- G. Option D
- H. Option A
Correct Answer: A 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question on this series.
You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application.Cities, and Sales.CustomerCategories tables.
Details for the Sales.Customers table are shown in the following table:
Details for the Application.Cities table are shown in the following table:
Details for the Sales.CustomerCategories table are shown in the following table:
You need to create a query that meets the following requirements:
- For customers that are not on a credit hold, return the CustomerID and the latest recorded population for the delivery city that is associated with the customer.
- For customers that are on a credit hold, return the CustomerID and the latest recorded population for the postal city that is associated with the customer.
Which two Transact-SQL queries will achieve the goal? Each correct answer presents a complete solution.
- A. Option B
- B. Option C
- C. Option D
- D. Option A
Correct Answer: A,D 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a stored procedure that will be used by hundreds of users concurrently.
You need to store rows that will be processed later by the stored procedure. The object that stores the rows must meet the following requirements:
* Be indexable
* Contain up-to-date statistics
* Be able to scale between 10 and 100,000 rows
The solution must prevent users from accessing one another's data.
Solution: You create a local temporary table in the stored procedure.
Does this meet the goal?
- A. No
- B. Yes
Correct Answer: A 🗳️
You develop and deploy a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application.
The add-on must meet the following requirements:
* Allow case sensitive searches for product.
* Filter search results based on exact text in the description.
* Support multibyte Unicode characters.
You run the following Transact-SQL statement:
You need to ensure that users can perform searches of descriptions.
Which Transact-SQL statement should you run?
- A. Option B
- B. Option C
- C. Option D
- D. Option A
Correct Answer: C 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a table named Products that contains information about the products that your company sells. The table contains many columns that do not always contain values.
You need to implement an ANSI standard method to convert the NULL values in the query output to the phrase "Not Applicable".
What should you implement?
- A. the ISNULL function
- B. a stored procedure
- C. the COALESCE function
- D. a view
- E. a table-valued function
- F. the TRY_CONVERT function
- G. a scalar function
- H. the TRY_PARSE function
Correct Answer: A 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
986 Customer Reviews
