You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the…

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.

Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?

Which of the following is the default instance name in an SQL Server 2012 installation?

In which of the following statements about audit information stored in an SQL Server 2012 environment is TRUE?

Which of the following transaction safety setting in SQL Server 2012 mirroring forces the m…

Which of the following is a high availability feature with SQL Server 2012?

Which of the following is NOT a pre-defined server role in SQL Server 2012?

Which of the following is required in order for a differential backup to be useful for recovery purposes?

Which of the following statements about the tempdb system database is FALSE?