You have a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application.
The add-on must meet the following requirements:
* Allow case sensitive searches for product.
* Filter search results based on exact text in the description.
* Support multibyte Unicode characters.
You run the following Transact-SQL statement:

Users connect to an instance of the bug tracking application that is hosted in New York City. Users in Seattle must be able to display the local date and time for any bugs that they create.
You need to ensure that the DateCreated column displays correctly.
Which Transact-SQL statement should you run?

• A. SELECT Id,Product,
  TODATETIMEOFFSET(DateCreated, -8)
  FROM Bug
• B. SELECT Id,Product,
  DateCreated AT TIME ZONE 'Pacific Standard Time'
  FROM Bug
• C. SELECT Id,Product,
  DATEADD(hh, -8, DateCreated)
  FROM Bug
• D. SELECT Id,Product,
  CAST(DateCreated AS DATETIMEOFFSET)
  FROM Bug

You are building a stored procedure named sp1 that calls a stored procedure named SP2.
SP2 calls another stored procedure named SP3 that returns a Recordset. The Recordset is stored in a temporary table.
You need to ensure that SP2 returns a text value to sp1.
What should you do?

• A. Add the text value to an output parameter of SP2.
• B. Return the text value by using the Retumvaiue when sp2 is called.
• C. Create a table variable in SP2, and then insert the text value into the table.
• D. Create a temporary table in sp2, and then insert the text value into the table.

You have a database named DB1 that contains a table named HR.Employees. HR.Employees contains two columns named ManagerID and EmployeeID. ManagerID refers to EmployeeID.
You need to create a query that returns a list of all employees, the manager of each employee, and the numerical level of each employee in your organization's hierarchy.
Which five statements should you add to the query in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You are developing a database to track customer orders. The database contains the following tables:
Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.

The following table describes the columns in Sales.Orders.

You need to design an indexed view to return customer information.
What are the requirements for creating an indexed view? Use the drop-down menus to select the answer choice that completes each statement.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You create a table by running the following Transact-SQL statement:

You need to return normalized data for all customers that were added in the year 2014.
Which Transact-SQL statement should you run?

• A. Option E
• B. Option F
• C. Option H
• D. Option A
• E. Option D
• F. Option G
• G. Option C
• H. Option B