70-469 試験問題を無料オンラインアクセス

You have a database named DB1.
You plan to create a stored procedure that will insert rows into three different tables. Each
insert must use the same identifying value for each table, but the value must increase from
one invocation of the stored procedure to the next.
Occasionally, the identifying value must be reset to its initial value.
You need to design a mechanism to hold the identifying values for the stored procedure to
use.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Create a sequence object that holds the next value in the sequence. Retrieve the next value by using the stored procedure. Reset the value by using an ALTER SEQUENCE statement as needed.
• B.Create an identity column in each of the three tables. Use the same seed and the same increment for each table. Insert new rows into the tables by using the stored procedure. Use the DBCC CHECKIDENT command to reset the columns as needed.
• C.Create a fourth table that holds the next value in the sequence. At the end each transaction, update the value by using the stored procedure. Reset the value as needed by using an UPDATE statement.
• D.Create a sequence object that holds the next value in the sequence. Retrieve the next value by using the stored procedure. Increment the sequence object to the next value by using an ALTER SEQUENCE statement. Reset the value as needed by using a different ALTER SEQUENCE statement.

You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?

• A.Extended Events
• B.Database Engine Tuning Advisor
• C.Performance Monitor
• D.Data Profile Viewer

You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on a backup server in the company's data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
• B.Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
• C.Put the differential backup on tape and send it to the third-party backup storage system.
• D.Set up SQL Server Always On with a SQL Azure database as a replica.

You need to implement a solution that solves the performance issues of
usp_GetOrdersAndItems.
Which statements should you execute?

• A.CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate) INCLUDE( Amount)
• B.CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate, Amount) WHERE ShipDate IS NULL
• C.CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate, Amount)
• D.CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate) INCLUDE(Amount) WHERE ShipDate IS NULL

You are evaluating the index design.
You need to recommend a change to Indexes.sql that will minimize the amount of time it takes for usp_AttendeesReport to execute. The solution must minimize the amount of database fragmentation.
Which line of code should you use to replace line 12 of Indexes.sql?

• A.(LastName, FirstName);
• B.(FirstName) INCLUDE (LastName);
• C.(LastName);
• D.(LastName) INCLUDE (FirstName);