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

Question 1: A company needs to ensure that all email sent to external recipients includes a legal disclaimer. Which Exchange 2010 feature should be configured?

Journaling
Ethical walls
Transport rules with disclaimers (Correct answer)
Message classifications

Correct answer: Transport rules with disclaimers

Transport rules in Exchange 2010 can be configured to append disclaimers to messages matching specified conditions.

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

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

Correct answer: [ServiceContract]

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

Question 3: Which Active Directory object type represents a collection of computers, users, or other groups that can be assigned permissions or used for email distribution?

Group (Correct answer)
Site
Organizational Unit
Container

Correct answer: Group

Active Directory Groups are used to organize users, computers, and other groups for permission assignment and, as distribution groups, for email.

Question 4: What does the Windows Firewall help protect against?

Expired licenses
Overheating
Unauthorized network access (Correct answer)
Slow internet speeds

Correct answer: Unauthorized network access

The Windows Firewall is a security component that monitors and controls incoming and outgoing network traffic based on predefined security rules. Its primary purpose is to protect the computer from unauthorized network access, preventing malicious software or external threats from compromising the system. It acts as a barrier between the computer and the network.

Question 5: Which Windows 7 technology allows IT to deliver a virtual application to a desktop without installing it locally, reducing conflicts between applications?

BranchCache
RemoteApp
Windows XP Mode
Microsoft App-V (Correct answer)

Correct answer: Microsoft App-V

Microsoft Application Virtualization (App-V) streams virtualized applications to desktops so they run in isolated environments.

Question 6: What is the default replication interval for Active Directory changes between domain controllers within the same site?

15 minutes
30 minutes
5 minutes (Correct answer)
60 minutes

Correct answer: 5 minutes

Within a site, AD replication is triggered immediately (notify-based) and occurs within approximately 5 minutes by default.

Question 7: In ASP.NET MVC, which component is responsible for handling incoming HTTP requests and returning responses?

Model
View
Controller (Correct answer)
Route Handler

Correct answer: Controller

The Controller processes incoming requests, works with the Model to retrieve data, and selects the appropriate View to render the response.

Question 8: Which .NET collection class provides a thread-safe, first-in-first-out data structure?

Queue<T>
ConcurrentQueue<T> (Correct answer)
LinkedList<T>
Stack<T>

Correct answer: ConcurrentQueue<T>

ConcurrentQueue<T> in System.Collections.Concurrent is designed for thread-safe FIFO operations without explicit locking.

Question 9: Which SharePoint 2010 class should you use to send an email from server-side code without configuring SMTP settings manually?

SPEmailMessage.Send
System.Net.Mail.SmtpClient
Microsoft.SharePoint.Utilities.SPUtility.SendEmail (Correct answer)
SPAdmin.SendNotification

Correct answer: Microsoft.SharePoint.Utilities.SPUtility.SendEmail

SPUtility.SendEmail uses the outbound email settings configured in SharePoint Central Administration to send emails.

Question 10: A developer needs to ensure that a series of data modifications within a stored procedure are treated as a single, atomic unit. If an error occurs at any point, all prior modifications within the procedure should be undone. Which T-SQL construct is most appropriate for handling this requirement?

A cursor to iterate through the statements.
An AFTER trigger on the target table.
A temporary table to log changes before applying them.
A TRY...CATCH block combined with a transaction. (Correct answer)

Correct answer: A TRY...CATCH block combined with a transaction.

The combination of a TRY...CATCH block and a transaction is the standard and most robust method for ensuring atomicity in SQL Server. The data modification statements are placed within a BEGIN TRANSACTION...COMMIT TRANSACTION block, which is itself inside a TRY block. If an error occurs, control passes to the CATCH block, where a ROLLBACK TRANSACTION statement can be executed to undo all the changes made since the transaction began.

Question 11: Which Windows 7 feature allows multiple users to stream media from a shared library to devices on the local network such as Xbox 360 or DLNA renderers?

