You need to be able to start the SQL Server
You administer a Microsoft SQL Server 2012 instance.
After a routine shutdown, the drive that contains tempdb fails.
You need to be able to start the SQL Server. What should you do?
You need to ensure that the application login is unable to access other production databases
You administer a single server that contains a Microsoft SQL Server 2012 default instance.
You plan to install a new application that requiresthe deployment of a database on the server.
The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases. What should you
do?
What should you configure?
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be ro
You administer a Microsoft SQL Server 2012 instancenamed 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 are10 GB in size.
The batch process will update these tables multipletimes.
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 need to ensure that the following requirements are met: No more than 5 minutes worth of transactions are l
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 all that apply.
Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server 2012 databasethat 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 need to evaluate existing and potential clustered and non-clustered indexes that will improve performance
You administer a Microsoft SQL Server 2012 server.
You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?
Which Transact-SQL statement should you use?
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 need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica
You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/
Server01 is the primary replica.
You have multiple queries that read data and produce reports from the database.
You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica.
What should you do?
You need to be able to create database mirroring endpoints on both servers
You administer two Microsoft SQL Server 2012 servers.
Each server resides in a different, untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?