1Z0-591 Exam Questions
131 real 1Z0-591 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #101
Which three options apply to FMW Application Roles?
- Question #102Oracle BI EE Architecture
How do you get the BI plug-in for MS Office?
BI plug-inMS OfficeBI Serverdownload - Question #103Creating Aggregate Tables
There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
aggregate tableslogical table sourcecontent tablevel mapping - Question #104
Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
- Question #105Oracle BI Administration Tool: Basics
The Consistency Checker checks______.
consistency checkermetadata validationphysical objectsmappings - Question #106Adding Multiple Logical Table Sources to a Logical Table
A 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. Wha...
partitionfragmentationregion tabledata splitting - Question #107Developing the Physical Layer of a Repository
What is the process in which there is redundancy of data to improve performance?
denormalizationdata redundancyperformancedata modeling - Question #108Adding Multiple Logical Table Sources to a Logical Table
An 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 pr...
fragmentation contentlogical table sourcesmultiple databasesdata federation - Question #109Setting Up and Administering a Security Model
When creating a Security Realm in the WebLogic Console, which object is created?
WebLogic Consolesecurity realmgroupsauthentication - Question #110Cache Management
Select the correct statement.
cache managementcache purgedata refreshquery cache - Question #111Modeling Time Series Data
A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?
rolling periodchronological keytime dimensionAGO functions - Question #112Developing the Presentation Layer of a Repository
When creating a query. Subject areas can be combined via point and click as long as____.
subject areasbusiness model layercombined queriespresentation layer - Question #113
Pre 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?
- Question #114Developing the Physical Layer of a Repository
How will you model a Type II Slowly-Changing Dimension?
Type II SCDslowly changing dimensiondimension tabledata modeling - Question #115Cache Management
Cache in OBIEE is used to_____. Select the two correct answers.
cache managementquery performancedashboard performance - Question #116Oracle BI EE Architecture
Identify the two types of storage for Essbase.
Essbaseaggregate storage optionblock storage optionOLAP - Question #117
Which resource identifies the OBIEE Web Catalog (webcat)?
- Question #118Developing the Physical Layer of a Repository
The ODBC DSN is never used for _______.
ODBC DSNphysical layer importRPD comparisondata source connection - Question #119Creating Aggregate Tables
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
Oracle OLAPOLAP cubesaggregation strategySQL querying - Question #120
When Exporting an Analysis from a Dashboard, which of the following is NOT an option?
- Question #121Extending the Oracle BI Server
What must be purchased when integrating Oracle map with Oracle BI?
Oracle Mapsspatial optionmap integrationlicensing - Question #122
Data is stored in facts and dimensions _________
- Question #123Using Variables
Initialization Blocks are never used to initialize which option?
initialization blocksrepository variablessession variablesRPD file - Question #124
In which Oracle-recommended implementation stage would you gather business requirements?
- Question #125
In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?
- Question #126Using Variables
Which two options are valid Repository Variable names?
repository variablesvariable namingsystem variablesreserved names - Question #127Developing the Physical Layer of a Repository
When designing a Star Schema, which option does not apply?
star schemadimensional modelingfact tablenormalization - Question #128
Which of the following is NOT true of consistency check?
- Question #129
Which two of the following are not recommended when working with the catalog manager?
- Question #130
Which of the following NEVER uses initialization blocks to initialize its values?
- Question #131Using Variables
Which two of the following variables persist only while a user's session is active?
session variablessystem session variablesnon-system session variablesvariable scope