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 database.You provide temporary securityadmin access to User1 to the database server.You need to know if User1 adds logins to securityadmin.Which server-level audit action group should you use?
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?
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?
You are the lead database administrator (DBA) of a Microsoft SQL Server environment.All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server.You need to create a server role named SpecialDBARole that can perform the following functions:✑ View all databases.✑ View the server state.✑ Assign GRANT, DENY, and REVOKE permissions on logins.You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary.Which three SQL statements should you use? Each correct answer presents part of the solution.
