A security team wants to analyze VPC Flow Logs for potential data exfiltration. They need a solution that allows querying with SQL and requires minimal setup. Which approach should they take?
Trap 1: Ingest VPC Flow Logs into Chronicle and use YARA-L rules.
Chronicle requires additional licensing and configuration; YARA-L is not SQL.
Trap 2: Stream VPC Flow Logs to Cloud SQL using a custom pipeline.
Cloud SQL is not designed for log analysis; it would require custom ingestion and is less scalable.
Trap 3: Export VPC Flow Logs to Cloud Logging and use Log Analytics with…
Exporting VPC Flow Logs to Cloud Logging and querying with Log Analytics requires cross-cloud integration between AWS and Google Cloud, which adds significant configuration overhead and is not a native, minimal-setup solution for an AWS environment. This approach is tempting because Log Analytics with SQL is a familiar and powerful tool for analysing structured log data, and in a purely Google Cloud context (using VPC Flow Logs from GCP), it would be the straightforward choice.
- A
Ingest VPC Flow Logs into Chronicle and use YARA-L rules.
Why wrong: Chronicle requires additional licensing and configuration; YARA-L is not SQL.
- B
Stream VPC Flow Logs to Cloud SQL using a custom pipeline.
Why wrong: Cloud SQL is not designed for log analysis; it would require custom ingestion and is less scalable.
- C
Export VPC Flow Logs to BigQuery via a log sink, then run SQL queries.
This is the simplest way to enable SQL analysis on VPC Flow Logs with minimal setup.
- D
Export VPC Flow Logs to Cloud Logging and use Log Analytics with SQL.
Why wrong: Exporting VPC Flow Logs to Cloud Logging and querying with Log Analytics requires cross-cloud integration between AWS and Google Cloud, which adds significant configuration overhead and is not a native, minimal-setup solution for an AWS environment. This approach is tempting because Log Analytics with SQL is a familiar and powerful tool for analysing structured log data, and in a purely Google Cloud context (using VPC Flow Logs from GCP), it would be the straightforward choice.