070-462試験無料問題集（305題）「Microsoft Administering Microsoft SQL Server 2012/2014 Databases 認定」

出題：1

You administer a Microsoft SQL Server database.
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
* Data import is performed by using a stored procedure.
* Data is loaded as a unit and is minimally logged.
Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Each data import command or recovery model 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.)

正解：

Explanation

出題：2

You are creating a SQL Server Master Data Services (MDS) model for a company.
The source data for the company is stored in a single table that contains the manager-to-subordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?

A. Parent

B. Natural

C. Recursive

D. Explicit

正解：C 解答を投票する

出題：3

You develop a Microsoft SQL Server 2012 database that contains tables named Employee and Person. The tables have the following definitions:

You create a view named VwEmployee as shown in the following Transact-SQL statement.

Users are able to use single INSERT statements or INSERT...SELECT statements into this view. You need to ensure that users are able to use a single statement to insert records into both Employee and Person tables by using the VwEmployee view.
Which Transact-SQL statement should you use?

A. CREATE TRIGGER TrgVwEmployeeON VwEmployeeFOR INSERTASBEGININSERT INTO Person(Id, FirstName, LastName)SELECT Id, FirstName, LastName, FROM insertedINSERT INTO Employee(PersonId, EmployeeNumber)SELECT Id, EmployeeNumber FROM insertedEND

B. CREATE TRIGGER TrgVwEmployeeON VwEmployeeINSTEAD OF INSERTASBEGININSERT INTO Person(Id, FirstName, LastName)SELECT Id, FirstName, LastName, FROM insertedINSERT INTO Employee(PersonId, EmployeeNumber)SELECT Id, EmployeeNumber FROM insertedEND

C. CREATE TRIGGER TrgVwEmployeeON VwEmployeeINSTEAD OF INSERTASBEGININSERT INTO Person(Id, FirstName, LastName)SELECT Id, FirstName, LastName FROM VwEmployeeINSERT INTO Employee(PersonID, EmployeeNumber)SELECT Id, EmployeeNumber FROM VwEmployeeEND

D. CREATE TRIGGER TrgVwEmployeeON VwEmployeeINSTEAD OF INSERTASBEGINDECLARE
@ID INT, @FirstName NVARCHAR(25),@LastName NVARCHAR(25), @PersonID
INT,@EmployeeNumber NVARCHAR(15)SELECT @ID = ID, @FirstName = FirstName,@LastName
= LastName, @EmployeeNumber = EmployeeNumberFROM insertedINSERT INTO Person(Id, FirstName, LastName)VALUES(@ID, @FirstName, @LastName)INSERT INTO Employee(PersonID, EmployeeNumber)VALUES(@PersonID, @EmployeeNumberEND

正解：B 解答を投票する

出題：4

You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node
2.
Node 1 fails and the cluster fails over to Node 2.
You need to replace Node 1 and add it to the cluster.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

正解：

Explanation

References:

出題：5

You administer a Microsoft SQL Server failover cluster that contains two nodes named Node A and Node B.
A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.
What should you do?

A. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.

B. Use Cluster Administrator to add a new Resource Group to Node B.

C. Use Node A to install SQL Server on Node C.

D. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?

A. Recovery model to Bulk logged

B. Recovery model to Simple

C. Containment type to Partial

D. Compatibility level to 120

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which of the following SQL Server 2012 features generates numeric values at a defined interval and order?

A. sequence

B. bigint

C. number table

D. index

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

On which of the following operating systems can you deploy the 64-bit version of SQL Server 2012 Enterprise edition? (Choose all that apply.)

A. Windows Server 2008 SP2 (x64) Enterprise edition

B. Windows Server 2003 R2 (x64) Enterprise edition

C. Windows 7 Ultimate (x64) edition

D. Windows Server 2008 R2 SP1 (x64) Standard edition

正解：A,D 解答を投票する

出題：9

You have a server named SQL1 mat has SQL Server installed SQU hosts several applications. You plan to deploy a third-party application to SQU. The application must have the following:
*A vendor-provided password for the sa account
*A vendor-provided user account that is a member of the sysadmin fixed server role
*A vendor-provided user account that is a member of the db.owner fixed database role in the msdb database
*A vendor-provided user account that is a member of the db.owner fixed database role in the master database
*A vendor-provided user account that is a member of the SQLAgentOperatorRole fixed database role m the msdb Database You need to identify the minimum number of SQL Server instances that you must add to SQL1 to support the application requirements. The solution must use the principle of least privilege How many SQL Server instances should you add to SQL1?

A. 2

B. 1

C. 0

D. 3

正解：D 解答を投票する

070-462試験無料問題集「Microsoft Administering Microsoft SQL Server 2012/2014 Databases 認定」