[Free] 2018(Jan) EnsurePass Examcollection Oracle 1z0-591 Dumps with VCE and PDF 61-70

2018 Jan Oracle Official New Released 1z0-591
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation Suite 11g Essentials

Question No: 61

If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

  1. By creating four new logical tables sources

  2. By creating four new logical table sources and choosing each dimension#39;s level of aggregation in the Content tab

  3. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels

  4. By creating four new logical table sources and using the quot;wherequot; section of the Content tab to specify the aggregation levels

Answer: B

Explanation: Content Tab Aggregation Content

You can define the aggregation (ie the group by) of:

by hierarchy level by logical column

It helps you to define an aggregate navigation

Ensurepass 2018 PDF and VCE

http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/fact_table/obiee_fragmentatio n_content_one_column.jpg?w=432

Note: logical table source

Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.

The definition of the logical table source is used:

->to specify transformations/calculations (in the column mapping tab),

->to enable aggregate navigation and fragmentation (in the content tab) The Content tab of the Logical Table Source is used to define :

->any aggregate table content definitions (specify the grain of the physical tables),

->fragmented table definitions for the source,

->and WHERE clauses (if you want to limit the number of rows returned).

Question No: 62

Which of the following native features of Essbase are not supported in OBIEE 11g?

  1. Member Alias

  2. Alternate Hierarchies

  3. Dynamic Time Series

  4. Parent/Child-based Hierarchies

Answer: C

Explanation: If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.


Ensurepass 2018 PDF and VCE

Sshot 30

Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.

There’s much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy


So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, there’s a lot to recommend OBIEE 11g to users of the “legacy” Hyperion tools looking for a bit of a refresh of their BI environment.

Question No: 63

A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

  1. Using the Expression Builder

  2. Using the Calculation Wizard

  3. Defining them in the physical data model

  4. Defining them in the Presentation Layer

Answer: B Explanation:

After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

Question No: 64

When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

  1. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.

  2. The Aggregate Persistence Wizard enables you to automate the creation of physical

    aggregate tables and their corresponding objects in the repository.

  3. Job Manager can be used to run the Aggregate Persistence script.

  4. The Extraction Transformation and Loading process creates the aggregate tables.

Answer: B,C

Explanation: B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they’re used when appropriate.

C: The wizard then shows me a preview of the script it’s going to generate, and asks me if I want to create any more summaries. Here’s how the preview script looks – note that it’s not SQL, it’s a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT … SELECT and so on SQL statements, “optimized” for the particular back-end database platform.

Script example: quot;ag_Itemsquot;

for quot;Seminar – Completequot;.quot;Itemsquot;(quot;Quantityquot;)

at levels (quot;Seminar – Completequot;.quot;Customerdimquot;.quot;Statequot;, quot;Seminar – Completequot;.quot;Productdimquot;.quot;Categoryquot;, quot;Seminar – Completequot;.quot;Timedimquot;.quot;Yearquot;) using connection pool quot;custdwquot;.quot;CUSTDW_Poolquot;

in quot;custdwquot;..quot;CUSTDWquot;;

Question No: 65

Which three options apply to FMW Application Roles?

  1. Provide an indirection between LDAP groups and BI roles

  2. Can be exported / moved between FMW11g environments

  3. Are created and managed by using the WLS Admin Console and FMW Control

  4. Can be created by using BI Administrator Client and quot;pushedquot; to WLS Admin Console

  5. Secures RPD permissions but NOT Web Catalog (webcat) permissions

Answer: A,B,C

Question No: 66

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

  1. By contacting the administrator

  2. By downloading it from the BI Server

  3. By downloading it from the Database Server

  4. By downloading it from Microsoft Server

Answer: B

Explanation: Download and installation of the client

The client install executable is available for download from the More Products menu in Oracle BI Interactive Dashboards and Oracle BI Answers.

See picture below.

Ensurepass 2018 PDF and VCE


Question No: 67

There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?

  1. By creating two new logical tables sources

  2. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab

  3. Both A and B

  4. By creating one new Logical Table Source

    Answer: B

    Explanation: B: Example:

    1. Configure the new source table to have the #39;logical level#39; under the content set to

      #39;Countries#39; (the summarized level)

      Ensurepass 2018 PDF and VCE


    2. Do the similiar setting for dimension table

      Now when user query the data at #39;Counties#39; level, the query will be redirected to these summary table instead of the more detail fact table

      Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

      Question No: 68

      Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?

      1. Navteq

      2. TeleAtlas

      3. Google

      4. ESRI

Answer: A

Question No: 69

The Consistency Checker checks .

  1. The validity of objects outside the metadata using the connection

  2. Mappings to the physical objects

  3. For objects deleted from the database

  4. Syntax errors in derived logical columns

Answer: B

Explanation: Consistency check is one of the process to check whether a repository is yielding proper results in Answer reports. It checks whether;* All logical columns are mapped correctly to physical columns (B).* All logical dimension tables have a logical key.* There are at least two logical tables in the business model; one is a logical fact table, the other is logical dimension table with join condition.* There are no circular logical join relationships.* A presentation catalog exists for the business model.

Question No: 70

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

  1. Fact-based

  2. Time-based

  3. Mixed

  4. Complex

Answer: D

Explanation: You have three sort of fragmentation:

Fact-based / Dimension-based fragmentation Content-based / Value-based fragmentation Level-based fragmentation / aggregate navigation

You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.

100% Free Download!
Download Free Demo:1z0-591 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-591 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *