Microsoft Certified Technology Specialist (MCTS) Exam — Questions and Answers

Question 1: Which utility is used to schedule tasks automatically in Windows?

Task Scheduler (Correct answer)
Event Viewer
Performance Monitor
Control Panel

Correct answer: Task Scheduler

The Task Scheduler is a Windows utility that allows users and administrators to automate the execution of programs or scripts at specific times or when certain system events occur. It can be used to schedule routine maintenance tasks, run backups, or launch applications automatically. This helps in streamlining administrative tasks and improving system efficiency.

Question 2: A developer creates a SharePoint Feature containing a custom list definition and several associated site columns. The requirement is that this list template must be available for use on any site within a specific site collection, but should not be available in other site collections. What is the most appropriate scope for this Feature?

Farm
Web
WebApplication
Site (Correct answer)

Correct answer: Site

The 'Site' scope corresponds to the site collection level. Activating a Feature at this scope makes its elements, like list definitions and site columns, available throughout that entire site collection and any subsites within it. The 'Web' scope is too narrow (a single site), while 'WebApplication' and 'Farm' scopes are too broad for this requirement.

Question 3: Which command is used to join a Windows computer to an Active Directory domain from the command line?

nltest /domain_trusts
netdom join /domain (Correct answer)
dsadd computer
net use /domain

Correct answer: netdom join /domain

The netdom join command allows administrators to join a computer to a domain, specifying credentials and OU placement via command-line parameters.

Question 4: A technician wants to configure Windows 7 so that the pagefile is stored on a separate physical disk from the OS. Where is this setting configured?

Disk Management
Computer Management > Storage
System Properties > Advanced > Performance Settings > Virtual Memory (Correct answer)
msconfig > Boot tab

Correct answer: System Properties > Advanced > Performance Settings > Virtual Memory

Virtual memory (pagefile) location is configured under System Properties > Advanced > Performance Settings > Advanced > Virtual Memory.

Question 5: What is the purpose of the web.config <customErrors> element in ASP.NET?

It defines custom HTTP headers for responses
It configures user-friendly error pages shown when unhandled exceptions occur (Correct answer)
It sets the maximum request size allowed
It disables all runtime exceptions

Correct answer: It configures user-friendly error pages shown when unhandled exceptions occur

The <customErrors> element lets you redirect users to friendly error pages instead of exposing raw exception details.

Question 6: In a SQL Server execution plan, what does a HASH MATCH JOIN indicate?

SQL Server found an index to satisfy the join
The join merged two pre-sorted result sets
SQL Server built an in-memory hash table on the smaller input to probe with the larger input because no suitable indexes existed (Correct answer)
The join used nested loops with row-by-row comparison

Correct answer: SQL Server built an in-memory hash table on the smaller input to probe with the larger input because no suitable indexes existed

Hash Match Join builds a hash table from one input (build phase) and probes it with the other input (probe phase), typically used when inputs are large and unsorted.

Question 7: In the context of the .NET garbage collector, which generation is collected most frequently and contains newly allocated, short-lived objects?

Generation 1
The Large Object Heap (LOH)
Generation 0 (Correct answer)
Generation 2

Correct answer: Generation 0

The .NET garbage collector uses a generational approach to optimize performance. New objects are allocated in Generation 0. The GC collects Generation 0 most frequently because most objects are short-lived and can be reclaimed quickly. Objects that survive a Generation 0 collection are promoted to Generation 1, and those that survive a Generation 1 collection move to Generation 2.

Question 8: In WCF, which transport credential type should be used when clients authenticate with a Windows domain account over NetTcpBinding?

UserName
Certificate
Windows (Correct answer)
Basic

Correct answer: Windows

Windows credential type leverages Kerberos or NTLM for authentication, integrating seamlessly with Active Directory when both client and service are domain-joined.

Question 9: What does the SQL Server DMV sys.dm_exec_query_stats expose?

Current active sessions and their blocking chains
Index fragmentation levels for all user tables
Aggregate performance statistics for cached query plans (Correct answer)
Memory allocation by database component

Correct answer: Aggregate performance statistics for cached query plans

sys.dm_exec_query_stats returns aggregate performance statistics (CPU, I/O, elapsed time, executions) for all cached query plans.

Question 10: An administrator runs 'repadmin /showrepl' and notices a replication error on one domain controller. What does this command primarily help diagnose?

FSMO role placement issues
DNS resolution problems for AD-integrated zones
Active Directory replication status and errors between domain controllers (Correct answer)
GPO application failures

Correct answer: Active Directory replication status and errors between domain controllers

