Scenario 01 — Logged-Out Web Scrape

Scenario

Yesterday, the Phantom Feed security team noticed unusual patterns in logged-out web traffic against the primary site web.phantomfeed.io. To investigate, you have been given a single day of HTTP logs (~170,000 rows) captured during the window of interest.

Your goal

Determine whether automated scraping is occurring against web.phantomfeed.io. If so, you should be able to answer:

What you may assume

The dataset

You will be querying a single SQLite table named phantomfeed_logs_logged_out. The console will auto-load it when you select this scenario. Click the Schema tab in the sidebar to see all columns with hints, or click Sample queries to load starter SQL.

Tips

Open the console for this scenario