A hospital data analyst is ready to retrieve patient satisfaction data from six months of collection. Which data retrieval tool should be used?

A hospital data analyst is ready to retrieve patient satisfaction data from six months of collection. Which data retrieval tool should be used?

• A. Spreadsheets
• B. CRM system
• C. SQL
• D. Data warehouse

Answer: (C)

SQL is the best choice because it’s built to retrieve structured data from relational tables. In a hospital setting, patient satisfaction data is usually stored across multiple related tables (surveys, responses, patients, dates, departments, providers). To pull six months’ worth of data, you need to filter by date, possibly join related tables to bring in context, and compute summaries (like average satisfaction or response counts). SQL handles all of this in one flexible query: select the needed fields, join the necessary tables, apply a date range filter, group by the dimensions you care about, and calculate the aggregates. It scales well to large datasets and can leverage indexes for faster results. Spreadsheets become unwieldy with large volumes and complex joins; a CRM system is focused on managing interactions rather than performing multi-table analyses over a time window; a data warehouse stores historical data and is accessed via SQL or BI tools—but the retrieval tool you use to extract the data is SQL itself.

SQL is the best choice because it’s built to retrieve structured data from relational tables. In a hospital setting, patient satisfaction data is usually stored across multiple related tables (surveys, responses, patients, dates, departments, providers). To pull six months’ worth of data, you need to filter by date, possibly join related tables to bring in context, and compute summaries (like average satisfaction or response counts). SQL handles all of this in one flexible query: select the needed fields, join the necessary tables, apply a date range filter, group by the dimensions you care about, and calculate the aggregates. It scales well to large datasets and can leverage indexes for faster results. Spreadsheets become unwieldy with large volumes and complex joins; a CRM system is focused on managing interactions rather than performing multi-table analyses over a time window; a data warehouse stores historical data and is accessed via SQL or BI tools—but the retrieval tool you use to extract the data is SQL itself.