Which is better?

The city of Chicago receives many 311 service requests throughout the day. 311 service requests are non-urgent community requests, ranging from graffiti removal to street light outages. Chicago maintains a data repository of all these services organized by type of requests. In this exercise, Potholes has been loaded as an example of a table in this repository. It contains pothole reports made by Chicago residents from the past week.

Explore the dataset. What data processing approach is this larger repository most likely using?

Possible answers

OLTP because this table could not be used for any analysis.

OLAP because each record has a unique service request number.

OLTP because this table's structure appears to require frequent updates.

OLAP because this table focuses on pothole requests only.

Exercise

Which is better?

Instructions

Possible answers