Course 55246-A: SQL 2016 AlwaysOn High Availability Quiz Questions and Answers

How many types of recovery model is provided by SQL Server ?

Answer :
  • 3

Which of the following operation requires to run SQL Server Setup on the node?

Answer :
  • All of the mentioned

How many types of wait occur in SQL Server ?

Answer :
  • 3

Which of the following is a extended event task ?

Answer :
  • All of the mentioned

Policy based management views are present in _________ database.

Answer :
  • MSDB

Does Always on require WSFC?

Answer :
  • Yes

_____________ is a set of technologies for copying and distributing data and database objects from one database to another.

Answer :
  • Replication

In which recovery model Log Shipping can be configured?

Answer :
  • Full
  • Bulk Logged

Benefits that SQL Server failover cluster instances provide?

Answer :
  • All of the mentioned

The resources owned by WSFC node include?

Answer :
  • One file share resource, if the FILESTREAM feature is installed