You administer a Microsoft SQL Server instance named SQL2012 that hosts an OLTP database of 1 terabyte in size.The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week.Backups are performed as shown in the following schedule:The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete.The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times.When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly.You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time.What should you do on Saturday?
You administer a Microsoft SQL Server 2012 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.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? Choose three.
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail.You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented.You need to reduce fragmentation. You need to achieve this goal without taking the index offline.Which Transact-SQL batch should you use?
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 should you do?
DRAG DROP -You administer a Microsoft SQL Server 2012 database.The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The database uses the FULL recovery model.You plan to perform a bulk import of a very large text file.You need to ensure that the following requirements are met during the bulk operation:✑ The database transaction log is minimally affected.✑ The database is online and all user transactions are recoverable.✑ All transactions are fully recoverable prior to the import.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 correct order.)Select and Place:
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
