MCM Cheat Sheet 2026

The 30 highest-yield MCM facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. Which quality improvement method is most applicable to cloud infrastructure & deployment in Microsoft Certified Master? → Plan-Do-Check-Act (PDCA) continuous improvement cycle
2. Which of the following is a core component of Exchange Server's transport pipeline? → Hub Transport server
3. What is the purpose of System Center Advisor? → Detecting configuration issues and providing recommendations.
4. When implementing incident response & disaster recovery practices, what should a MCM professional prioritize first? → Compliance with established standards and protocols
5. In Microsoft Certified Master, what role does automation & scripting fundamentals play in ensuring client/stakeholder satisfaction? → It builds trust through demonstrated competence and consistency
6. What ethical consideration is most relevant to incident response & disaster recovery in MCM practice? → Maintaining confidentiality and acting in the best interest of stakeholders
7. Which of the following best describes a key competency required for automation & scripting fundamentals in MCM certification? → Critical thinking and evidence-based decision making
8. What is the function of System Center Configuration Manager (SCCM)? → Managing devices, software deployment, and compliance.
9. Which ConfigMgr role must be installed before deploying operating systems using PXE boot? → Distribution Point with PXE enabled
10. A ConfigMgr administrator notices that client push installation fails on a subnet. After verifying firewall rules, what should be checked next? → Client Push Installation account has local admin rights on targets
11. 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? → Distributed Replay
12. Which protocol is used by Active Directory for communication? → LDAP
13. Which version of Exchange Server introduced Database Availability Groups (DAGs)? → Exchange Server 2010
14. Which of the following best describes a key competency required for cloud infrastructure & deployment in MCM certification? → Critical thinking and evidence-based decision making
15. In Exchange Server 2010, which feature allows a user's mailbox to reside on a passive database copy while still being accessible? → Mailbox Database Copy activation
16. In DPM, what action must be taken when a protected SQL Server database grows beyond the allocated protection volume size? → Run Disk Allocation modification to grow the replica and recovery point volume
17. Which SQL Server feature allows you to specify that a column should only store non-NULL values sparsely, reducing storage for columns that are mostly NULL? → SPARSE columns
18. In SQL Server, what does the NOLOCK table hint actually do at the engine level? → Reads data without acquiring any shared locks, allowing dirty reads
19. What is the significance of peer review in incident response & disaster recovery for MCM professionals? → It promotes accountability, knowledge sharing, and quality improvement
20. Which feature of Exchange Server helps prevent unwanted emails from reaching user mailboxes? → Anti-spam filtering.
21. 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? → Transparent Data Encryption (TDE)
22. What SQL Server mechanism automatically adjusts the memory grant for a query based on actual rows processed in previous executions of the same plan? → Memory Grant Feedback
23. Which authentication protocol does Active Directory use by default in Windows Server 2008 and later environments? → Kerberos v5
24. In SQL Server Service Broker, what is a 'conversation endpoint' used for? → Representing one side of a reliable message exchange between two services
25. In SQL Server AlwaysOn Availability Groups, what is the maximum number of synchronous-commit secondary replicas allowed? → 3
26. In Microsoft Certified Master, what role does cloud infrastructure & deployment play in ensuring client/stakeholder satisfaction? → It builds trust through demonstrated competence and consistency
27. Which tool is used to manage Active Directory on Windows Server? → Active Directory Users and Computers
28. An administrator configures a Receive Connector with the 'ExchangeUsers' permission group. What does this allow? → Authenticated SMTP submission from internal Exchange servers
29. Which of the following SQL Server components is responsible for database backup and recovery? → SQL Server Backup and Restore
30. In Microsoft Certified Master, what role does incident response & disaster recovery play in ensuring client/stakeholder satisfaction? → It builds trust through demonstrated competence and consistency