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

You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?

• A.Scalar user-defined function
• B.Table-valued user-defined function
• C.Inline user-defined function
• D.Stored procedure

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

You need to create a query for a report. The query must meet the following requirements:
NOT use object delimiters.
Return the most recent orders first.
Use the first initial of the table as an alias.
Return the most recent order date for each customer.
Retrieve the last name of the person who placed the order.
Return the order date in a column named MostRecentOrderDate that appears as the last column in the report.
The solution must support the ANSI SQL-99 standard.
Which code segment should you use?
To answer, type the correct code in the answer area.

• A.SELECT c.CustomerID --optional c.LastName, max(o.OrderDate) 'MostRecentOrderDate' FROM Customer c LEFT OUTER JOIN Orders o ON o.CustomerID = c.CustomerID GROUP BY c.CustomerID, c.LastName ORDER BY 3 DESC
• B.SELECT LastName, O.OrderDate AS MostRecentOrderDate FROM Customers AS C INNER JOIN Orders AS O ON CustomerID = O.CustomerID ORDER BY O.OrderDate DESC
• C.select C.Lastname, P.MostRecentOrderDate from customers AS C inner join ( select customID, MostRecentOrderDate=max(orderDate) from orders group by customID
  )P
  on C.customerID=P.CustomerID
  order by P.MostRecentOrderDate desc

You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?

• A.Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode
• B.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
• C.SQL Server that includes an application database configured to perform transactional 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 a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
• F.Two servers configured in different data centers SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
• G.SQL Server that includes an application database configured to perform snapshot replication
• H.Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode
  One server configured as an Active Secondary

You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back. Which Transact-SQL statement should you include at the beginning of the stored procedure?

• A.SET XACT_ABORT OFF
• B.SET ARITHABORT ON
• C.SET ARITHABORT OFF
• D.BEGIN
• E.SET XACT_ABORT ON
• F.TRY

You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01. You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring. You need to prepare the Contoso database for database mirroring. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:

正解：

Explanation:
--Burgos - YES