IBM C2090-616 Exam Actual Questions

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?

Correct Answer: Explanation 🗳️
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1304whatsnewdb2105/index.html

Which of the following editions of DB2 include support for Federation with Oracle database?

Correct Answer: C 🗳️
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html

Which three facilities are used to control authorization in DB2?

Correct Answer: D 🗳️
Reference: https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_9.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0006307.html

Which database object can be locked explicitly?

Correct Answer: D 🗳️
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html