Microsoft-Administering Microsoft SQL Server 2012 Databases Set 5

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?

You administer a database that has User A, B and C. User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data. User C must be able to provide windows logins to the database To which role or roles should you add to UserB? Select all that apply.

You administer a database that has User A, B and C. User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data. User C must be able to provide windows logins to the database To which role or roles should you add to UserC? Select all that apply.

A network administrator creates a virtual machine from a template that has SQL Server installed. You need to ensure that you can create SQL Server databases on the new virtual machine. Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution.

You administer a Microsoft SQL Server database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

You administer a Microsoft SQL Server instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. The database is configured to use the FULL recovery model. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met: No more than 5 minutes worth of transactions are lost. Data can be recovered by using the minimum amount of administrative effort. What should you do? Each correct answer presents part of the solution.

You administer a Microsoft SQL Server database. The database is currently configured to log ship to a secondary server. You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online. You want to perform a tail-log backup. You need to leave the primary database in a read-only state that can also have further transaction logs applied. Which option of the BACKUP LOG command should you use?

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?

You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?