Free Microsoft 070-462 Exam Dumps Questions & Answers

Which of the following is the default file extension for an SQL Server 2012 backup file?

• A..rman
• B..db
• C..bak
• D..bac

You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)

You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format.

Which Transact-SQL query should you use?

• A.SELECT Name, Country, Crderld, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId =FOR XML AUTO, ELEMENTS
• B.SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, AmountFROM OrdersINNER JOIN Customers ON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML PATH ('Customers')
• C.SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN Customers ON Orders.CustomerId = Customers-CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW
• D.SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML AUTO, ELEMENTS
• E.SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML AUTO
• F.SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW, ELEMENTS
• G.SELECT Name, Country, Orderld, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML AUTO, ELEMENTS
• H.SELECT Name AS 'Customers/Name', Country AS 'Customers/Country', OrderId,OrderDate, AmountFROM OrdersINNER JOIN Customers ON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML PATH ('Customers')

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases are hosted on a SAN (Storage Area Network).
You need to design a database solution for a new application.
You are tasked with designing a high-availability database solution.
The solution must include a single copy of the database to save disk space and the database must remain online in the event of a SQL Server failure. What should you include in your solution?

• A.You should include two servers and log shipping.
• B.You should include two servers configured as a failover cluster.
• C.You should include two servers configure as a SQL Server Availability Group
• D.You should include two servers and database mirroring.

You plan to install Microsoft SQL Server 2012 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?

• A.Standard Edition
• B.Express Edition with Advanced Services
• C.Web Edition
• D.Express Edition with Tools

You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3.
You have permissions on both Database1 and Database2.
You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in Database3.
dbo.usp_InsertEvent must execute other stored procedures in the other databases.
You need to ensure that callers that do not have permissions on Database1 or Database2 can execute the stored procedure.
Which Transact-SQL statement should you use?

• A.EXECUTE AS CALLER
• B.EXECUTE AS OWNER
• C.USE Database2
• D.USE Database1