Microsoft SQL Server 2012 70-461日本語

Not sure a study set is what you need? Download the free 70-461日本語 demo from Getcertkey and review a sample of the Microsoft Querying Microsoft SQL Server 2012/2014 (70-461日本語版) practice questions before you spend anything — the 2026 edition is ready to try today.

Microsoft 70-461日本語 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Querying Microsoft SQL Server 2012/2014
Exam Number:	70-461
Exam Duration:	120 minutes
Real Exam Qty:	40-60
Certificate Validity Period:	Certification retired; originally valid while MCSA: SQL Server 2012/2014 program remained active
Passing Score:	700/1000
Exam Price:	USD 165
Exam Format:	Build List, Case Study, Active Screen, Multiple Choice, Multiple Response, Drag and Drop
Available Languages:	French, English, Portuguese (Brazil), German, Chinese (Simplified), Japanese
Related Certifications:	MCSA: SQL Server 2012/2014
Sample Questions:
Exam Way:	Delivered through Pearson VUE testing centers and online proctored delivery (when available during exam lifecycle).
Pre Condition:	No formal prerequisite exam. Exam counted toward MCSA: SQL Server 2012/2014 certification path together with exams 70-462 and 70-463.
Official Syllabus URL:	https://learn.microsoft.com/en-us/credentials/certifications/exams/70-461/

Microsoft 70-461日本語 Exam Syllabus Topics:

70-461日本語 Exam FAQs for 2026 Candidates

Which certification does the 70-461日本語 exam lead to?

The 70-461日本語 exam is the official Microsoft exam behind the Microsoft SQL Server 2012 certification, validating the skills measured by the Microsoft Querying Microsoft SQL Server 2012/2014 (70-461日本語版) credential. It sits at the Associate level of the Microsoft certification program. It also connects to MCSA: SQL Server 2012/2014, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 70-461日本語 exam, and how much time do I get?

The 70-461日本語 exam contains 40-60 questions to be completed within 120 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 70-461日本語 exam, and what does it cost?

The passing score for the 70-461日本語 exam is 700/1000, and the official registration fee is USD 165. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 252 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 70-461日本語 exam?

No formal prerequisite exam. Exam counted toward MCSA: SQL Server 2012/2014 certification path together with exams 70-462 and 70-463. Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the 70-461日本語 practice questions before I buy?

Yes. Getcertkey provides a free 70-461日本語 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 70-461日本語 exam, and how is my order delivered?

Every Microsoft Querying Microsoft SQL Server 2012/2014 (70-461日本語版) purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 70-461日本語 exam?

The Microsoft Querying Microsoft SQL Server 2012/2014 (70-461日本語版) exam blueprint is organized into 4 domains. The first three are:

• Troubleshoot and Optimize — 24-29% of the exam
• Work with Data — 24-29% of the exam
• Modify Data — 23-28% of the exam

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Microsoft Querying Microsoft SQL Server 2012/2014 (70-461日本語版) Sample Questions:

Question 1

あなたは、Microsoft SQL Server 2012のデータベースを管理します。データベースには、Employeeという名前のテーブルが含まれています。Employeeテーブルの一部は、展示に示されています。（Exhibitボタンをクリックしてください。）


従業員に関する機密情報はEmployeeDataという別のテーブルに格納されます。1つのレコードは従業員テーブルの各レコードのEmployeeDataに存在します。あなたは、データの整合性と視認性を確保するために適切な制約やテーブルのプロパティを割り当てる必要があります。 On which column in the Employee table should you create a unique constraint?

A. EmployeeNum
B. FirstName
C. LastName
D. DateHired
E. EmployeeID
F. MiddleName
G. JobTitle
H. ReportsToID
I. DepartmentID

Question 2

uv_CustomerFullNamesという名前のビューを作成する必要があります。ビューは、顧客テーブルの基本構造が変更されないようにする必要があります。
正しいT-SQLステートメントの一部が回答エリアに提供されています。完全なコードを提供します。

A. CREATE VIEW sales.uv_CustomerFullNames
スケマビンディングあり
選択として
ファーストネーム、
FROM Sales.Customers
B. CREATE VIEW sales.uv_CustomerFullNames
スケマビンディングあり
選択として
ファーストネーム、
苗字
FROM Sales.Customers

Question 3

