QUESTION NO: 1
What is the default location where
parameter files are created by DAC?
A. $DAC_HOME\Informatica\server\parameters
B. $DAC_HOME\Informatica\parameters
C. $DAC_HOME\parameters
D. $lNFA_HOME\server\infa_shared\BWParam
Answer: B
QUESTION NO: 2
The webcat structure, along with
various other presentation parameters are stored in:
A. DBFeatures.ini
B. Instanceconfig.xml
C. NQSConfig.ini
D. Repository File
(.rpd)
Answer: D
QUESTION NO: 3
A large insurance company ABC-Safe
uses PeopleSoft and Hyperion Planning & Budgeting for
Financial Analytics and a third-party
software package for HR Compensation. ABC-Safe wants to
have a consolidated picture of its
finances and compensation packages. What would you advise?
A. Immediately enhance
the existing Oracle BI Financial Application with HR analytics.
B. Perform a fit-gap
analysis on the usability of the ETL for HR analytics and cross functionality
with Financial Applications and
present a business case for extending the Oracle BI Applications
environment with Oracle BI HR
analytics or enhance the existing BI applications environment with
HR data by building the ETL, enhance
the BI repository, Reports& Dashboards, security and other
needed elements.
C. Oracle BI
applications cannot be enhanced by data from third-party software packages.
D. Offer implementing
Oracle BI HR Analytics, including a calculation for reusing prebuilt ETL
using the Universal connector.
E. Offer implementing
Oracle BI Standard Edition One, including a Compensation warehouse
setup in Warehouse Builder.
Answer: B
QUESTION NO: 4
Which three variable types does the BI
Applications data model support for specifying currencies?
A. Document
B. Local
C. Global
D. Override
Answer: A,B,C
QUESTION NO: 5
Which condition results in a source
record being neglected during incremental load?
A. INTIAL_UPDATE_DATE
>= LAST_EXTRACT_DATE
B. LAST_UPDATE_DATE
>= LAST_EXTRACT_DATE
C. LAST_UPDATE_DATE >
= INITIAL_EXTRACT_DATE
D. LAST_UPDATE DATE
<= LAST EXTRACT DATE
Answer: D
QUESTION NO: 6
How can you be sure to access a
specific data source in a default Oracle BI Applications
installation for users working from a
client machine? Assume that log level 2 has been enabled.
A. With log level 2 or
higher enabled in the NQsConfig.ini, you can check the SQL from the query
log of a specific Answers request.
Read the SQL and check the connection pool(s) used and the
data source name(s).
B. The only data source
in a standard BI Applications installation is the data warehouse. This
source is defined in DAC in the Setup
View under Physical Data Sources. You can also check the
(native) connection credentials.
C. Sources can range
from data warehouse to OLTP systems. Their connections are named in
connection pools in the BI repository.
Using these connection names you can check the (native)
connection credentials.
D. All physical
connections are defined in Informatica Powercenter Repository Manager. Log in
and check all connection credentials.
E. Users can log in to
Answers, the BI repository, DAC or Informatica to check connection
credentials and data source names.
Answer: C
QUESTION NO: 7
Which three calendar types are
supported by BI Applications 7.9.6 release?
A. Enterprise
B. 13 Period, 4-4-5
C. Fiscal and Gregorian
D. 15 Period
Answer: A,B,C
QUESTION NO: 8
A new source is available containing
several big tables with over 2 million rows of data. Some of
this data is needed in Oracle BI
analysis, combined with existing data sources. What are your
options to enable this combined
analysis?
A. Analyze the needed
data and needed granularity. If applicable create aggregation tables and
partitioned tables in the source
database. Apply a type 2 customization in Informatica
PowerCenter and modify the DAC with
appropriate objects. Model the BI repository with the new
data warehouse objects and enable
aggregate navigation and partition navigation. Enable cross
analysis in the logical layer. Use
simple requests and analyze the request performance on the new
data.
B. Apply a type 2
customization in Informatica PowerCenter to include the necessary data
warehouse objects and modify the DAC
with appropriate objects. Model the BI repository with the
new data warehouse objects and enable
aggregate navigation and partition navigation.
C. Apply a type 1
customization in Informatica PowerCenter to include the necessary data
warehouse objects and modify the DAC
with appropriate objects. Model the BI repository with the
new data warehouse objects and enable aggregate
navigation and partition navigation. Enable
cross-analysis in the logical layer.
D. Analyze the needed
data and needed granularity. If applicable create aggregation tables and
partitioned tables in the source
database. Apply a type 1 customization in Informatica
PowerCenter and modify the DAC with
appropriate objects. Model the BI repository with the new
data warehouse objects and enable
aggregate navigation and partition navigation.
E. Normalize the new
data source into smaller tables and apply a type 2 customization in
Informatica PowerCenter. Apply changes
in DAC to read the new source data and have execution
plans load the needed data into the
data warehouse. Model the BI repository with the new data
warehouse objects and enable aggregate
navigation and partition navigation. Enable crossanalysis
in the logical layer.
F. Normalize the new
data source into smaller tables and apply a type 1 customization in
Informatica PowerCenter. Model the BI
repository with the new data warehouse objects and
enable aggregate navigation and
partition navigation. Enable cross-analysis in the logical layer.
Answer: A
QUESTION NO: 9
Which is true regarding the location
of Informatics PowerCenter client tools installation?
A. the client tools
should be installed on the same machine as the transactional database.
B. the client tools
should be installed on the same machine as the DAC Server.
C. the client tools
should be installed on the same machine as the OBAW database.
D. the client tools
should be installed on the same machine as the DAC client.
Answer: D
QUESTION NO: 10
The universal adapter in Informatica,
is used to load data from what two sources?
A. EBS
B. JD Edwards
C. Legacy OLTP Systems
D. Non Oracle Sources
Answer: A,C
QUESTION NO: 11
Which is not a customized fact or
dimension table?
A. wc_xxx_f
B. w_xxx_f
C. wc_xxx_fs
D. wc_xxx_a
Answer: B
QUESTION NO: 12
Which task level parameter(s)
control(s) the granularity of data in Aggregate tables?
A. TIME_GRAIN only
B. GRAIN_LEVEL only
C. GRAIN only
D. TIME_GRAIN or GRAIN
Answer: A
QUESTION NO: 13
What is a DTM in Informatica?
A. Data Transmission
Manager
B. Data Transmission
Mode
C. Data Transformation
Manager
D. Data Transformation
Mode
Answer: C
QUESTION NO: 14
The Green Factory (a national
agricultural organization with one office for IT support and
consisting of 20 farmers, 2 dairy
producing factories, and a vegetables and flowers Auction)
wishes you to implement Sales
Analytics and enable all members to benefit most from the Out of
the Box materials. What would you
advise?
A. Analyze expected use
and calculate capacity. Organize architecture according to the calculated
capacity and implement Oracle BI Sales
Analytics centrally. Define user groups and apply object
security. Define different profiles in
Delivers and schedule iBots to provide users with the data they
need. Arrange meetings for quick user
acceptance.
B. Organize architecture
and directly implement Oracle BI Sales Analytics centrally. Define one
user group and schedule iBots to
provide this group with the data it needs. Arrange meetings for
quick user acceptance.
C. As Answer A, but
check and reuse existing user groups
D. As Answer A, but
installed de-centrally
E. As Answer B, but
installed de-centrally
Answer: C
QUESTION NO: 15
Which two statements are true?
A. It is recommended to
co-locate the DAC Client with the Power Center Client Tool on the same
machine.
B. It is recommended to
co-locate the DAC Server and Power Center Server on the same
machine.
C. It is recommended to
co-locate DAC Server, Informatica Server, and the Database Server on
the same machine.
D. It is recommended to
co-locate the DAC Server, Informatica Server, and BI Server on the same
machine.
Answer: A,B
QUESTION NO: 16
Which csv file contains grouping
information of natural accounts?
A. file_group_acct_codes
. csv
B. file_group_acct_names.csv
C. file_glacct_segment_config.csv
D. file_grpact fstmt.csv
Answer: B
QUESTION NO: 17
Which two are mandatory
pre-installation tasks for Informatica Power Center Client installation?
A. Pre-installation of
Informatica Server
B. Creation of
Informatica repository
C. Creation of ODBC
Database Connections
D. Pre-installation of
Data Warehouse Administration console
E. Pre-installation of
Oracle Business Intelligence Enterprise Edition
Answer: C,E
QUESTION NO: 18
Web object security can be enforced at
which three levels?
A. Report column
B. Report
C. Dashboard
D. Dashboard page
Answer: A,B,C
QUESTION NO: 19
What is the purpose of csv files under
the SrcFiles folder in Informatica server home?
A. They are used to
store Informatica parameters.
B. They are the source
for enterprise-dependent data, required for loading certain dimensions.
C. They are used to hold
data extracted during ETL processes.
D. They are used for
customization.
QUESTION NO: 20
During what phase does DAC calculate
the sequence of the tasks listed under the selected
subject area?
A. when you
'synchronize" the tasks
B. when you
"generate parameters" for an execution plan
C. when you
"assemble" the subject area
D. when you
"build" the execution plan
Answer: C
QUESTION NO: 21
Data Warehouse Administration Console
(DAC) interacts with Informatica Server using what
command?
A. PMCMD
B. PMREP
C. infacmd
D. infasetup
Answer: D
QUESTION NO: 22
Considering BIEE is seamlessly
integrated with source application, identify three ways in which
user credentials can be passed on to
BIEE from the source application login.
A. Cookies
B. Server variables
C. http header / url
D. Use of shared memory
Answer: A,B,C
QUESTION NO: 23
What is the significance of
Configuration tags in Oracle DAC?
A. It controls the
inclusion of tasks in a subject area.
B. It controls the
parameters generated by DAC.
C. It controls the OS
configuration parameters required for functioning of DAC
D. It controls the
configuring of the source and target database schemas.
Answer: A
QUESTION NO: 24
During which phase of the Oracle BI
Applications project flow are decision makers interviewed for
the first time?
A. Design
B. Build
C. Define
D. Validate
Answer: A
QUESTION NO: 25
Where is the appropriate JDBC Driver
installed to enable DAC to connect to the database?
A. DAC/bin
B. DAC/lib
C. DAC/drivers
D. DAC/log
Answer: B
QUESTION NO: 26
Which three tasks is DAC capable of
handling Data Warehouse connection Information?
A. Managing an
Informatica workflow.
B. Executive an external
program.
C. Running a SQL file.
D. Performing a database
Backup/Restore.
Answer: A,C,D
QUESTION NO: 27
Which utility reads the contents of
the .ctl file and generates the SQL statements to create and
alter tables?
A. ddlimp
B. cryptotools
C. pmrep
D. pmcmd
Answer: A
QUESTION NO: 28
How does DAC know the source OLTP and
target Data Warehouse connection Information?
A. This information is
given in the Physical Data sources tab in DAC client.
B. This information is
given in two flat files, file_source.csv and file_target.csv.
C. It fetches this
information from Informatica.
D. DAC doesn’t require
knowing this information. However ft is required to give this information in
Answer: A
QUESTION NO: 29
To enable SSO integration of the
Source EBS Application with BIEE which file do you need to
configure?
A. NQSConfig.ini
B. credentialstore.xml
C. instanceconfig.xml
D. isapiconfig.xml
Answer: C
QUESTION NO: 30
Which variable is changed for Target
Warehouse in the OBIEE repository while promoting the
code to the new environment?
A. TARGET_DB
B. OLTP_DSN
C. DW_CONNECTION
D. OLAP_DSN
Answer: B
QUESTION NO: 31
Which is the right sequence of a typical Informatica Type 1 Customization?
i) Extend Staging and target Database table to accommodate new column.
ii) Copy appropriate Informatica mapping and workflow to Informatica Custom folder.
iii) Modify the existing Informatica mapping workflow to accommodate new columns.
iv) Modify DAC with the necessary change.
A. i, ii, in, iv
B. i, iii, ii, iv
C. iii, ii, i, iv
D. ii, i, iii, iv
Answer: B
QUESTION NO: 32
What techniques would you use to
promote Oracle BI Applications materials to a new environment
after ail environments have been set
up initially?
A. Copy the BI
Presentation catalog and BI repository into the new environment, create a db
dump
for the DAC repository and Informatics
Repository and Data Warehouse. Load these into the new
environment.
B. Copy the BI
Presentation catalog and BI repository into the new environment, create a db
dump
for the DAC repository and load this
into the new environment. Restore connections between
DAC, Informatica, the Warehouse and
its source(s).
C. Copy the BI
Presentation catalog and BI repository into the new environment. Check
connections between DAC, Informatica,
the Warehouse and its source(s).
D. Copy the BI
repository into the new environment, create a db dump for the DAC repository
and
Warehouse and load these into the new
environment. Check connections between DAC,
Informatica, the Warehouse and its
source(s). Merge new standard reports and dashboards into
the new presentation catalog using the
Catalog Manager and keep ad-hoc materials from the new
environment.
E. It is sufficient to
copy the BI Presentation catalog and BI repository into the new environment.
F. Copy the BI
Presentation catalog, create a db dump for the DAC repository and Warehouse and
load these into the new environment.
Check connections between DAC, Informatica, the
Warehouse and its source(s).
Answer: D
QUESTION NO: 33
Some users need a new Critical Success
Factor or Ratio based on a measure that is not available.
How would you help them in a way that
is the least time consuming?
A. Start looking in the
source database(s) for base elements. Next step would be to check BTL if
these are already mapped and available
in the warehouse. If not, build new ETL, register ETL and
new warehouse objects in DAC and model
in BI repository. If available, build the new ratio in the
Business Model and Mapping Layer, set
available in the presentation layer and test in Answers.
B. Start looking for
base elements in the physical layer in the repository. If available you can
directly build the ratio in the
Business Model and Mapping Layer, set available for querying in the
presentation layer and test results in
Answers. If not available, check the warehouse tables and
lastly the source tables.
C. Directly start
building SDE and SIL mappings to enhance the warehouse with extra columns.
Register the mappings and new
warehouse objects in the DAC, run the ETL and model in the BI
repository. Test your work in Answers.
D. Build a request in
Answers based on the online BI Repository and create your new ratio as a
new column based on other columns.
E. Build a request in
Answers directly on the source data available to you and create the new ratio
as a new column in your report.
Answer: A
QUESTION NO: 34
Considering loading a fact named
w_xxx_A, what is the exact sequence in which the mappings
related fact are loaded?
A. SDE -> PLP->
SIL
B. SDE -> SIL ->
PLP
C. SIL -> SDE ->
PLP
D. PLP-> SIL ->
SDE
Answer: B
QUESTION NO: 35
By default for a session in Informica,
which properly is used to configure the minimum number of
errors to be encountered, to mark the
session as failed?
A. Error limit
B. Minimum Errors
C. Stop on Errors
D. Error Benchmark
Answer: D
QUESTION NO: 36
How many Informatica Repository
Servers can be configured with a single DAC server?
A. One
B. Two
C. Three
D. Any number
Answer: A
QUESTION NO: 37
Which combination of the following
machines represents an appropriate architecture for an Oracle
BI Applications implementation?
i) Machine A running DAC Server and
DAC Client
ii) Machine B running DAC Server and
Informatica Services
iii) Machine C running Informatica
Services and Informatica Client tools
iv) Machine D running DAC Client and
Informatica Client tools
v) Machine E running DAC server and client, Informatica
services and Client tools
vi) Machine F running Oracle BI EE
components
vii) Machine G running an Oracle
Database hosting the data warehouse
viii) Machine H running the source
system
A. Machines: A, C, F, G,
H
B. Machines: B, D, F, G,
H
C. Machines: E, F, H
D. Machines: B, F, G, H
Answer: B
QUESTION NO: 38
In an Oracle BI Cluster Server
environment which statement is true?
A. BI Scheduler can
reside outside Local Area Network (LAN) whereas the other components
(Clustered BI Servers, Master BI
Server, BI Cluster Manager) of Oracle BI Cluster Server must
reside on the same LAN.
B. Clustered BI Servers,
Master BI Server, BI Scheduler and Cluster Manager all need to reside in
one Local Area Network (LAN).
C. Cluster Manager can
reside outside Local Area Network (LAN) whereas the other components
(Clustered BI Servers, Master BI
Server, BI Scheduler) of Oracle BI Cluster Server must reside on
the same LAN.
D. All components of an
Oracle BI Cluster Server environment may exist on different Local Area
Networks (LANs), provided the LAN are
connected through a single Wide Area Network (WAN).
Answer: A
QUESTION NO: 39
After a year of working with HR and
Financial Analytics, your organization chooses to add Sales
Order Management Analytics. How would
you combine this new module with the existing ones in
the BI Applications installation?
A. Build a new Sales
Order Warehouse and ETL rules to source it. Then import its metadata into
DAC and model as new physical layer in the BI repository.
Test your work in Answers.
B. Install Oracle BI
Applications Sales Order Management and create the extra objects in the
existing warehouse. Perform a table
scan from DAC and check connection pools in the BI
repository. Test your work in Answers
and Dashboards.
C. Make a backup of your
ETL, the Warehouse, BI Presentation Catalog and BI Repository. Install
Oracle BI Applications Sales Order
Management and have the extra objects created by a script in
the existing warehouse and Informatica
Repository. Seed the DAC repository with new metadata,
test new Out-of-the-Box execution
plans, merge the newly installed BI repository with the backup
and do the same with the presentation
catalogs. Enable logging and test your work in Answers
and Dashboards.
D. Make a backup of the
BI Presentation Catalog and BI Repository. Run the installation for
Oracle BI Applications Sales Order
Management. Merge all new objects with your back-up
materials. Enable logging and test
your results in Answers.
E. Build a new Sales
Order Warehouse and ETL rules to source it. Then import its metadata into
DAC and build new execution plans
based on the new Warehouse objects. Enable the BI
repository with Sales Order metadata
and cross-analysis and test your work in Answers.
F. Install Oracle BI
Applications Sales Order Management. After the installation check the
connection pools in the BI repository.
Test your work in Answers and Dashboards.
Answer: C
QUESTION NO: 40
Which item under DAC connection
information will be modified while promoting the code to a new
environment?
A. Execute
B. Setup
C. Subject Area
D. System
Answer: B
QUESTION NO: 41
What is a set of books?
i) It is synonymous with a Ledger
ii) A set of books identifies a
company or fund that shares a common chart of accounts structure,
calendar, and functional currency
iii) List of parameters required for
the ETL to run successfully
A. i, ii
B. ii, iii
C. i, iii
D. i, ii, iii
Answer: A
QUESTION NO: 42
Which two statements about a micro-ETL
are true?
A. They usually handle
small subject areas or subsets of larger subject areas.
B. Before a micro-ETL
execution plan runs, the DAC Populates refresh date values in the Refresh
Dates child tab of the Execution Plans
tab.
C. They are ETL
processes that you schedule at very frequent intervals, such as hourly or
halfhourly
D. There can be no
common subject areas between normal ETL and micro-ETL execution plans.
Answer: A,C
QUESTION NO: 43
Which two Ports are checked while
implementing Slowly Changing Dimension in Oracle BI
Application?
A. TYPE1_COLLS_DIFF
B. SYSTEM_COLLS_DIFF
C. TYPE2_COLLS_DIFF
D. CHANGE_COLLS DIFF
Answer: B,D
QUESTION NO: 44
Why do we need to set the NLS Lang
Parameter correctly during BI Applications implementation?
A. Astern OBI EE to
display the data correctly, based on the language supported by the operating
system.
B. It helps DAC to send
commands to Informatica correctly, based on the language supported by
the operating system.
C. It helps the ETL too,
Informica, to transform data based on the language supported by the
operating system.
D. It helps EBS to
display the data correctly, based on the language supported by the operating
system.
Answer: A
QUESTION NO: 45
What is the name of the Informatica
repository that comes as part of the BI Applications
installation?
A. Oracle_BI_DW_Base.rep
B. OracleBIAnalyticsApps.rpd
C. Oracle_BI_DW_Base.rpd
D. OracleBIAnalyticsApps.rep
Answer: A
QUESTION NO: 46
Which Informatica Power Center
component is used for configuration of domain, server grid and
services?
A. Repository Manager
B. Designer
C. Workflow Manager
D. Administration Console
Answer: D
QUESTION NO: 47
How does Informatica know which source
OLTP and target Datawarehouse connection
information is to be used for task
execution in BI Applications?
A. This information is
given in the DAC Parameter file.
B. This information is
given in Relational connections of Workflow manager.
C. This information is
given in two flat files, fiie_source.csv and fiie_target.csv.
D. Informatica doesn't
require knowing this information. However, it is required to give this
information in DAC.
Answer: A
QUESTION NO: 48
Which statement is true?
A. SIL stands for Source
Independent Load and is used to move the data from staging tables to
Data Warehouse.
B. SIL stands for Source
Independent Load and is used to move the data from source to staging
tables of Data Warehouse.
C. SIL stands for Source
Intensive Load and is used to move the data from staging tables to Data
Warehouse.
D. SIL stands for Source
Intensive Load and is used to move the data from source to staging
tables of Data Warehouse.
Answer: A
QUESTION NO: 49
Data Warehouse Administration Console
Is used for which three purposes?
A. Defining ETL subject areas
and execution plans
B. Prioritizing and load
balancing of the ETL workflow execution
C. Performing automatic
index management
D. Managing access
rights to the data warehouse
E. Defining custom
dashboards queries
Answer: A,B,C
QUESTION NO: 50
How can you be sure that all ETL tasks
are executed in the right ordering by Informatica?
A. You can be sure after
a successful batch run of the ETL in Informatica Powercenter.
B. You can never be
really sure.
C. Execute all ETL using
DAC Subject Areas embedded in execution plans. DAC will calculate the
ordered tasks.
D. Execute single ETL
mappings in parallel in Informatica Powercenter Workflow Manager.
E. Answers A or D.
Answer: C
QUESTION NO: 51
How does the DAC task instruct
Informatica whether to run a full load or incremental load?
A. DAC issues additional
parameters to Informatica.
B. DAC does not handle
such responsibilities.
C. Informatica
intelligently decides whether to run a full load or not.
D. DAC issues separate
commands for full load and incremental load.
Answer: A
QUESTION NO: 52
Upon which two entities can security be based when using
PeopleSoft as source application?
Analytics Warehouse in case of A.
Sales order information of a Stock
Broker or B. HR information of a small city?
A. Capacity planning for
A and B is the same and focused on non-frequent large ETL runs.
B. Capacity planning for
A is focused on frequent, smaller ETL runs, including micro batches and
iBot schedules and active cache
management using scheduled cache purging and polling tables.
For B, capacity planning is focused on
less frequent bigger ETL runs and cache management
using scheduled cache purging.
C. Capacity planning for
A is focused on less frequent, bigger ETL runs and cache management
using scheduled cache purging.
Capacity planning for B is focused on frequent, smaller ETL runs,
including micro batches and iBot
schedules and active cache management using scheduled cache
purging and polling tables.
D. Capacity planning for
A and B is the same and focused on infrequent, small ETL runs.
E. Capacity planning for
A and B is the same and focused on very frequent, small ETL runs
F. Capacity planning for
A and B is the same and focused on very frequent, large ETL runs.
Answer: B
QUESTION NO: 54
Which two parameters are to be set
while configuring BI Applications for Supply Chain Analytics?
A. Inventory Master Id
B. Category Master Id
C. Category Set ID
D. Inventory Category
Set Id
Answer: A,B
QUESTION NO: 55
A shipping company uses many standard
forms that need to contain Customer name, address,
contract information and a perfectly
printable barcode for tracking orders. What functionality would
you advise this organization to use
from Oracle BI Applications?
A. Reuse as many
Out-of-the-Box reports as possible.
B. Build requests,
include these on dashboard pages and include PDF files to show the barcodes.
C. Schedule requests
using Delivers, print these in PDF and then deliver to email addresses.
D. Build reports in BI
Publisher based on existing BI requests or BI Presentation Layer columns.
E. Build reports using
the Microsoft Office plug-in based on BI Presentation Layer columns.
F. Answer D and E are
both valid possibilities.
Answer: F
QUESTION NO: 56
After you configured object and data
security the user group representatives also express their
wish to change the workflow order in
the Presentation Catalog available to them. How would you
do that?
A. Add new reports or
reuse existing reports in Answers and modify the column navigation
behavior to define the workflow. Add
the first report in the flow on a high-level dashboard page.
B. Add or modify guided
navigation on a Dashboard page. The link should navigate to a report in
the workflow.
C. Add or modify links
on a Dashboard page. The link should navigate to a report in the workflow.
D. Answer A and B
combined
E. Answer A and C
combined
F. Answer A and E are
both possibilities.
Answer: B
QUESTION NO: 57
Your organization’s management expresses
the need for having specific Web content available for
specific user groups, including rules that ensure data
security. How would you make this work?
A. Run specified
execution plans in DAC and enable data security in user groups in the BI
repository.
B. Run specified
execution plans in DAC, create session variable and enable data security on
user
groups in the BI repository.
C. Create session
variable to define the user group, and then enable data and objects security in
the BI repository.
D. Create specific
dashboards including specific content and enable object security for the user
groups in the Catalog Manager or
Administration link in the web interface.
E. Answer A and D
combined.
F. Answer A and D
combined.
Answer: D
QUESTION NO: 58
Which utility is used by the DAC
server to issue commands to read information in the Informatica
repository?
A. Ddlimp
B. cryptotools
C. pmrep
D. pmcmd
Answer: D
QUESTION NO: 59
Which three attributes identify a
single set of books?
A. Chart of accounts
B. Currency
C. Calendar definition
D. Company name or
identifier
Answer: A,B,C
QUESTION NO: 60
Which statement is true about the safe
path in SDE and SIL mappings when implementing a Type
I customization?
A. The safe path is used
by all lookup data and is used to populate variables.
B. The safe path columns
in a mapping should not be duplicated or renamed.
C. The safe path defines
a path through which all extension logic should be routed and is indicated
in the mapping by a placeholder column
named x_custom.
D. The safe path defines
a path through which all extension logic should be routed and is indicated
in the mapping by a placeholder column
named x safePath.
Answer: C
QUESTION NO: 61
What is the significance of the
Informatica parameter files: parameterfileOLTP and
parameterfileDW?
A. They help in
configuring the domain values and other source files
B. They are generated at
run time to provide Informatica, the parameters required for ETL
C. They hold the
predefined task-level parameters defined
D. They contain the
standard parameters for each task that is to be configured in DAC
Answer: D
QUESTION NO: 62
In Dashboards, the data security is
implemented by_____.
A. Oracle BI EE using
the concept of "WEBGROUPS" session variable
B. Oracle BI EE using
the concept of "GROUP" session variable
C. Oracle Data
warehouse, using standard relational database features
D. Object security is
not implemented in Oracle BI Applications
Answer: B
QUESTION NO: 63
By default how many aging buckets are
configured for Accounts Payable/Receivables Aging
reports?
A. One
B. Two
C. Three
D. Four
Answer: D
QUESTION NO: 64
Which two are considered Informatica
Type II Customizations?
A. Addition of new Fact
and Dimension tables to the data warehouse for packaged application
datasource(s).
B. Addition of new Fact
and Dimension tables to the data warehouse for non-packaged application
datasource(s).
C. Addition of new rows
(to existing tables) from the source systems for non-packaged application
datasource(s).
D. Addition of new rows
(to existing tables) from the source systems for packaged application
datasource(s).
Answer: A,C
QUESTION NO: 65
Which types of data level security are
available in BI Applications?
A. i, iii, v, vi
B. i, ii, iii, iv
C. i, ii, iii, v, vi
D. i, ii, iii, iv, v, vi
Answer: B
QUESTION NO: 66
The parameter files generated by DAC
are_____.
A. created for each
workflow, using the combination of parameters specified in the
parameterfileDW.txt,
parameterfileOLTP.txt, and DAC parameters
B. created for each
mapping, using the combination of parameters specified in the
parameterfileDW.txt,
parameterfileOLTP.txt, and DAC parameters
C. created for each
mapping, using the combination of parameters specified in the
parameterfileDW.txt and
parameterfileOLTP.txt
D. created for each
workflow, using the combination of parameters specified in the
parameterfileDW.txt and
parameterfileOLTP.txt
Answer: D
QUESTION NO: 67
The Out of the Box BI Applications
reports that are included on the dashboards are role based.
How do you support these roles
specifically in workflows?
A. Roles can be
supported in workflows by using session variables as filter in permission
settings
such as enabling access permissions
for user groups and data security, defining workflows by
guided navigation and column behavior,
dashboard links and conditional guided navigation on
dashboard sections.
B. Roles can be supported
in workflows only by enabling session variables in connection pools.
C. Roles can be
supported in workflows entirely by defining dimensional hierarchies and using
the
default drill functionality.
D. Roles can be
supported in workflows only by conditional formatting and using the STYLE
session variable.
E. Roles can be
supported in workflows by user groups, data security, and conditional
formatting.
Answer: A
QUESTION NO: 68
Your organization plans to deploy BI
Applications for the first time. In order to make sure that the
approximately 300 users are enabled to
work in a smooth and performing way what would you
consider?
A. Use at least one
environment for development and testing and one for production. In each
environment install the Oracle BI
Server, DAC and Informatica PowerCenter on the same
machine. Install the Oracle BI
Presentation server on a second machine. Only enable caching in
the development environment. Enable
automatic purging and seeding of the cache. Enable object
security.
B. Use one environment
and install the Oracle BI Server, DAC and Informatica on the same
machine and install the Oracle BI
Presentation server on a different machine. Enable automatic
purging and seeding of the cache.
C. Use at least one
environment for development and testing and one for production. In each
environment install the Oracle BI
Server, DAC and Informatica PowerCenter on the same
machine. Install the Oracle BI
Presentation server on a second machine. Keep the data
warehouse separated from the OLTP
database. Only enable caching in the production
environment. Enable automatic purging
and seeding of the cache. Enable object and data
security.
D. Use at least one
environment for development and testing and one for production. Enable
object and data security per user,
enable logging and disable caching.
E. Use at least one
environment for development and testing and one for production. Install DAC
and Presentation server on one machine
and install Informatica PowerCenter and Oracle BI
Server on one machine. Install the
data warehouse in the OLTP database on a third machine.
F. Use at least one
environment for development and testing and one for production. Install DAC
and Presentation server on one machine
and install Informatica PowerCenter and Oracle BI
Server on one machine. Install the
data warehouse in the OLTP database on the Oracle BI Server
machine.
Answer: C
QUESTION NO: 69
In which BI Applications release can
the calendar definition be extracted from the source
applications?
A. Release 7.9.6
B. Release 7.9.5.1
C. All releases of BI
Applications
D. It is not possible in any
released version of BI Applications
Answer: A
QUESTION NO: 70
Which module is not covered in BI
Applications for EBS?
A. Financial Analytics
B. HR Analytics
C. Procurement and Spend
Analytics
D. Marketing Analytics
Answer: D
QUESTION NO: 71
What are action links used for?
A. Direct navigation
from source application to BI reports
B. Direct navigation
from BI record to transactional data source
C. Functionality to
invoke iBots
D. Drilling down to
transactional-level data within the report
Answer: B
Till Next Time