HomeGroup
Windows Media Center
Windows Media Player Home Media Streaming (Correct answer)
Network and Sharing Center

Correct answer: Windows Media Player Home Media Streaming

Windows Media Player's streaming feature enables DLNA-based media sharing to compatible devices on the same network.

Question 12: Which NTFS permission allows a user to view file names in a folder but not read the file contents?

List Folder Contents (Correct answer)
Read
Traverse Folder
Read & Execute

Correct answer: List Folder Contents

List Folder Contents grants permission to view file and subfolder names within a directory without the ability to open or read individual file content.

Question 13: In ASP.NET MVC Razor views, what does the @model directive declare?

The base class the view inherits from
The strongly-typed data model the view expects to receive from the controller (Correct answer)
The namespace imported for use in the view
The layout page the view should use for rendering

Correct answer: The strongly-typed data model the view expects to receive from the controller

The @model directive specifies the type of the Model property in the Razor view, enabling IntelliSense and compile-time checking for the data passed from the controller.

Question 14: What tool allows administrators to monitor system performance in real time?

Paint
File Explorer
Performance Monitor (Correct answer)
Taskbar

Correct answer: Performance Monitor

The Performance Monitor is a powerful Windows tool that allows administrators to monitor system performance in real time. It collects and displays data on various system resources, such as CPU usage, memory, disk I/O, and network activity. This helps in identifying bottlenecks, diagnosing performance issues, and understanding the overall health of the system.

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

Computer Management
Network and Sharing Center (Correct answer)
Windows Firewall
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 16: A company wants to deploy a domain controller in a branch office with low physical security. The administrator is concerned about the potential theft of the server and the compromise of all domain credentials. Which Windows Server 2008 feature should be implemented to mitigate this risk?

BitLocker Drive Encryption on a standard Domain Controller
Active Directory Federation Services (AD FS)
A Backup Domain Controller (BDC)
Read-Only Domain Controller (RODC) (Correct answer)

Correct answer: Read-Only Domain Controller (RODC)

A Read-Only Domain Controller (RODC) is designed for scenarios like branch offices where physical security is a concern. By default, an RODC does not cache user passwords, minimizing the security risk if the server is compromised. It hosts a read-only copy of the Active Directory database.

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

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

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 18: In ASP.NET Web Forms, what is the role of the IsPostBack property?

Verifies that cross-site request forgery protection is active
Checks if ViewState is enabled for the current page
Indicates whether the page is being loaded in response to a client postback (Correct answer)
Determines if the current request came from an authenticated user

Correct answer: Indicates whether the page is being loaded in response to a client postback

IsPostBack returns true when the page is loaded because a user action triggered a form submission back to the server, helping you avoid re-initializing data on postbacks.

Question 19: Which ASP.NET feature allows you to run code before and after the application starts and stops by implementing methods in Global.asax?

Initialization handlers
Startup filters
HttpModules
Application lifecycle events (Application_Start, Application_End) (Correct answer)

Correct answer: Application lifecycle events (Application_Start, Application_End)

Global.asax exposes application lifecycle event handlers like Application_Start and Application_End that run when the web application initializes or shuts down.

Question 20: Which ASP.NET caching mechanism stores data in memory on the web server and supports dependencies on files, keys, or SQL tables?

Session state
Application cache (HttpRuntime.Cache) (Correct answer)
ViewState
Response cache headers

Correct answer: Application cache (HttpRuntime.Cache)

HttpRuntime.Cache (also accessible as HttpContext.Cache) is the ASP.NET application cache that supports expiration policies and dependencies on external resources like files or database tables.

Question 21: What is the purpose of the 'using' statement in C# when working with objects that implement IDisposable?

To ensure Dispose() is called automatically when the block exits (Correct answer)
To create alias names for types
To import namespaces at the top of a file
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 22: An administrator runs 'repadmin /showrepl' and notices a replication error on one domain controller. What does this command primarily help diagnose?

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

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 23: Which Microsoft tool is used for managing Windows Server environments?

