Coding Exercise: Monitor Failed Job Counts by Server
Explore how to write SQL queries that join datasets, filter records, and aggregate failed job counts by server location. This lesson helps you practice key data engineering skills like data querying and performance analysis to support operational decision-making.
We'll cover the following...
We'll cover the following...
Scenario
As a junior data engineer at a cloud services company, you monitor job performance across various servers. Your team wants a quick report showing which servers have the most failed jobs, so they can investigate potential issues and optimize workload distribution.
Dataset
...Jobs
job_id | server_id | status | run_time |
1 | 101 | success | 32 |
2 | 102 | failed | 18 |
3 | 101 | failed | 25 |
4 | 103 | success | 41 |
5 | 102 | failed | 20 |
...