000M87Netezza.docx
- 文档编号:23273644
- 上传时间:2023-05-15
- 格式:DOCX
- 页数:15
- 大小:144.16KB
000M87Netezza.docx
《000M87Netezza.docx》由会员分享,可在线阅读,更多相关《000M87Netezza.docx(15页珍藏版)》请在冰豆网上搜索。
000M87Netezza
Q1.Withworkloadmanagement,anAdministratorcansetaside_________S-Bladestobeusedexclusivelywithagivendatabase?
A.1
B.2
C.all
D.0
Answer:
D
Explanation:
Q2.WhichofthefollowingisTRUEabouttheGROOMTABLEcommand?
A.Youmustfirstrunthenzstopcommandasthenzuserfromthehostcommandline.
B.GROOMcanmaterializetheresultsofpreviousALTERTABLEADD/DROPcolumncommands.
C.Thetablebeinggroomedwillbelockedexclusivelyduringthegroomoperation.
D.GROOMisanadministrativecommandthatmustberunbyaDBA.
Answer:
B
Explanation:
Q3.WhichofthefollowingstatementsaboutNetezzaprivilegesisNOTtrue?
A.Privilegesareadditiveoucannotremoveaprivilegefromauserwhohasbeengrantedthatprivilegeasamemberofagroup.
B.Objectownersautomaticallyhavefullaccesstotheirobjects.
C.Userswithprivilegesonanobjectcanpassthatobjecttoothersbydefault.
D.Bydefault,newlycreatedobjectshavenoprivilegesassociatedwiththem.
Answer:
C
Explanation:
Q4.Whichofthefollowingstatementscanbeusedtocreateatemporarytable?
A.SELECTINTO#TEMPTABLEcol1,col2FROMMYTABLE;
B.CREATETEMPTABLEASTEMPTABLESELECTcol1,col2FROMMYTABLE;
C.CREATETEMPORARYTABLEMYTABLESAMEASMYOTHERTABLE;
D.Noneoftheabove.
Answer:
B
Explanation:
Q5.IsitCORRECTthatifatableisdistributedrandomly,ZoneMapsarenotused?
A.ZoneMapsarenotusedatall.
B.ZoneMapsareusedintheexactsamewayasinanyotherdistribution.
C.ZoneMapsareusedonlywhenstatisticsarenotuptodate.
D.Noneoftheabove.
Answer:
B
Explanation:
Q6.WhichofthefollowingstatementsaboutexternaltablesisNOTaccurate?
A.Queryingexternaltablesisaboutthesamespeedasqueryingnormaltables.
B.Loadingdataviaexternaltablesisaboutthesamespeedasusingthenativenzloadutility.
C.ExternaltablescanbeusedtoloadremotedatafilesviaanODBCorJDBCconnection.
D.ExternaltablescanbeusedtoloadorunloaddatafromNetezza.
Answer:
A
Explanation:
Q7.WhichofthefollowingisNOTtrueoftheGENERATESTATISTICScommand?
A.TheonlydifferencebetweenEXPRESSandFULLstatisticsishowdispersioniscalculated.
B.TheusercanspecifywhetherFULLorEXPRESSstatisticsarecalculated.
C.ZoneMapsaredisabledforthedurationoftheGENERATESTATISTICScommand.
D.Itrequiresspecificpermissions.
Answer:
B
Explanation:
Q8.Whichofthefollowingoptionsbestcompletesthisstatement?
Whenaqueryiscompiled,_______________________.
A.exactlyonesnippetisgeneratedrepresentingtheentirequery
B.onesnippetisgeneratedforeachjoinwithinthequery
C.thenumberofsnippetsgenerateddependsonanumberoffactors,includingthecomplexityofthequery
D.onesnippetisgeneratedforeachTBofdatascanned
Answer:
C
Explanation:
Q9.WhichofthefollowingisMOSTTRUEofhowNetezzastoresdata?
A.Netezzaisacolumnardatabase.
B.Netezzaisarow-baseddatabase.
C.Netezzausesaformofcolumnarcompression,butstoresdatainarow-basedformat.
D.NetezzastoresdatainaformatdeterminedbyZoneMaps.
Answer:
C
Explanation:
Q10.WhichofthefollowingstatementsareTRUEaboutbackups?
A.OnlyfullbackupsaresupportedonNetezza.
B.Anadministratorcanusethenzbackupcommandtobackupasingletable.
C.Youmustexplicitlygrantpermissionforanon-ownertodobackupsonaparticulardatabase.
D.Alloftheabove.
Answer:
C
Explanation:
Q11.WhichofthefollowingdoesNetezzausetoensureACIDcompliance?
A.Multiversioning
B.Two-phasecommit
C.Locking
D.Round-robin
Answer:
A
Explanation:
Q12.WhatelementsoflogicaldatamodelingdoesNetezzasupport?
A.B-TreeIndexes
B.RangePartitions
C.Tablespaces
D.NoneoftheAbove.
Answer:
D
Explanation:
Q13.WhichofthefollowingstatementsmostaccuratelydescribeZoneMaps?
A.ZoneMapsarelikeindexes,theytellyouwherespecificdataisonthedisk.
B.ZoneMapsaremaintainedautomaticallybytheHost.
C.ZoneMapsarelikestreetaddresses,theytellNetezzatherangeofdatainaspecificextent.
D.ZoneMapsarelikestatisticsanddescribethecharacteristicsofstoreddata.
Answer:
C
Explanation:
Q14.ClusteredBaseTablesareeffectivebecausethey_________________.
A.automaticallycreateaclusteredindexforfasterseektimes
B.arealwaysmoreeffectivethanreorderingatablemanually
C.allowdatatobedistributedonacolumnotherthanthedistributionkey
D.makeZoneMapsmoreeffectivebygroupingsimilardatatogether
Answer:
D
Explanation:
Q15.InaTwinFin12,whatdoesthenumber?
2?
referto?
A.ThenumberofFPGAs(notcores)used.
B.ThenumberofSnippetProcessors.
C.ThenumberofS-Blades.
D.Theamountofmemoryperblade,inGB.
Answer:
C
Explanation:
Q16.Whichofthefollowingimpactdatadistribution?
A.Thephysicalorderthatdataisloadedintothetable.
B.Thenumberofharddrivesonthesystem.
C.TheZoneMapsonthetablecolumns.
D.TheORGANIZATIONKEYthatisdefinedonthetable.
Answer:
B
Explanation:
Q17.WhycouldthefollowingSQLStatementsFAIL?
A.ThereisnoDISTRIBUTEONstatement,thisisrequiredforNetezzatables.
B.ThereisaPrimaryKeydeclared,NetezzadoesnotsupportReferentialIntegrity(RI).
C.Therowistoowideforthetabletobecreated.
D.Theidcolumncannotbealteredbecauseitisthedistributionkey.
Answer:
D
Explanation:
Q18.WhichofthefollowingstatementsaboutanFPGAisTRUE?
A.ItisacommonchipusedinauniquewayinNetezzaarchitecture.
B.ItisacustomchipusedinNetezzaTwinFinservertoprovideauniqueadvantage.
C.ItisauniqueIBMtechnologythatNetezzausestodifferentiateitselffromotherdatabaseplatforms.
D.Itisacommoncomponentofmanyhigh-performancedatabasesystems.
Answer:
A
Explanation:
Q19.WhichofthefollowingisNOTtrueofNetezzaeventmanagementsystem?
A.Somecommoneventsareenabledbydefault.
B.Customeventscanbecreatedbyadministrators.
C.Netezzacannativelysendanemailorrunacommandwhenaneventistriggered.
D.Noneoftheabove.
Answer:
D
Explanation:
Q20.WhenasingleSQLqueryisrunonanemptysystemwithoutworkloadmanagementenabled,whatarethemaximumsystemresourcesitreceivesbydefault?
A.25%
B.50%
C.100%
D.Whateverisdefinedinthedefaultworkloadmanagementprofilethattheadministratorhasinstalledatinstalltime.
Answer:
C
Explanation:
Q21.Howcandirtyreads(whereatransactionisallowedtoreaddatafromarowthathasbeenmodifiedbyanotherrunningtransactionnotyetcommitted)beenabledonNetezza?
A.BysettingtheALLOW_DIRTY_READSflaginthesystemregistry.
B.ByissuingaETDIRTY_READS=ON;?
SQLstatement.Byissuinga?
ETDIRTY_READS=ON;?
SQLstatement.
C.ByissuingaETSHOW_DELETED_RECORDS=TRUE;?
SQLstatement.Byissuinga?
ETSHOW_DELETED_RECORDS=TRUE;?
SQLstatement.
D.Dirtyreadscannotbeenabled.
Answer:
D
Explanation:
Q22.WhichofthefollowingmethodsdoesNetezzausetoensuredataintegrityandavailability?
A.ReplicationandRegeneration.
B.Replication,Regeneration,andFailover.
C.RegenerationandFailover.
D.Allofthem.
Answer:
B
Explanation:
Q23.Whatusuallyhappenswhenasectoronadiskbecomescorrupted?
A.Thediskisautomaticallyfailedover.
B.Thesectorismarkedbadandthedataiscopiedoverfromthemirroredcopy.
C.TheFPGAprocessesthedataagaintoresolvethecorruption.
D.AnalertissenttothemonitoringaliasintheNetezzaeventmanager.
Answer:
B
Explanation:
Q24.WhatisthemaximumrowsizeinNetezza?
A.32,768bytes
B.65,535bytes
C.5,460bytes*thenumberofdisksinthesystem
D.ThereisnomaximumrowsizeinNetezza.
Answer:
B
Explanation:
Q25.WhyisthefollowingSQLINCORRECT?
A.ThereismorethanonebasetableintheFROMclause.
B.TheWHEREclauseisused.
C.TheORDERBYclausehasDESCspecified.
D.Alloftheabove.
Answer:
D
Explanation:
Q26.DatadecompressionisdoneinwhatcomponentoftheNetezzaarchitecture?
A.CPU
B.SPU
C.FPGA
D.RAM
Answer:
C
Explanation:
Q27.WhichofthefollowingdatatypesaresupportednativelybyNetezza?
A.Array
B.Numeric
C.Varchar2
D.Blob
Answer:
B
Explanation:
Q28.Whichofthefollowingdataredistributionmethodsgenerallyresultsinthefastestquerytimes?
A.Co-locatedjoins
B.Singleredistributionjoins
C.Doubleredistributionjoins
D.Broadcastjoins
Answer:
A
Explanation:
Q29.Whichofthefollowingitemshaveanimpactonthequeryplanthattheoptimizerchooses?
A.Tablestatistics
B.ZoneMaps
C.BothtablestatisticsandZoneMaps
D.Noneoftheabove.
Answer:
A
Explanation:
Q30.ForthefollowingSQL:
Assumethatthisqueryistypicalofhowthefact_tabletableisused.Whatwouldbethebestorganizationkey?
A.ORGANIZEON(name)
B.ORGANIZEON(fact_table)
C.ORGANIZEON(insert_date)
D.ORGANIZEON(transaction_date)
Answer:
D
Explanation:
Q31.WhichofthefollowingphrasesdoesnotdescribeawaythatNetezzacanensurethatdataforajoinisonthesameSnippetProcessor?
A.Co-location
B.Broadcast
C.Correlation
D.SingleRedistribution
Answer:
C
Explanation:
Q32.ForthefollowingSQL:
Whatfield(s)wouldmostlikelybeusedtodistributefact_tableifyouwantedoptimalqueryperformance?
A.DISTRIBUTEON(id)
B.DISTRIBUTEONRANDOM
C.DISTRIBUTEON(id,country_code)
D.DISTRIBUTEON(country_code)
Answer:
A
Explanation:
Q33.ForthefollowingSQL:
Whatfieldwouldbeusedtodistributefact_tableifyouwantedaco-locatedjoin?
A.DISTRIBUTEON(id)
B.DISTRIBUTEONRANDOM
C.DISTRIBUTEON(country_code)
D.DISTRIBUTEON(transaction_date)
Answer:
A
Explanation:
Q3
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 000 M87Netezza