Tell me about your experience with SQL and choosing the right database type for a data engineering solution.
Demonstrate your approach by analyzing the supplied workload data for active workloads during January 2026. Classify each workload using query mix, consistency requirements, processed rows, and latency.
workload_name, total_queries, read_percentage, average_latency_ms, average_rows_processed, recommended_database_typeworkload_name ascending| Column | Type | Description |
|---|---|---|
| workload_idPK | INT | Unique workload identifier |
| workload_name | VARCHAR(100) | Name of the data workload |
| business_domain | VARCHAR(60) | Business area associated with the workload |
| is_active | BOOLEAN | Whether the workload is currently active |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique query event identifier |
| workload_id | INT | Workload associated with the query event |
| occurred_on | DATE | Date when the query occurred |
| query_type | VARCHAR(20) | Query operation type, such as read or write |
| latency_ms | DECIMAL(10,1) | Observed query latency in milliseconds |
| rows_processed | INT | Number of rows processed by the query |
| consistency_required | BOOLEAN | Whether the query requires strong consistency |