Quiz
EY Test FINAL
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (120)
1When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?
- AThe lowest level of aggregation
- BThe highest level of aggregation
- CMultiple levels of aggregation
- DIndependently from aggregation level
2The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be .
- A$10,000
- B0
- C1
- DYear
3Which two components are required for all OBIEE installations?
- AAdmin Server
- BRCU Schema
- CManaged Server
- DNode Manager
- EOracle 11g
4The administration tool is the developer s interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?
- AChanges to the repository can only be carried out in offline mode.
- BMultiple developers can work on one repository at the same time.Results can be merged later on.
- CAll aspects of security are being held in the repository file.
- DOpening the rpd.filein online mode results in performance Issues for the application user.
5Which installation option is used to install into an existing Fusion Middleware Home?
- ASoftware Only Install
- BSimple Install
- CEnterprise Install
- DCannot install into an existing Fusion Middleware Home
6What are the two methodologies that are followed within an OBIEE implementation?
- ADo not use prototypes
- BUse an iterative approach
- CStart with a small model and then enhance the repository
- DStart with a big repository and trim it down with the requirements
7Which option describes how OBIEE Integrates with Planning?
- AOBIEE primarily accesses Planning using standard Essbase integration techniques.
- BOBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
- CPlanning is not a supported OBIEE source.
- DOBIEE integrates with Planning directly through relational database access.
8What is an example of a Session Variable?
- AETL Load Date
- BUser Organization
- COLAP DSN
- DTop Customers by Revenue
9Which option is used to enter the rank function when creating a new rank measure?
- AInitialization Block
- BExpression Builder
- CConnection Pool
- DWeb Catalog
10Query limits tab can be accessed through :
- ASecurity Manager, Query tab, Application role dialog box, Permissions
- BSecurity Manager, Application Roles tab, Query dialog box, Permissions
- CSecurity Manager, Application Roles tab, Application role dialog box, Permissions
- DSecurity Manager, Application Roles tab, Application role dialog box, Query Properties
11One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?
- AYear
- BMonth
- CQuarter
- DCurrent Month
12WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
- ACreating and Maintaining Users
- BAuthentication and Authorization
- CBasic Directory for storing user details
- DSubject area and row-level security, connection pool passwords
- EApplication of Session Variables as Data Filters
13Point-and-click generation of case statement logic can be accessed via which option?
- AColumn Formula -> Bins tab
- BCompound Layout
- CColumn Properties -> Conditional Format tab
- DAdvanced Tab
- ESubject Area metrics
14Which task can be performed after the Administrator link has been reached through logging into OBIEE?
- AAssociate map layers to columns
- BManage access to Subject Areas
- CSSO enablement
- DStart or Stop BI Managed Servers
15Which three techniques are applied to support Failover?
- AWebLogic Clustering
- BUniversal Installer > Scale Out BI System option
- COBIEE Clustering
- DVertical Scaleout
16The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
- AMS Visio
- BMS Excel
- CMS Project
- DMS Word
17A user s BI Home page provides one-click access to which three options?
- ACreate new content
- BOracle BI online documentation
- CCatalog search functionality
- DDashboard layout editor
- EBusiness model metadata
18A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- ABy creating a derived measure by using the Logical Columns available
- BBy creating a derived measure in the Column Mapping dialog box byusing the physical table columns.
- CBy creating a derived measure by using Logic Columns available and changing the aggregation type
- DBy creating a derived metric by using the Expression Builder
- EBy creating a derived metric by using the Calculation Wizard
19Which resource identifies the OBIEE Web Catalog (webcat) ?
- Ainstanceconfig.xml
- BRCU Schema
- CIdentity Store
- Dnqsconfig.ini
- EAdmin Server
20The ODBC DSN is never used for :
- AInitial import of the physical layer metadata on a Windows server
- BQuery execution and data access on a Windows server
- CInitial import of the physical layer metadata, query execution, and data access on a Windows Server
- DChanging passwords
- EComparing RPDs
21Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
- AOLAP cubes eliminate the need for a large number of aggregate tables.
- BOLAP cubes are stored outside of the database in highly optimized file structures.
- COLAP cubes can be easily transported from database to database.
- DOLAP cubes can be queried by using SQL.
22When Exporting an Analysis from a Dashboard, which of the following is NOT an option?
- AMS Excel
- BMS Word
- CPDF
- DCSV
23Which of the following characteristics pertain to a "ragged" hierarchy?
- AIt can only be stored in an XML structure.
- BA branch of the hierarchy may have a different number of levels than other branches.
- CAll values can have a maximum of six levels.
- DIt creates multiple levels of hierarchy in the database table.
24What is the process in which there is redundancy of data to improve performance?
- ARedundancy
- BNormalization
- CDenormalization
- DGranularity
- ECardinality
25An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD?
- ABy creating two Logical Fact Tables for each database
- BBy creating joins in the physical model so it looks like a single table
- CBy creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
- DBy creating two logical table sourcesand checking the�This Source should be combined with other sources at this level�box leaving the Fragmentation content area blank.
- EBy creating one logical table sources and checking the�This Source should be combined with other sources at this level�box
26What are the two leading design solutions recommended by Oracle that you would use for performance?
- ADesign requests that use Complex Queries
- BAvoid returning big data sets within the Dashboard
- CUse Cache
- DAvoid using Guided Navigation unless the data set is large
27The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?
- AOracle RDBMS
- BMicrosoft SQL Server
- CIBMDB2
- DTeradata
28There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
- ABy creating a derived measure on the logical columnItem number and using the count Function
- BBy creating a derived measure on the logical column item number and usingthe count distinct function
- CBy creating a derived measure based on the physical column item number and changing theaggregation method to count
- DBy creatinga derived metric by using the Expression Builder
29Which language is used by OBIEE to query Essbase?
- ASQL
- BLINQ
- CMDX
- DDMX
30Which are the three types of tables available to physical tables in the physical layer?
- APhysical Table
- BStored Proc
- CSelect
- DView
- ETable
31Which option describes how OBIEE natively integrates with HFM?
- AThrough EPM Analytic Data Model (ADM) connectivity
- BDirect relational database access
- CThrough Essbase connectivity
- DOBIEE does not support HFM integration
32Select the scenario in which block storage must be used instead of aggregate storage.
- AIncremental data loading
- BTop - down planning
- CExtremely sparse data sets
- DMillions of members in the outline
33What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
- ACascading Style Sheets
- BDHML Message files
- CXML Message Files
- DBI Presentation services web template
34In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?
- AAccess and Performance Layer
- BMaster Data Layer
- CStaging Data Layer
- DPresentation Data Layer
35Which two options are valid Repository Variable names?
- AUSER
- BCurrentDay
- CCurrentMonth
- DDate
36One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that :
- AMultiple SQL queries are performed
- BTwo SQL queries are performed to get data from both tables
- CA single SQL query is performed to get data from both tables
- DNo SQL queries are performed against the source tables
37When creating a Security Realm in the WebLogic Console, which object is created?
- AGroups
- BRow Level Filters
- CServer Password
- DSingle Sign On
38Select the correct statement.
- ACache provides fast and always up-to-date information.
- BCache can increase traffic to back end database.
- CCache needs to be purged to refresh data.
- DCachecan degrade query performance by reading data from the disk instead of the database.
- ECache is seeded by manually running PL/SQL at the back end database.
39A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?
- AClicking the "Time" option in theLogical Dimension Dialog
- BDesignating a chronological key for every level of every dimension hierarchy
- CClicking the "Time" option in the LogicalTable Source Dialog
- DDesignating a chronological keyfor every logical column in the Logical Table Source
- ESpecifying a sort order in the Logical Table dialog
40When creating a query. Subject areas can be combined via point and click as long as .
- Athe subject areas share objects of the same name
- Bthe subject areas both share the same model in the business model and mapping layer
- Cthe subject areas are both from the same physical source, though they may be in separate business layers
- Dtwo or more subject areas cannot be joined together without manually mapping the contents
41Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?
- ATest Environment
- BSystem Testing
- CPerformance Tuning
- DProject initiation and resourcing
- EData Validation / Verification
42How will you model a Type II Slowly-Changing Dimension?
- AAdd an additional column to the dimension table to capture a version of change
- BOverwrite an existing dimension table record with the changed record
- CAdd a new row to the dimension table with a new key for the changed record
- DDo Nothing
43Cache in OBIEE is used to . Select the two correct answers.
- Aimprove performance of Dashboards and Analysis
- Bdecrease query response time
- Cimprove Analysis data quality
- Deliminate Write Back Capabilities
- Ecreate Aggregate tables
44A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?
- ALogical Key
- BImplicitFact Column
- CAlias
- DLogical Column Name
- ECustomDisplay Name
45A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
- ABy specifying a one-to-many join between the tables with the small and large numbers of values
- BBy specifying a driving table
- CBy specifying a many to one join between the tables with the small and large numbers of values
- DBy creating your logical join by using theJoins Manager
- EBy creating your joins by using the Business Model Diagram
46Why is it necessary to join multiple source tables to a single dimension?
- ABecause transactional source systems are often denormalized
- BBecause transactional source systems are often normalized
- CBecause a single source table often contains all the dimensions needed
- DBecause the dimensions tables are built in the transactional systems
47Query Limits are used to manage Query environment in the repository for users and roles and can .
- AControl runaway queries
- BLimit Queries by maximum run time
- CControl aggregation
- DControl User Authentication
- EControl WriteBack Capabilities
48A derived measure is never used to_ .
- ACalculate share measures
- BAdd two logical columns together
- CCalculate a variance between two measures
- DCalculate the rank dimension values
- EInput data
49What are the two types of Session Variables?
- ASystem
- BNon System
- CStatic
- DDynamic
50Content that is saved in personal and shared folders can be browsed by using which view?
- ACatalog
- BDashboard
- CNew -> Analysis
- DHome
- EFavorites
51Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
- AAssign users to a webcatalog group
- BCreate a new repository group
- CCreate a new user in the repository
- DCreate a web catalog group
- EDefine permissions for Dashboard
52OBIEE 11g authentication of users is performed by which two components listed below?
- ARepository file (rpd)
- BEmbedded WebLogicLDAP server
- CExternal directories such as Active Directory using WebLogic and Fusion Middleware s Oracle Platform Security Services framework
- DBI Presentation Services
53One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?
- ABusiness Requirements Definition
- BTechnical Requirements Definition
- CData Quality Assessment
- DDashboard Testing
54Identify the two true statements about alias tables.
- AAlias tables are set up to avoid triangular or circular joins.
- BAlias tables are set up to include best practice naming conventions for physical table names.
- CAlias tables are set up to create another physical copy of the data.
- DAlias tables are set up to create a copy of the data with a filter applied to it.
55DSNs are set up for access to which data sources?
- AODBC Data Sources
- BOracle Data Sources
- CIBM Data Sources
- DTeradata Data Sources
56You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?
- ACreate a physical time table in your database.
- BCreate a Logical Table that is sourced from the time key in the fact table.
- CCreate an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.
- DCreate a Logical Table that is sourced from a time field in one of your dimension tables.
- ECreate a time table that is joined through a intervening Table so there is no foreign key relationship.
57Identity the three advantages of the BI Server metadata repository.
- AMapping of federated data sources to one logical object
- BAbility to change physical sources without losing reports
- CLittle changes in the physical layer to shiftfrom development to production environment
- DThree layers support the highest level of security
58The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
- AStart and Stop BI Services
- BBuild Aggregate Queries
- CCreate SummaryTables
- DManage user logins
59The Time Dimension hierarchy is a good example of a .
- ALevel-basedTime Dimension hierarchy
- BRagged Hierarchy
- CSkip Level Hierarchy
- DValue-based Hierarchy
60When designing a Star Schema, which option does not apply?
- AThe facts are quantifiable.
- BThe fact has several foreign keys that are primary keys in the dimensional table
- CFact table is joined to the related dimensional tables.
- DDimensional tables are normalized.
- EDimensional tables have one attribute primary key as Product_ID for products.
61If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
- ABy creating four new logical tables sources
- BBy creating four new logical table sources and choosing each dimension s level of aggregationin the Content tab
- CBy creatingfour new logical table sources and using the Fragmentation content to specify theaggregation levels
- DBy creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
62Which of the following native features of Essbase are not supported in OBIEE 11g?
- AMember Alias
- BAlternate Hierarchies
- CDynamic Time Series
- DParent/Child-based Hierarchies
63A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
- AUsing the Expression Builder
- BUsing the Calculation Wizard
- CDefining them in the physical data model
- DDefining them in the Presentation Layer
64When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
- AThe analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
- BThe Aggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
- CJob Managercanbe used to run the Aggregate Persistence script.
- DTheExtractionTransformation and Loading process creates the aggregate tables.
65Which three options apply to FMW Application Roles?
- AProvide an indirection between LDAP groups and BI roles
- BCan be exported / moved between FMW11g environments
- CAre created and managed by using the WLS Admin Console and FMW Control
- DCan be created by using BI Administrator Client and "pushed" to WLS Admin Console
- ESecures RPD permissions but NOT Web Catalog (webcat) permissions
66How do you get the BI plug-in for MS Office?
- ABy contacting the administrator
- BBy downloading it from the BI Server
- CBy downloading it from the Database Server
- DBy downloading it from Microsoft Server
67There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
- ABy creating two new logical tables sources
- BBy opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
- CBoth A and B
- DBy creating one new Logical Table Source
68Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
- ANavteq
- BTeleAtlas
- CGoogle
- DESRI
69The Consistency Checker checks .
- AThe validity of objects outside the metadata using the connection
- BMappings to the physical objects
- CFor objects deleted from the database
- DSyntax errors in derived logical columns
70A company s Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
- AFact-based
- BTime-based
- CMixed
- DComplex
71Identify the two types of storage for Essbase.
- AAggregate Storage Option and Block Storage Option
- BAggregate Storage and Cell Storage
- COLAP Storage and Cell Storage
- DAggregate Storage and Hybrid Columnar Compression
72Where is Cache in OBIEE located?
- AIn relational database
- BIt is local disk-based.
- CIn dynamic aggregate D
- DIn memory cache
73A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?
- AMake AggregateTable 1 the first table in the list of Logical Table Sources.
- BDo not map the logical levelin the Content tab.
- CSet the Priority Group to 0.
- DSet the Priority Croup to 5.
74Which OBIEE capability enables developers to build Aggregate tables?
- AAggregate Persistence Wizard
- BExpression Builder
- CTable Builder
- DQuery Analyzer
75When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?
- ALogical Key
- BParent Level
- CChild Level
- DDynamic Key
76What are the two types of Repository Variables?
- ASystem
- BNon System
- CStatic
- DDynamic
77Under what circumstances would you model within the BI environment to include transactional data directly?
- AWhen the customer needs near real-time data to support decision making in a fast changing environment
- BWhen the customer is not prepared to spend budget on data-warehousing
- CWhen the complexity of operational schema does not allow modeling in the BI repository
- DWhen it is not possible to query against a transactional system
78What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?
- AEdit Analysis
- BRefresh All
- CEdit Prompts and Levels
- DPublish
79Which three components are part of a cluster server?
- AMaster Server
- BRepository Publishing Directory
- CPrimary Cluster Controller
- DWeb Server
- EServer request Controller
80If Security attributes conflict, what happens?
- AThe user or application role is granted the minimum security attribute
- BThe user or application role is granted the maximum security attribute
- CThe user or application role is granted No security attribute
- DThe user or application role is granted the Fully Restrictive security attribute
81How do Dynamic Repository Variables differ from Static Repository Variables?
- ADynamic Repository Variables are not initialized by the Initialization Block.
- BDynamic Repository Variables cannot be used in the Expression Builder.
- CDynamic Repository Variables can be changed by data that is returned from queries.
- DDynamic Repository Variables cannot be used in a CASE statement.
82The three metadata layers are an important concept of the BI Server. Which statement is incorrect?
- AThe physical layer defines the objects and relationships that the OracleBIServer needs to writenative queries against each physical data source.
- BSeparating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
- CThe model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
- DThe presentation layer defines the relationship thatis needed to create the DML.
83Which two options are included in Oracle BI Server cache management techniques?
- AUsing NQSConfig.ini to manually edit the parameters
- BScheduling Server password
- CMaximum Number of Rows to Download to Excel
- DInspecting the cache reports
- EManage access to Subject Areas
84To add multiple sources to on existing logical table dimension in the Business Model and
Mapping layer, the source of the data must first exist in which option?- APresentation Layer
- BBusiness Aggregate Layer
- CPhysical Layer
- DWeb Catalog
85A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?
- AStores
- BOrders
- CProducts
- DTime
86What is the first step when creating an Aggregate table in the OBI repository?
- ATest the Aggregate table by using Analysis
- BSpecify the Fact table that you want to aggregate
- CUse Job Manager to run the Aggregate script
- DCreate a dedicated Connection Pool
87Where is Oracle Mapviewer installed?
- AIn the same domain as OBIEE on the web application server
- BNever on the same domain as OBIEE on the web application server
- COn the Database server
- DOn its own application server
88When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?
- AIt defines the granularity of the dimension.
- BIt determines the actual value of the dimension.
- CIt creates a new session variable.
- DIt creates a foreign key relationship.
89Which component is responsible for determining the device that receives the alerts for a given user account?
- ADashboard
- BiBot
- CAlerts
- DDelivery Profiles
90What are the two disadvantages of implementing Query Caching?
- AReduction in BI server processing time
- BCache results being old
- CStorage space for cache
- DIncreased network traffic
- ENeeds a lot of administrators time
91Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
- AOnline
- BOffline
- CManaged
- DUnManaged
92Derived metrics are .
- ADerived from other logical columns
- BDerived from other physical columns
- CUsed to apply pre-aggregation calculations to measures
- DUsed to rename measures to user-friendly names
93Which variable does not use initialization blocks to initialize its values?
- AStatic Repository Variable
- BDynamic Repository Variable
- CSystem Variable
- DNon System Variable
94An organization has its employees names in an Employees table, and information about their jobs in a Jobs table. However, an organization s employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to- many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?
- ABy modeling the many to many relationshipin the business model
- BBy creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
- CBy creating the many to many join in the physical model
- DBy creating alogical table source (LTS) thatjoins the Employees and Jobs tables
95Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week s sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished
- AEveryday before Data Warehouse refresh
- BEvery day after Data Warehouse refresh
- CEvery Monday early morning
- DEvery Monday late night
96Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
- ANQSConfig.ini
- BCache table in OBIEE repository
- CWebCatalogue
- DInstanceconfig.xml
97What must be done before you can run the Oracle Business Intelligence 11g Installer?
- AObtain BI installation media
- BCreate required Oracle Business Intelligence schemas in a database
- CEnsure system meets installation requirements for Fusing Middleware, Oracle Business Intelligence, AND Repository Creation Utility
- DInstall the WLS Admin Server
- ESelect installation components �OBIEE, BIP, RTD
98Which option does not describe Aggregate tables?
- AAggregatetables increase query performance by pre-calculating frequently accessed measure aggregations.
- BAggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
- CAggregate tables typically have fewer rows than the non aggregate tables and,therefore,processing should be quicker.
- DAggregate tables are created and stored on the BI Server.
99Security Manager is used for .
- ASetting permissions for particular users or application roles
- BSetting permissions for individual objects in the Presentation Layer
- CSetting up new Roles and Groups
- DSetting up new Application Roles
100Which configuration can be changed through Enterprise Manager?
- AMinimum Number of Rows to Download to Excel
- BThe default BI Server Repository
- CStart and Stop BI Services
- DManages user login
101Which two Oracle BI Components contain security information regarding permissions and privileges?
- AThe Web Catalog
- BThe Repository
- CNQSConfig.ini File
- DNQServer.ini File
- EInstanceConfig.xml File
102A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?
- ACreate a derived measure by using the addition function that adds each product value together.
- BCreate a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.
- CCreate a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.
- DCreate a derived metric by using the Expression Builder.
103Which analysis features could be applied to provide interactive controls for end users?
- AColumn Selector
- BAction Links
- CConditional Formatting
- DNarrative View
- EGreenbar Styling
104An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
- ABy creating Presentation Folder calledTime and then two subsequent folders called-> Fiscal Calendar and-> Julian Calendar
- BBy creating aPresentationFolder called ->Timecalledthen two subsequent folders calledFiscal Calendar and Julian Calendar
- CBy creatingaPresentation Foldercalled -Time and then two subsequent folders called + FiscalCalendar and+Julian Calendar
- DBycreating a Presentation Foldercalled Time<parent> and thentwo subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>
105OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the .
- APolicy Store
- BCredential Store
- CIdentity Store
- DPerson Store
106If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?
- AThe data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.
- BData warehouses can only be based on multidimensional data modeling.
- CApplication based data warehouses can be bought off the shelf and used without any tweaking.
- DData warehouse projects are usually implemented within two weeks.
107Initialization Blocks are never used to initialize which option?
- ADynamic Repository Variables
- BSystem Session Variables
- CNon System Session Variables
- Drpd file
108What must be purchased when integrating Oracle map with Oracle BI?
- AOracle Mapviewer
- BOracle Business Intelligence Enterprise Edition
- CSpatial Option with Database
- DOLAP option
109The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.
- AOperational system might be overburdened with analytical requests resulting in had performance for transactional processes.
- BThe BI server cannot integrate various sourcesin one metadata model.
- CDataquality issues might emerge, due to missing data cleansing.
- DBusiness issues are depending on real-time data.
110Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
- AOracle Enterprise Manager
- BOracle HTTP Server
- CWeb Logic Server Administration Component
- DBI Administration Tool
111You run the Consistency Check and receive the warning: [39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT. What would you check?
- AWhether the logical table source for this column has been disabled
- BWhether the columns creating CREATE_DT have been deleted
- CWhether there is a logical join between the DIM and FACT tables
- DWhether there is a physical join between the DIM and FACT tables
- EWhether there is a physical column mapped to the logical column
- FDIM_Offer_End_Date.CREATE_DT
112How do System Session Variables obtain their values?
- AThey are entered by user input on a dashboard
- BThey are obtained from data fields in the Physical Layer
- CThey are obtained from the Presentation Layer
- DThey are obtained from the Initialization Block
113Selecting the Manage Map Data link allows one to do which three of the following?
- AAssociate map layers to columns defined in the OBIEE metadata
- BCreate a new map layer
- CSet the zoom level of an imported map
- DImport images for use on maps
114Which option is not an example of a level-based measure?
- ARegional Revenue
- BSales
- CBrand Cost
- DEmployee Salary
115Use of the Enterprise Install option is recommended for which three options?
- AMultiple instances on a single computer
- BScale out for High Availability and Failover
- CSupport for high security requirements
- DEvaluation of end user functionality
- ESingle users working on a single computer
116What are the two ways to use the administration tool?
- AIt can be used to manage user password.
- BThe administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.
- CIt can be used for versioning of the rpd.
- DAdministrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
117An integrated BI tools business case can be built around which three options?
- AScalability
- BFault tolerance
- CCost Savings
- DDevelopment efficiency
118Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?
- ASingle Sign-On (SSO)
- BDatabase Authentication
- CBusiness Logic Object Security
- DExternal Table Authentication
- ELDAP Authentication
119Which two steps are needed to set up Failover support for an OBIEE deployment?
- AUse Installer to affect Horizontal scale out of an existing instance
- BEmploy WebLogic Enterprise Edition, licensed separately
- CUse Installer to set up separate single instances, then apply Horizontal scale out clustering
- DApply OBIEE Clustering option
- ELeverage spare hardware capacity of single machine by using Verticalscale out option
120When creating an initialization Block, which BI Administration function is used?
- AVariable Manager
- BJob Manager
- CIdentity Manager
- DProjects Manager
Informações
- Descrição
- Fitness Quiz sobre EY Test FINAL, criado por xd xdd em 08-09-2018.
- Autor
- xd xdd
- Idioma
- Español
- Visualizações
- 50
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz