Courseiva
← SC-200
Full test
mediummultiple choiceObjective-mapped

A SOC analyst creates a watchlist in Microsoft Sentinel from a CSV file containing IP ranges (10.0.0.0/16) and a tag. The analyst wants to use this watchlist in a KQL query to check if a sign-in IP is within the ranges. Which KQL function should be used?

Question 1mediummultiple choice
Full question →

A SOC analyst creates a watchlist in Microsoft Sentinel from a CSV file containing IP ranges (10.0.0.0/16) and a tag. The analyst wants to use this watchlist in a KQL query to check if a sign-in IP is within the ranges. Which KQL function should be used?

Full question →

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Distractor review

_GetWatchlist('name') and use the has operator

The has operator checks if a string contains a substring, not if an IP falls within a CIDR range. It would not handle IP range logic correctly.

B

Distractor review

_GetWatchlist('name') and use the in operator

The in operator checks equality against a list of exact values. It cannot evaluate IP ranges dynamically; it would only match an exact IP listed, not a range.

C

Best answer

_GetWatchlist('name') and use the ipv4_is_in_range function with the watchlist as a parameter

ipv4_is_in_range(stringIP, stringRange) evaluates whether the IP is within the CIDR range. By passing the watchlist values, the analyst can match sign-in IPs against the stored ranges.

D

Distractor review

_GetWatchlist('name') and use the contains operator

contains is a substring search, not suitable for IP range matching. It would incorrectly match IPs if the range string appears as a substring of the IP, which is not intended.

Common exam trap

Common exam trap: usable hosts are not the same as total addresses

Subnetting questions often tempt you into counting all addresses. In normal IPv4 subnets, the network and broadcast addresses are not usable host addresses.

Technical deep dive

How to think about this question

Subnetting questions test whether you can identify the network, broadcast address, usable range, mask and correct subnet. Slow down enough to calculate the block size correctly.

KKey Concepts to Remember

  • CIDR notation defines the prefix length.
  • Block size helps identify subnet boundaries.
  • Network and broadcast addresses are not usable hosts in normal IPv4 subnets.
  • The required host count determines the smallest suitable subnet.

TExam Day Tips

  • Write the block size before choosing the subnet.
  • Check whether the question asks for hosts, subnets or a specific address range.
  • Do not confuse /24, /25, /26 and /27 host counts.

Related practice questions

Related SC-200 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

SC-200 fundamentals practice questions

Practise SC-200 questions linked to SC-200 fundamentals.

SC-200 scenario practice questions

Practise SC-200 questions linked to SC-200 scenario.

SC-200 troubleshooting practice questions

Practise SC-200 questions linked to SC-200 troubleshooting.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

Question 1

A Microsoft Sentinel scheduled analytics rule detects impossible travel but creates too many duplicate incidents for the same user within a short period. Which two rule settings should you tune? (Choose 2.)

Question 2

A phishing email was delivered to several users. The analyst wants to find all messages in the campaign, see delivery actions, and perform remediation from the Microsoft 365 Defender portal. Which tool should they use?

Question 3

A security analyst in Microsoft Defender for Cloud receives an alert that an Azure VM has a vulnerability with a high severity. The analyst wants to see the detailed finding, including the steps to remediate. Which blade or page should the analyst open?

Question 4

A company uses Microsoft Defender for Cloud to protect an Azure Kubernetes Service (AKS) cluster. The security team wants to receive security alerts about suspicious activities within the cluster, such as a container running with root privileges or attempts to read sensitive host paths. Which Defender for Cloud plan must be enabled to generate these alerts?

Question 5

A security analyst is configuring Microsoft Sentinel scheduled analytics rules to detect brute-force attacks on Microsoft Entra ID. Arrange the steps in the correct order from first to last.

Question 6

An organization uses Microsoft 365 Defender. A security analyst is investigating a malware incident on a user's device. The automated investigation and response (AIR) has already isolated the device from the network. The analyst now needs to collect a copy of a specific suspicious file from the device for further analysis. Which action should the analyst initiate from the device's entity page?

FAQ

Questions learners often ask

What does this SC-200 question test?

CIDR notation defines the prefix length.

What is the correct answer to this question?

The correct answer is: _GetWatchlist('name') and use the ipv4_is_in_range function with the watchlist as a parameter — The watchlist stores the range as a string (e.g., '10.0.0.0/16'). To check if an IP address falls within a CIDR range, the ipv4_is_in_range function is designed for this purpose. The has operator is for string containment, in is for exact match or list, and contains also does substring matching. Therefore, ipv4_is_in_range is correct.

What should I do if I get this SC-200 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.