READ Free Dumps For Microsoft- 70-462
| Question ID 18837 | You administer a Microsoft SQL Server 2012 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?
|
| Option A | Run the New SQL Server stand-alone installation Wizard on Node C.
|
| Option B | Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
|
| Option C | Use Node B to install SQL Server on Node C.
|
| Option D | Use Node A to install SQL Server on Node C.
|
| Correct Answer | B |
Explanation Explanation: http://technet.microsoft.com/en-us/library/ms191545.aspx To add a node to an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node. The Installation Wizard will launch the SQL Server Installation Center. To add a node to an existing failover cluster instance, click Installation in the left-hand pane. Then, select Add node to a SQL Server failover cluster.
| Question ID 18838 | You are migrating a database named Orders to a new server that runs Microsoft SQL
Server 2012.
You attempt to add the [Corpnet\User1] login to the database. However, you receive the
following error message:
"User already exists in current database."
You need to configure the [Corpnet\User1] login to be able to access the Orders database
and retain the original permissions. You need to achieve this goal by using the minimum
required permissions.
Which Transact-SQL statement should you use?
|
| Option A | DROP USER [User1]; CREATE USER [Corpnet\User1] FOR LOGIN [Corpnet\User1]; ALTER ROLE [db_owner] ADD MEM3ER [Corpnet\User1];
|
| Option B | ALTER SERVER RCLS Isysadmin] ADD MEMBER [Corpnet\User1];
|
| Option C | ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];
|
| Option D | ALTER ROLE [db owner] ADD MEMBBR [Corpnet\User1];
|
| Correct Answer | C |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms176060.aspx Topic 2, Volume B