IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 5

You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year.
Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?

Answer options

Correct answer:

Explanation

The DB2 Advanced Enterprise Server Edition is designed to handle large databases and complex queries efficiently, making it suitable for applications with significant data processing needs. The other editions, while capable, may not provide the same level of performance optimization and data management features necessary to minimize disk usage for complex queries and large datasets.