Best Perplexity prompts for Software Quality Assurance Analysts and Testers

Given a SQL query with multiple joins and subqueries, analyze the query plan and provide a step-by-step optimization strategy to reduce execution time, including index recommendations and rewriting subqueries as joins, assuming a Snowflake database with 100 million rows of data.

Create a comprehensive test suite for a Python data cleaning script that handles missing values, outliers, and data normalization, using a combination of unit tests and integration tests, and provide example test cases for each scenario, assuming a dataset with 10 features and 1000 samples.

Generate a detailed statistical summary of a regression model's performance, including metrics such as mean squared error, R-squared, and coefficient of variation, and provide a visual representation of the residuals and predicted values using Tableau, assuming a dataset with 5000 samples and 10 features.

Perform a thorough audit of an existing ETL pipeline, identifying bottlenecks, data quality issues, and opportunities for optimization, and provide a refactored pipeline design that incorporates data validation, error handling, and parallel processing, assuming a pipeline with 10 stages and 100 million rows of data.