Cheat sheet
Microsoft SC-200 Cheat Sheet
Manage SecOps Environment
- 40-45% of exam
- Automation Config Sentinel Platform Data Connectors Detections Analytics Rules Defender for Endpoint
Respond to Incidents
- 35-40% of exam
- XDR Investigation Endpoint Actions Copilot for Security Defender Workloads M365 Activities Case Management
Perform Threat Hunting
- 20-25% of exam
- KQL Operators Advanced Hunting Tables Sentinel Graph Hunting Queries Data Lake Jobs Notebooks + MCP
Quick Facts
- Exam SC-200
- Credential Security Operations Analyst
- Time 100 min
- Questions 40-60
- Pass 700/1000
- Fee $165 USD
- Level Associate
- Blueprint Apr 16 2026
Analytics Rule Types SE
- Scheduled NRT Security TI ML
- Scheduled: KQL NRT: ~1 min Security: promote TI: IOC ML: anomaly
Analytics vs Automation Rule SE
Analytics Rule
- Detects threats
- Creates alerts
- KQL/ML logic
Automation Rule
- Triggers on incident
- Assigns/tags/closes
- Calls playbooks
- Detect vs orchestrate
Which Sentinel Rule SE
- Custom KQL logic → Scheduled rule ( Interval )
- Lowest latency alert → NRT rule ( ~1 min )
- Promote Defender alerts → Microsoft security rule ( Built-in )
- Match IOC feed → Threat intelligence rule ( Indicators )
- Multi-stage correlation → Fusion ( ML built-in )
- Behavior baseline → Anomaly rule ( ML/UEBA )
- Pre-aggregate big data → Summary rule ( Data lake )
XDR Automation SE
- AIR Automated investigation response
- Attack disruption Auto-contain in-progress attack
- Automation level Full vs semi remediation
- ASR rules Block risky behaviors
- Email notifications Incident/threat alerts
- Alert tuning Suppress/correlate alerts
- Device groups Scope automation/RBAC
- Live response Remote device shell
Sentinel Tiers SE
- Analytics -> Data lake -> XDR
- Analytics: hot Data lake: cheap XDR: Defender tables
Playbook vs Automation Rule SE
Playbook
- Logic App workflow
- External actions
- Reusable steps
Automation Rule
- Native conditions
- Sequences playbooks
- No-code routing
- Workflow vs router
Which Data Connector SE
- Windows security events → Security Events AMA ( DCR scoped )
- No agent allowed → WEF ( Event forwarding )
- Linux logs → Syslog via AMA ( RFC syslog )
- Firewall/appliance → CEF via AMA ( Common format )
- Azure resource logs → Diagnostic settings ( Activity )
- External IOC feed → TI connector ( TAXII/API )
- Custom app data → Custom log table ( Ingestion API )
Sentinel Platform SE
- Workspace Log Analytics backing
- Analytics tier Hot interactive queries
- Data lake tier Cheap long retention
- XDR tier Defender table retention
- Sentinel roles Reader/Responder/Contributor
- Workbooks Visualization dashboards
- SOC optimization Coverage/cost tuning
- Watchlists Reference enrichment data
Domain Order SE
- Manage 40-45 Respond 35-40 Hunt 20-25
- Manage: build Respond: act Hunt: search
Defender XDR vs Sentinel SE
Defender XDR
- Microsoft-only signals
- Native correlation
- Auto remediation
Sentinel
- Any source SIEM
- Custom KQL rules
- SOAR + workbooks
- XDR vs SIEM
Data Connectors SE
- AMA Azure Monitor Agent
- Security Events AMA Windows security events
- WEF Windows Event Forwarding
- Syslog via AMA Linux/network logs
- CEF via AMA Appliance common format
- DCR Data collection rule
- Azure activity Diagnostic settings
- Custom log tables Bespoke ingestion
NRT vs Scheduled Rule SE
NRT
- ~1 min latency
- One table only
- No lookback join
Scheduled
- Interval cadence
- Complex joins
- Lookback window
- Speed vs flexibility
Analytics Rule Types SE
- Scheduled KQL on interval
- NRT Near-real-time, ~1 min
- Microsoft security Promote Defender alerts
- Threat intelligence Match IOC indicators
- Anomaly ML baseline deviation
- Fusion Multi-stage correlation
- Entity mapping Tie rows to entities
- Incident grouping Alerts into incident
Threat Intelligence SE
- Indicator (IOC) IP/URL/hash/domain
- TI connector TAXII or upload API
- ThreatIntelligenceIndicator Sentinel IOC table
- TI analytics rule Match logs to IOC
- MITRE ATT&CK Tactic/technique mapping
- Threat analytics XDR campaign reports
- UEBA Behavior anomaly scoring
- Custom detection Hunting query to rule
Endpoint Actions IN
- Isolate Collect Live Restrict
- Isolate: contain Collect: forensics Live: shell Restrict: allowlist
Incident vs Alert IN
Alert
- Single detection
- One signal
- Rule output
Incident
- Grouped alerts
- Full attack story
- Investigation unit
- Signal vs case
Which Defender Product IN
- Endpoint malware → Defender for Endpoint ( EDR )
- Phishing email → Defender for Office 365 ( Email )
- On-prem AD attack → Defender for Identity ( Lateral move )
- Risky SaaS app → Defender for Cloud Apps ( CASB )
- Risky sign-in → Entra ID Protection ( Identity risk )
- VM/container threat → Defender for Cloud ( Workload )
- Data exfil/audit → Purview ( Compliance )
- Cross-product attack → Defender XDR ( Correlation )
Defender XDR Products IN
- Defender XDR Unified portal correlation
- Defender Endpoint Device EDR
- Defender Identity On-prem AD signals
- Defender Office 365 Email/collab threats
- Defender Cloud Apps SaaS/CASB control
- Entra ID Protection Risky users/sign-ins
- Defender for Cloud Workload protection
- Purview Data/audit signals
Pick Response Action IN
- Active C2 device → Isolate device ( Contain )
- Need forensics → Collect package ( Evidence )
- Hands-on triage → Live response ( Remote shell )
- Unknown binary → Restrict app exec ( Allowlist )
- Compromised mailbox → Disable user + reset ( Identity )
- Malicious email → Soft delete ( O365 action )
- Repetitive triage → Automation rule ( SOAR )
Response Actions IN
- Isolate device Cut network access
- Live response Remote investigation shell
- Collect package Investigation forensic bundle
- Restrict app exec Allow signed only
- Soft delete email Office 365 remediation
- Disable user Block Entra identity
- Confirm compromised Raise user risk
- Case management Track incident lifecycle
Defender for Cloud IN
- Secure score Posture percentage
- Recommendation Hardening action
- Defender plan Workload protection toggle
- Servers plan VM EDR + alerts
- Containers plan AKS/registry threats
- JIT VM access Time-boxed port open
- FIM File integrity monitoring
- Exemption Waive recommendation
Copilot for Security IN
- Embedded experience Inside Defender portal
- Standalone portal securitycopilot.microsoft.com
- Agentic AI Autonomous investigation steps
- Incident summary Auto narrative writeup
- Promptbook Reusable prompt sequence
- Plugins Connect data sources
- SCU Security compute unit
- SC-5006 Applied Skills credential
KQL Pipeline TH
- Where -> Project -> Summarize -> Join
- where: filter project: columns summarize: aggregate join: combine
Workbook vs Hunting Query TH
Workbook
- Visual dashboard
- Monitor trends
- Shared view
Hunting Query
- Proactive search
- Find unknown threats
- Bookmark evidence
- Visualize vs search
KQL Operators TH
- where Filter rows
- project Select/rename columns
- extend Add computed column
- summarize Aggregate by group
- join Combine two tables
- union Stack multiple tables
- ago() Relative time window
- bin() Bucket timestamps
- evaluate Plugin (parse, bag)
- let Reusable variable
Analytics vs Data Lake TH
Analytics tier
- Hot interactive
- Real-time rules
- Higher cost
Data lake tier
- Cheap retention
- KQL jobs/batch
- Long-term hunt
- Hot vs cold
Advanced Hunting Tables TH
- DeviceEvents Endpoint activity
- DeviceProcessEvents Process creation
- DeviceNetworkEvents Endpoint connections
- EmailEvents Office 365 mail flow
- IdentityLogonEvents On-prem AD logons
- SigninLogs Entra ID sign-ins
- AlertEvidence Alert-linked entities
- SecurityIncident Sentinel incidents
Sentinel Hunting TH
- Hunting query Proactive saved KQL
- Bookmark Save hunt evidence
- Livestream Active query session
- Sentinel Graph Entity relationship map
- Blast radius Impact spread view
- KQL jobs Data lake batch query
- Summary rules Pre-aggregate tables
- Notebooks + MCP Sentinel MCP Server hunt
Common Traps
Detect vs orchestrate
- Analytics rule detects ≠ Automation rule responds
Workflow vs router
- Playbook runs steps ≠ Automation rule sequences
Signal vs case
- Alert is one signal ≠ Incident groups alerts
XDR vs SIEM
- XDR Microsoft sources ≠ Sentinel any source
Speed vs flexibility
- NRT one table ≠ Scheduled joins/lookback
Hot vs cold
- Analytics interactive ≠ Data lake batch jobs
Identity owner
- Defender Identity on-prem ≠ Entra Protection cloud
Last Minute
- 1. Weights: 40-45 / 35-40 / 20-25
- 2. Analytics = detect; Automation = respond
- 3. Playbook = Logic App workflow
- 4. NRT = ~1 min, one table
- 5. Alert = signal; Incident = case
- 6. XDR = Microsoft; Sentinel = any source
- 7. Isolate device = contain C2
- 8. Defender Identity = on-prem AD
- 9. Data lake = cheap long retention
- 10. TI rule matches IOC indicators
- 11. Sentinel Graph = entity relationships
- 12. Copilot embedded in Defender portal
Microsoft Certified: Security Operations Analyst Associate (SC-200)
- Practice Questions 100 questions Study Guide 18 topics Cheat Sheet 98 facts Flashcards 50 cards Videos 1 video Blogs 1 blog Free CE Podcast