Keep close to the test syllabus and spare yourself the wrong materials. The Microsoft Querying Data with Transact-SQL VCE PDF at PassCollection follows the field's pace — 205 practice questions for the 070-761 exam.
Microsoft 070-761 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Available Languages: | Chinese (Traditional), Chinese (Simplified), German, English, French, Russian, Japanese, Portuguese (Brazil) |
| Exam Duration: | 120 minutes |
| Real Exam Qty: | 40-60 |
| Exam Format: | Multiple choice, Short answer, Build list, Multiple response, Review screen, Drag and drop, Active screen, Hot area |
| Certificate Validity Period: | No fixed expiration for earned legacy certification; exam retired on January 31, 2021 |
| Related Certifications: | MCSA: SQL 2016 Database Development |
| Passing Score: | 700/1000 |
| Exam Price: | $165 USD |
| Sample Questions: |  |
| Exam Way: | Pearson VUE testing center or online proctored delivery when available; the exam is retired and no longer available for registration. |
| Pre Condition: | No formal prerequisite exam. Intended for SQL Server database administrators, system engineers, and developers with two or more years of experience writing Transact-SQL queries. Exam 70-762 was also required to earn MCSA: SQL 2016 Database Development. |
Microsoft 070-761 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage data with Transact-SQL | 40-45% | - Modify data
|
| Topic 2: Program databases by using Transact-SQL | 25-30% | - Implement data types and NULLs
|
| Topic 3: Query data with advanced Transact-SQL components | 30-35% | - Query data by using subqueries and APPLY
|
Microsoft Querying Data with Transact-SQL Exam FAQ — Irresistible Answers
No formal prerequisite exam. Intended for SQL Server database administrators, system engineers, and developers with two or more years of experience writing Transact-SQL queries. Exam 70-762 was also required to earn MCSA: SQL 2016 Database Development. Eligibility rules change over time, so verify the current requirements on the official page before registering.
The Microsoft Querying Data with Transact-SQL is Microsoft's certification exam for MCP, at the Associate level. Related credentials include MCSA: SQL 2016 Database Development. Start simply: free demo first, full set when convinced.
120 minutes for 40-60 questions. The PassCollection engine simulates real examination conditions, so the pacing feels familiar before exam day.
Yes — download our demo freely as your reference; you may be impressed by the conciseness and clearness of the Microsoft Querying Data with Transact-SQL exam VCE. Purchases include 365 days of free updates by email; renew afterward at 50% off.
The Microsoft Querying Data with Transact-SQL blueprint spans 3 domains — including Query data with advanced Transact-SQL components (30-35%), Manage data with Transact-SQL (40-45%), Program databases by using Transact-SQL (25-30%). Our material keeps close to this syllabus; the complete outline above lists every subtopic.
Checkout is brief: add your chosen Microsoft Querying Data with Transact-SQL version to cart, check your email address, apply a discount code if you have one, pay by credit card — the system emails the product automatically within about a minute, with 24/7 help if nothing arrives within 2 hours. All operations are safe and secure. If you fail the corresponding 070-761 exam within 60 days of purchase, we refund in full: send a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam, processed within 7 days. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products. Or exchange for two equal-value products free.
$165 USD per attempt, 700/1000 to pass. Retakes cost the full fee — prepare day to day with the 205 practice questions for the 070-761 exam at PassCollection and review your wrong items thoroughly.
Microsoft Querying Data with Transact-SQL Sample Questions:
You have 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 display a comma separated list of all product bugs filed by a user named User1.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
References: https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017
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 to that question.
You have a database for a banking system. The database has two tables named tblDepositAcct and tblLoanAcct that store deposit and loan accounts, respectively. Both tables contain the following columns:
You need to determine the total number of customers who have either deposit accounts or loan accounts, but not both types of accounts.
Which Transact-SQL statement should you run?
- A. SELECT COUNT(DISTINCT L.CustNo)FROM tblDepositAcct DRIGHT JOIN tblLoanAcct L ON D.CustNo = L.CustNoWHERE D.CustNo IS NULL
- B. SELECT COUNT(*)FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo = L.CustNo
- C. SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctUNION ALLSELECT CustNoFROM tblLoanAcct) R
- D. SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctEXCEPTSELECT CustNoFROM tblLoanAcct) R
- E. SELECT COUNT(*)FROM (SELECT AcctNoFROM tblDepositAcctINTERSECTSELECT AcctNoFROM tblLoanAcct) R
- F. SELECT COUNT (DISTINCT D.CustNo)FROM tblDepositAcct D, tblLoanAcct LWHERE D.CustNo = L.CustNo
- G. SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctUNIONSELECT CustNoFROM tblLoanAcct) R
- H. SELECT COUNT (DISTINCT COALESCE(D.CustNo, L.CustNo))FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo = L.CustNoWHERE D.CustNo IS NULL OR L.CustNo IS NULL
Correct Answer: H 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
You need to create a database object that meets the following requirements:
* accepts a product identifies as input
* calculates the total quantity of a specific product, including quantity on hand and quantity on order
* caches and reuses execution plan
* returns a value
* can be called from within a SELECT statement
* can be used in a JOIN clause
What should you create?
- A. a memory-optimized table that has updated statistics
- B. a user-defined table-valued function
- C. an extended stored procedure
- D. a user-defined stored procedure that has an OUTPUT parameter
Correct Answer: B 🗳️
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 to that question.
You have a database for a banking system. The database has two tables named tblDepositAcct and tblLoanAcct that store deposit and loan accounts, respectively. Both tables contain the following columns:
You need to determine the total number of deposit and loan accounts.
Which Transact-SQL statement should you run?
- A. SELECT COUNT (DISTINCT COALESCE(D.CustNo, L.CustNo))FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo =L.CustNoWHERE D.CustNo IS NULL OR L.CustNo IS NULL
- B. SELECT COUNT(*)FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo = L.CustNo
- C. SELECT COUNT(DISTINCT L.CustNo)FROM tblDepositAcct DRIGHT JOIN tblLoanAcct L ON D.CustNo =L.CustNoWHERE D.CustNo IS NULL
- D. SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctEXCEPTSELECT CustNoFROM tblLoanAcct) R
- E. SELECT COUNT(*)FROM (SELECT AcctNoFROM tblDepositAcctINTERSECTSELECT AcctNoFROM tblLoanAcct) R
- F. SELECT COUNT (DISTINCT D.CustNo)FROM tblDepositAcct D, tblLoanAcct LWHERE D.CustNo = L.CustNo
- G. SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctUNIONSELECT CustNoFROM tblLoanAcct) R
- H. SELECT COUNT(*)FROM (SELECT CustNoFROMtblDepositAcctUNION ALLSELECT
CustNoFROM tblLoanAcct) R
Correct Answer: H 🗳️
Explanation: Only visible for PassCollection 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 create a table by running the following Transact-SQL statement:
You are developing a report that aggregates customer data only for the year 2014. The report requires that the data be denormalized.
You need to return the data for the report.
Which Transact-SQL statement should you run?
- A. Option G
- B. Option C
- C. Option B
- D. Option H
- E. Option D
- F. Option F
- G. Option E
- H. Option A
Correct Answer: A 🗳️
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
Cliff 
Valentina 
Verne 
Enoch 
Madge 
Webb 
Ivy 
Uriah 
Burke 
Ingemar 
Alexia 
Mag 
Boyce 
Queena 
Truda 
