MCTS Core Microsoft Technologies 3 — Questions and Answers
Question 1: In IIS 7 and later, which feature replaces the older ISAPI filters for processing HTTP requests and responses?
- ASP.NET Handlers
- Managed Modules (Correct answer)
- HTTP Modules Pipeline
- ISAPI Extensions
Correct answer: Managed Modules
IIS 7 introduced a unified pipeline where managed modules (replacing ISAPI filters) can process all request types, not just ASP.NET requests.
Question 2: Which SQL Server feature automatically creates indexes based on workload analysis to improve query performance?
- Database Engine Tuning Advisor (Correct answer)
- SQL Server Profiler
- Query Store
- Plan Forcing
Correct answer: Database Engine Tuning Advisor
The Database Engine Tuning Advisor analyzes workloads and recommends or automatically creates indexes, indexed views, and partitions to improve performance.
Question 3: What is the maximum number of nodes supported in a Windows Server Failover Cluster?
- 8
- 16
- 32
- 64 (Correct answer)
Correct answer: 64
Windows Server 2008 R2 and later support up to 16 nodes in a failover cluster, but Windows Server 2012 increased this limit to 64 nodes.
Question 4: Which ASP.NET feature allows web application state to be maintained across multiple web servers in a web farm?
- In-Process Session State
- State Server Session
- SQL Server Session State (Correct answer)
- ViewState
Correct answer: SQL Server Session State
SQL Server Session State stores session data in a SQL Server database, making it accessible to all servers in a web farm regardless of which server handles each request.
Question 5: In Active Directory, what is a 'trust' used for?
- Encrypting data between domain controllers
- Allowing users in one domain to access resources in another domain (Correct answer)
- Replicating Group Policy Objects
- Managing DNS zone delegation
Correct answer: Allowing users in one domain to access resources in another domain
A trust relationship allows users authenticated in one domain or forest to access resources in another domain or forest without re-authentication.
Question 6: What is the purpose of the 'using' statement in C# when working with objects that implement IDisposable?
- To import namespaces at the top of a file
- To ensure Dispose() is called automatically when the block exits (Correct answer)
- To create alias names for types
- To enable unsafe code blocks
Correct answer: To ensure Dispose() is called automatically when the block exits
The using statement ensures that Dispose() is called on an IDisposable object when the code block exits, even if an exception occurs.
Question 7: Which Windows Server role service provides centralized management of network access policies for VPN, dial-up, and 802.1X connections?
- Routing and Remote Access
- Network Policy Server (Correct answer)
- DirectAccess
- Connection Manager Administration Kit
Correct answer: Network Policy Server
Network Policy Server (NPS) is the Microsoft implementation of RADIUS and provides centralized authentication, authorization, and accounting for network access.
MCTS Core Microsoft Technologies 3
In IIS 7 and later, which feature replaces the older ISAPI filters for processing HTTP requests and responses?