A. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
B. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
C. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
D. The IMPORT utility is now deprecated and INGEST is the recommended alternative.
A. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.
B. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.
C. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.
D. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.
A. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.
B. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.
C. DB2 LBAC monitors table data access and tables modifications made by database users.
D. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.
A. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into DB2 tables.
B. Implementation of a row and column access control policy is transparent to applications accessing the database.
C. HADR with multiple standbys supports reads on all standby databases.
D. WLM is not supported in DB2 pureScale environments.
