Quiz
EY Parte 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (30)
1Which 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
2Select 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
3What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
- ACascading Style Sheets
- BDHMLMessage files
- CXMLMessage Files
- DBI Presentation services web template
4In 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 DataLayer
5Which two options are valid Repository Variable names?
- AUSER
- BCurrentDay
- CCurrentMonth
- DDate
6One 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
7When creating a Security Realm in the WebLogic Console, which object is created?
- AGroups
- BRow Level Filters
- CServer Password
- DSingle Sign On
8Select 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.
9A 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 theLogicalTable dialog
10When 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
11Pre 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
- DProjectinitiation and resourcing
- EData Validation / Verification
12How 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
13Cache 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
14A 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
15A 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 largenumbers 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
16Why 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
17Query 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
18A 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
19What are the two types of Session Variables?
- ASystem
- BNon System
- CStatic
- DDynamic
20Content that is saved in personal and shared folders can be browsed by using which view?
- ACatalog
- BDashboard
- CNew -> Analysis
- DHome
- EFavorites
21Identify 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
22OBIEE 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
23One 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 RequirementsDefinition
- BTechnical Requirements Definition
- CData Quality Assessment
- DDashboard Testing
24Identify 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.
25DSNs are set up for access to which data sources?
- AODBC Data Sources
- BOracle Data Sources
- CIBM Data Sources
- DTeradata Data Sources
26You 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 aLogical Table that is sourced fromthe time keyin the fact table.
- CCreate an "Opaque View" in the physicallayer that contains the time columns from the fact and map itinto your physical model.
- DCreate a Logical Table that is sourced from a time field in one of your dimension tables.
- ECreat ea time table that is joined through a intervening Table so there is no foreign keyrelationship.
27Identity 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
28The 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
29The Time Dimension hierarchy is a good example of a .
- ALevel-basedTime Dimension hierarchy
- BRagged Hierarchy
- CSkip Level Hierarchy
- DValue-based Hierarchy
30When 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.
Information
- Description
- Quiz on EY Parte 2, created by xd xdd on 01/08/2018.
- Author
- xd xdd
- Language
- Español
- Views
- 37
- Rating
- No ratings yet Rate this quiz