Pass4itsure > Oracle > Oracle Java > 1Z0-591 > 1Z0-591 Online Practice Questions and Answers

1Z0-591 Online Practice Questions and Answers

Questions 4

An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010

and 2011 on a single report.

How can you model this in the RPD?

A. By creating two Logical Fact Tables for each database

B. By creating joins in the physical model so it looks like a single table

C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source

D. By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.

E. By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box

Buy Now
Questions 5

The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

A. Oracle RDBMS

B. Microsoft SQL Server

C. IBM DB2

D. Teradata

Buy Now
Questions 6

How will you model a Type II Slowly-Changing Dimension?

A. Add an additional column to the dimension table to capture a version of change

B. Overwrite an existing dimension table record with the changed record

C. Add a new row to the dimension table with a new key for the changed record

D. Do Nothing

Buy Now
Questions 7

When designing a Star Schema, which option does not apply?

A. The facts are quantifiable.

B. The fact has several foreign keys that are primary keys in the dimensional table

C. Fact table is joined to the related dimensional tables.

D. Dimensional tables are normalized.

E. Dimensional tables have one attribute primary key as Product_ID for products.

Buy Now
Questions 8

How do you get the BI plug-in for MS Office?

A. By contacting the administrator

B. By downloading it from the BI Server

C. By downloading it from the Database Server

D. By downloading it from Microsoft Server

Buy Now
Questions 9

A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?

A. Fact-based

B. Time-based

C. Mixed

D. Complex

Buy Now
Questions 10

What is the first step when creating an Aggregate table in the OBI repository?

A. Test the Aggregate table by using Analysis

B. Specify the Fact table that you want to aggregate

C. Use Job Manager to run the Aggregate script

D. Create a dedicated Connection Pool

Buy Now
Questions 11

Which component is responsible for determining the device that receives the alerts for a given user account?

A. Dashboard

B. iBot

C. Alerts

D. Delivery Profiles

Buy Now
Questions 12

Which analysis features could be applied to provide interactive controls for end users?

A. Column Selector

B. Action Links

C. Conditional Formatting

D. Narrative View

E. Greenbar Styling

Buy Now
Questions 13

Which two steps are needed to set up Failover support for an OBIEE deployment?

A. Use Installer to affect Horizontal scale out of an existing instance B. Employ WebLogic Enterprise Edition, licensed separately

C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering

D. Apply OBIEE Clustering option

E. Leverage spare hardware capacity of single machine by using Vertical scale out option

Buy Now
Exam Code: 1Z0-591
Exam Name: Oracle Business Intelligence Foundation Suite 11g Essentials
Last Update: Mar 21, 2024
Questions: 120
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$45.99

VCE

$49.99

PDF + VCE

$59.99