Vendor: IBM
Certifications: IBM Certified Advanced Database Administrator
Exam Name: DB2 10.1 Advanced DBA for Linux UNIX and Windows
Exam Code: C2090-614
Total Questions: 108 Q&As
Last Updated: Mar 15, 2024
Note: Product instant download. Please sign in and click My account to download your product.
VCE
IBM C2090-614 Last Month Results
C2090-614 Q&A's Detail
Exam Code: | C2090-614 |
Total Questions: | 108 |
CertBus Has the Latest C2090-614 Exam Dumps in Both PDF and VCE Format
C2090-614 Online Practice Questions and Answers
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
Add Comments
I'm very happy that I have passed the C2090-614 exam with high score. I will share this good dumps with my friend. You can trust on it.
Before attending the exam, I have studied every question and answer. when i seated for exam, I felt confident in every question. At last, I passed the exam with high score without doubt.Thanks for this valid dumps.
thanks god and thank you all. 100% valid. you can trust on it.
Great dumps! I achieved high score with the help of this dumps, I will continue use this dumps and introduce it to others.
Thanks for your help. I passed my exam yesterday with the full points! Great job.
Now, I'm very happy that I have passed the C2090-614 exam in the morning. Thanks for my friend introducing the good dumps to me. I will also recommend the dumps to others.
Passed yesterday..more than 75% questions came from this dumps.. So happy.
I'm so glad that I have chosen you as my assistant with my C2090-614 exam. I passed my exam. Full scored. I will recommend to friends.
A valid dumps. It helped me pass the exam in short time. Thanks a million.
hi guys I had my exam yesterday and passed. It is really a good dumps. Thanks very much.