You administer a Microsoft SQL Server 2012 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN). You discover I/O issues. The SAN is at capacity and additional disks…
You are a database administrator for a Microsoft SQL Server 2012 environment. You want to deploy a new application that will scale out the workload to at least five different SQL Server instances. You need to ensure that for each…
You administer a Microsoft SQL Server 2012 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…
You administer a Microsoft SQL Server 2012 database named Orders. Orders contains a table named OrderShip that is defined as follows: A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL. Customers require a…
You administer a Microsoft SQL Server 2012 database. You want to make a full backup of the database to a file on disk. In doing so, you need to output the progress of the backup. Which backup option should you…
You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012. You create an Availability Group defined by the following schema. (Line numbers are included for reference only.) You need to implement an AlwaysOnAvailablity Group that will…
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services. You are configuring snapshot replication from…
You administer a Microsoft SQL Server 2012 database instance. You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. You need to ensure…
You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. You add two Windows groups as logins for the server: CORPEmployees – All company employees CORPHRAdmins – HR administrators only HR…
You administer a SQL Server 2012 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use? A. A domain user B. The BUILTINSYSTEM account C. A local user…