Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 認定 70-457 試験問題:

1. You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. What should you do?

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

2. 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 TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName FROM VwEmployee
INSERT INTO Employee(PersonID, EmployeeNumber)
SELECT Id, EmployeeNumber FROM VwEmployee
End
B) CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN
DECLARE @ID INT, @FirstName NVARCHAR(25), @LastName NVARCHAR(25), @PersonID INT, @EmployeeNumber NVARCHAR(15)
SELECT @ID = ID, @FirstName = FirstName, @LastName = LastName,
@EmployeeNumber = EmployeeNumber
FROM inserted
INSERT INTO Person(Id, FirstName, LastName)
VALUES(@ID, @FirstName, @LastName)
INSERT INTO Employee(PersonID, EmployeeNumber)
VALUES(@PersonID, @EmployeeNumber
End
C) CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted
INSERT INTO Employee(PersonId, EmployeeNumber)
SELECT Id, EmployeeNumber FROM inserted
END
D) CREATE TRIGGER TrgVwEmployee ON VwEmployee FOR INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted
INSERT INTO Employee(PersonId, EmployeeNumber)
SELECT Id, EmployeeNumber FROM inserted
END

3. You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.

A) Enable Contained Databases on the Server Instance.
B) Enable FILESTREAM on the Server Instance.
C) Disable FILESTREAM on the Database.
D) Set the FILESTREAM directory name on the Database.
E) Create a non-empty FILESTREAM file group.
F) Configure the Database for Partial Containment.

4. You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/ Server01 is the primary replica. You have multiple queries that read data and produce reports from the database. You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica. What should you do?

A) Set the Availability Mode property of HA/Server01 to Asynchronous commit.
B) Set the Availability Mode property of HA/Server02 to Asynchronous commit.
C) Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
D) Set the Readable Secondary property of HA/Server02 to Read-intent only.

5. 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.)
Select and Place:

質問と回答：