Copy and Edit

51-75_1z0-591_OBIEE III

Description

First Certificate of Cambridge Tecnología Test sobre 51-75_1z0-591_OBIEE III, creado por Janeire Salicio el 25/07/2017.
Janeire Salicio
Quiz by Janeire Salicio, updated more than 1 year ago
Janeire Salicio
Created by Janeire Salicio over 6 years ago
41
1
0

Resource summary

Question 1

Question
QUESTION NO: 51 Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
Answer
  • A. Assign users to a web catalog group
  • B. Create a new repository group
  • C. Create a new user in the repository
  • D. Create a web catalog group
  • E. Define permissions for Dashboard

Question 2

Question
QUESTION NO: 52 OBIEE 11g authentication of users is performed by which two components listed below?
Answer
  • A. Repository file (rpd)
  • B. Embedded WebLogic LDAP server
  • C. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework
  • D. BI Presentation Services

Question 3

Question
QUESTION NO: 53 One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?
Answer
  • A. Business Requirements Definition
  • B. Technical Requirements Definition
  • C. Data Quality Assessment
  • D. Dashboard Testing

Question 4

Question
QUESTION NO: 54 Identify the two true statements about alias tables.
Answer
  • A. Alias tables are set up to avoid triangular or circular joins.
  • B. Alias tables are set up to include best practice naming conventions for physical table names.
  • C. Alias tables are set up to create another physical copy of the data.
  • D. Alias tables are set up to create a copy of the data with a filter applied to it.

Question 5

Question
QUESTION NO: 55 DSNs are set up for access to which data sources?
Answer
  • A. ODBC Data Sources
  • B. Oracle Data Sources
  • C. IBM Data Sources
  • D. Teradata Data Sources

Question 6

Question
QUESTION NO: 56 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?
Answer
  • A. Create a physical time table in your database.
  • B. Create a Logical Table that is sourced from the time key in the fact table.
  • C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.
  • D. Create a Logical Table that is sourced from a time field in one of your dimension tables.
  • E. Create a time table that is joined through a intervening Table so there is no foreign key relationship.

Question 7

Question
QUESTION NO: 57 Identity the three advantages of the BI Server metadata repository.
Answer
  • A. Mapping of federated data sources to one logical object
  • B. Ability to change physical sources without losing reports
  • C. Little changes in the physical layer to shift from development to production environment
  • D. Three layers support the highest level of security

Question 8

Question
QUESTION NO: 58 The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
Answer
  • A. Start and Stop BI Services
  • B. Build Aggregate Queries
  • C. Create Summary Tables
  • D. Manage user logins

Question 9

Question
QUESTION NO: 59 The Time Dimension hierarchy is a good example of a__________.
Answer
  • A. Level-based Time Dimension hierarchy
  • B. Ragged Hierarchy
  • C. Skip Level Hierarchy
  • D. Value-based Hierarchy

Question 10

Question
QUESTION NO: 60 When designing a Star Schema, which option does not apply?
Answer
  • 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.

Question 11

Question
QUESTION NO: 61 If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
Answer
  • A. By creating four new logical tables sources
  • B. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab
  • C. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
  • D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels

Question 12

Question
QUESTION NO: 62 Which of the following native features of Essbase are not supported in OBIEE 11g?
Answer
  • A. Member Alias
  • B. Alternate Hierarchies
  • C. Dynamic Time Series
  • D. Parent/Child-based Hierarchies

Question 13

Question
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?
Answer
  • A. Using the Expression Builder
  • B. Using the Calculation Wizard
  • C. Defining them in the physical data model
  • D. Defining them in the Presentation Layer

Question 14

Question
QUESTION NO: 64 When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
Answer
  • A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
  • B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
  • C. Job Manager can be used to run the Aggregate Persistence script.
  • D. The Extraction Transformation and Loading process creates the aggregate tables.

Question 15

Question
QUESTION NO: 65 Which three options apply to FMW Application Roles?
Answer
  • A. Provide an indirection between LDAP groups and BI roles
  • B. Can be exported / moved between FMW11g environments
  • C. Are created and managed by using the WLS Admin Console and FMW Control
  • D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console
  • E. Secures RPD permissions but NOT Web Catalog (webcat) permissions

Question 16

Question
QUESTION NO: 66 How do you get the BI plug-in for MS Office?
Answer
  • 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

Question 17

Question
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?
Answer
  • A. By creating two new logical tables sources
  • B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
  • C. Both A and B
  • D. By creating one new Logical Table Source

Question 18

Question
QUESTION NO: 68 Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
Answer
  • A. Navteq
  • B. TeleAtlas
  • C. Google
  • D. ESRI

Question 19

Question
QUESTION NO: 69 The Consistency Checker checks______.
Answer
  • A. The validity of objects outside the metadata using the connection
  • B. Mappings to the physical objects
  • C. For objects deleted from the database
  • D. Syntax errors in derived logical columns

Question 20

Question
QUESTION NO: 70 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?
Answer
  • A. Fact-based
  • B. Time-based
  • C. Mixed
  • D. Complex

Question 21

Question
QUESTION NO: 71 Identify the two types of storage for Essbase.
Answer
  • A. Aggregate Storage Option and Block Storage Option
  • B. Aggregate Storage and Cell Storage
  • C. OLAP Storage and Cell Storage
  • D. Aggregate Storage and Hybrid Columnar Compression

Question 22

Question
QUESTION NO: 72 Where is Cache in OBIEE located?
Answer
  • A. In relational database
  • B. It is local disk-based.
  • C. In dynamic aggregate
  • D. In memory cache

Question 23

Question
QUESTION NO: 73 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?
Answer
  • A. Make Aggregate Table 1 the first table in the list of Logical Table Sources.
  • B. Do not map the logical level in the Content tab.
  • C. Set the Priority Group to 0.
  • D. Set the Priority Croup to 5.

Question 24

Question
QUESTION NO: 74 Which OBIEE capability enables developers to build Aggregate tables?
Answer
  • A. Aggregate Persistence Wizard
  • B. Expression Builder
  • C. Table Builder
  • D. Query Analyzer

Question 25

Question
QUESTION NO: 75 When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?
Answer
  • A. Logical Key
  • B. Parent Level
  • C. Child Level
  • D. Dynamic Key
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Test Diagnóstico de Informática Básica
victorlobato2009
TECNOLOGÍA TAREA
Denisse Alcalá P
Materiales de construccion
Diana Woolfolk
INSTRUMENTOS DE MEDIDAS Y SIMBOLOGÍA ELECTRICA - VOLTAJE.
Teresa Villa
Leyes de Kirchhoff (Voltaje y corriente)
dianamardp
DISPOSITIVOS DE ALMACENAMIENTO
Esteban Bravo3B
tema 6 : ELECTRÓNICA
alejandrauscola
20 preguntas sobre sistemas operativos
esmeraldameza100
codigos QR
Cristina Padilla
Curso Basico De Android
manrongel
Historia de la Ingeniería
Camila González
Browse Library