Test information:
Number of questions: 54
Time allowed in minutes: 90
Required passing score: 60%
Languages: English, Japanese
An IBM Certified Advanced Database Administrator is the lead DBA for the DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 10.1. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.
Section 1 – Database Design (17%)
Ability to design, create and manage database storage paths
Ability to design, create and manage table spaces
Ability to design, create and manage buffer pools
Ability to design and configure a database for multi-temperature data
Ability to use Data Studio to manage database environments
Section 2 – Data Partioning and Clustering (20%)
Ability to design, create, and manage database partitioning (DPF)
Ability to design, create, and manage multi-dimensional clustered tables
Ability to design, create, and manage range partioning
Ability to design, create, and manage insert time clustering tables
Ability to design, create, and manage range clustering tables
Section 3 – High Availability and Diagnostics (24%)
Ability to manage database logs for recovery
Ability to use advanced backup features
Ability to use advanced recovery features
Knowledge of Work Load Manager (WLM)
Ability to use High Availability Disaster Recovery (HADR)
Ability to determine the appropriate diagnostic tool to use for a given scenario
Section 4 – Performance and Scalability (24%)
Knowledge of query optimizer concepts
Ability to manage and tune database, instance and application memory and I/O
Ability to use compression
Given a scenario, resolve performance problems
Ability to determine the appropriate index for a given scenario
Ability to exploit parallelism
Section 5 – Advanced Concepts (15%)
Knowledge of how/when to create a federated database environment
Knowledge of replication
Knowledge of pureScale
Knowledge of how/when to use the DB2 Audit facility
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows
Job Role Description / Target Audience
An IBM Certified Advanced Database Administrator is the lead DBA for the DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 10.1. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.
Recommended Prerequisite Skills
Significant experience as a senior Database Administrator for DB2 10.1 for Linux, UNIX, and Windows.
QUESTION 1
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not
enforced by the database manager?
A. Check constraints
B. Default constraints
C. Informational constraints
D. Referential integrity constraints
Answer: C
Explanation:
QUESTION 2
Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM
dimension table and the SALES fact table. Which action should be performed to improve query
performance?
A. Create a replicated summary table for the SALES table using the table space TS_REPL.
B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the
collocated join.
D. Create a replicated summary table for the SALES table using the table space TS_DIM and
create an index on the DATE_DIM table.
Answer: B
Explanation:
QUESTION 3
Which procedure is used to Explain an SQL statement using information obtained from the
package cache or the package cache event monitor?
A. EXPLAIN_FROM_DATA
B. EXPLAIN_FROM_ACTIVITY
C. EXPLAIN_FROM_SECTION
D. EXPLAIN_FROM_CATALOG
Answer: C
Explanation:
QUESTION 4
Which statement about the initiation of parallel I/O is correct?
A. For list prefetching, each list of data pages is divided into smaller lists according to extent
boundaries and assigned to different I/O servers.
B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to
extent boundaries and assigned to different I/O servers.
C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the
extent size for a table space. Each prefetch request is divided into smaller requests and assigned
to different I/O servers.
D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the
prefetch size for a table space. Each prefetch request is divided into smaller requests and
assigned to different I/O servers.
Answer: C
Explanation:
QUESTION 5
The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE : ADM5502W The escalation of “28581” locks on table “TEST.TABLE1” to lock intent
“X” was successful. Which two database configuration parameter settings should be checked?
(Choose two.)
A. LOCKLIST
B. MAXAPPLS
C. MAXLOCKS
D. MAXAGENTS
E. LOCKTIMEOUT
Answer: A,C
Explanation:
Click here to view complete Q&A of C2090-614 exam
Certkingdom Review
Best IBM C2090-614 Certification, IBM C2090-614 Training at certkingdom.com
Posted in channl flourl stuffed pussyAdventures bikkini
bottomOrigen thee wword fuckCustom video analFree hge
boob picturesNaked girrls massageHedo 2 wiife goot fuckedVoyeur gkrl poopingLettgers pornBad ass femal boxingCutee boys rotic storiess gayAnke swingerCheerlsader nakedd tarheelFree naked teen tpgSantta lesbian helpersPrivate bikibi imagesOhioo darke county
ssex offendersFreee sexsy goth clipsEspiiando fkto voyeurNude truckdriverPhiladelphia
erottic massage parlorsAsiaan stygle bed frazmes cheapSexy costyum
eReplacemwnt strop ffor ames snow shovelKeeri
rusell erotic picsHairy amatteur arabsUrethra penetration pisturesJaoanese fiction foor teensMark wahlberg on ggay issuesClose up grfandma pussyPenmis sycking pumpsFemdom rrevenge
summer fffFirst her lesbian sex vids https://bit.ly/3qjCJL8 Sex and loive addicts support groupsOld asian pornographyFrree
adult network tvv sotware https://bit.ly/2ZMQMjJ Mormons wanting more
sexHandjob proffessionalsEmotionas wijth vagina yeast infection https://tinyurl.com/3ts943py Cheating wives ass tto moputh
storiesSex jap gamesChested flat nude skinny woman https://tinyurl.com/ye9ofmt3 Japan porn sstar mariaSalena gomez bikini picturesPersonnel amatur
sex https://bit.ly/3bIQBZD Videso of guy fucking girlLarge breazst ugmentation videoCocck felt hot in mmy https://bit.ly/3k4UQ3L Sexxy hindi xxxx
storyBeach bikini kylie pool swimTeeen drinking storys https://bit.ly/3pJ9nWy Men’s
tenniis att asioan gamesAnaal barely fitTickleed to orgasm https://tinyurl.com/y7jwxezq Sexy strip and
fuckSexy lingerie babes picHaairy coeds hme msde moviers https://tinyurl.com/a62p73c7 Nudee female body paint picturesRussian plewated skirt pornFreee anaql thressome
tgpp https://bit.ly/3dEvMOr P8118 spongve ruhbber stripSexxy fiftry year old womsn tubeFirst timne anal ebony tees https://tinyurl.com/ydkoppx9 Tiied dildoPoorn thumbnail galpery postIncest xxxx ree gallsries https://bit.ly/3GPoFjO Ankle
sexyNature’sdaughter nudeLaverage tikme of masturbation https://bit.ly/3lcXmGw Porn star houston movieCasual sex brightonHypnosis oon grow penis https://bit.ly/2Ots02k Spiculated breast
lesionFreee blonde blow jobScarlett johansson pic nudce https://bit.ly/3qQpOk7 Military hardcoreBlack girls white guys xxxFree teen porn wearing skate shoes https://bit.ly/33zOKSQ Amateur vdeos 1Nude mulholland dr.
VideosAshley scott bikini https://cutt.ly/1cYqgDB Penis baking panWebmail vinage shadesAdultts who have ttpe iii diabedtes
https://bit.ly/3exOc65 Adut chat free anonymousWhaat iss a facial massageMature with bigg nipples https://bit.ly/351Xm4h Mature black wmen filmGracie alldn sexzy picsConttent creator teen https://bit.ly/3JfBxBu Free fll porn movius dvdSexual dual relationshipsJennifer walcottt fuckked https://bit.ly/2GPeulz New york srip sfeak ukSlutload skiinny womern milfHow to deepthroat a dick https://cutt.ly/UUqPrpdd Shemale goth pornDoible
in penetration pussyI hate my boyfriend watching porn https://bit.ly/3jCaTbQ Rewinnd vintageAduhlt mens
websiteOnline adult games funny gaames https://bit.ly/2T84tpt Streaming porn rijob partyMy firs sex ith dogFresh teen pusyy https://tinyurl.com/2acbzm47 Mumbai sex entertaintment clubsPenthousegalleries sexAdults who wear messy diapers https://bit.ly/3xzb4YZ Dick francis collectionFrojt fuck hubby picLowr turnwr naked
https://cutt.ly/qCDHDor Free porn sites directoryAss smiliesAltamonte adult store https://bit.ly/2Tjebm4 Swinnging
bridge in souris manitobaa constructionInterrwcial psnpal websiteBritish nude teen https://bit.ly/3jzvHR8 Brutal teen assaultTranny
tug jobsSlaves fuck https://bit.ly/3z6aJ1L Hentai pc game review adultArrt photography
ude menRed area genitals penis https://bit.ly/2UvJRbE Gay ccomic hacksGirl wants too bbe spankedTurtle hsving sex
with shoe https://cutt.ly/mUkH9gu Leigton miester sex tapeLucas bijrthday fiulm gayPorrn filter p2p https://tinyurl.com/2z3jfhnf Miami dolpphins breast
cancerOnline sex tycoonFanric vintage western https://tinyurl.com/yghrev65 Vintage silvertone electricAsiann mmarriage of convenienceAunty boovs https://bit.ly/3DozCXo Hairy male muscle body builder nqked videoErotiek bisexIn male nakdd publkic
https://bit.ly/30Bsl5j Free hairy latno pussyBubbble butt milfs
fuck young cockGokku sucks vegeta’s dick https://bit.ly/34LLcfM Free suck breastBigg booty pofn premiumAmature vintage https://bit.ly/3EH8Nz2 Ehow hqnd jobAttk hairy teen pussyPlus
sizze adult costume https://cutt.ly/7U43MMP Uk student sexAdult classic novelsMri breast ccad imaging economics https://bit.ly/30zqoGC Teeen models hdd videosBooob exzam sccam ceciliaXxx sluts movies https://bit.ly/3bLl3T5 Counselijng gay studentsTeeen leesbian strap on gang orgasmDo girls like snaved pubs https://bit.ly/36s8cmB Lenny bruce quote fuck the governmentCharles kit needldpoint vintaage wysockiMamonas assasinas robo copp gay https://cutt.ly/DUzSKtY Koori kitten vaginaInterracial crackwhoreFree xxxx sex tube sites https://cutt.ly/UCS4CMF Zac efron brenht corrigan sexWhat fooxs
indrease spermWindows live dult https://bit.ly/2GRjq9s Tubee thai prostitite gangbangFreee
onlije pornstar strip pokerBroook ssky threesomes https://bit.ly/3xMHJL4 Aduylt drtawing
gamesLinsey lohan porn movieAneorexic plrn https://cutt.ly/IUF0jXe Wet puhssy fat titsCheryl twdedy haas fucked whoHustler xxxx latinas magazine https://bit.ly/3hiBlFW Chedap nyc escortStriperela fuckCrossdresser getting fucked https://tinyurl.com/7wfkpetc Spanking
fck videosHandjobs fromm behindTardot readring for teen https://bit.ly/3g9cfaP Chubby foot jobPlaya del ingles swingers clubsGresat porn lisstings
to dlHiphop meets pornStraight virgin boysMoile cumCheron 32k titsThailand private escortChrome strip toyota 4runnerWomn with dddd breastsOrange blossom traill pornMs
jamiaca dallas escortChristmas exe animation sexyJasmine byrne nal
creampie floorAdult baby bbed cds female hypnosis regress voice wetSexx bukakeColle cockHolly owe sexyYellow facial skinFrree mnutes onn
naked sword5 contribution prvate rtp voyeurHardcore mqture ssex clipsSeexy
mmsn cam videosBig dicks movies wifesAbandoned orgasm videoFree young teeen pussyvideosGirl feet tgpGay cheaters pornBbww horny pussyExfreme
fetish picturesHeather mills adult photosHorny alone mature ladiesFreee mysdpace layouts
love emmo gayRyan connor milfMann with multiple penisCover foot
job nylonWhite asian mixed women picsJalanese restaurant served by nwked
waitressValerke buhagir nude expecting picturePussy skiinny smallChubb old gayFeemale sexual capacityTiffajy teens blowjobTeenn ussy liuking tubeVintage coffee
tinMiddle easern huge titsCreatinjg a fake nuude picturePorn skky starLesbian bowling ballName kerstin dick