Registry Editor
Server Manager (Correct answer)
Task Scheduler
Control Panel

Correct answer: Server Manager

Server Manager is a key Microsoft tool used for managing Windows Server environments. It provides a centralized console for administrators to view server roles, features, local and remote servers, and perform various administrative tasks like configuring settings and monitoring server status.

Question 24: Which ADO.NET object is used to execute a stored procedure and retrieve a result set?

SqlConnection
SqlDataAdapter
DataSet
SqlCommand (Correct answer)

Correct answer: SqlCommand

SqlCommand executes SQL statements or stored procedures and can return results via ExecuteReader or ExecuteScalar.

Question 25: You are configuring User Account Control (UAC) on a Windows 7 computer for a standard user. You want to ensure the user is prompted for an administrator's username and password whenever a program attempts to make changes to the computer. Which UAC notification level should you configure?

Notify me only when programs try to make changes to my computer (do not dim my desktop)
Always notify
Never notify
Notify me only when programs try to make changes to my computer (default) (Correct answer)

Correct answer: Notify me only when programs try to make changes to my computer (default)

For a standard user account, the default UAC setting, 'Notify me only when programs try to make changes to my computer,' achieves the stated goal. When an action requires administrative privileges, UAC will display a secure desktop prompt asking for the credentials of an administrator account before allowing the change. The 'Always notify' setting also does this but is more intrusive, prompting for administrative tasks as well. The other two settings are less secure and do not meet the requirement.

Question 26: Which ASP.NET configuration element is used to define custom error pages for specific HTTP status codes?

<errorPages> in system.web
<customErrors> in system.web (Correct answer)
<httpErrors> in system.webServer
<statusCodes> in system.webServer

Correct answer: <customErrors> in system.web

The <customErrors> element in system.web allows you to specify redirect URLs for specific HTTP error status codes such as 404 or 500.

Question 27: A user needs to encrypt the entire contents of a removable USB flash drive to protect sensitive data. The user must be able to access the data on other Windows 7 computers, and also have read-only access on computers running Windows XP. Which Windows 7 feature should be used to accomplish this?

Encrypting File System (EFS)
Rights Management Services (RMS)
NTFS permissions
BitLocker To Go (Correct answer)

Correct answer: BitLocker To Go

BitLocker To Go is a feature introduced in Windows 7 designed specifically for encrypting removable data drives like USB flash drives. It provides full data protection and includes a 'BitLocker To Go Reader' for older operating systems like Windows XP and Vista, which allows for read-only access to the encrypted data after providing the correct password. EFS encrypts individual files/folders, not entire drives. NTFS permissions control access but do not encrypt the data at rest on the drive. RMS is for protecting information within documents, not for full drive encryption.

Question 28: Which system database in SQL Server stores login accounts and system configuration?

master (Correct answer)
msdb
model
tempdb

Correct answer: master

The `master` database is a critical system database in SQL Server that stores all system-wide information. This includes metadata about all other databases on the SQL Server instance, server configuration settings, login accounts, and endpoints. It is essential for the operation of the SQL Server instance, as the server cannot start if the `master` database is unavailable.

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

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

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 30: Which filegroup type in SQL Server is used to store read-only data for improved performance?

PRIMARY filegroup
ROWS filegroup
FILESTREAM filegroup
Read-only filegroup (Correct answer)

Correct answer: Read-only filegroup

A read-only filegroup can be placed on slower storage since it never requires write I/O, and SQL Server skips logging for it.

Question 31: Which Windows 7 command-line tool converts a basic disk to a dynamic disk without losing existing data?

fdisk
convert
diskpart (Correct answer)
format

Correct answer: diskpart

The diskpart utility with the 'convert dynamic' command converts a basic disk to dynamic while preserving existing volumes.