Repadmin /showrepl displays the replication status, last replication attempt, and any errors for each replication partner of a domain controller.

Question 11: In Windows Hyper-V, what is a 'differencing disk'?

A backup disk for virtual machine checkpoints
A disk used to compare production and test environments
A VHD that stores only changes made since it was linked to a parent disk (Correct answer)
A disk that stores only the differences between two snapshots

Correct answer: A VHD that stores only changes made since it was linked to a parent disk

A differencing disk stores only the changes made to a virtual machine's disk relative to its parent VHD, saving storage space and enabling shared base images.

Question 12: A Windows 7 computer is configured to use a proxy server. A user needs to bypass the proxy for internal intranet addresses. Where is this configured?

hosts file
Internet Options > Connections > LAN Settings > Bypass proxy server for local addresses (Correct answer)
Windows Firewall > Advanced Settings
Network and Sharing Center > Change adapter settings

Correct answer: Internet Options > Connections > LAN Settings > Bypass proxy server for local addresses

The 'Bypass proxy server for local addresses' checkbox in LAN Settings routes intranet traffic directly, skipping the proxy.

Question 13: Which feature allows remote configuration of a Windows machine?

Remote Desktop (Correct answer)
Performance Monitor
Task Scheduler
Event Viewer

Correct answer: Remote Desktop

Remote Desktop is a built-in Windows feature that allows a user to connect to and control a remote Windows machine graphically over a network. This enables administrators to configure, troubleshoot, and manage a computer from a different location as if they were physically present. It's a vital tool for remote administration and support.

Question 14: Which Windows Server 2008 feature allows you to install only the Active Directory components needed, without a full GUI, to reduce the attack surface?

Read-Only Domain Controller
Active Directory Application Mode
Active Directory Lightweight Directory Services
Server Core installation (Correct answer)

Correct answer: Server Core installation

Server Core is a minimal Windows Server 2008 installation option that provides essential server roles without the full GUI, reducing the attack surface.

Question 15: A user's roaming profile is extremely large, causing slow logon times. Which Group Policy setting helps enforce a profile size limit?

Configure mandatory profiles
Limit profile size under User Profiles policies (Correct answer)
Enable Offline Files synchronization
Redirect user folders to a network share

Correct answer: Limit profile size under User Profiles policies

The 'Limit profile size' GPO setting alerts users and prevents logoff if their profile exceeds a defined quota, helping manage roaming profile growth.

Question 16: A user's Windows 7 system is slow after several months of use. Which built-in tool analyzes the causes of degraded performance over time and displays a stability index?

System Information
Event Viewer
Performance Monitor
Reliability Monitor (Correct answer)

Correct answer: Reliability Monitor

Reliability Monitor tracks system stability over time and correlates events like crashes and installations with the stability index.

Question 17: What happens when you execute DBCC CHECKDB on a SQL Server database?

It shrinks the data and log files to their minimum size
It rebuilds all fragmented indexes and updates statistics
It forces a full checkpoint and flushes dirty pages to disk
It checks the logical and physical integrity of all objects in the database (Correct answer)

Correct answer: It checks the logical and physical integrity of all objects in the database

DBCC CHECKDB validates allocation structures, page and row integrity, index consistency, and inter-table consistency for every object in the target database.

Question 18: Which SQL Server windowing function returns the rank of each row within a partition, with no gaps in ranking values?

NTILE()
RANK()
DENSE_RANK() (Correct answer)
ROW_NUMBER()

Correct answer: DENSE_RANK()

DENSE_RANK() assigns consecutive rank values with no gaps when there are ties, whereas RANK() skips rank values after ties.

Question 19: Which SQL Server 2008 backup option allows you to continue taking a backup even if the source database has suspect pages?

WITH CONTINUE_AFTER_ERROR (Correct answer)
WITH COMPRESSION
WITH CHECKSUM
WITH SKIP

Correct answer: WITH CONTINUE_AFTER_ERROR

WITH CONTINUE_AFTER_ERROR instructs the backup to continue even if errors such as suspect pages are encountered, recording errors in the backup header.

Question 20: What SQL Server feature enables you to enforce rules that span multiple tables, such as ensuring referential integrity across databases?

DML triggers with cross-database queries
DDL triggers
INSTEAD OF triggers (Correct answer)
CHECK constraints

Correct answer: INSTEAD OF triggers

INSTEAD OF triggers intercept DML and allow custom logic, including cross-database integrity checks that CHECK constraints and FOREIGN KEY constraints cannot enforce.

Question 21: Which cmdlet in Exchange 2010 is used to view the current queue of messages on a Hub Transport or Edge Transport server?

