- Exam Code: 070-761J
- Exam Name: Querying Data with Transact-SQL (070-761日本語版)
- Updated: Sep 17, 2026
- Q & A: 205 Questions and Answers
Vendors revise exam objectives, and yesterday's notes age faster than most people expect. Actual4Dumps tracks those changes and keeps its Microsoft Querying Data with Transact-SQL (070-761日本語版) practice questions aligned with the live exam, with 365 days of free updates included for every 2026 buyer.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Exam Price: | $165 USD |
| Available Languages: | French, German, Traditional Chinese, English, Russian, Japanese, Brazilian Portuguese, Simplified Chinese |
| Exam Format: | Drag and drop, Code completion, Build list, Active screen, Short answer, Multiple choice, Multiple response, Hot area |
| Certificate Validity Period: | MCSA certification valid for 2 years; exam retired since January 2021 |
| Real Exam Qty: | 40–60 |
| Exam Duration: | 90–180 |
| Passing Score: | 700 / 1000 |
| Related Certifications: | MCSA: SQL 2016 Database Development 70-762 MCSA: SQL 2016 BI Development |
| Recommended Training: | Exam Ref 70-761 Querying Data with Transact-SQL Course 20761: Querying Data with Transact-SQL |
| Exam Registration: | Pearson VUE (archived) Microsoft Exam Page |
| 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 |
| Section | Weight | Objectives |
|---|---|---|
| Manage data with Transact-SQL | 40–45% | - Query multiple tables by using joins
|
| Query data with advanced Transact-SQL components | 30–35% | - Use set operators and grouping
|
| Program databases by using Transact-SQL | 20–25% | - Implement functions and error handling
|
Microsoft Querying Data with Transact-SQL (070-761日本語版) is an official certification exam from Microsoft, identified by the exam code 070-761日本語. Pass it and you hold the MCSA: SQL 2016 Database Development / MCSA: SQL 2016 Business Intelligence Development certification, which sits at the Associate level. It also feeds into related credentials, including 70-762, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 BI Development. In practical terms, this certification tells employers your skills have been measured against the vendor's own standard, which is why certified candidates tend to stand out in hiring and promotion decisions.
Expect 40–60 questions within 90–180 on the Microsoft Querying Data with Transact-SQL (070-761日本語版) exam. Numbers aside, the real challenge is rhythm: lingering too long on one item quietly steals time from three others. Build the habit of answering, flagging, and moving on, then rehearse the full experience under a countdown with the Actual4Dumps test engine until finishing comfortably early becomes your norm.
Registration for Microsoft Querying Data with Transact-SQL (070-761日本語版) officially runs $165 USD, with 700 / 1000 required to pass. Worth knowing before you book: retakes are billed at the same full $165 USD, so a failed attempt doubles your spend. The smarter sequence is to measure yourself first. When your scores on the Actual4Dumps practice tests clear the passing line with room to spare, consistently, that is your signal to schedule the real thing.
No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016
Because vendors update their policies without much fanfare, verify the latest entry requirements before you book using the official exam page.
Booking for the Microsoft Querying Data with Transact-SQL (070-761日本語版) exam goes through the vendor's official registration channels.
When you choose your slot, note that the exam is delivered Retired; previously delivered via Pearson VUE test centers or online proctored.
Microsoft lists the following recommended training for Microsoft Querying Data with Transact-SQL (070-761日本語版) candidates.
Courses teach the concepts; repetition makes them exam-ready. Round out whichever training you pick with the 205 practice questions from Actual4Dumps, and each topic stops being theory and starts being points.
Yes, and we encourage it. Download the free PDF demo of the Microsoft Querying Data with Transact-SQL (070-761日本語版) questions from Actual4Dumps and evaluate the quality on your own terms. After you buy, every update for the next 365 days is free, and when that window closes you can extend your update service at half price.
A 100% money-back guarantee applies, governed by clear conditions. If you sit the Microsoft Querying Data with Transact-SQL (070-761日本語版) exam within 60 days of purchase and fail, you can claim a full refund, as long as the exam corresponds to your product. Attempts made within 3 days of purchase are ineligible, as are products you downloaded but never used, free materials, and expired orders; the name on the exam record must match the payer's name. File your claim with a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and it is settled within 7 days. Rather have a replacement than a refund? You may exchange for two other exam products of equal value, free, and your original product keeps its update service.
Delivery is essentially instantaneous: files unlock for download at payment and arrive in your email within one minute. Some vendors make you wait a day; if 2 hours pass here without delivery, check spam and contact customer service. Install on as many computers as you like, with no restrictions.
The Microsoft Querying Data with Transact-SQL (070-761日本語版) blueprint spans 3 domains. The ones carrying the most weight include Program databases by using Transact-SQL (20–25%), Manage data with Transact-SQL (40–45%), and Query data with advanced Transact-SQL components (30–35%). The complete domain-by-domain breakdown is in the exam topics section above; treat it as your master checklist and let the weights tell you where your study hours earn the most.
プロジェクト管理アプリケーションを開発してデプロイします。 アプリケーションはMicrosoft SQL Serverデータベースを使用してデータを格納します。 あなたはアプリケーションのソフトウェアバグ追跡アドオンを開発しています。
アドオンは次の要件を満たす必要があります。
* 製品の大文字と小文字を区別した検索を許可します。
* 説明の正確なテキストに基づいて検索結果をフィルタします。
* マルチバイトのUnicode文字をサポートします。
次のTransact-SQLステートメントを実行します。
ユーザーは、製品Saltを検索すると製品saltの結果も返されると報告しています。
クエリが正しい結果を返すようにする必要があります。
Transact-SQLステートメントをどのように完成させるべきですか? 回答するには、回答領域で適切なTransact-SQLセグメントを選択します。
注:それぞれ正しい選択は1ポイントの価値があります。
Correct Answer:

Explanation
References:
https://stackoverflow.com/questions/1831105/how-to-do-a-case-sensitive-search-in-where-clause-im-using-sql-s
Sales.Customersという名前の一時テーブルを含むDB1という名前のデータベースがあります。
2017年の初めにDB1の各顧客が利用可能な与信限度を返すクエリを作成する必要があります。
どのクエリを実行する必要がありますか?

Correct Answer: C 🗳️
次の要件を満たすTransact-SQLステートメントを開発する必要があります。
*テーブルの更新に問題がある場合、ステートメントはカスタムエラーを返す必要があります。
*エラー番号は値でなければなりません
*エラーの重大度は
*エラー状態が発生した場合、Microsoft SQL Serverアラートをトリガーする必要があります。
要件ごとにどのTransact-SQLセグメントを使用する必要がありますか?回答するには、回答領域で適切なTransact-SQLセグメントを選択します。
Correct Answer:

Explanation
RAISERROR generates an error message and initiates error processing for the session. RAISERROR can either reference a user-defined message stored in the sys.messages catalog view or build a message dynamically. The message is returned as a server error message to the calling application or to an associated CATCH block of a TRY...CATCH construct. New applications should use THROW instead.
Note: RAISERROR syntax:
RAISERROR( { msg_id | msg_str | @local_variable }
{ ,severity ,state }
[ ,argument [ ,...n ] ] )
[ WITH option [ ,...n ] ]
The LOG option logs the error in the error log and the application log for the instance of the Microsoft SQL Server Database Engine.
References:
https://msdn.microsoft.com/en-us/library/ms178592.aspx
ストアドプロシージャのコードレビューを実行しています。 行SP03のコードは実行に失敗します(行番号は参照用としてのみ含まれています)。
エラーが発生したときにトランザクションがロールバックされるようにする必要があります。
どのTransact-SQLセグメントをSP07行に挿入しますか?
Correct Answer: D 🗳️
Explanation: Only visible for Actual4Dumps members. You can sign-up / login (it's free).
注:この質問は、同じシナリオを提示する一連の質問の一部です。 シリーズの各質問には、記載された目標を達成できる独自の解決策が含まれています。 いくつかの質問セットには1つ以上の正しい解決策があるかもしれないが、他の質問セットには正しい解決策がないかもしれない。
このセクションの質問に答えた後。 あなたはそれに戻ることができません。 その結果、これらの質問はレビュー画面に表示されません。
次のTransact-SQLステートメントを実行して、Productsという名前のテーブルを作成します:
次のストアドプロシージャがあります:
次の新しい要件を満たすストアドプロシージャを変更する必要があります:
- 製品レコードを1つの作業単位として挿入します。
- 製品がデータベースに挿入できなかった場合にエラー番号51000を返します。
- 製品レコード挿入操作が失敗した場合は、製品情報をデータベースに永続的に書き込まないでください。
解決策:次のTransact-SQLステートメントを実行します:
解決策は目標を達成していますか?
Correct Answer: B 🗳️
Over 45369+ Satisfied Customers
Actual4Dumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
If you prepare for the exams using our Actual4Dumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Actual4Dumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.