Question 32: An administrator needs to restrict which software can run on Windows 7 computers based on file path, publisher certificate, or hash. Which feature provides this capability?

Software Restriction Policies
Windows Defender
AppLocker (Correct answer)
BitLocker

Correct answer: AppLocker

AppLocker (available in Ultimate/Enterprise) provides granular application control using path, publisher, and hash rules.

Question 33: In the Exchange 2010 Role Based Access Control (RBAC) model, what component serves as a container for management roles and is assigned to administrators to grant permissions?

Management Role Entry
Management Role Group (Correct answer)
Management Role Scope
Management Role Assignment

Correct answer: Management Role Group

A Management Role Group is a universal security group (USG) that contains users, mail-enabled USGs, and other role groups. Management roles are assigned to a role group, and administrators are made members of that group, thereby granting them all the permissions defined by the roles. A Role Entry is a single cmdlet (a task), a Role Assignment links a role to a group, and a Role Scope defines where the permissions can be applied.

Question 34: Which Visual Studio feature helps track changes made to code?

Syntax Highlighter
Version Control System (Correct answer)
IntelliSense
Debugger

Correct answer: Version Control System

A Version Control System (VCS), such as Git (which is often integrated into Visual Studio), is a crucial feature for tracking changes made to code over time. It allows developers to manage different versions of their source code, collaborate with others, revert to previous states, and merge changes efficiently. This ensures code integrity and facilitates team development.

Question 35: Which SharePoint 2010 workflow template is based on Windows Workflow Foundation and supports sequential and state-machine patterns?

Reusable Workflow
Visual Studio Workflow (Correct answer)
Declarative Workflow
SharePoint Designer Workflow

Correct answer: Visual Studio Workflow

Visual Studio workflows are compiled code-based workflows built on WF 3.5 and support both sequential and state-machine models.

Question 36: Which utility allows configuration of system boot options in Windows?

msconfig (Correct answer)
regedit
services.msc
Task Manager

Correct answer: msconfig

The `msconfig` utility, also known as System Configuration, is a Windows tool that allows users to configure various system boot options. It enables managing startup programs, services, boot parameters (like safe mode), and system tools. This utility is essential for troubleshooting startup issues and optimizing system performance.

Question 37: Which SQL Server feature allows you to query historical data as it existed at a past point in time?

Temporal Tables (Correct answer)
Database Snapshots
Change Data Capture
Log Shipping

Correct answer: Temporal Tables

Temporal tables (system-versioned) automatically track row history in a history table, and FOR SYSTEM_TIME AS OF lets you query past states.

Question 38: A user needs delegate access to another user's calendar in Exchange 2010. Which permission level allows the delegate to read, create, and modify items?

Owner
Author
Reviewer
Editor (Correct answer)

Correct answer: Editor

The Editor permission level grants the delegate the ability to read, create, and modify calendar items in the delegated mailbox.

Question 39: A server's pagefile is located on the same volume as the OS. What is the primary risk of this configuration?

Slower read speeds due to disk fragmentation
Increased boot time due to pagefile initialization
The pagefile may not be large enough for crash dumps (Correct answer)
Pagefile encryption conflicts with BitLocker

Correct answer: The pagefile may not be large enough for crash dumps

Storing the pagefile on the OS volume can prevent complete memory dumps if the pagefile is smaller than physical RAM, which is required for full crash dumps.

Question 40: Which replication topology is automatically generated by the Knowledge Consistency Checker (KCC) in Active Directory?

Ring topology with bidirectional connections (Correct answer)
Hub-and-spoke topology controlled by administrators
Star topology with PDC Emulator at center
Full mesh topology between all DCs

Correct answer: Ring topology with bidirectional connections

The KCC automatically builds a ring topology with bidirectional connections ensuring no more than three hops between any two domain controllers within a site.

Question 41: Which tool is used to raise the domain functional level in Windows Server 2008 Active Directory?

