Here you have the best IBM C2090-616 practice exam 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?
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.
Which of the following editions of DB2 include support for Federation with Oracle database?
The DB2 Developer Edition includes support for Federation with Oracle database. This edition is designed for development and thus includes comprehensive functionality, including features for database federation, which allows integrating data across multiple databases including Oracle.
Which three facilities are used to control authorization in DB2?
In DB2, authorization is controlled using privileges, authority levels, and Label-Based Access Control (LBAC) credentials. Privileges determine what actions users can perform, authority levels provide hierarchical administrative controls, and LBAC credentials provide fine-grained access control to data.
Which database object can be locked explicitly?
A table is a database object that can be explicitly locked. This is done using commands such as LOCK TABLE ... IN EXCLUSIVE MODE or LOCK TABLE ... IN SHARE MODE, which allow for specific control over how the table is accessed by different transactions. Rows, views, and indexes do not support explicit locking in the same way tables do.
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser