Quiz
EY Parte 2
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem 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.
Informationen
- Beschreibung
- Quiz am EY Parte 2, erstellt von xd xdd am 01/08/2018.
- Autor
- xd xdd
- Sprache
- Español
- Aufrufe
- 37
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz