EY Parte 1

1. 1When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?

   1. AThe lowest level of aggregation
   2. BThe highest level of aggregation
   3. CMultiple levels of aggregation
   4. DIndependently from aggregation level
2. 2The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be .

   1. A$10,000
   2. B0
   3. C1
   4. DYear
3. 3Which two components are required for all OBIEE installations?

   1. AAdmin Server
   2. BRCU Schema
   3. CManaged Server
   4. DNode Manager
   5. EOracle 11g
4. 4The administration tool is the developer s interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

   1. AChanges to the repository can only be carried out in offline mode.
   2. BMultiple developers can work on one repository at the same time.Results can be merged later on.
   3. CAll aspects of security are being held in the repository file.
   4. DOpening the rpd.filein online mode results in performance Issues for the application user.
5. 5Which installation option is used to install into an existing Fusion Middleware Home?

   1. ASoftware Only Install
   2. BSimple Install
   3. CEnterprise Install
   4. DCannot installinto an existing Fusion Middleware Home
6. 6What are the two methodologies that are followed within an OBIEE implementation?

   1. ADo not use prototypes
   2. BUse an iterative approach
   3. CStart with a small model and then enhance the repository
   4. DStart with a big repository and trim it down with the requirements
7. 7Which option describes how OBIEE Integrates with Planning?

   1. AOBIEE primarily accesses Planning using standard Essbase integration techniques.
   2. BOBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
   3. CPlanning is not a supported OBIEE source.
   4. DOBIEEintegrates with Planning directly through relational database access.
8. 8What is an example of a Session Variable?

   1. AETL Load Date
   2. BUser Organization
   3. COLAP DSN
   4. DTop Customers by Revenue
9. 9Which option is used to enter the rank function when creating a new rank measure?

   1. AInitialization Block
   2. BExpression Builder
   3. CConnection Pool
   4. DWeb Catalog
10. 10Query limits tab can be accessed through _.

    1. ASecurity Manager, Query tab, Application role dialog box, Permissions
    2. BSecurity Manager, Application Roles tab, Query dialog box, Permissions
    3. CSecurity Manager, Application Roles tab, Application role dialog box, Permissions
    4. DSecurity Manager, Application Roles tab, Application role dialog box, Query Properties

11. 11One 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?

    1. AYear
    2. BMonth
    3. CQuarter
    4. DCurrentMonth
12. 12WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

    1. ACreating and Maintaining Users
    2. BAuthentication and Authorization
    3. CBasic Directory for storing user details
    4. DSubject area and row-level security, connection pool passwords
    5. EApplication of SessionVariables as Data Filters
13. 13Point-and-click generation of case statement logic can be accessed via which option?

    1. AColumn Formula-> Bins tab
    2. BCompound Layout
    3. CColumn Properties -> Conditional Format tab
    4. DAdvanced Tab
    5. ESubject Area metrics
14. 14Which task can be performed after the Administrator link has been reached through logging into OBIEE?

    1. AAssociate map layers to columns
    2. BManage access to Subject Areas
    3. CSSO enablement
    4. DStart or Stop BI Managed Servers
15. 15Which three techniques are applied to support Failover?

    1. AWebLogic Clustering
    2. BUniversal Installer > Scale Out BI System option
    3. COBIEE Clustering
    4. DVertical Scaleout
16. 16The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
    

    1. AMS Visio
    2. BMS Excel
    3. CMS Project
    4. DMS Word
17. 17A user s BI Home page provides one-click access to which three options?

    1. ACreate new content
    2. BOracle BI online documentation
    3. CCatalog search functionality
    4. DDashboard layout editor
    5. EBusiness model metadata
18. 18A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

    1. ABy creating a derived measure by using the Logical Columns available
    2. BBy creating a derived measure in the Column Mapping dialog box byusing the physical table columns.
    3. CBy creating a derived measure by using LogicColumnsavailable andchanging the aggregation type
    4. DBy creating a derived metricby using the Expression Builder
    5. EBy creatinga derived metricby using the Calculation Wizard
19. 19Which resource identifies the OBIEE Web Catalog (webcat)?

    1. Ainstanceconfig.xml
    2. BRCU Schema
    3. CIdentity Store
    4. Dnqsconfig.ini
    5. EAdmin Server
20. 20The ODBC DSN is never used for .

    1. AInitial import of the physical layer metadata on a Windows server
    2. BQuery execution and data access on a Windows server
    3. CInitial import of the physical layer metadata, query execution, and data access on a Windows Server
    4. DChanging passwords
    5. EComparing RPDs
21. 21Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

    1. AOLAP cubes eliminate the need for a large number of aggregate tables.
    2. BOLAP cubes are stored outside of the database in highly optimized file structures.
    3. COLAP cubes can be easily transported from database to database.
    4. DOLAP cubes can be queried by using SQL.
22. 22When Exporting an Analysis from a Dashboard, which of the following is NOT an option?

    1. AMS Excel
    2. BMS Word
    3. CPDF
    4. DCSV
23. 23Which of the following characteristics pertain to a "ragged" hierarchy?

    1. AIt can only be stored in an XML structure.
    2. BA branch of the hierarchy may have a different number of levels than other branches.
    3. CAll values can have a maximum of six levels.
    4. DIt creates multiple levels of hierarchy in the databasetable.
24. 24What is the process in which there is redundancy of data to improve performance?

    1. ARedundancy
    2. BNormalization
    3. CDenormalization
    4. DGranularity
    5. ECardinality
25. 25An 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?

    1. ABy creating two Logical Fact Tables for each database
    2. BBy creating joins in the physical model so it looks like a single table
    3. CBy creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
    4. DBy creatingtwo logical table sourcesand checkingthe�This Source should be combined with other sources at this level�box leaving the Fragmentation content area blank.
    5. EBy creatingonelogical table sources and checkingthe�This Source should be combined with other sources at this level�box
26. 26What are the two leading design solutions recommended by Oracle that you would use for performance?

    1. ADesign requests that use Complex Queries
    2. BAvoid returning big data sets within the Dashboard
    3. CUse Cache
    4. DAvoid using GuidedNavigation unless the data set is large
27. 27The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

    1. AOracle RDBMS
    2. BMicrosoft SQL Server
    3. CIBMDB2
    4. DTeradata
28. 28There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?

    1. ABy creating a derived measure on the logical columnItem number and using the count Function
    2. BBy creating a derived measure on the logical column item number and usingthe count distinct function
    3. CBy creating a derived measure based on the physical column item number and changing theaggregation method to count
    4. DBy creatinga derived metric by using the Expression Builder
29. 29Which language is used by OBIEE to query Essbase?

    1. ASQL
    2. BLINQ
    3. CMDX
    4. DDMX
30. 30Which are the three types of tables available to physical tables in the physical layer?

    1. APhysical Table
    2. BStored Proc
    3. CSelect
    4. DView
    5. ETable

Description

Quiz on EY Parte 1, created by xd xdd on 01/08/2018.

Author

xd xdd

Language

Español

Views

36

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Oracle Analytics Cloud and OBIEE