Try Microsoft : 070-457 practice torrent pass for sure

You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database. You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal. What should you do?

• A. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
• B. Perform a point-in-time restore.
• C. Restore the latest full backup. Then, restore the latest differential backup.
• D. Perform a page restore.
• E. Perform a partial restore.
• F. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
• G. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
• H. Restore the latest full backup.

You have a database that contains the tables as shown in the exhibit. (Click the Exhibit button.)

You have the following query:

You need to recreate the query to meet the following requirements:
Reference columns by using one-part names only.
Sort aggregates by SalesTerritoryID, and then by ProductID.
Order the results in descending order from SalesTerritoryID to ProductID.
The solution must use the existing SELECT clause and FROM clause.
Which code segment should you use?
To answer, type the correct code in the answer area.

• A. SELECT SalesTerritoryID, ProductID, AVG(UnitPrice), MAX(OrderQty), MAX(DiscountAmount) FROM Sales.Details GROUP BY SalesTerritoryID,ProductID ORDER BY SalesTerritoryID DESC, ProductID DESC
• B. SELECT SalesTerritoryID,
  ProductID,
  AVG(UnitPrice),
  MAX(OrderQty),
  MAX(DiscountAmount)
  FROM Sales.Details
  ORDER BY SalesTerritoryID DESC, ProductID DESC

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. Which configuration should you use?

• A. * Two servers configured in the same data center * A primary server configured to perform log-shipping every 10 minutes * A backup server configured as a warm standby
• B. * Two servers configured in different data centers * SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
• C. * SQL Server that includes an application database configured to perform snapshot replication
• D. * Two servers configured in the same data center * SQL Server Availability Group configured in Asynchronous-Commit Availability Mode * One server configured as an Active Secondary
• E. * Two servers configured in different data centers * SQL Server Availability Group configured in Synchronous-Commit Availability Mode * One server configured as an Active Secondary
• F. * Two servers configured on the same subnet * SQL Server Availability Group configured in Synchronous-Commit Availability Mode
• G. * SQL Server that includes an application database configured to perform transactional replication
• H. * Two servers configured in a Windows Failover Cluster in the same data center * SQL Server configured as a clustered instance

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, LAG(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,
  LEAD(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 develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistoncal. You write the following Transact-SQL query:
INSERT INTO OrdersHistorical SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement. Which table hint should you use?

• A. ROWLOCK
• B. XLOCK
• C. HOLDLOCK
• D. UPDLOCK
• E. TABLOCK