1Z1-591 Practice Exams and Training Solutions for Certifications [Q32-Q52]

QUESTION 32
Select the scenario in which block storage must be used instead of aggregate storage.

Incremental data loading

Top – down planning

Extremely sparse data sets

Millions of members in the outline

QUESTION 33
What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?

Edit Analysis

Refresh All

Edit Prompts and Levels

Publish

QUESTION 34
Which configuration can be changed through Enterprise Manager?

Minimum Number of Rows to Download to Excel

The default BI Server Repository

Start and Stop BI Services

Manages user login

QUESTION 35
A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

Make Aggregate Table 1 the first table in the list of Logical Table Sources.

Do not map the logical level in the Content tab.

Set the Priority Group to 0.

Set the Priority Croup to 5.

QUESTION 36
You run the Consistency Check and receive the warning:
[39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT.
What would you check?

Whether the logical table source for this column has been disabled

Whether the columns creating CREATE_DT have been deleted

Whether there is a logical join between the DIM and FACT tables

Whether there is a physical join between the DIM and FACT tables

Whether there is a physical column mapped to the logical column

DIM_Offer_End_Date.CREATE_DT

QUESTION 37
Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week’s sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times.
How is this accomplished?

Every day before Data Warehouse refresh

Every day after Data Warehouse refresh

Every Monday early morning

Every Monday late night

QUESTION 38
Which option describes how OBIEE natively integrates with HFM?

Through EPM Analytic Data Model (ADM) connectivity

Direct relational database access

Through Essbase connectivity

OBIEE does not support HFM integration

QUESTION 39
OBIEE 11g authentication of users is performed by which two components listed below?

Repository file (rpd)

Embedded WebLogic LDAP server

External directories such as Active Directory using WebLogic and Fusion Middleware’s Oracle Platform Security Services framework

BI Presentation Services

QUESTION 40
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar

By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar

By creating a Presentation Folder called Time<parent> and then two subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>

QUESTION 41
What are the two ways to use the administration tool?

It can be used to manage user password.

The administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.

It can be used for versioning of the rpd.

Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.

QUESTION 42
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

Creating and Maintaining Users

Authentication and Authorization

Basic Directory for storing user details

Subject area and row-level security, connection pool passwords

Application of Session Variables as Data Filters

QUESTION 43
Which two options are included in Oracle BI Server cache management techniques?

Using NQSConfig.ini to manually edit the parameters

Scheduling Server password

Maximum Number of Rows to Download to Excel

Inspecting the cache reports

Manage access to Subject Areas

QUESTION 44
Which option describes how OBIEE Integrates with Planning?

OBIEE primarily accesses Planning using standard Essbase integration techniques.

OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.

Planning is not a supported OBIEE source.

OBIEE integrates with Planning directly through relational database access.

A:
* Combining Relational and OLAP Data Sources: Oracle’s Common Enterprise Information Model allows users to combine data from a relational system and an OLAP source in a single calculation. For example, a user can compare sales forecasts from an Oracle CRM System with budget data from an Oracle Essbase planning application. To clients of the Common Enterprise Information Model, the forecast and budget data appear to be from the same logical source.
* The Essbase server provides advanced multi-user read and write capabilities, including data update and multi-user recalculation. Business users with front-end tools can write data back to a server and recalculate the data on a server using calculation scripts-key functionality to support sophisticated modeling and planning applications.
* Using aggregate storage, Essbase serves a wide range of analytic needs-financial analysis, planning, budgeting, sales analysis, marketing analysis, supply-chain analysis, and profitability analytics-all from a single analytic infrastructure.
Note 2: Data model for business intelligence
The most important component of business intelligence is the concept of ‘data model’. data model determinde what kind of analysis that end user could do with the data. It is also an independant concept that could span across different vendor ‘s product.
Unlike data model of the transaction system, the typical analytic data model is often denormalized and store extra data for analytic query and better query performance while transaction data model use is often normalized and optimized for a few data read and write, which is implemented by jointing many tables.
The most common used analytic data model in business intelligence is call the ‘Star schema’ data model.
With the Oracle business intelligence system, We could define star schema and dimension data model in the
‘logical layer’ in the admin tools. The data model in OBIEE could span different data source in physical layer, which means OBIEE have the capability of building one logical data model which is actually connect to different database in the backend

QUESTION 45
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?

Year

Month

Quarter

CurrentMonth

QUESTION 46
Where is Cache in OBIEE located?

In relational database

It is local disk-based.

In dynamic aggregate

In memory cache

QUESTION 47
Which two options are valid Repository Variable names?

USER

CurrentDay

CurrentMonth

Date

QUESTION 48
You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

Create a physical time table in your database.

Create aLogical Table that is sourced fromthe time keyin the fact table.

Create an “Opaque View” in the physicallayer that contains the time columns from the fact and map itinto your physical model.

Create a LogicalTable that is sourced from a time field in one of your dimension tables.

Createa time table that is joined through a intervening Table so there is no foreign keyrelationship.

QUESTION 49
Query limits tab can be accessed through________.

Security Manager, Query tab, Application role dialog box, Permissions

Security Manager, Application Roles tab, Query dialog box, Permissions

Security Manager, Application Roles tab, Application role dialog box, Permissions

Security Manager, Application Roles tab, Application role dialog box, Query Properties

QUESTION 50
What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

Cascading Style Sheets

DHML Message files

XML Message Files

BI Presentation services web template

QUESTION 51
Which two components are required for all OBIEE installations?

Admin Server

RCU Schema

Managed Server

Node Manager

Oracle 11g

QUESTION 52
When Exporting an Analysis from a Dashboard, which of the following is NOT an option?

MS Excel

MS Word

PDF

CSV

1Z1-591 Practice Exams and Training Solutions for Certifications [Q32-Q52]

admin

Leave a Reply Cancel reply