070-462問題集、Microsoft実際の試験問題

質問 1

Which of the following is NOT a database role that you can assign users in SQL Server 2012?

A. db_databaseadmin

B. db_owner

C. db_datawriter

D. db_ddladmin

正解: A

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

質問 2

You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table.

You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID. Which Transact- SQL statement should you use?

A. CREATE TABLE Customer(SourceID int NOT NULL PRIMARY KEY CLUSTERED,CustomerID int NOT NULL UNIQUE,CustomerName varchar(255) NOT NULL);

B. CREATE TABLE Customer(SourceID int NOT NULL,CustomerID int NOT NULL PRIMARY KEY CLUSTERED,CustomerName varchar(255) NOT NULL);

C. CREATE TABLE Customer(SourceID int NOT NULL,CustomerID int NOT NULL,CustomerName varchar(255) NOT NULL,CONSTRAINT PK_Customer PRIMARY KEY CLUSTERED(SourceID, CustomerID));

D. CREATE TABLE Customer(SourceID int NOT NULL IDENTITY,CustomerID int NOT NULL IDENTITY,CustomerName varchar(255) NOT NULL);

正解: C

質問 3

You administer a Microsoft SQL Server server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables.
You need to configure the SQL Server environment to support these packages.
What should you do?

A. Install Data Quality Services.

B. Install Master Data services.

C. Create an Integration Services catalog.

D. Create SSIS configuration files for the packages.

正解: C

質問 4

You are a database administrator for a Microsoft SQL Server environment.
You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.
You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.
Which feature should you use?

A. peer-to-peer replication

B. database audits

C. snapshot replication

D. failover clustering

正解: A

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

質問 5

You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?

A. DBCC INPUTBUFFER (60)

B. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60

C. SELECT * FROM sys.dm_exec_requests WHERE session_id = 60

D. DBCC OPENTRAN

正解: C

質問 6

You plan to install Microsoft SQL Server 2012 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?

A. Standard Edition

B. Express Edition with Advanced Services

C. Web Edition

D. Express Edition with Tools

正解: A

質問 7

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. Use Cluster Administrator to add a new Resource Group to Node B.

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

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 C.

正解: D

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

質問 8

Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?

A. Bitmap Index

B. Columnstore Index

C. Clustered Index

D. Function-based Index

正解: D

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

質問 9

You administer a Microsoft SQL Server database server.
A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct issue or issues in the answer area. Each tool 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

質問 10

You administer a Microsoft SQL Server database named Contoso on a server named Server01.
You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact to the server.
What should you create?

A. A Database Audit Specification

B. A Policy

C. A SQL Profiler Trace

D. A Server Audit Specification

E. An Alert

F. A Resource Pool

G. An Extended Event session

正解: G

質問 11

You have an index called Employee_IDX on the table Employees. Which of the following will rebuild this index online?

A. ALTER INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);

B. CREATE INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);

C. ALTER INDEX REBUILD ONLINE Employee_IDX;

D. REBUILD ONLINE INDEX Employee_IDX ON Employees;

正解: A

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

質問 12

You administer a Microsoft SQL Server server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

A. Use the Database Engine Tuning Advisor.

B. Query the sys.dm_db_index_usage_stats DMV.

C. Query the sys.dm_db_missing_index_columns DMV.

D. Query the sys.dm_db_missing_index_details DMV.

正解: A

質問 13

A network administrator creates a virtual machine from a template that has SQL Server installed.
You need to ensure that you can create SQL Server databases on the new virtual machine.
Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution.

A. Execute the SP_ADDSERVER statement.

B. Run setup.exe and specify the upgrade option.

C. Execute the SP_SERVER_DIAGNOSTICS statement.

D. Edit the Instance Names registry key.

E. Execute the SP_DROPSERVER statement.

正解: A,E

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

Microsoft Administering Microsoft SQL Server 2012/2014 Databases - 070-462 模擬練習