image


P2090-054 Dumps

P2090-054 Braindumps P2090-054 Real Questions P2090-054 Practice Test P2090-054 Actual Questions


IBM


P2090-054


IBM Information Management DB2 10.5 pureScale Mastery Test v3


https://killexams.com/pass4sure/exam-detail/P2090-054


  1. DB2 pureScale feature does not support range-partitioning tables.

  2. A DB2 pureScale installation is only supported on AIX platform.

  3. DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).

  4. DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).


Answer: D


QUESTION: 63

With respect to DB2 security, what is authorization?


  1. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.

  2. Authorization is the process where the DBA gathers information to see who will have access to the database.

  3. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.

  4. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.


Answer: A


QUESTION: 64

The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?


  1. Temporary Tables Compression

  2. Declared Global Temporary Tables Compression

  3. Adaptive Compression

  4. Classic Row Compression


Answer: C


QUESTION: 65

What is a buffer pool in DB2?


  1. A buffer pool is an area of main memory that has been allocated by the database manager

    for the purpose of caching table and index data as it is read from the physical media.

  2. A buffer pool is a DB2 component that manages connections to databases.

  3. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.

  4. A buffer pool is a logical storage grouping composed of one or more containers.


Answer: A


QUESTION: 66

What does the table partitioning feature in DB2 allow you to do?


  1. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

  2. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

  3. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

  4. Table partitioning allows you to partition the table data based on the hash values of the primary key.


Answer: B


QUESTION: 67

What is a table space in DB2?


  1. A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as

    it is read from the physical media.

  2. A table space is a DB2 component that manages access to databases.

  3. A table space is a space reserved for catalog tables and base table data.

  4. A table space is a logical storage grouping that can be composed of one or more containers.


Answer: D


QUESTION: 68

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?


  1. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

  2. Table data is protected against direct access to the table. Access using views is unrestricted.

  3. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

  4. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.


Answer: D


QUESTION: 69

Which of the following is TRUE about PL/SQL support in DB2?


  1. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

  2. DB2 requires third party software to execute PL/SQL statements.

  3. You can only execute PL/SQL statements using the CLPPIus interface.

  4. PL/SQL support is only enabled when using federation to access other vendor databases.


Answer: A


image

6$03/( 48(67,216


7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP


([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP


3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV


*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\


'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU

.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG