1Z0-591 Exam Questions
131 real 1Z0-591 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51
An integrated BI tools business case can be built around which three options?
- Question #52Setting Up and Administering a Security Model
Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?
object securitysubject areasbusiness logicaccess control - Question #53Using Variables
When creating an initialization Block, which BI Administration function is used?
initialization blockVariable ManagerBI Administrationvariable setup - Question #54Oracle BI EE Architecture
Which two steps are needed to set up Failover support for an OBIEE deployment?
failoverhigh availabilityhorizontal scale outOBIEE clustering - Question #55
When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?
- Question #56Modeling Time Series Data
The 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________.
rank measuretime seriessales rankinglevel-based measures - Question #57Oracle BI EE Architecture
Which two components are required for all OBIEE installations?
OBIEE installationRCU schemaOracle 11gsystem requirements - Question #58Oracle BI Administration Tool: Basics
The 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?
administration toolonline modemultiuser developmentrepository file - Question #59Oracle BI EE Architecture
Which installation option is used to install into an existing Fusion Middleware Home?
Software Only InstallFusion Middleware Homeinstallation optionsdeployment - Question #60
What are the two methodologies that are followed within an OBIEE implementation?
- Question #61Extending the Oracle BI Server
Which option describes how OBIEE Integrates with Planning?
Essbase integrationPlanningOBIEE integrationdata sources - Question #62Developing the Business Model and Mapping Layer of a Repository
Which option is used to enter the rank function when creating a new rank measure?
rank functionExpression Builderrank measurelogical measures - Question #63Setting Up Query Limits and Usage Tracking
Query limits tab can be accessed through________.
query limitsSecurity Managerapplication rolesquery properties - Question #64Using Variables
What is an example of a Session Variable?
session variablesvariable typesuser contextOBIEE variables - Question #65Using Variables
One 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?
dynamic repository variablesvariable initializationfiltersCurrentMonth - Question #66
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
- Question #67Building Reports and Charts
Point-and-click generation of case statement logic can be accessed via which option?
case statementsbinscolumn formulareport authoring - Question #68Creating and Administering Dashboards and Pages
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
map layersOBIEE administrationadministrator linkspatial integration - Question #69Cache Management
What are the two leading design solutions recommended by Oracle that you would use for performance?
performance optimizationcachingdashboard designquery efficiency - Question #70Oracle BI EE Architecture
The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?
WebLogicRCUrepository schemaDBMS compatibility - Question #71Developing the Business Model and Mapping Layer of a Repository
There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
derived measurescount distinctlogical columnsaggregation functions - Question #72Extending the Oracle BI Server
Which language is used by OBIEE to query Essbase?
EssbaseMDXmultidimensional queryOLAP connectivity - Question #73Developing the Physical Layer of a Repository
Which are the three types of tables available to physical tables in the physical layer?
physical table typesstored proceduresselect tablesphysical layer objects - Question #74Extending the Oracle BI Server
Which option describes how OBIEE natively integrates with HFM?
HFM integrationEPM ADMfinancial managementOracle EPM connectivity - Question #75Extending the Oracle BI Server
Select the scenario in which block storage must be used instead of aggregate storage.
block storageaggregate storageEssbasetop-down planning - Question #76Creating and Administering Dashboards and Pages
What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
CSSUI customizationpresentation servicesstyling - Question #77
Which two of the following could be the disadvantages of implementing query caching?
- Question #78
Row-wise initialization is enabled to initialize_________
- Question #79Adding Multiple Logical Table Sources to a Logical Table
One 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______.
multiple table sourcesforeign key joinsSQL generationlogical table sources - Question #80Adding Multiple Logical Table Sources to a Logical Table
Why is it necessary to join multiple source tables to a single dimension?
normalized source systemsdimensional modelinglogical table sourcesphysical joins - Question #81Setting Up Query Limits and Usage Tracking
Query Limits are used to manage Query environment in the repository for users and roles and can_________.
query limitsmax run timequery managementperformance controls - Question #82
A derived measure is never used to_________.
- Question #83Using Variables
What are the two types of Session Variables?
session variablessystem variablesnon-system variablesvariable classification - Question #84Creating and Administering Dashboards and Pages
Content that is saved in personal and shared folders can be browsed by using which view?
catalogfolder navigationshared contentpersonal folders - Question #85Setting Up and Administering a Security Model
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
object-level securityrepository groupsuser managementBI Admin tool - Question #86
OBIEE 11g authentication of users is performed by which two components listed below?
- Question #87
One 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?
- Question #88Developing the Physical Layer of a Repository
Identify the two true statements about alias tables.
alias tablescircular joinsnaming conventionsphysical layer design - Question #89Developing the Physical Layer of a Repository
DSNs are set up for access to which data sources?
DSNODBCdata source configurationphysical layer connectivity - Question #90Oracle BI EE Architecture
Identity the three advantages of the BI Server metadata repository.
metadata repositoryfederated data sourcesphysical layersecurity - Question #91Modeling Time Series Data
You 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?
time serieslogical table sourcetime dimensionphysical time table - Question #92Oracle BI EE Architecture
The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
WebLogic ConsoleBI Managed ServerBI servicesadministration - Question #93Developing the Presentation Layer of a Repository
A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?
implicit fact columndimension queriespresentation layerno measures - Question #94Developing the Physical Layer of a Repository
A 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 optimi...
cross database joindriving tablequery optimizationfederated queries - Question #95Creating Dimensional Hierarchies
The Time Dimension hierarchy is a good example of a__________.
time dimensionlevel-based hierarchydimensional hierarchy types - Question #96Creating Aggregate Tables
If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
aggregate tableslogical table sourcesdimension level aggregationcontent tab - Question #97
You would like to customize the text elements that appear in BI answer, BI delivers, and on dashboard pages. Which of the following would you use?
- Question #98Developing the Physical Layer of a Repository
Which of the following native features of Essbase are not supported in OBIEE 11g?
Essbasedynamic time seriesnative featuresOBIEE 11g - Question #99Building Reports and Charts
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
calculation wizardpercent changerevenue metricsderived measures - Question #100Creating Aggregate Tables
When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
Aggregate Persistence Wizardphysical aggregate tablesJob Managerautomation