MCTS Core Microsoft Technologies 3

Question 1

In IIS 7 and later, which feature replaces the older ISAPI filters for processing HTTP requests and responses?

Accepted Answer

Managed Modules

Answer

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?

Accepted Answer

Database Engine Tuning Advisor

Answer

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?

Accepted Answer

64

Answer

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?

Accepted Answer

SQL Server Session State

Answer

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?

Accepted Answer

Allowing users in one domain to access resources in another domain

Answer

A trust relationship allows users authenticated in one domain or forest to access resources in another domain or forest without re-authentication.

(MCTS) Microsoft Certified Technology Specialist Practice Test

(MCTS) Microsoft Certified Technology Specialist Practice Test

MCTS Core Microsoft Technologies 3