70-462 Administering Microsoft SQL Server 2012/2014 Databases

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Volume B)

Which of the following is a valid upgrade path for SQL Server 2012?

Select an option, then click Submit answer.

  • SQL Server 2000 -> SQL Server 2012

  • SQL Server 2000 -> SQL Server 2005 -> SQL Server 2012

  • SQL Server 7 -> SQL Server 2012

  • Oracle 11g -> SQL Server 2012

Question 14 (Volume B)

You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA.

Currently, Server01/HA is the primary replica.

You need to ensure that the following requirements are met:

Backup operations occur on Server03/HA.

If Server03/HA is unavailable, backup operations occur on Server02/HA. Backup operations do not occur on Server01/HA.

How should you configure HaContoso?

Select an option, then click Submit answer.

  • Set the backup preference of HaContoso to Prefer Secondary.
    Set the backup priority of Server02/HA to 20.
    Set the backup priority of Server03/HA to 10.

  • Set the backup preference of HaContoso to Secondary only.
    Set the backup priority of Server02/HA to 20.
    Set the backup priority of Server03/HA to 10.

  • Set the backup preference of HaContoso to Secondary only.
    Set the backup priority of Server02/HA to 10.
    Set the backup priority of Server03/HA to 20.

  • Set the exclude replica of Server01/HA to true. Set the backup priority of Server02/HA to 10.
    Set the backup priority of Server03/HA to 20.

Question 15 (Volume B)

You administer a Microsoft SQL Server failover cluster that contains two nodes named Node A and Node

B. A single instance of SQL Server is installed on the cluster.

An additional node named Node C has been added to the existing cluster.

You need to ensure that the SQL Server instance can use all nodes of the cluster.

What should you do?

Select an option, then click Submit answer.

  • Use Node A to install SQL Server on Node C.

  • A single instance of SQL Server is installed on the cluster.
    An additional node named Node C has been added to the existing cluster.
    You need to ensure that the SQL Server instance can use all nodes of the cluster.
    What should you do?
    Use Cluster Administrator to add a new Resource Group to Node B.

  • Use Node В to install SQL Server on Node C.

  • Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node C.

  • Use Node В to install SQL Server on Node C.

  • Build a new cluster, shut down the current instance, and then migrate to the new cluster.

  • Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.