Oracle 1z0-591 Exam Practice Questions (P. 3)
- Full Access (120 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #11
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?
Repository Variable?
- AYear
- BMonth
- CQuarter
- DCurrentMonth
Correct Answer:
D
CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.
Provide Intialization Block variable Name
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g. select lower(sys_context('USERENV','SESSION_USER'))||
'@'||
lower(sys_context('USERENV','DB_NAME'))
from dual;
D
CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.
Provide Intialization Block variable Name
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g. select lower(sys_context('USERENV','SESSION_USER'))||
'@'||
lower(sys_context('USERENV','DB_NAME'))
from dual;
Question #13
Point-and-click generation of case statement logic can be accessed via which option?
- AColumn Formula -> Bins tab
- BCompound Layout
- CColumn Properties -> Conditional Format tab
- DAdvanced Tab
- ESubject Area metrics
Correct Answer:
A
The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that its a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note:
Figure:
Incorrect answers:
C: The "Conditional Format" tab lets you set formatting when specific conditions are met.
A
The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that its a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note:
Figure:
Incorrect answers:
C: The "Conditional Format" tab lets you set formatting when specific conditions are met.
Question #14
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
- AAssociate map layers to columns
- BManage access to Subject Areas
- CSSO enablement
- DStart or Stop BI Managed Servers
Correct Answer:
BCD
B: BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options
C: Enable the SSO through the FMW Control.
D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line.
BCD
B: BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options
C: Enable the SSO through the FMW Control.
D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line.
Question #15
Which three techniques are applied to support Failover?
- AWebLogic Clustering
- BUniversal Installer > Scale Out BI System option
- COBIEE Clustering
- DVertical Scaleout
Correct Answer:
ABC
A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.
B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, youd choose to instead scale out the existing BI domain.
C: OBIEE Clustering Approach of Oracle BI Server Load balancing/Failover
ABC
A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.
B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, youd choose to instead scale out the existing BI domain.
C: OBIEE Clustering Approach of Oracle BI Server Load balancing/Failover
All Pages