A2090-544 - Assessment: DB2 9.7 Advanced DBA for LUW - Assessment

Go back to IBM

Example Questions

Which statement is true about clustering indexes in a partitioned database? Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following? What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data? Which action(s) will cause a compression dictionary to be removed from a table? A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance? What is a method for enabling non-buffered I/O at the table space level in a DB2 database? Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions? An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.) If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true? At which two levels can events be audited? (Choose two.) The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, 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 objective? What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries? Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair? How can a DBA validate that an existing backup was compressed? Which two operators would indicate inter-partition parallelism in an Optimizer Plan? (Choose two.) Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed? A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning? Which conditions must be met to implement HADR? Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted? Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility? In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value? What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.) What will the db2audit facility do when a DB2 database instance is stopped? A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true? What determines the degree of inter-partition parallelism used? Which command CANNOT be used to create the compression dictionary for a table? Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option? Which command will prevent prefetching during crash recovery? What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage? When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent? A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server? How can you change an existing non-partitioned index for a partitioned table to a partitioned index? Which data organization schemes are supported? Which action can be performed by the ALTER TABLESPACE statement? If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance? A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem? A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification? Which command would be used to obtain the name of the first active log file for a database with log retain enabled? A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly? A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection? Which statement is correct about statistical views? Which command CANNOT be used to explicitly build a compression dictionary for a table? Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server? TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.) The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, 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 objective? A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing 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? Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable? While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client: CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS samp001 AT NODE node001; TERMINATE; When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem? If LOGSECOND=-1 then which of the following statements is true? What new security authorities have been introduced in DB2 V9.7?