Get-Message
Show-TransportLog
Get-Queue (Correct answer)
Get-TransportQueue

Correct answer: Get-Queue

Get-Queue retrieves information about queues on Hub Transport and Edge Transport servers including message counts and status.

Question 22: What is the minimum number of Mailbox servers required to form a Database Availability Group (DAG) in Exchange 2010?

3
2 (Correct answer)
4
1

Correct answer: 2

A DAG requires a minimum of 2 Mailbox servers to replicate database copies and provide failover capability.

Question 23: What does the 'ReadyBoost' feature in Windows 7 use to improve system performance?

An SSD as a secondary page file
CPU cache optimization
A USB flash drive as supplemental cache (Correct answer)
Additional RAM modules

Correct answer: A USB flash drive as supplemental cache

ReadyBoost uses flash memory on a USB drive or SD card as a disk cache to speed up data access.

Question 24: An administrator is deploying a new two-node Exchange 2010 Database Availability Group (DAG) in a single Active Directory site. To maintain quorum in the event of a server failure, a File Share Witness (FSW) is required. Which of the following is a valid configuration for the witness server?

Any server running Windows Server 2003 Standard Edition.
An Edge Transport server in the perimeter network.
A member server of the Database Availability Group.
A Hub Transport server running Windows Server 2008 in the same forest. (Correct answer)

Correct answer: A Hub Transport server running Windows Server 2008 in the same forest.

The witness server for an Exchange 2010 DAG must be a Windows Server in the same Active Directory forest as the DAG, but it cannot be a member of the DAG itself. While it's often recommended to use a Hub Transport server in the same site for convenience, any supported Windows Server (2003 R2 or later) in the forest is technically valid. An Edge Transport server is not in the same forest, and a DAG member cannot witness itself. Windows Server 2003 Standard is not sufficient; 2003 R2 or later is required.

Question 25: What does the APPLY operator do differently from a standard JOIN?

APPLY replaces GROUP BY in aggregation queries
APPLY invokes a table-valued function or subquery for each row of the outer table expression (Correct answer)
APPLY is faster than JOIN for all query types
APPLY can only be used with scalar functions

Correct answer: APPLY invokes a table-valued function or subquery for each row of the outer table expression

CROSS APPLY and OUTER APPLY invoke a right table expression once per row of the left expression, enabling row-by-row correlated table operations.

Question 26: What is the purpose of an FSMO (Flexible Single Master Operations) role in Active Directory?

Performing certain domain-wide operations that must occur on only one DC at a time (Correct answer)
Providing redundant domain controller availability
Controlling replication topology in a site
Managing DNS zone transfers between domain controllers

Correct answer: Performing certain domain-wide operations that must occur on only one DC at a time

FSMO roles designate a single domain controller to handle operations that could cause conflicts if performed on multiple DCs simultaneously, such as schema updates and RID pool allocation.

Question 27: Which SharePoint 2010 service application provides search functionality across enterprise content?

Search Service Application (Correct answer)
Business Data Connectivity Service
Managed Metadata Service
User Profile Service

Correct answer: Search Service Application

The Search Service Application indexes and queries content across SharePoint and connected external data sources.

Question 28: What is the purpose of the Resource Governor feature introduced in SQL Server 2008?

To control disk I/O per database file
To restrict the number of concurrent connections per login
To limit the size of individual databases
To manage and limit CPU and memory resources used by different workload groups (Correct answer)

Correct answer: To manage and limit CPU and memory resources used by different workload groups

Resource Governor allows DBAs to classify incoming sessions into workload groups and assign resource pools with CPU and memory limits.

Question 29: You need to implement transparent encryption on a SQL Server 2008 database without changing the application. Which feature should you use?

Encrypted backup with MEDIAPASSWORD
Transparent Data Encryption (TDE) (Correct answer)
Column-level encryption with ENCRYPTBYKEY
SQL Server rights management

Correct answer: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the entire database at the page level, protecting data at rest with no application changes required.

Question 30: Which T-SQL command deallocates a cursor and releases all resources associated with it?

CLOSE cursor_name
DROP cursor_name
RELEASE cursor_name
DEALLOCATE cursor_name (Correct answer)

Correct answer: DEALLOCATE cursor_name

DEALLOCATE removes the cursor definition and releases all resources; CLOSE only closes the cursor but keeps the definition available for re-opening.

Question 31: Which IIS feature must be enabled for ASP.NET URL routing without file extensions to work correctly?

HTTP Redirect module
Static content compression
runAllManagedModulesForAllRequests setting or extensionless URL routing (Correct answer)
Windows Authentication module

