Free Microsoft 70-462 Exam Dumps Questions & Answers

You administer a Microsoft SQL Server database.
The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
* The first row of the file contains the first row of data.
* Each record is of the same length.
* The date follows the U.S. date format.
* The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Correct Answer:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx

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 c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY COUNT(OrderAmount) DESC) AS RnkFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDWHERE o.Rnk = 1
• B.  SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM(SELECT c.CustomerID, c.CustomerName, o.ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY COUNT(o.OrderAmount) ASC) AS RnkFROM Customer cINNER JOIN Orders oON c.CustomerID = o.CustomerIDGROUP BY c.CustomerID, c.CustomerName, o.ShippingCountry) csWHERE Rnk = 1
• C.  SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY OrderAmount DESC) AS RnkFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDWHERE o.Rnk = 1
• D.  SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,COUNT(OrderAmount) DESC) AS OrderAmountFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDORDER BY OrderAmount DESC

You administer a Microsoft SQL Server database server.
When errors that have severity level of 18 or higher occur, 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.  An Extended Events session
• C.  Policies under Policy-Based Management
• D.  SQL Mail

You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition.
You need to improve the performance of the view by persisting data to disk.
What should you do?

• A.  Create a clustered index on the view.
• B.  Create an AFTER trigger on the view.
• C.  Create an INSTEAD OF trigger on the view.
• D.  Modify the view to use the WITH VIEW_METADATA clause.

Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:

At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database.
You need to ensure that the transactional database is restored.
You also need to ensure that data loss is minimal.
What should you do?

• A.  Perform a point-in-time restore.
• B.  Perform a partial restore.
• C.  Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
• D.  Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
• E.  Restore the latest full backup. Then, restore the latest differential backup.
• F.  Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
• G.  Perform a page restore.
• H.  Restore the latest full backup.