070-461 무료 덤프문제 온라인 액세스

You administer a Microsoft SQL Server 2012 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.Query the sys.dm_db_index_usage_stats DMV.
• B.Query the sys.dm_db_missing_index_details DMV.
• C.Use the Database Engine Tuning Advisor.
• D.Query the sys.dm_db_missing_index_columns DMV.

A database contains tables as shown in the exhibit. (Click the Exhibit button.) Products that are discontinued are moved from the Products table to the DiscontinuedProducts table. Any orders for discontinued products are removed from the Orders table.
You write the following SELECT statement to return all the discontinued products:
SELECT ProductId FROM DiscontinuedProducts
You need to extend the SELECT statement to include products who do not have any orders.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Exhibit

정답:

You administer a Microsoft SQL Server database named Orders. Orders is highly active OLTP system used for e-commerce.
Performance on the database has degraded over the past few months as the volume of data has increased, and now users report the application is unusable.

You need to identify the cause of the performance problem.
Which Transact-SQL statement should you run?

• A.SET STATISTICS IO ON
• B.SET STATISTICS TIME ON
• C.DBCC CHECKCONTRAINTS
• D.SET FORCEPLAN ON

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 previous year.
Which Transact-SQL query should you use?

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

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

You need to create a query that calculates the total sales of each OrderId from the Sales.Details table. The solution must meet the following requirements:
* Use one-part names to reference columns.
* Sort the order of the results from OrderId.
* NOT depend on the default schema of a user.
* Use an alias of TotalSales for the calculated ExtendedAmount.
* Display only the OrderId column and the calculated TotalSales column.
Which code segment should you use?
To answer, type the correct code in the answer area.

• A.SELECT OrderID, SUM(ExtendedAmount) AS TotalSales
  FROM Sales.Details
  ORDER BY OrderID
• B.SELECT OrderID, SUM(ExtendedAmount) AS TotalSales
  FROM Sales.Details
  GROUP BY OrderID
  ORDER BY OrderID