- All Exams Instant Download
You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B
DRAG DROP You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B. The instance is currently running on NodeA . You want to patch both Node A and Node B by using the most recent SQL Server Service...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 database. You need to convert the database to a contained database. You also need to ensure that all users are converted to contained users. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list...
What should you do?
HOTSPOT You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition: You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard. You need to ensure that the following requirements are met:...
What should you do?
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What...
Which event should you select?
You administer a Microsoft SQL Server 2012 database. Users report that a billing application becomes unresponsive during busy times of the day. While investigating, you notice large number of processes taking or waiting for table locks. You suspect that SQL Server is assigning stronger locks to queries. You start a...
What should you do?
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 that database users and required server logins are migrated to...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server. You need to install the Power View components on a stand-alone server. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the...
Which backup should you perform every two hours?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: - A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is...
Which Transact-SQL command should you use?
You administer a Windows Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Reporting. Which Transact-SQL command should you use?A . BACKUP DATABASE Orders TO DISK = 'D:Orders.bak'RESTORE DATABASE Orders_Reporting FROM DISK = 'D:Orders.bakB . BACKUP DATABASE Orders TO DISK = 'D:Orders.bak'CREATE DATABASE Orders_Reporting...
Which recovery model should the database use?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on...
