You maintain a SQL Server database that is used by a retailer to track sales and salespeople. The database includes two tables and two triggers that is defined by the following Transact-SQL statements:

During days with a large sales volume, some new sales transaction fail and report the following error: Arithmetic overflow error converting expression to data type int.
You need to ensure that the two triggers are applied once per sale, and that they do not interfere with each other.
How should you complete the relevant Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct location or locations. Each Transact-SQL segment 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.

You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up telephone numbers for these companies.
The view has the following definition:

You need to ensure that users can update only the phone numbers by using this view.
What should you do?

• A. Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index on the view.
• B. Create an INSTEAD OF UPDATE trigger on the view.
• C. Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
• D. Create an AFTER UPDATE trigger on the view.

You use Microsoft SQL Server to develop a database application.
Your application sends data to a VARCHAR(50) variable named @var.
You need to write a Transact-SQL statement that will return information on a successful or unsuccessful cast to an integer in a table.
Which Transact-SQL statement should you run?

• A. Option B
• B. Option D
• C. Option C
• D. Option A

You are developer for a Microsoft Azure SQL Database instance.
You are creating a new stored procedure. The procedure must perform the following tasks in this order:
* 1. Update a table named OrderHistory.
* 2. Delete rows from a table named Orders.
* 3. Delete rows from a table named Customers.
* 4. Insert rows into a table named ProcessHistory.
You need to ensure that the procedure meets the following requirements:
* If either DELETE operation fails, the rest of operation must continue.
* If either the UPDATE operation or the INSERT operation fails, the whole procedure should fail and no changes should be retained.
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.

You are a database developer for an application hosted on a Microsoft SQL Server 2012 server.
The database contains two tables that have the following definitions:

Global customers place orders from several countries.
You need to view the country from which each customer has placed the most orders.
Which Transact-SQL query do you use?

• A. SELECT CustomerID, CustomerName, ShippingCountry
  FROM
  (SELECT c.CustomerID, c.CustomerName,
  o. ShippingCountry,
  RANK() OVER (PARTITION BY c. CustomerID
  ORDER BY o. OrderAmount DESC) AS Rnk
  FROM Customer c
  INNER JOIN Orders o
  ON c.CustomerID = o.CustomerID
  GROUP BY c.CustomerID, c.CustomerName,
  o.ShippingCountry) cs
  WHERE Rnk = 1
• B. SELECT CustomerID, CustomerName, ShippingCountry
  FROM
  (SELECT c.CustomerID, c.CustomerName, o.ShippingCountry,
  RANK() OVER (PARTITION BY c.CustomerID
  ORDER BY COUNT(o.OrderAmount) ASC) AS Rnk
  FROM Customer c
  INNER JOIN Orders o
  ON c.CustomerID = o.CustomerID
  GROUP BY c.CustomerID, c.CustomerName,
  o.ShippingCountry) cs
  WHERE Rnk = 1
• C. SELECT c.CustomerID, c.CustomerName, o.ShippingCountry
  FROM Customer c
  INNER JOIN
  (SELECT CustomerID, ShippingCountry,
  COUNT(OrderAmount) AS OrderAmount
  FROM Orders
  GROUP BY CustomerID, ShippingCountry) AS o
  ON c.CustomerID = o.CustomerID
  ORDER BY OrderAmount DESC
• D. SELECT c.CustomerID, c.CustomerName, o.ShippingCountry
  FROM Customer c
  INNER JOIN
  (SELECT CustomerID, ShippingCountry,
  RANK() OVER (PARTITION BY CustomerID
  ORDER BY COUNT(OrderAmount) DESC) AS Rnk
  FROM Orders
  GROUP BY CustomerID, ShippingCountry) AS o
  ON c.CustomerID = o.CustomerID
  Where o.Rnk = 1