Correct answer: runAllManagedModulesForAllRequests setting or extensionless URL routing

Setting runAllManagedModulesForAllRequests to true in web.config or configuring extensionless URL routing ensures IIS passes requests without file extensions to the ASP.NET pipeline for route matching.

Question 32: When a Group Policy Object (GPO) is linked to both a site and an OU, and they have conflicting settings, which GPO takes precedence by default?

Site GPO always wins
The GPO with higher priority number wins
The newer GPO always wins
OU GPO takes precedence over site GPO (Correct answer)

Correct answer: OU GPO takes precedence over site GPO

GPOs are applied in LSDOU order (Local, Site, Domain, OU), so OU-linked GPOs are applied last and override conflicting settings from site or domain GPOs.

Question 33: Which recovery model in SQL Server allows bulk operations like BCP and SELECT INTO to be minimally logged?

FULL
READ_ONLY
SIMPLE
BULK_LOGGED (Correct answer)

Correct answer: BULK_LOGGED

BULK_LOGGED recovery minimally logs bulk operations (BCP, BULK INSERT, SELECT INTO), reducing log space usage while still allowing log backups.

Question 34: What is the correct way to dispose of an SPWeb object obtained via SPSite.OpenWeb() in SharePoint 2010?

Call SPWeb.Close()
Call SPSite.Close()
Set the variable to null
Use a using statement or call SPWeb.Dispose() (Correct answer)

Correct answer: Use a using statement or call SPWeb.Dispose()

SPWeb implements IDisposable, so it must be disposed via a using block or explicit Dispose() call to prevent memory leaks.

Question 35: Which Exchange 2010 cmdlet would you use to test whether a specific email address can successfully receive messages through your Exchange organization?

Test-SmtpConnectivity
Test-MailFlow (Correct answer)
Send-MailMessage
Test-Mailbox

Correct answer: Test-MailFlow

Test-MailFlow sends a test message through the Exchange transport pipeline and reports whether delivery succeeded.

Question 36: To which of the following can a Fine-Grained Password Policy (FGPP) be directly applied in a Windows Server 2008 environment?

Computer Objects
Global Security Groups and User Objects (Correct answer)
Domain Local Groups
Organizational Units (OUs)

Correct answer: Global Security Groups and User Objects

Fine-Grained Password Policies can only be applied directly to user objects and global security groups. They cannot be applied directly to Organizational Units (OUs).

Question 37: In SQL Server, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads?

Read Committed
Serializable
Repeatable Read (Correct answer)
Read Uncommitted

Correct answer: Repeatable Read

Repeatable Read prevents dirty reads and non-repeatable reads by holding shared locks until the transaction ends, but phantom rows can still appear.

Question 38: Which Windows Server component provides a web-based interface for managing IIS web sites and application pools?

Remote Desktop Services Manager
Windows Admin Center
IIS Manager (inetmgr) (Correct answer)
Server Manager dashboard

Correct answer: IIS Manager (inetmgr)

IIS Manager (inetmgr) is the dedicated MMC snap-in for configuring Internet Information Services web sites, application pools, bindings, and authentication.

Question 39: Which Windows 7 tool provides a single dashboard to configure network discovery, file sharing, and homegroup settings based on network location?

Windows Firewall
Network and Sharing Center (Correct answer)
Computer Management
Device Manager

Correct answer: Network and Sharing Center

Network and Sharing Center lets users view network status and configure sharing and discovery settings per network profile.

Question 40: Which T-SQL function returns the number of rows in a window frame up to and including the current row?

LEAD()
LAG()
FIRST_VALUE()
SUM() OVER (ORDER BY col ROWS UNBOUNDED PRECEDING) (Correct answer)

Correct answer: SUM() OVER (ORDER BY col ROWS UNBOUNDED PRECEDING)

SUM() with the OVER clause and a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW frame specification computes a running total.

Question 41: A developer needs to ensure that a compiled .NET assembly can be shared across multiple applications on a single machine. Which of the following is a mandatory prerequisite for deploying an assembly to the Global Assembly Cache (GAC)?

The assembly must be compiled in Release mode.
The assembly must have a strong name. (Correct answer)
The assembly must be registered using the regasm.exe tool.
The assembly must be digitally signed with a code signing certificate.

Correct answer: The assembly must have a strong name.

To be installed in the Global Assembly Cache (GAC), an assembly must have a strong name. A strong name consists of the assembly's identity—its simple text name, version number, and culture information (if provided)—plus a public key and a digital signature. This ensures the uniqueness of the assembly and prevents conflicts.

