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?
Given the requirements of handling long, complex queries, significant data size, and the need for optimized storage on disk, DB2 Advanced Enterprise Server Edition is the best choice. This edition includes advanced features such as BLU Acceleration, which is specifically designed to efficiently execute complex queries with groupings and aggregations by using columnar storage and in-memory processing. Additionally, it does not have the resource limitations that other editions such as Express-C or Workgroup Server Edition might have, ensuring the system can handle the size and expected growth of the database.
Correct Answer: D Because the database consumes 5TB only the advanced editions do not have resource limitations. An enterprise edition is needed for Analytics and BLU.
The good answer is "D. DB2 Advanced Enterprise Server Edition". DB2 Express-C is died in the version 11.1. DB2 Workgroup Server Edition is an appropriated edition of DB2 for a smal business. DB2 Enterprise Server Edition is most appropriate for medium-to-large enterprise-wide solutions with hundreds of users but is not most appropriated to run long, complex queries that select a subset of columns perform grouping and aggregation. Indeed, Advanced Workgroup Server Edition, Advanced Enterprise Server Edition and DIrect Advanced Edition are the only editions which offer "DB2 - Blu - table organized by column" feature to accelerate long, complex queries that select a subset of columns and often perform grouping and aggregation. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/c0058536.html