1z0591BI Foundation 11g题库v2.docx
- 文档编号:3305315
- 上传时间:2022-11-21
- 格式:DOCX
- 页数:29
- 大小:29.22KB
1z0591BI Foundation 11g题库v2.docx
《1z0591BI Foundation 11g题库v2.docx》由会员分享,可在线阅读,更多相关《1z0591BI Foundation 11g题库v2.docx(29页珍藏版)》请在冰豆网上搜索。
1z0591BIFoundation11g题库v2
1、WhencreatinganinitializationBlock,whichBIAdministrationfunctionisused?
A.VariableManager
B.JobManager
C.IdentityManager
D.ProjectsManager
A
2、WhichtwostepsareneededtosetupFailoversupportforanOBIEEdeployment?
A.UseInstallertoaffectHorizontalscaleoutofanexistinginstance
B.EmployWebLogicEnterpriseEdition,licensedseparately
C.UseInstallertosetupseparatesingleinstances,thenapplyHorizontalscaleoutclustering
D.ApplyOBIEEClusteringoption
E.LeveragesparehardwarecapacityofsinglemachinebyusingVerticalscaleoutoption
AD
3、ObjectSecuritycontrolsaccesstoSubjectAreas,Tables,andColumnsinOBIEEandcanbeimplementedbyusingwhichmethod?
A.SingleSign-On(SSO)
B.DatabaseAuthentication
C.BusinessLogicObjectSecurity
D.ExternalTableAuthentication
E.LDAPAuthentication
C
4AnintegratedBItoolsbusinesscasecanbebuiltaroundwhichthreeoptions?
A.Scalability
B.Faulttolerance
C.CostSavings
D.Developmentefficiency
ACD
5、Whatarethetwowaystousetheadministrationtool?
A.Itcanbeusedtomanageuserpassword.
B.Theadministrationtoolusesasetofwizardsthatsupportthedesignofcalculations, expressions,dimensions,andsoon.
C.Itcanbeusedforversioningoftherpd.
D.Administratorcanuserepositoryandsessionvariablesinarepositorytostreamline administrativetasksanddynamicallymodifymetadatacontenttoadjusttoachangingdata environment.
CD
6、UseoftheEnterpriseInstalloptionisrecommendedforwhichthreeoptions?
A.Multipleinstancesonasinglecomputer
B.ScaleoutforHighAvailabilityandFailover
C.Supportforhighsecurityrequirements
D.Evaluationofenduserfunctionality
E.Singleusersworkingonasinglecomputer
ABC
7、Whichoptionisnotanexampleofalevel-basedmeasure?
A.RegionalRevenue
B.Sales
C.BrandCost
D.EmployeeSalary
B
8、SelectingtheManageMapDatalinkallowsonetodowhichthreeofthefollowing?
A.AssociatemaplayerstocolumnsdefinedintheOBIEEmetadata
B.Createanewmaplayer
C.Setthezoomlevelofanimportedmap
D.Importimagesforuseonmaps
ACD
9、HowdoSystemSessionVariablesobtaintheirvalues?
A.Theyareenteredbyuserinputonadashboard
B.TheyareobtainedfromdatafieldsinthePhysicalLayer
C.TheyareobtainedfromthePresentationLayer
D.TheyareobtainedfromtheInitializationBlock
D
10、YouruntheConsistencyCheckandreceivethewarning:
[39003]Missingfunctionaldependencyassociationforcolumn:
DIM_Offer_End_Date.CREATE_DT.Whatwouldyoucheck?
A.Whetherthelogicaltablesourceforthiscolumnhasbeendisabled
B.WhetherthecolumnscreatingCREATE_DThavebeendeleted
C.WhetherthereisalogicaljoinbetweentheDIMandFACTtables
D.WhetherthereisaphysicaljoinbetweentheDIMandFACTtables
E.Whetherthereisaphysicalcolumnmappedtothelogicalcolumn
F.DIM_Offer_End_Date.CREATE_DT
A
11、PermissionsforPresentationlayerobjectsandBusinesslayerobjectsthatrestrictusersisconfiguredinwhichsoftwarecomponent?
A.OracleEnterpriseManager
B.OracleHTTPServer
C.WebLogicServerAdministrationComponent
D.BIAdministrationTool
D
12、Thecustomerisquestioningthenecessitytohaveadatawarehouseinplace.TheywanttorunOBIEEagainstvarioustransactionalsystems.Identifythetwolimitations.
A.Operationalsystemmightbeoverburdenedwithanalyticalrequestsresultinginhad performancefortransactionalprocesses.
B.TheBIservercannotintegratevarioussourcesinonemetadatamodel.
C.Dataqualityissuesmightemerge,duetomissingdatacleansing.
D.Businessissuesaredependingonreal-timedata.
AC
13、WhatmustbepurchasedwhenintegratingOraclemapwithOracleBI?
A.OracleMapviewer
B.OracleBusinessIntelligenceEnterpriseEdition
C.SpatialOptionwithDatabase
D.OLAPoption
A
14、InitializationBlocksareneverusedtoinitializewhichoption?
A.DynamicRepositoryVariables
B.SystemSessionVariables
C.NonSystemSessionVariables
D.rpdfile
D
15、Ifacustomerisplanningonbuildingadatawarehouse,howwouldyoudescribedatawarehousingtothecustomer?
A.Thedatainthedatawarehousedescribeseventsandstatusesofbusinessprocesses, productsandservices,goalsandorganizationalunits,andgenerallymirrorseveryaspectofthe structureandbehavioroftheorganization.
B.Datawarehousescanonlybebasedonmultidimensionaldatamodeling.
C.Applicationbaseddatawarehousescanbeboughtofftheshelfandusedwithoutanytweaking.
D.Datawarehouseprojectsareusuallyimplementedwithintwoweeks.
A
16、OBIEEdefaultsecuritymodelstoressecurityInformationsuchasusernamesandpasswordcombinationsforaccessinganexternalsystemsuchasActiveDirectory.Itisstoredinthe____________.
A.PolicyStore
B.CredentialStore
C.IdentityStore
D.PersonStore
CORB?
17、AnorganizationwouldliketoseeaTimefolderwithsubfoldersforitsFiscalandJuliancalendars.Howwouldyouaccomplishthis?
A.BycreatingPresentationFoldercalledTimeandthentwosubsequentfolderscalled->Fiscal Calendarand->JulianCalendar
B.BycreatingaPresentationFoldercalled->Timecalledthentwosubsequentfolderscalled FiscalCalendarandJulianCalendar
C.BycreatingaPresentationFoldercalled-Timeandthentwosubsequentfolderscalled+Fiscal Calendarand+JulianCalendar
D.BycreatingaPresentationFoldercalledTime
A
18、Whichanalysisfeaturescouldbeappliedtoprovideinteractivecontrolsforendusers?
(ChooseTwo)
A.ColumnSelector
B.ActionLinks
C.ConditionalFormatting
D.NarrativeView
E.GreenbarStyling
AB
Explanation:
Anactionlinkisalinktoanactionthatyouhaveembeddedinananalysis,
dashboardpage,scorecardobjective,scorecardinitiative,orKPIthat,whenclicked,runsan
associatedaction.
19、Acustomerneedstocreateaproductsharecalculation.Whatarethetwowaysthattheywouldgettherevenueforallproductstouseinthedenominator?
A.Createaderivedmeasurebyusingtheadditionfunctionthataddseachproductvaluetogether.
B.CreateaderivedmeasurebasedonRevenuethathastheLevelTotalProductselectedonthe LevelTaboftheLogicalColumnDialog.
C.CreateaderivedmeasurebasedonRevenuethathasallthelevelsselectedontheLevelTab oftheLogicalColumnDialogexceptTotalProduct.
D.CreateaderivedmetricbyusingtheExpressionBuilder.
AC
20、WhichtwoOracleBIComponentscontainsecurityinformationregardingpermissionsandprivileges?
A.TheWebCatalog
B.TheRepository
C.NQSConfig.iniFile
D.NQServer.iniFile
E.InstanceConfig.xmlFile
AB
Explanation:
WebCatalogdoescontainobjectpermissions:
folder,reports,etc.Therepository
hasobjectspermissionstoSubjectAreas,etc.
Reference:
OracleFusionMiddlewareSystemAdministrator’sGuideforOracleBusiness,A
NQSConfig.INIFileConfigurationSettings
21、WhichconfigurationcanbechangedthroughEnterpriseManager?
A.MinimumNumberofRowstoDownloadtoExcel
B.ThedefaultBIServerRepository
C.StartandStopBIServices
D.Managesuserlogin
B
22、SecurityManagerisusedfor______.
A.Settingpermissionsforparticularusersorapplicationroles
B.SettingpermissionsforindividualobjectsinthePresentationLayer
C.SettingupnewRolesandGroups
D.SettingupnewApplicationRoles
A
23、WhichoptiondoesnotdescribeAggregatetables?
A.Aggregatetablesincreasequeryperformancebypre-calculatingfrequentlyaccessedmeasure aggregations.
B.Aggregatetablesrelievebottlenecksandpre-calculateandstorethedataforbetterquery response.
C.Aggregatetablestypicallyhavefewerrowsthanthenonaggregatetablesand,therefore, processingshouldbequicker.
D.AggregatetablesarecreatedandstoredontheBIServer.
D
24、WhatmustbedonebeforeyoucanruntheOracleBusinessIntelligence11gInstaller?
A.ObtainBIinstallationmedia
B.CreaterequiredOracleBusinessIntelligenceschemasinadatabase
C.EnsuresystemmeetsinstallationrequirementsforFusingMiddleware,OracleBusiness Intelligence,ANDRepositoryCreationUtility
D.InstalltheWLSAdminServer
E.Selectinstallationcomponents�OBIEE,BIP,RTD
ABC
25、OracleBIServercachesetupinformationisconfiguredbyusingEnterpriseManagerFusionMiddlewarecontrol.WhichcomponentstorestheconfigurationInformation?
A.NQSConfig.ini
B.CachetableinOBIEErepository
C.WebCatalogue
D.Instanceconfig.xml
A
26、OracleBIServeratacompanyisconnectedtoDataWarehousethatisrefreshedonadailybasis,themajorityofusersatthecompanylogintoOracleBIeveryMondaytogeneratethepreviousweek’ssalesreport.TheBIAdministratorschedulescachepurgeandcacheseedingtoimprovereportresponsetimes.Howisthisaccomplished?
A.EverydaybeforeDataWarehouserefresh
B.EverydayafterDataWarehouserefresh
C.EveryMondayearlymorning
D.EveryMondaylatenight
C
Explanation:
Purgeandreseedonceaweekafterthereportshaveruntoimprovereportresponsetime.
27、Anorganizationhasitsemployees’namesinanEmployeestable,andinformationabouttheirjobsinaJobstable.However,anorganization’semployeescanhavemultiplejobs,andthesamejobcanbeperformedbymultipleemployees.Thissituationwouldresultinamanyto-manyrelationshipbetweentheEmployeesandJobstables.Howcanthemanyto-manyrelationshipissueberesolved?
A.Bymodelingthemanytomanyrelationshipinthebusinessmodel
B.Bycreatingabridgetablethatrepresentsoneemployeedoingonejob,withseveralrowsforan employeewhohasseveraljobs
C.Bycreatingthemanytomanyjoininthephysica
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 1z0591BI Foundation 11g题库v2 z0591BI 11 题库 v2