Mixed Deck — All MCM Topics Flashcards
100 cards from real MCM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 20 Mixed Deck — All MCM Topics flashcards as text
Which Active Directory feature allows you to restore accidentally deleted objects without restoring from backup?
Answer: Active Directory Recycle Bin
The Active Directory Recycle Bin, introduced in Windows Server 2008 R2, allows full restoration of deleted objects with all attributes intact.
What is the primary purpose of cloud infrastructure & deployment in the context of Microsoft Certified Master?
Answer: To ensure consistent quality and professional accountability
Cloud Infrastructure & Deployment in Microsoft Certified Master primarily ensures consistent quality and professional accountability, forming the foundation of competent practice in this field.
What is the recommended approach for high availability of the SharePoint Distributed Cache service?
Answer: Running multiple Distributed Cache service instances with AppFabric cache clustering
AppFabric (Windows Server AppFabric) supports a cache cluster where multiple Distributed Cache hosts share and replicate cached data, providing redundancy if one node fails.
What is the primary purpose of automation & scripting fundamentals in the context of Microsoft Certified Master?
Answer: To ensure consistent quality and professional accountability
Automation & Scripting Fundamentals in Microsoft Certified Master primarily ensures consistent quality and professional accountability, forming the foundation of competent practice in this field.
Which attribute in Active Directory stores the Kerberos principal name used for service authentication?
Answer: servicePrincipalName
The servicePrincipalName (SPN) attribute links a service to the account under which it runs, enabling Kerberos service ticket issuance.
Which Exchange 2010 high-availability component automatically reseeds a failed database copy after disk replacement?
Answer: AutoReseed
AutoReseed detects disk failures in a DAG and automatically initiates a reseed of the affected database copy from a healthy source copy.
Which of the following SQL Server components is responsible for database backup and recovery?
Answer: SQL Server Backup and Restore
SQL Server Backup and Restore is a fundamental feature set within SQL Server that provides mechanisms for creating copies of databases and transaction logs, and subsequently restoring them in case of data loss or corruption. This ensures data recoverability and business continuity, protecting against system failures or accidental deletions.
What is the function of System Center Configuration Manager (SCCM)?
Answer: Managing devices, software deployment, and compliance.
System Center Configuration Manager (SCCM) is a powerful management solution that enables IT administrators to manage a large number of Windows-based computers. Its core functions include software deployment, patch management, operating system deployment, hardware and software inventory, and compliance settings management across the enterprise.
Which PowerShell cmdlet can be used to check the replication status of all domain controllers in a forest?
Answer: Get-ADReplicationFailure
Get-ADReplicationFailure returns replication failure information for domain controllers, showing errors and their counts across the environment.
In SCSM, a Configuration Item (CI) represents what type of object in the CMDB?
Answer: Any manageable component in the IT environment that needs to be tracked and controlled
A Configuration Item (CI) in SCSM's CMDB represents any component — hardware, software, service, or relationship — that must be tracked to deliver IT services.
What is the function of the Request Management Service introduced in SharePoint Server 2013?
Answer: Routing incoming HTTP requests based on rules to appropriate SharePoint servers or throttling abusive clients
Request Management enables fine-grained routing and throttling of incoming HTTP requests based on configurable rules, improving farm performance and protecting against abusive traffic.
What is the significance of peer review in incident response & disaster recovery for MCM professionals?
Answer: It promotes accountability, knowledge sharing, and quality improvement
Peer review promotes accountability, knowledge sharing, and quality improvement by allowing MCM professionals to benefit from collective expertise and identify areas for growth.
What Exchange 2010 feature throttles resource consumption per user to prevent a single client from degrading server performance?
Answer: Client Throttling Policy
Client Throttling Policies define per-user resource budgets (connections, CPU time, RPC operations) and throttle clients that exceed those budgets.
What is a common challenge professionals face when applying incident response & disaster recovery principles in Microsoft Certified Master?
Answer: Balancing theoretical knowledge with practical application
Balancing theoretical knowledge with practical application is a well-recognized challenge, as real-world scenarios often present complexities not covered in standard training.
In SQL Server, what happens to a transaction that encounters a deadlock?
Answer: The transaction with the lowest deadlock priority is chosen as the victim and rolled back
SQL Server's deadlock monitor selects a victim based on the lowest deadlock priority (SET DEADLOCK_PRIORITY) and, if equal, the transaction that is cheapest to roll back.
What does the 'Protected Users' security group in Windows Server 2012 R2 and later prevent its members from using?
Answer: NTLM, DES, RC4 Kerberos, and credential delegation
Members of the Protected Users group cannot authenticate via NTLM, use DES or RC4 Kerberos encryption, use unconstrained delegation, or have credentials cached.
Which SQL Server feature allows a DBA to capture a workload on a production server and replay it on a test server for performance analysis?
Answer: Distributed Replay
Distributed Replay captures a workload trace and replays it across multiple client machines to simulate concurrent production load on a test server.
Which SQL Server feature enables you to encrypt data at rest by encrypting the entire database files, including log files, using a Database Encryption Key?
Answer: Transparent Data Encryption (TDE)
TDE encrypts the entire database at the file level using a Database Encryption Key, protecting data at rest without requiring application changes.
Which SQL Server execution plan operator indicates that the query optimizer chose to perform a Hash Join but at runtime switched to a nested-loop join due to a row count underestimate?
Answer: Adaptive Join operator
The Adaptive Join operator (SQL Server 2017+) defers the join type decision until after the build-side rows are counted, switching between Hash Join and Nested Loops based on actual row count vs. the adaptive threshold.
In SQL Server, which type of index is stored separately from the data pages and contains a copy of selected columns from the base table?
Answer: Nonclustered index
A nonclustered index is a separate structure from the heap or clustered index, containing the indexed key columns plus a row locator back to the base data.