www.DirectCertify.com IT Certification Exams PDF
IBM C2090-544 DB2 9.7 Advanced DBA for LUW
Edition = DEMO Full Version Features: 90 Days Free Updates 30 Days Money Back Guarantee Instant Download Once Purchased 24 Hours Live Chat Support
Full version is available at link below with affordable price.
http://www.directcertify.com/C2090-544.html
Page | 1
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF Question: 1 The DBA needs to create a table with key columns YEAR DAY, YEAR, and DAY. This table needs to be part1t1oned by column YEAR DAY with three months per data part1t1on. Addit1onally, data needs to be organized so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this object1ve? A. CREATETABLEtab1 (yearday INT, year CHAR(2), day INT)) PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3) ORGANIZE BY DIMENSIONS (year, day)) B. CREATETABLEtab1 (yearday INT, year CHAR(2), day INT)) PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3) ORGANIZE BY DIMENSIONS (year, day)) C. CREATE TABLE tab1 (yearday INT, year CHAR(2), day INT)) PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3) ORGANIZE BY DIMENSIONS (year)) D. CREATE TABLE tab1 (yearday INT, year CHAR(2), day INT)) PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3) ORGANIZE BY DIMENSIONS (day))
Answer: C Question: 2 Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.) A. INTRA_PARALLEL NO B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100 C. MAX_AGENTS 100, MAX_CONNECTIONS 2000 D. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000 E. INTRA_PARALLEL YES
Answer: B, E Question: 3 Page | 2
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF A DBA would like to examine repart1t1oning opt1ons for a part1t1oned database named PRQDDB Which tool can be used to provide recommendat1ons on re-part1t1oning? A. Configurat1on Advisor B. Part1t1on Assistant C. Design Advisor D. Workload Manager
Answer: C Question: 4 Which command CANNOT be used to explic1tly build a compression dict1onary for a table? A. REORG B. LOAD C. INSPECT D. IMPORT
Answer: D Question: 5 A DBA has established connect1vity to a DB2 for z/OS database and is exploit1ng a System z sysplex for load balanc1ng and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list? A. UPDATE DBM CFG USING NUM_INITAGENTS 200; db2stop; db2start; B. UPDATE DBM CFG USING NUM_INITAGENTS 0; db2stop; db2start; C. UPDATE DBM CFG USING NUM_POOLAGENTS 200; db2stop; db2start; D. UPDATE DBM CFG USING NUM_POOLAGENTS 0; db2stop; db2start;
Answer: C Question: 6 A DBA migrat1ng an exist1ng database to DB2 9.7 wants to allow the primary and secondary recovery logs to be used with non-buffered 10. Which statement is true? A. This behavior is automat1cally enabled by default. B. The DB2_LOGGER_BUFFERED registry variable must be set to OFF. C. The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES. Page | 3
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF D. The DB2_LOGGER_NON_BUFFERED_IO registry variable must be set to AUTO.
Answer: A Question: 7 What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries? A. parse query; rewrite query; check semant1cs; pushdown predicates; execute access plan B. check semant1cs; parse query; rewrite query; build access plan C. parse query; check semant1cs; rewrite query; build access plan D. check semant1cs; parse query; build access plan; pushdown predicates; execute access plan
Answer: C Question: 8 A database named MYDB was created by execut1ng the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a dec1sion is made to modify this database so that both it and its table spaces use automat1c storage. What steps are required to make this modificat1on? A. Use the ALTER DATABASE command to convert the database; all exist1ng table spaces will be converted automat1cally. B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all exist1ng table spaces. C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all exist1ng SMS table spaces. D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all exist1ng DMS table spaces.
Answer: D Question: 9 Which condit1ons must be met to implement HADR? A. Operat1ng systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit). B. Operat1ng systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit). C. Operat1ng systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit). D. Operat1ng systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
Answer: D Page | 4
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF Question: 10 Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which sett1ng would prevent a SORTHEAP overflow when the temporary table is sorted? A. SORTHEAPTHRES 10000K, SORTHEAP 250K B. SORTHEAPTHRES 10000K C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K D. SORTHEAP AUTOMATIC, SHEAPTHRES 0
Answer: D Question: 11 Which command CANNOT be used to create the compression dict1onary for a table? A. IMPORT B. INSPECT C. LOAD D. RUNSTATS
Answer: D Question: 12 When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent? A. It terminates immediately. B. It remains act1ve as long as the MAXAGENTS sett1ng is not exceeded. C. It is placed in the agent pool if the connect1on is terminated. D. It automat1cally releases the database connect1on and returns to the pool.
Answer: C Question: 13 If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which ut1lity can be used to list the applicat1ons currently connected to the database MYDB? A. db2dart B. db2apptrk C. db2acsut1l D. db2pd
Answer: D Page | 5
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF Question: 14 A part1t1oned instance named DB2INSTI uses the following db2nodes.cfg file: If the CREATE DATABASE command is executed on server C, which part1t1on will be the catalog part1t1on? A. 0 B. 1 C. 4 D. 6
Answer: C Question: 15 A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSPI and both tables were populated with 100,000 rows. If a DBA dec1des that database MYDB should use automat1c storage, which command(s) are needed to convert the database? A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbspl MANAGED BY AUTOMATIC STORAGE; C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbspl MANAGED BY AUTOMATIC STORAGE;
Answer: A Question: 16 A database named DB1 has a database part1t1on group named MULTIPG that has been defined across part1t1ons 3, 4 and 5. The DBA issues the following series of commands/SQL statements: CONNECT TO dbl; SET CURRENT DBPARTITIONNUM 4; ALTER DATABASE PARTITION GROUP mult1gp ADD DBPARTITIONNUM (6); Which part1t1on will DB2 use as a model for table spaces on part1t1on 6? A. catalog part1t1on B. part1t1on 3 C. part1t1on 4 D. part1t1on 5
Page | 6
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF Answer: B Question: 17 Your UNIX system administrator has indicated that there appears to be a lot of I/O wait t1me assoc1ated with your database, which is stored in a 7+p RAID array. An invest1gat1on reveals the following informat1on: DB2_PARALLEL_IO=* Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of I 6K, an extent size of 32, and a prefetch size of 64. Which sett1ng would opt1mize I/O for the largest table? A. DB2_PARALLEL_lO=7:64 B. DB2_PARALLEL_lO=7:7 C. DB2_PARALLEL_lO=7:16 D. DB2_PARALLEL_lO=7:32
Answer: B Question: 18 Which factor should influence your select1on of distribut1on key(s)? A. The distribut1on key(s) should include the most frequently accessed XML column(s). B. The distribut1on key(s) should include the longest column(s). C. The distribut1on key(s) should include column(s) with the smallest number of dist1nct values. D. The distribut1on key(s) should include the most frequently joined column(s).
Answer: D Question: 19 You have a database with eight part1t1ons on a single server. Immediately after execut1ng the following command: CREATE BUFFERPOOL mybp DEFERRED SIZE 3000 How much memory is consumed by buffer pool MYBP on the server? A. 0 pages B. 3000 pages C. 24000 pages D. 192000 pages
Answer: A Question: 20 Which data organizat1on schemes are supported?
Page | 7
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF A. PARTITION BY HASH and ORGANIZE BY B. PARTITION BY RANGE and ORGANIZE BY HASH C. PARTITION BY HASH and ORGANIZE BY RANGE D. PARTITION BY RANGE and ORGANIZE BY
Answer: D Question: 21 Which descript1on is correct when discussing the DB2_MEM_TUNING_RANGE registry variable? A. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled. B. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insuffic1ent system memory problems are occurring. C. It is recommended that this variable be enabled at all t1mes in order to prevent DB2 from taking too much physical memory. D. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.
Answer: B Question: 22 A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSPI and both tables were populated with 100,000 rows. If a DBA dec1des that database MYDB should use automat1c storage, which command(s) are needed to convert both the database and table space TBSPI? A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbspl MANAGED BY AUTOMATIC STORAGE; C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbspl MANAGED BY AUTOMATIC STORAGE;
Answer: B Question: 23 Which method should be used to construct an LBAC security component that represents a person’s level of trust? A SET Page | 8
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF B TREE C ARRAY D ORDER
Answer: C Question: 24 Which command would be used to obtain the name of the first act1ve log file for a database with log retain enabled? A. GET CURRENT ACTIVE LOGFILE B. LIST LOGFILES C. GET DATABASE CONFIGURATION D. LIST INDOUBT TRANSACTIONS
Answer: C Question: 25 An act1ve part1t1oned instance named DB2INSTI uses the following db2nodes.cfg file:
The following command is issued to add a new database part1t1on: db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME serverl PORT 4 Upon successful complet1on of the db2start command, which statement is true regarding the status of the instance DB2INSTI? A. Part1t1ons 1, 2, 3, 4, and 5 are act1ve and available. B. Part1t1ons 1, 2, 3, and 4 are act1ve, but part1t1on 5 is not. C. All part1t1ons are act1ve but part1t1on 5 is not available unt1l a temporary table space is defined. D. DB2 responds to the configurat1on change by stopping all part1t1ons.
Answer: B
Page | 9
http://www.directcertify.com/C2090-544.html
www.DirectCertify.com IT Certification Exams PDF
Full version is available at link below with affordable price.
http://www.directcertify.com/C2090-544.html 15% Discount Coupon Code: D39Z55X994
Full Product Includes.
Page | 10
http://www.directcertify.com/C2090-544.html