Group Policy Management Console
Active Directory Users and Computers
Active Directory Domains and Trusts (Correct answer)
Active Directory Sites and Services

Correct answer: Active Directory Domains and Trusts

Active Directory Domains and Trusts is the MMC snap-in used to raise both the domain and forest functional levels.

Question 42: What is the primary function of the .NET Framework in Windows development?

Compiles Java programs.
Manages hardware drivers.
Handles Linux server installations.
Provides a development and runtime environment for Windows apps. (Correct answer)

Correct answer: Provides a development and runtime environment for Windows apps.

The .NET Framework is a software framework by Microsoft that provides a comprehensive development and runtime environment for Windows applications. It includes a vast class library and the Common Language Runtime (CLR), enabling developers to build various types of applications across different programming languages.

Question 43: What is the purpose of the SharePoint 2010 BDC (Business Data Connectivity) model?

Defines the schema and operations for connecting SharePoint to external data systems (Correct answer)
Configures the User Profile import schedule
Manages content type publishing across farms
Controls the display template for search results

Correct answer: Defines the schema and operations for connecting SharePoint to external data systems

A BDC model (BDCM file) defines external content types, their data source connections, and the CRUD operations available on external data.

Question 44: Which SQL Server 2008 DMV would you query to find queries currently executing on the server along with their execution plans?

sys.dm_exec_requests joined with sys.dm_exec_sql_text and sys.dm_exec_query_plan (Correct answer)
sys.dm_exec_query_stats
sys.dm_exec_procedure_stats
sys.dm_exec_cached_plans

Correct answer: sys.dm_exec_requests joined with sys.dm_exec_sql_text and sys.dm_exec_query_plan

Joining sys.dm_exec_requests with sys.dm_exec_sql_text and sys.dm_exec_query_plan provides both the SQL text and execution plan for actively running queries.

Question 45: In Active Directory, what is a 'trust' used for?

Allowing users in one domain to access resources in another domain (Correct answer)
Encrypting data between domain controllers
Managing DNS zone delegation
Replicating Group Policy Objects

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 46: Which WCF binding is optimized for cross-machine communication over TCP and is NOT suitable for internet-facing services?

NetTcpBinding (Correct answer)
WSHttpBinding
BasicHttpBinding
WebHttpBinding

Correct answer: NetTcpBinding

NetTcpBinding uses the TCP transport for efficient intranet communication but is not suitable for internet scenarios because TCP port 808 is typically blocked by firewalls.

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

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

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 48: A technician needs to configure Windows 7 to automatically install updates but allow users to choose when to restart. Which Windows Update setting should be selected?

Check for updates but let me choose whether to download and install them
Install updates automatically (Correct answer)
Download updates but let me choose whether to install them
Never check for updates

Correct answer: Install updates automatically

'Install updates automatically' downloads and installs updates on a schedule but prompts users before restarting.

Question 49: 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?

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

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 50: A user reports they cannot connect to SQL Server using Windows Authentication. The SQL Server error log shows 'Login failed for user. Reason: Token-based server access validation failed.' What is the MOST likely cause?

The TCP/IP protocol is disabled in SQL Server Configuration Manager
The user is not in the sysadmin fixed server role
The user's password has expired in Active Directory
The SQL Server service account does not have permission to query Active Directory for group membership (Correct answer)

Correct answer: The SQL Server service account does not have permission to query Active Directory for group membership

This error typically occurs when the SQL Server service account cannot contact a domain controller to validate the user's Windows group memberships for authorization.

Question 51: Which WCF service behavior must be enabled to allow clients to retrieve the service's WSDL metadata?

serviceAuthorization
serviceDebug
serviceThrottling
serviceMetadata (Correct answer)

Correct answer: serviceMetadata

The serviceMetadata behavior, with httpGetEnabled or httpsGetEnabled set to true, exposes the WSDL so clients can generate proxies.

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