Free Microsoft 070-457 Exam Dumps Questions & Answers

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?

• A.Use the DATETIME2 data type.
• B.Use the TODATETIMEOFFSET function.
• C.Use the DATETIMEOFFSET data type.
• D.Use the VARBINARY data type.
• E.Use the CAST function.
• F.Use the DATE data type.
• G.Use the DATETIME data type.
• H.Use the FORMAT function.
• I.Use an appropriate collation.
• J.Use a user-defined table type.

DRAG AND DROP You administer a Microsoft SQL Server 2012 server. A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue. Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct issue or issues in the answer area. Each tool 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.)
Select and Place:

Correct Answer:

Explanation:
--Burgos - NO

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?

• A.Alerts and operators in SQL Server Agent
• B.SQL Mail
• C.Policies under Policy-Based Management
• D.An Extended Events session

Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number of global sales and total sales amounts. You need to ensure that your query executes in the minimum possible time. Which query should you use?

• A.SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
  FROM (
  SELECT SalesOrderId, SalesAmount
  FROM DomesticSalesOrders
  UNION ALL
  SELECT SalesOrderId, SalesAmount
  FROM InternationalSalesOrders
  ) AS p
• B.SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
  FROM (
  SELECT SalesOrderId, SalesAmount
  FROM DomesticSalesOrders
  UNION
  SELECT SalesOrderId, SalesAmount
  FROM InternationalSalesOrders
  ) AS p
• C.SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrders UNION ALL SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM InternationalSalesOrders
• D.SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrders UNION SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM InternationalSalesOrders

You have an XML schema collection named Sales.InvoiceSchema. You need to declare a variable of the
XML type named XML1. The solution must ensure that XML1 is validated by using Sales.InvoiceSchema.
Which code segment should you use?
To answer, type the correct code in the answer area.

• A.Declare @XML1=XML(Sales.InvoiceSchema)
• B.DECLARE @XML1 XML @XML1 = Sales.InvoiceSchema CREATE XML SCHEMA COLLECTION XML1 AS @XML1