Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 8
1. ___________ feature will be removed in a future version of Microsoft SQL Server.
Correct Answer is : Database mirroring
2. Which of the following benefit is provided by database mirroring ?
Correct Answer is : All of the mentioned
3. Database mirroring operates in how many modes ?
Correct Answer is : 3
4. Point out the wrong statement :
Correct Answer is : Database mirroring provides less redundancy of the data
5. Which of the following modes writes the data on the principal and mirror databases synchronously ?
Correct Answer is : High safety with automatic cluster
6. The high performance mode is only available in the __________ edition of SQL Server.
Correct Answer is : Enterprise
7. Which of the following is upgrade step to database mirroring ?
Correct Answer is : Perform a rolling upgrade
8. Which of the following pair of technology is supported in SQL Server ?
Correct Answer is : All of the mentioned
