This dump is 100% valid to pass Oracle Java and Middleware 1Z0-591 exam. The only tips is please do not just memorize the questions and answers, you need to get through understanding of it because the question changed a little in the real exam. Follow the instructions in the CertBus Java and Middleware 1Z0-591 Oracle Business Intelligence Foundation Suite 11g Essentials PDF and VCEs. All CertBus materials will help you pass your Oracle Java and Middleware exam successfully.
We CertBus has our own expert team. They selected and published the latest 1Z0-591 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-591.html
QUESTION NO:55
DSNs are set up for access to which data sources?
A. ODBC Data Sources
B. Oracle Data Sources
C. IBM Data Sources
D. Teradata Data Sources
Answer: A
Explanation: The principal connection to an OBI Server inside the Oracle BI System is
made through an Odbc Connection.
OBI Server can handle multiple repository but you can connect to only one at the same
time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each
repository.
QUESTION NO:98
Which option does not describe Aggregate tables?
A. Aggregate tables increase query performance by pre-calculating frequently accessed
measure aggregations.
B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better
query response.
C. Aggregate tables typically have fewer rows than the non aggregate tables and,
therefore, processing should be quicker.
D. Aggregate tables are created and stored on the BI Server.
Answer: D
Explanation:
QUESTION NO:61
If you have a database with four aggregate tables, how should the repository be configured
to take advantage of the aggregates?
A. By creating four new logical tables sources
B. By creating four new logical table sources and choosing each dimension\’s level of
aggregation in the Content tab
C. By creating four new logical table sources and using the Fragmentation content to
specify the aggregation levels
D. By creating four new logical table sources and using the “where” section of the Content
tab to specify the aggregation levels
Answer: B
Explanation: Content Tab
Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level
by logical column
It helps you to define an aggregate navigation
Note: logical table source
Logical table sources define the mappings from a single logical table to one or more
physical tables. A logicaltable contains one or more logical table source. The mapping
between physical columns and logical columns are done in this element.
The definition of the logical table source is used:
The Content tab of the Logical Table Source is used to define :
QUESTION NO:16
The Oracle BI office plug-in allows you to import the results of an OBI request into which
two MS applications?
A. MS Visio
B. MS Excel
C. MS Project
D. MS Word
Answer: B,D
Explanation: Oracle Business Intelligence Office Plug-In is a Windows application that is
an optional feature under the Oracle Business Intelligence Presentation Services. The
Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that
report into Microsoft Word or Excel.
Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide
> Installing Individual Oracle BI Components >Installing Oracle BI Office Plug-In
QUESTION NO:28
There is a logical fact table that contains Item number, store, time, and revenue. How
would you add Number of items sold?
A. By creating a derived measure on the logical column Item number and using the count
Function
B. By creating a derived measure on the logical column item number and using the count
distinct function
C. By creating a derived measure based on the physical column item number and changing
the aggregation method to count
D. By creating a derived metric by using the Expression Builder
Answer: C
Explanation: A measure column is a column unlike the baseline column that has a default
aggregation rule defined in the Aggregation tab of the Logical Column dialog in the
repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a
measure.
QUESTION NO:57
Identity the three advantages of the BI Server metadata repository.
A. Mapping of federated data sources to one logical object
B. Ability to change physical sources without losing reports
C. Little changes in the physical layer to shift from development to production environment
D. Three layers support the highest level of security
Answer: A,C,D
Explanation: A: OBIEE Federated Repository
Instead of moving data in to a single database, OBIEE
QUESTION NO:31
Which option describes how OBIEE natively integrates with HFM?
A. Through EPM Analytic Data Model (ADM) connectivity
B. Direct relational database access
C. Through Essbase connectivity
D. OBIEE does not support HFM integration
Answer: A
Explanation: BI EE uses the ADM driver to extract the data from HFM.
Note: HFM (Hyperion Financial Management)
Example:
I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to
basically make the EPM environment variables available for access to BI EE. Before
making the changes, there are a couple of things to be aware of
1. Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client
to work/connect properly with HFM Server.
2. Ensure that HFM Client is installed.
The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to
have the ADM drivers installed manually. All of this is documented clearly. So, rather than
re-iterating that i will just point to the link here. Ensure that you follow all the steps
mentioned in the docs else you will have issues in the connectivity. Once all the prerequisite
steps are done, we start off with the metadata import process.
QUESTION NO:67
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?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes and mapping the appropriate
levels in the Content tab
C. Both A and B
D. By creating one new Logical Table Source
Answer: B
Explanation: B: Example:
1. Configure the new source table to have the \’logical level\’ under the content set to
\’Countries\’ (the summarized level)
b
2. Do the similiar setting for dimension table
Now when user query the data at \’Counties\’ level, the query will be redirected to these
summary table instead of the more detail fact table
Note: Aggregate tables are Physical tables that store Aggregates of measures across
multiple levels of a Hierarchy.
QUESTION NO:41
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?
A. Test Environment
B. System Testing
C. Performance Tuning
D. Project initiation and resourcing
E. Data Validation / Verification
Answer: D
Explanation:
QUESTION NO:63
A customer would like to create a change and a % Change for Revenue at the same time.
How would they accomplish this?
A. Using the Expression Builder
B. Using the Calculation Wizard
C. Defining them in the physical data model
D. Defining them in the Presentation Layer
Answer: B
Explanation:
After creating your base metrics, try using the Calculation Wizard to automate the process
of creating time-series metrics or comparison metrics such as: Change, Percent Change,
Index, and Percent. The Wizard may save you many hours of time and frustration,
especially if you have to create more than a handful of these metrics. In addition, the
Wizard allows you to include customized logic to handle nulls in the base metrics. You may
refer to the Oracle documentation for further detail.
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-591 exam successfully with our Oracle materials. CertBus Oracle Business Intelligence Foundation Suite 11g Essentials exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle Business Intelligence Foundation Suite 11g Essentials exam questions and answers are the most valid. CertBus exam Oracle Business Intelligence Foundation Suite 11g Essentials exam dumps will help you to be the Oracle specialist, clear your 1Z0-591 exam and get the final success.
1Z0-591 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mTmxMWlpXVzVxUDg/view?usp=sharing
1Z0-591 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-591.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.