あなたは、あなたは、学生の年半ば成績を記録するためにStudentCode、SubjectCodeおよび成績カラムを持っているテーブルを作成します。 テーブルには様々な主題のために50の学生によって得られたマークがあります。あなたは、次の要件が満たされていることを確認する必要があります。
* 学生は彼らの平均点に基づいて評価されていなければなりません。
* 一人以上の学生が同じ平均点を持っている場合、同じランクはこれらの学生に与えられなければなりません。
* 同じランクが割り当てられる場合、連続するランクがスキップされなければなりません。
どのTransact-SQLクエリを使うべきでしょうか。

A. SELECT StudentCode as Code,
RANK() OVER(ORDER BY AVG (Marks) DESC) AS Value
FROM StudentMarks
GROUP BY StudentCode
B. SELECT StudentCode AS Code,Marks AS Value FROM (
SELECT StudentCode, Marks AS Marks,
RANK() OVER(PARTITION BY SubjectCode ORDER BY Marks DESC) AS Rank
FROM StudentMarks) tmp
WHERE Rank = 1
C. SELECT StudentCode AS Code,Marks AS Value FROM (
SELECT StudentCode, Marks AS Marks,
RANK() OVER(PARTITION BY SubjectCode ORDER BY Marks ASC) AS Rank
FROM StudentMarks) tmp
WHERE Rank = 1
D. SELECT StudentCode as Code,
DENSE_RANK() OVER(ORDER BY AVG (Marks) DESC) AS Value
FROM StudentMarks
GROUP BY StudentCode
E. SELECT StudentCode as Code,
NTILE(2) OVER(ORDER BY AVG (Marks) DESC) AS Value
FROM StudentMarks
GROUP BY StudentCode
F. SELECT StudentCode AS Code,Marks AS Value FROM (
SELECT StudentCode, Marks AS Marks,
RANK() OVER(PARTITION BY StudentCode ORDER BY Marks ASC) AS Rank
FROM StudentMarks) tmp
WHERE Rank = 1
G. SELECT Id, Name, Marks,
DENSE_RANK() OVER(ORDER BY Marks DESC) AS Rank
FROM StudentMarks
H. SELECT StudentCode AS Code,Marks AS Value FROM (
SELECT StudentCode, Marks AS Marks,
RANXO OVER(PARTITION BY StudentCode ORDER BY Marks DESC) AS Rank
FROM StudentMarks) tmp
WHERE Rank = 1

Question 4

Productsという名前のテーブルを含むMicrosoft SQL Serverデータベースを管理します。
Discontinuedというビット列では、値1は製品が非アクティブであることを示し、値0は製品がアクティブであることを示します。
完全な製品ステータスの説明を含む列を返すビューを作成する必要があります。
どの式を使用して列を定義しますか？

A. CASE Discontinued
WHEN 0 THEN 'Active'
WHEN 1 THEN 'Inactive'
END
B. IF Discontinued = 0
'Active'
ELSE
'Inactive'
C. DECODE (Discontinued, 0, 'Active', 1, 'Inactive', 'Unknown')
D. IF(Discontinued = 0, 'Active', 'Inactive')

Question 5

展示に示されているテーブルを含むSalesという名前のデータベースがあります。 （[展示]ボタンをクリックします。）

レポートのクエリを作成する必要があります。クエリは次の要件を満たしている必要があります。
*注文した顧客の姓を返します。
*各顧客の最新の注文日を返します。
* CustomerIDで結果をグループ化します。
*結果を最新のOrderDateで並べ替えます。
*テーブル参照にはデータベース名とテーブル名を使用します。
*テーブルの列を参照するときは、テーブルの最初のイニシャルをエイリアスとして使用します。
ソリューションは、ANSI SQL-99標準をサポートする必要があり、オブジェクト識別子を使用しないでください。
正しいT-SQLステートメントの一部が回答エリアに提供されています。 SQLステートメントを完成させます。

A. SELECT o.LastName、
MAX（o.OrderData）AS MostRecentOrderData
GROUP BY o.CustomerID
ORDER BY o.OrderDate DESC
B. SELECT o.LastName、
MAX（o.OrderData）AS MostRecentOrderData
FROM Sales.Orders AS o
GROUP BY o.CustomerID
ORDER BY o.OrderDate DESC

Solutions: