Best Gemini prompts for Computer Systems Analysts

Given a SQL query that joins three tables - customers, orders, and products - and filters on order date and product category, analyze the query plan and provide recommendations to improve performance. Assume the database is hosted on Snowflake and the query is executed daily. Consider factors such as table indexing, data distribution, and join order. Provide a rewritten query that incorporates these optimizations and estimate the potential performance gain.

Interpret the results of a linear regression model built using Python and scikit-learn, where the target variable is customer churn and the features include demographic data, usage metrics, and transaction history. Provide a detailed analysis of the coefficients, p-values, and R-squared value, and discuss the implications of the model's findings on our business strategy. Assume the model has been trained on a dataset of 10,000 customer records and evaluated on a holdout set of 2,000 records.

Design an ETL pipeline to integrate data from three sources - a MySQL database, an API endpoint, and a CSV file - into a unified data warehouse hosted on Google BigQuery. The pipeline should handle data transformation, data quality checks, and error handling, and provide a data dictionary that describes the resulting dataset. Assume the data is loaded daily and the pipeline is executed using Apache Beam.

Develop a data cleaning script using Python and Pandas to handle missing values, outliers, and data inconsistencies in a dataset containing customer feedback survey responses. The script should include data profiling, data transformation, and data validation steps, and provide a report on the number of records cleaned and the distribution of cleaned data. Assume the dataset contains 50,000 records and 20 features, and the script will be executed monthly.