Question 42: Which Windows 7 Group Policy setting controls whether users can install hardware devices that are not pre-approved by an administrator?

User Account Control elevation prompt
Prevent installation of devices not described by other policy settings (Correct answer)
Windows Update driver installation policy
Device Manager > View > Show hidden devices

Correct answer: Prevent installation of devices not described by other policy settings

This Group Policy setting under Computer Configuration > Administrative Templates > System > Device Installation blocks unapproved device installs.

Question 43: Which .NET attribute marks an interface as a WCF service contract?

[ServiceContract] (Correct answer)
[MessageContract]
[DataContract]
[OperationContract]

Correct answer: [ServiceContract]

[ServiceContract] is applied to an interface or class to declare it as a WCF service contract, defining the overall service.

Question 44: Which PowerShell cmdlet retrieves a list of all installed Windows features on a server?

Get-WindowsFeature (Correct answer)
Get-Service
Get-Module
Get-Package

Correct answer: Get-WindowsFeature

Get-WindowsFeature returns all available and installed roles, role services, and features on Windows Server.

Question 45: Which Microsoft technology provides a unified messaging platform that integrates email, voice mail, and fax into a single inbox?

SharePoint Shared Services
System Center Communications Manager
Exchange Server Unified Messaging (Correct answer)
Microsoft Lync

Correct answer: Exchange Server Unified Messaging

Exchange Server Unified Messaging integrates voice mail, fax, and email into a single Exchange mailbox accessible from multiple devices.

Question 46: In SharePoint 2010, which CAML element is used to filter list items by a specific field value in a CAML query?

<OrderBy>
<GroupBy>
<ViewFields>
<Where> (Correct answer)

Correct answer: <Where>

The <Where> element in CAML queries contains the filter conditions that restrict which list items are returned.

Question 47: An administrator wants to prevent a specific GPO from applying to members of the 'Executives' security group in an OU. Which method should be used?

Set 'Deny Apply Group Policy' permission for the Executives group on the GPO (Correct answer)
Move the Executives accounts to a different OU
Enable Block Policy Inheritance on the Executives user accounts
Delete the GPO link from the OU

Correct answer: Set 'Deny Apply Group Policy' permission for the Executives group on the GPO

Setting 'Deny Apply Group Policy' permission for a security group on a GPO prevents that GPO from applying to members of that group.

Question 48: In Exchange 2010, which type of address list would you create to allow users in the Sydney office to find only their local colleagues in the global address list?

Custom Address List (Correct answer)
Room List
Dynamic Distribution Group
Offline Address Book

Correct answer: Custom Address List

A custom address list filtered by recipient attributes (such as office location) allows users to find specific subsets of recipients.

Question 49: In SQL Server, what is a covering index?

An index that encrypts all included columns
An index that automatically covers all foreign key columns
A non-clustered index that includes all columns needed by a query, eliminating key lookups (Correct answer)
A clustered index that spans multiple filegroups

Correct answer: A non-clustered index that includes all columns needed by a query, eliminating key lookups

A covering index includes all columns referenced by a query (via key columns or INCLUDE columns), allowing the query to be satisfied entirely from the index without a clustered index lookup.

Question 50: An administrator accidentally deleted an entire Organizational Unit (OU) containing several user accounts. They want to restore the objects with all their attributes and group memberships intact. Which of the following features, first available in Windows Server 2008 R2, must be enabled BEFORE the deletion occurs to allow for this type of recovery?

Restartable Active Directory Domain Services
Authoritative Restore from a System State backup
Active Directory Recycle Bin (Correct answer)
Tombstone Reanimation

Correct answer: Active Directory Recycle Bin

The Active Directory Recycle Bin, when enabled, preserves all attributes of deleted objects, allowing for a complete restoration. To enable this feature, the forest functional level must be at least Windows Server 2008 R2. Standard tombstone reanimation does not preserve all attributes like group memberships.

Question 51: Which Exchange 2010 permission model should be used to allow a help desk team to reset passwords and manage mailbox properties without granting full admin rights?

Discretionary ACLs
Shared permissions
Role-Based Access Control (RBAC) (Correct answer)
Split permissions

Correct answer: Role-Based Access Control (RBAC)

RBAC in Exchange 2010 allows fine-grained delegation of administrative tasks through management role assignments.

Microsoft Certified Technology Specialist (MCTS) Exam

MCTS certifications validate expertise in specific Microsoft technologies, demonstrating proficiency in implementing, troubleshooting, and debugging a particular Microsoft product or technology.

Questions

120 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds