IBM C2090-614 dumps - 100% Pass Guarantee!

A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?

A. Drop the current data type mapping.

Create the new data type mapping.

B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.

C. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.

D. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.

A storage group named MED_SG was created as follows:

CREATE STOGROUP med_sg ON db2fs1 db2fs2 '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD db2fs4 ALTER STOGROUP med_sg ADD db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?

A. ALTER TABLESPACE ts1 REBALANCE

B. ALTER STOGROUP med_sg ADD db2fs5ALTER STOGROUP med_sg ADD db2fs5

C. ALTER STOGROUP med_sg DROP '/db2fs4'

D. ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE

A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:

What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID

B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID

C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in the REPL_SALES table, and collect statistics on REPL_SALES table.

D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.

Which type of storage is utilized in the implementation of an effective and flexible multi- temperature database?

A. System managed storage

B. Automatic storage utilizing storage groups

C. System managed storage utilizing storage groups

D. Database managed storage with file system caching

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

A. Data class, work class, and a limit

B. Data class, action class, and a threshold

C. Service subclass, action class, and a limit

D. Service subclass, work class, and a threshold