70-461最も有効な質問と解答で勉強

試験内容は2026年も随時見直されており、古い教材のままでは出題傾向とのずれが生じてしまいます。Tech4Examの70-461練習問題は購入後365日間無料で更新されるため、Microsoft Querying Microsoft SQL Server 2012/2014の最新の出題内容に沿って学習を続けられます。

Microsoft 70-461 試験概要:

Microsoft 70-461 試験シラバストピック:

Microsoft Querying Microsoft SQL Server 2012/2014に関するよくあるご質問

Microsoft Querying Microsoft SQL Server 2012/2014 認定 70-461 試験問題：

問題 #1

You have a business reporting database.
Several power users generate reports from the database.
You need to create an object in the database to meet the following requirements:
* Provide the power users with the ability to use simple queries.
* Prevent schema changes on objects related to the query.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within code that has been provided as well as below it
.


Use the 'Check Syntax' button to verify your work. Any syntax or spelling errors will be reported by line and character position.

A. 1 Create View Customer_Orders WITH SCHEMABINDING AS SELECT CustomerName,
2 OrderDate FROM Customers INNER JOIN Orders on
3 Customers.CustomerID=Orders.CustomerID
To Line 1, after WITH, add SCHEMABINDING
When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition.
B. 1 Create View Customer_Orders WITH SCHEMABINDING AS SELECT CustomerName,
2 OrderDate FROM Customers INNER JOIN Orders on
3 Customers.CustomerID=Orders.CustomerID
To Line 1, after WITH, add SCHEMABINDING
SCHEMABINDING binds the view to the schema of the underlying table or tables. When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition.

問題 #2

A database named AdventureWorks contains two tables named Production.Product and Sales.SalesOrderDetail. The tables contain data on the available products and a detailed order history.
The Production.Product table contains the following two columns:
The Sales.SalesOrderDetail table contains the following three columns:
You need to create a query listing all of the products that were never ordered.
Which statements should you execute?

A. Option B
B. Option D
C. Option C
D. Option A

問題 #3

You develop a database for a travel application. You need to design tables and other database objects.
You need to store media files in several tables.
Each media file is less than 1 MB in size. The media files will require fast access and will be retrieved frequently.
What should you do?

A. Use the CAST function.
B. Use the DATETIME2 data type.
C. Use a user-defined table type.
D. Use the VARBINARY data type.
E. Use the DATETIME data type.
F. Use an appropriate collation.
G. Use the DATE data type.
H. Use the FORMAT function.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

問題 #4

You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?

A. Set the Remote Connection Timeout on the Publisher to 0.
B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
C. Set the Merge agent on the problem subscribers to use the slow link agent profile.
D. Change the Merge agent on the problem subscribers to run continuously.

問題 #5

You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)


Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table.
You need to assign the appropriate constraints and table properties to ensure data integrity and visibility.
On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?

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

解説：