Best ChatGPT prompts for Software Quality Assurance Analysts and Testers

Given a Snowflake database with 500+ tables, each with an average of 10 columns, and a set of 20 SQL queries that are currently being used in production, analyze the query plans and provide a ranked list of the top 5 queries that are most in need of optimization, along with specific recommendations for rewriting the queries to improve performance, including suggestions for indexing, caching, and partitioning. Assume that the database is currently experiencing an average query latency of 500ms, and that the goal is to reduce this latency by at least 30% through targeted optimization efforts.

Using a Python-based regression model that has been trained on a dataset of 10,000 samples, with 10 features and a single target variable, generate a comprehensive validation report that includes metrics such as mean squared error, R-squared, and mean absolute error, as well as a visual representation of the residuals and a summary of the model's performance on a holdout test set. Assume that the model is being used to predict continuous outcomes, and that the goal is to evaluate its performance and identify potential areas for improvement.

Given an ETL pipeline that ingests data from 5 different sources, performs data transformation and aggregation using a combination of Python and SQL, and loads the resulting data into a Snowflake database, design a data quality assessment framework that includes checks for data completeness, consistency, and accuracy, as well as metrics for measuring data freshness and latency. Provide a set of specific recommendations for improving data quality, including suggestions for data validation, data cleansing, and data normalization.

Using a Tableau dashboard that consists of 10 visualization components, each of which is connected to a separate data source, generate a statistical summary of the dashboard's performance, including metrics such as data fetch time, rendering time, and user engagement metrics such as click-through rate and time on page. Assume that the dashboard is being used to support business decision-making, and that the goal is to identify areas for improvement and optimize the dashboard for faster performance and better user experience.