Are you up to the challenge? Do you have what it takes to design a highly available SQL Server system?
Quiz-summary
0 of 4 questions completed
Questions:
- 1
- 2
- 3
- 4
Information
Find out if you have a good understanding of the available Microsoft® High Availability Technologies. Take the test below.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 4 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- Answered
- Review
-
Question 1 of 4
1. Question
1 pointsWhich Microsoft High Availability technology can be used to run the SQL Server database engine?
Correct
The SQL Server database engine is only supported to run on Windows Server Failover Clustering
Incorrect
Unfortunately, that’s not the correct answer.
-
Question 2 of 4
2. Question
3 pointsWhich Microsoft High Availability technology can be used to run SQL Server Analysis Services? Choose all that apply.
Correct 3 / 3PointsSQL Server Analysis Services is supported to run on both Windows Network Load Balancing and Windows Server Failover Clustering
Incorrect / 3 PointsUnfortunately, that’s not the correct answer.
-
Question 3 of 4
3. Question
6 pointsTo provide high availability solution to a SQL Server Reporting Services instance, which Microsoft® High Availability technologies can be used? Choose all that apply.
Correct 6 / 6PointsIn order to provide high availability to a SQL Server Reporting Services instance, you would need Windows Network Load Balancing for the Reporting Services service and Windows Server Failover Clustering for the Reporting Services catalog databases.
Incorrect / 6 PointsUnfortunately, that’s not the correct answer.
-
Question 4 of 4
4. Question
1 pointsIs virtualization high availability alone enough to provide high availability to the application running inside the virtual machine?
Correct
Virtualization high availability – for example, VMWare HA and Hyper-V Cluster – only protects the operating system in the virtual machine. It does not protect against issues inside the virtual machine like application failure.
Incorrect
Virtualization high availability – for example, VMWare HA and Hyper-V Cluster – only protects the operating system in the virtual machine. It does not protect against issues inside the virtual machine like application failure.
Feeling helpless and confused when dealing with Windows Server Failover Clustering (WSFC) for your SQL Server databases?
You’re not alone. I’ve heard the same thing from thousands of SQL Server administrators throughout my entire career. These are just a few of them.
“How do I properly size the server, storage, network and all the AD settings which we do not have any control over?”
“I don’t quite understand how the Windows portion of the cluster operates and interacts with what SQL controls.”
“I’m unfamiliar with multi-site clustering.”
“Our servers are setup and configured by our parent company, so we don’t really get much experience with setting up Failover Clusters.“
If you feel the same way, then, this course is for you. It’s a simple and easy-to-understand way for you to learn and master how Windows Server Failover Clusters can keep your SQL Server databases highly available. Be confident in designing, building and managing SQL Server databases running on Windows Server Failover Clusters.
But don’t take my word for it. Here’s what my students have to say about the course.
“The techniques presented were very valuable, and used them the following week when I was paged on an issue.”
“Thanks again for giving me confidence and teaching all this stuff about failover clusters.”
“I’m so gladdddddd that I took this course!!”
“Now I got better knowledge to setup the Windows FC ENVIRONMENT (DC) for SQL Server FCI and AlwaysON.”
Please note: I reserve the right to delete comments that are offensive or off-topic.