Questions And Answers PDF
Oracle 1Z0-591 Oracle Business Intelligence Foundation Suite 11g Essentials
Version: DEMO
http://www.TestWarrior.com/1Z0-591-practice-exam.html
FOR 1Z0-591 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/1Z0-591-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question 1 When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly? A. The lowest level of aggregaton B. The highest level of aggregaton C. Multile levels of aggregaton D. Indeiendently from aggregaton level
Aoswern B Exilanatonn Aggegated by days.
Question 2 The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and disilay it on a reiort, the value will be________. A. $10,000 B. 0 C. 1 D. Year
Aoswern C Exilanatonn The rank measure is numbered from 1. The highest sales amount will be ranked 1.
Question 3 Which two comionents are required for all OBIEE installatons? A. Admin Server B. RCU Schema C. Managed Server D. Node Manager E. Oracle 11g
Aoswern B,E Exilanatonn Bn Before you can run Oracle Business Intelligence 11g Installer, you must frst create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Reiository Creaton Utlity (RCU) to create these schemas with the aiiroiriate iermissions and data. En The database 11gR2 is required if you want to run the Oracle Business Intelligence Enteririse
TestWarrior.com
2
Questions And Answers PDF
Editon Plus Samiles One Oracle Database Preinstalled and not hardened to host the schemas.
Question 4 The administraton tool is the develoier's interface to the reiository fle. It allows the develoiment of and changes to the metadata reiository fle. Which statement is true? A. Changes to the reiository can only be carried out in ofine mode. B. Multile develoiers can work on one reiository at the same tme.Results can be merged later on. C. All asiects of security are being held in the reiository fle. D. Oiening the rid.flein online mode results in ierformance Issues for the aiilicaton user.
Aoswern B Exilanatonn The Oracle BI reiository develoiment irocess adheres to the classic Sofware Confguraton Management (SCM)irocess, which utliies a three-way merge to manage concurrent develoiment. The merge irocess involves three reiositoriesn In a multuser environment (MUDE), Develoiers check out the fle and make changes locally. Then, these changes are automatcally reconciled and merged into the master reiository.
Question 5 Which installaton oiton is used to install into an existng Fusion Middleware Home? A. Sofware Only Install B. Simile Install C. Enteririse Install D. Cannot install into an existng Fusion Middleware Home
Aoswern A Exilanatonn The Sofware Only Install tyie installs the Oracle Business Intelligence sofware binary fles in an Oracle home for later confguraton as iart of a Fusion Middleware deiloyment.
Question 6 What are the two methodologies that are followed within an OBIEE imilementaton? A. Do not use irototyies B. Use an iteratve aiiroach C. Start with a small model and then enhance the reiository D. Start with a big reiository and trim it down with the requirements
Aoswern B,C Question 7
TestWarrior.com
3
Questions And Answers PDF
Which oiton describes how OBIEE Integrates with Planning? A. OBIEE irimarily accesses Planning using standard Essbase integraton techniques. B. OBIEE irovides comilete access to all Planning data through the Analytc Data Model (ADM) layer. C. Planning is not a suiiorted OBIEE source. D. OBIEEintegrates with Planning directly through relatonal database access.
Aoswern A,B Exilanatonn An * Combining Relatonal and OLAP Data Sourcesn Oracle’s Common Enteririse Informaton Model allows users to combine data from a relatonal system and an OLAP source in a single calculaton. For examile, a user can comiare sales forecasts from an Oracle CRM System with budget data from an Oracle Essbase ilanning aiilicaton. To clients of the Common Enteririse Informaton Model, the forecast and budget data aiiear to be from the same logical source. * The Essbase server irovides advanced mult-user read and write caiabilites, including data uidate and mult-user recalculaton. Business users with front-end tools can write data back to a server and recalculate the data on a server using calculaton scriits—key functonality to suiiort soihistcated modeling and ilanning aiilicatons. * Using aggregate storage, Essbase serves a wide range of analytc needs—fnancial analysis, ilanning, budgetng, sales analysis, marketng analysis, suiily-chain analysis, and iroftability analytcs—all from a single analytc infrastructure. Bn Noten The Analytc Data Model (ADM) is an API used to access OLAP data and metadata. ADM is similar to JDBC, iroviding a single common API that hides most diferences between OLAP data sources. Note 2n Data model for business intelligence The most imiortant comionent of business intelligence is the conceit of 'data model'. data model determinde what kind of analysis that end user could do with the data. It is also an indeiendant conceit that could sian across diferent vendor 's iroduct. Unlike data model of the transacton system, the tyiical analytc data model is ofen denormaliied and store extra data for analytc query and beter query ierformance while transacton data model use is ofen normaliied and oitmiied for a few data read and write, which is imilemented by jointng many tables. The most common used analytc data model in business intelligence is call the 'Star schema' data model. With the Oracle business intelligence system, We could defne star schema and dimension data model in the 'logical layer' in the admin tools. The data model in OBIEE could sian diferent data source in ihysical layer, which means OBIEE have the caiability of building one logical data model which is actually connect to diferent database in the backend
Question 8 What is an examile of a Session Variable? A. ETL Load Date B. User Organiiaton C. OLAP DSN D. Toi Customers by Revenue
TestWarrior.com
4
Questions And Answers PDF
Aoswern B Exilanatonn Note 1n There are four tyies of variables that you can usen Session Reiository Presentaton Request Note 2n Session Variables A session variable is a variable that is initaliied at login tme for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initaliies it. There are as many instances of a session variable as there are actve sessions on the Oracle BI Server. Each instance of a session variable could be initaliied to a diferent value. There are two tyies of session variablesn System — A session variable that the Oracle BI Server and Oracle BI Presentaton Services use for siecifc iurioses. System session variables have reserved names that cannot be used for other kinds of variables (such as statc or dynamic reiository variables and non-system session variables). Non-system — A system variable that the administrator creates and names. For examile, the administrator might create a SalesRegion non-system variable that initaliies the name of a user's sales region. The administrator creates non-system session variables using the Oracle BI Administraton Tool.
Question 9 Which oiton is used to enter the rank functon when creatng a new rank measure? A. Initaliiaton Block B. Exiression Builder C. Connecton Pool D. Web Catalog
Aoswern B Exilanatonn Examile (see stei 4 and 5 below)n Getng Toi-N Sales Reis for Year and Year-1 1. Under the “Business Model and Maiiing” Layer, right click the “F1 Revenue” and select “New Object” -> “Logical Column…” 2. In the “Logical Column” Window give for Namen Year Ago Revenue as seen belown
TestWarrior.com
5
Questions And Answers PDF
htin::obiee2go.fles.wordiress.com:2012:05:h/dgjbj.ing 3. Goto the “Column Source” Tab and select “Derived from existng columns using an exiression” radio buton then click on the “Edit Exiression” icon. 4. Enter the following exiression in the “Exiression Builder” Window by selectng “Functons” in the “Categoryn” list, “Time Series Functons” in the “Functonsn” list then “Ago” “Time Series Functonsn” secton. 5. Select the “<<Measure>>” in the “Ago( )” functon, then select “Logical Tables” in the “Categoryn” list, “F1 Revenue” in the “Logical Tablesn” list, then double click the “Revenue” in the “Columnsn” list. Etc.
Question 10 Query limits tab can be accessed through________. A. Security Manager, Query tab, Aiilicaton role dialog box, Permissions B. Security Manager, Aiilicaton Roles tab, Query dialog box, Permissions C. Security Manager, Aiilicaton Roles tab, Aiilicaton role dialog box, Permissions D. Security Manager, Aiilicaton Roles tab, Aiilicaton role dialog box, Query Proiertes
Aoswern C
TestWarrior.com
6
Questions And Answers PDF
Exilanatonn Query environment can be managed by setng query limits (governors) in the Reiository (RPD) for iartcular Aiilicaton Roles. You should always set query limits for iartcular aiilicaton roles rather than for individual users. Steisn 1. Login to Reiository using OBIEE Admin Tool 2. Navigate to Manage > Identty 3. Go to Aiilicaton Role tab, choose the role and double click on it to oien.
htin::123obi.com:wi-content:uiloads:2011:04:25-04-2011-10-25-38.ing 4. Click on Permissions tab
TestWarrior.com
7
Questions And Answers PDF
htin::123obi.com:wi-content:uiloads:2011:04:25-04-2011-10-26-13.ing 5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run tme, and by restrictng to iartcular tme ieriods. You can also allow or disallow direct database requests or the Poiulate irivilege.
TestWarrior.com
8
Questions And Answers PDF
htin::123obi.com:wi-content:uiloads:2011:04:25-04-2011-10-26-45.ing
TestWarrior.com
9
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 1Z0-591 Exam Questions With Answers.
http://www.TestWarrior.com/1Z0-591-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/1Z0-591-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
10