Best Gemini prompts for Information Security Analysts

Given a dataset of network traffic logs from the past quarter, containing fields for source IP, destination IP, packet size, and timestamp, use SQL to identify the top 5 most common source IPs associated with malicious activity, and then use Python to generate a heatmap visualizing the distribution of these IPs over time, with a focus on identifying patterns and anomalies that may indicate advanced persistent threats. Assume the data is stored in a Snowflake database and the visualization will be displayed in Tableau.

Using a regression model built in Python/R to predict the likelihood of a data breach based on a set of input features, including user authentication metrics, network configuration, and system vulnerability data, optimize the model's hyperparameters to achieve a precision of at least 90% on a held-out test set, and then use SQL to generate a report detailing the top 10 most important features contributing to the model's predictions, along with their corresponding coefficients and p-values.

Design an ETL pipeline in Python to extract data from a set of network packet capture files, transform the data into a structured format, and load it into a Snowflake database for analysis, with a focus on detecting potential data exfiltration attempts, and then use Tableau to create a dashboard visualizing the top 5 most suspicious data transfer events, including source and destination IPs, packet sizes, and timestamps.

Using a dataset of security metrics, including mean time to detect (MTTD), mean time to respond (MTTR), and incident frequency, calculate a statistical summary of these metrics over the past year, including mean, median, standard deviation, and 95th percentile, and then use Python to generate a set of visualizations, including histograms, box plots, and scatter plots, to help identify trends and patterns in the data, with a focus on informing security operations and resource allocation decisions.