Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 321:

  Which of the following is a high availability feature with SQL Server 2012?

  A. Clustering
  B. AlwaysOn
  C. Log Shipping
  D. Active-Active
  B. AlwaysOn

  ---

  References: https://msdn.microsoft.com/en-us/library/ms190202%28v=sql.110%29.aspx

• Question 322:

  DRAG DROP

  You have a SQL server database server that contains a database named CustomerDB. CustomerDB is protected by using transparent data encryption (TDE) and a certificate named TDE_cert.

  The Server fails.

  You deploy a new server and restore all of the backups to a folder named C:/backups.

  You need to restire the database to the new server.

  Which Statements should you execure in sequence?

  Select and Place:

  

  

• Question 323:

  You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive that contains tempdb fails.

  You need to be able to start the SQL Server.

  What should you do?

  A. Modify tempdb location in startup parameters.
  B. Start SQL Server in minimal configuration mode.
  C. Start SQL Server in single-user mode.
  D. Configure SQL Server to bypass Windows application logging.
  B. Start SQL Server in minimal configuration mode.

  ---

  References: http://msdn.microsoft.com/en-us/library/ms186400.aspx http://msdn.microsoft.com/en-us/library/ms345408.aspx

• Question 324:

  You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from an existing server to the new server.

  You want to evaluate the new server's performance based on the workloads of the existing server.

  To do so, you need to run the workloads captured from the existing server against the new server from multiple computers.

  Which SQL Server tool should you use?

  A. Distributed Replay
  B. Data Tools
  C. Migration Assistant
  D. Upgrade Advisor
  A. Distributed Replay

  ---

  With Distributed Replay, you can replay a workload from multiple computers and better simulate a mission-critical workload. References: https://technet.microsoft.com/en-us/library/ff878183(v=sql.110).aspx