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

A table named Profits stores the total profit made each year within a territory. The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits made by each territory for each year and its preceding year. Which Transact-SQL query should you use?

• A.SELECT Territory, Year, Profit,
  LEAD(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS
  NextProfit
  FROM Profits
• B.SELECT Territory, Year, Profit,
  LAG(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS
  NextProfit
  FROM Profits
• C.SELECT Territory, Year, Profit, LAG(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS
  NextProfit
  FROM Profits
• D.SELECT Territory, Year, Profit,
  LEAD(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS
  NextProfit
  FROM Profits

You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to
17:00 hours. Users modify more than 30 percent of the data in the database during the week. Backups are performed as shown in the following schedule:

The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete. The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times. When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly. You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time. What should you do on Saturday?

• A.Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at
  08:59 hours.
• B.Create a database snapshot at 08:59 hours.
• C.Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 08:59 hours.
• D.Perform a differential backup at 08:59 hours.
• E.Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at
  17:01 hours.
• F.Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 17:01 hours.

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:
No more than 5 minutes worth of transactions are lost.
Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.

• A.Create a DIFFERENTIAL database backup every 24 hours.
• B.Create a FULL database backup every 24 hours.
• C.Configure the database to use the FULL recovery model.
• D.Create a LOG backup every 5 minutes.
• E.Configure the database to use the SIMPLE recovery model.
• F.Create a DIFFERENTIAL database backup every 4 hours.

You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use?

• A.SERIALIZABLE
• B.SNAPSHOT
• C.READ COMMITTED SNAPSHOT
• D.REPEATABLE READ

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:

正解：

Explanation:
--Burgos - NO