MCTS Core Microsoft Technologies 2

Question 1

Which Windows Server feature allows administrators to install only the components needed for a specific role, reducing the attack surface?

Accepted Answer

Server Core

Answer

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?

Accepted Answer

Repeatable Read

Answer

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?

Accepted Answer

Providing a partial replica of all objects in the forest for fast searches

Answer

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?

Accepted Answer

SqlCommand

Answer

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?

Accepted Answer

Get-Process

Answer

Get-Process retrieves information about processes running on the local or remote computer.

(MCTS) Microsoft Certified Technology Specialist Practice Test

(MCTS) Microsoft Certified Technology Specialist Practice Test

MCTS Core Microsoft Technologies 2