PDF Version DemoIBM C2090-541 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | Assessment: DB2 9.7 DBA for Linux, UNIX and Windows |
| Exam Number: | A2090-541 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX and Windows |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Multiple Response |
| Exam Price: | USD 200 |
| Passing Score: | 61% |
| Real Exam Qty: | 64 |
| Available Languages: | English |
| Certificate Validity Period: | No fixed validity period (certification retired) |
| Sample Questions: | IBM C2090-541 Sample Questions |
| Exam Way: | Assessment delivered through IBM certification testing via authorized Pearson VUE testing centers. |
| Pre Condition: | The assessment is intended for candidates preparing for the IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX and Windows certification and generally assumes knowledge equivalent to the DB2 Fundamentals certification. |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ |
IBM C2090-541 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Performance Monitoring and Problem Determination | - Monitor database performance and resource utilization - Identify and resolve common database issues - Use DB2 diagnostic and monitoring tools |
| Database Creation and Configuration | - Create databases and configure database settings - Manage automatic storage and storage groups - Configure instance and database manager parameters |
| Backup, Recovery and High Availability | - Understand high availability and disaster recovery solutions - Implement backup and recovery strategies - Perform restore and rollforward recovery |
| Database Objects and Security | - Create and manage table spaces and database objects - Configure authentication, authorization and privileges - Manage schemas, indexes and views |
| Maintenance and Data Movement | - Execute REORG and RUNSTATS utilities - Perform routine database maintenance tasks - Import, export and load data |
| Planning and Installing DB2 | - Create and configure DB2 instances - Plan installation requirements and prerequisites - Install and upgrade DB2 products |
IBM DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
1. A database named FINANCE resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which two actions must be performed before a backup image can be created in this manner? (Choose two.)
A) Workload Manager must be installed on the server.
B) DB2 Advanced Copy Services (ACS) must be installed, activated, and configured.
C) The TOOLS catalog must be created for the instance to which the database belongs.
D) The DB2 High Availability (HA) features must be available for the server.
2. Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?
A) ALTER INDEXtablxl PCTFREE 40
B) ALTER INDEXtablxl ADD COLUMN (col_2)
C) ALTER INDEXtablxl CLUSTER
D) ALTER INDEXtablxl COMPRESS YES
3. A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?
A) BACKUP DATABASE payroll USE XBSA
B) BACKUP DATABASE payroll USE FU\SHCOPY
C) BACKUP DATABASE payroll USE MIRROR
D) BACKUP DATABASE payroll USE SNAPSHOT
4. Table TAB_A is already populated with a large number or rows, and you wish to insert more rows from a file named data.del. While these row are added, you want users to still have full access to the table in read/Write mode. Which command should you use to do this?
A) IMPORT FROM data.del OF DEL INSERT INTOtab_a
B) IMPORT FROM data.del OF DEL INSERT INTOtab_a ALLOW WRITE ACCESS
C) LOAD FROM data.del OF DEL INSERT INTO taba ALLOW WRITE ACCESS
D) LOAD FROM data.del OF DEL INSERT INTOtab_a
5. Click the Exhibit button.
IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?
A) 192.168.2.1
B) 192.168.1.1
C) 192.168.2.102
D) 192.168.1.102
Solutions:
| Question # 1 Answer: B,D | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: C |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
907 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.