MCTS Core Microsoft Technologies 2 — Questions and Answers
Question 1: Which Windows Server feature allows administrators to install only the components needed for a specific role, reducing the attack surface?
- Server Core (Correct answer)
- Hyper-V
- Windows Deployment Services
- Remote Desktop Services
Correct answer: Server Core
Server Core is a minimal installation option that reduces the attack surface by installing only essential components for specific server roles.
Question 2: In SQL Server, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads?
- Read Uncommitted
- Read Committed
- Repeatable Read (Correct answer)
- Serializable
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 3: What is the primary purpose of the Global Catalog in Active Directory?
- Storing all DNS records for the domain
- Providing a partial replica of all objects in the forest for fast searches (Correct answer)
- Managing FSMO roles across domains
- Authenticating users from external forests
Correct answer: Providing a partial replica of all objects in the forest for fast searches
The Global Catalog stores a partial replica of all objects in the Active Directory forest, enabling fast cross-domain searches and universal group membership resolution.
Question 4: Which .NET Framework class is used to execute a stored procedure and retrieve results in ADO.NET?
- SqlConnection
- SqlDataAdapter
- SqlCommand (Correct answer)
- DataSet
Correct answer: SqlCommand
SqlCommand is used to execute SQL statements and stored procedures against a SQL Server database in ADO.NET.
Question 5: In Windows PowerShell, what cmdlet is used to retrieve all running processes on a local computer?
- Get-Service
- Get-Process (Correct answer)
- Get-EventLog
- Get-WmiObject
Correct answer: Get-Process
Get-Process retrieves information about processes running on the local or remote computer.
Question 6: Which Microsoft technology provides a unified messaging platform that integrates email, voice mail, and fax into a single inbox?
- Microsoft Lync
- Exchange Server Unified Messaging (Correct answer)
- SharePoint Shared Services
- System Center Communications Manager
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 7: What does the 'volatile' keyword indicate in C#?
- The variable cannot be modified after initialization
- The variable can only be accessed within the class
- The variable may be modified by multiple threads simultaneously (Correct answer)
- The variable is stored in unmanaged memory
Correct answer: The variable may be modified by multiple threads simultaneously
The volatile keyword in C# tells the compiler that a field may be modified by multiple threads and prevents certain compiler optimizations that assume single-threaded access.
MCTS Core Microsoft Technologies 2
Which Windows Server feature allows administrators to install only the components needed for a specific role, reducing the attack surface?