Extensions Ecosystem: PostGIS Quiz Home › PostgreSQL DBA › Extensions Ecosystem: PostGIS 🧩 Postgres Database Administration – Extensions Ecosystem: PostGIS 20 questions · 15 min timer · Explanations included · Free 1. In TimescaleDB, what is the purpose of continuous aggregates? To optimize the storage of large text fields. To enhance security by encrypting aggregates. To automatically update materialized views. To provide real-time data replication. None 1 out of 20 2. What is a best practice when using PG_Stat_Statements to monitor query performance? Disable it after collecting initial data. Enable it only during off-peak hours. Regularly review and optimize slow queries. Use it to replace all manual query tuning efforts. None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's up