The correct answer is A. Creating views to support repeat queries. CompTIA DataSys+ emphasizes that views are an effective way to improve performance, usability, and consistency when users frequently run complex queries against live production tables. A view is a virtual table based on a predefined SQL query that presents data in a simplified and reusable format without physically storing the data.
When analysts run complex queries directly against live tables, it can increase CPU usage, I/O operations, and locking contention, potentially impacting other users and critical workloads. By creating views, the database administrator can encapsulate complex joins, filters, and aggregations into a single logical object. Analysts can then query the view instead of repeatedly executing expensive SQL statements. This reduces query complexity, improves readability, and can lead to more predictable performance. DataSys+ highlights views as a best practice for supporting reporting and analytical workloads while minimizing disruption to transactional systems.
Option B, removing data redundancy, is related to normalization and data integrity, not query performance optimization for analysts. Option C, modifying the data in the table, risks data integrity issues and does not address performance concerns. Option D, deleting records from the table, may reduce table size but is not an appropriate or safe method for improving user query performance and can result in data loss.
CompTIA DataSys+ also notes that views can enhance security by limiting analysts’ access to only the required columns or rows, further protecting live data. In some implementations, indexed or materialized views can offer additional performance benefits for repeated queries.
Therefore, the best solution to improve analyst performance when running complex, repeat queries on live tables is creating views to support repeat queries, making option A the correct and fully verified answer.
