Book Image

Microsoft Security Operations Analyst Exam Ref SC-200 Certification Guide

By : Trevor Stuart, Joe Anich
Book Image

Microsoft Security Operations Analyst Exam Ref SC-200 Certification Guide

By: Trevor Stuart, Joe Anich

Overview of this book

Security in information technology has always been a topic of discussion, one that comes with various backgrounds, tools, responsibilities, education, and change! The SC-200 exam comprises a wide range of topics that introduce Microsoft technologies and general operations for security analysts in enterprises. This book is a comprehensive guide that covers the usefulness and applicability of Microsoft Security Stack in the daily activities of an enterprise security operations analyst. Starting with a quick overview of what it takes to prepare for the exam, you'll understand how to implement the learning in real-world scenarios. You'll learn to use Microsoft's security stack, including Microsoft 365 Defender, and Microsoft Sentinel, to detect, protect, and respond to adversary threats in your enterprise. This book will take you from legacy on-premises SOC and DFIR tools to leveraging all aspects of the M365 Defender suite as a modern replacement in a more effective and efficient way. By the end of this book, you'll have learned how to plan, deploy, and operationalize Microsoft's security stack in your enterprise and gained the confidence to pass the SC-200 exam.
Table of Contents (19 chapters)
1
Section 1 – Exam Overview and Evolution of Security Operations
4
Section 2 – Implementing Microsoft 365 Defender Solutions
8
Section 3 – Familiarizing Yourself with Alerts, Incidents, Evidence, and Dashboards
13
Section 4 – Setting Up and Connecting Data Sources to Microsoft Sentinel
15
Section 5 – Hunting Threats within Microsoft 365 Defender and Microsoft Sentinel

Kusto query overview

Let's talk about Kusto queries. These are read-only requests for data that you define in the query itself, so think of it as a PowerShell get cmdlet. You're simply asking to retrieve information, as defined in the query. If you're familiar with SQL, then Kusto should be easy for you to pick up as it's similar to the database, table, and column hierarchy.

First, we need to figure out a place to start. Looking at the schema, we have a handful of table descriptions that show the available tables. We have Alerts, Apps and Identities, Email, Devices, and Threat and Vulnerability Management. Let's start with DeviceEvents, which can be found under Devices, as shown in the following screenshot:

Figure 11.1 – Advanced hunting column categories

The following is a sample query that we'll break down quickly. We'll start with a table called DeviceEvents that contains all sorts of events that take place on...