SKILL 4.4 AND 4.5 QUIZ

QUESTION 1

___________________are easier to implement and administer because there is only a single set of database files that are hosted by a SQL Server instance and made available to users.

		a. Availability groups
		b. Fiber Channels
		c. Failover Clustering
		d. None of the above

4 points   

QUESTION 2

Forced failover defines the minimum amount of data loss following a disaster incident.

		a. True
		b. False

4 points   

QUESTION 3

_____________________is a secondary replica that has been configured as an automatic failover destination.

		A. Availability Group
		B. Availability Group Listener
		C. Database Cluster
		D. Failover Partner

4 points   

QUESTION 4

________________was introduced in SQL Server 2012 and they revolutionized high availability by dropping the reliance on hardware and enabled the option to scale out a database solution.

		a. Availability Groups
		b. Transaction logs
		c. RECOVERY
		d. None of the above

4 points   

QUESTION 5

_____________________is a combination of a virtual network name and virtual IP address that can be used by client applications to connect to the databases hosted within the Availability Group.

		a. Availability Group Listener
		b. TNS Listener
		c. Availability Group
		d. None of the above

4 points   

QUESTION 6

________________failover occurs when you explicitly perform a failover because you need to perform some administrative task such as patching the OS or server.

		a. Automatic
		b. Manual
		c. Forced
		d. None of the above

4 points   

QUESTION 7

To create an availability group, what criteria must be met?

		a. The SQL Server instance should be installed on all servers that will be a part of the availability group
		b. A failover cluster must have been created
		c. Availability groups must be enabled for each SQL Server Instance
		d. All of the above

4 points   

QUESTION 8

_____________________is a secondary replica that has been configured to allow select queries to run against it.

		a. Primary replica
		b. Secondary replica
		c. Readable secondary replica
		d. Secondary database

4 points   

QUESTION 9

Availability groups support synchronous and asynchronous commits

		a. True
		b. False

4 points   

QUESTION 10

_________________create temporary statistics inside the [tempdb] system database to help optimize query performance on that particular secondary readable secondary.

		a. Availability Groups
		b. SQL Enterprise Manager
		c. Readable Secondaries
		d. None of the above