EY Parte 3

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

   1. ABy creating four new logical tables sources
   2. BBy creating four new logical table sources and choosing each dimension s level of aggregationin the Content tab
   3. CBy creatingfour new logical table sources and using the Fragmentation content to specify theaggregation levels
   4. DBy creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
2. 2Which of the following native features of Essbase are not supported in OBIEE 11g?

   1. AMember Alias
   2. BAlternate Hierarchies
   3. CDynamic Time Series
   4. DParent/Child-based Hierarchies
3. 3A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

   1. AUsing the Expression Builder
   2. BUsing the Calculation Wizard
   3. CDefining them in the physical data model
   4. DDefining them in the Presentation Layer
4. 4When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
   

   1. AThe analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
   2. BThe Aggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
   3. CJob Managercanbe used to run the Aggregate Persistence script.
   4. DTheExtractionTransformation and Loading process creates the aggregate tables.
5. 5Which three options apply to FMW Application Roles?

   1. AProvide an indirection between LDAP groups and BI roles
   2. BCan be exported / moved between FMW11g environments
   3. CAre created and managed by using the WLS Admin Console and FMW Control
   4. DCan be created by using BI Administrator Client and "pushed" to WLS Admin Console
   5. ESecures RPD permissions but NOT Web Catalog (webcat) permissions
6. 6How do you get the BI plug-in for MS Office?

   1. ABy contacting the administrator
   2. BBy downloading it from the BI Server
   3. CBy downloading it from the Database Server
   4. DBy downloading it from Microsoft Server
7. 7There 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. ABy creating two new logical tables sources
   2. BBy opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
   3. CBoth A and B
   4. DBy creating one new Logical Table Source
8. 8Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?

   1. ANavteq
   2. BTeleAtlas
   3. CGoogle
   4. DESRI
9. 9The Consistency Checker checks .

   1. AThe validity of objects outside the metadata using the connection
   2. BMappings to the physical objects
   3. CFor objects deleted from the database
   4. DSyntax errors in derived logical columns
10. 10A 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?

    1. AFact-based
    2. BTime-based
    3. CMixed
    4. DComplex

11. 11Identify the two types of storage for Essbase.

    1. AAggregate Storage Option and Block Storage Option
    2. BAggregate Storage and Cell Storage
    3. COLAP Storage and Cell Storage
    4. DAggregate Storage and Hybrid Columnar Compression
12. 12Where is Cache in OBIEE located?

    1. AIn relational database
    2. BIt is local disk-based.
    3. CIn dynamic aggregate D
    4. DIn memory cache
13. 13A 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?

    1. AMake AggregateTable 1 the first table in the list of Logical Table Sources.
    2. BDo not map the logical levelin the Content tab.
    3. CSet the Priority Group to 0.
    4. DSet the Priority Croup to 5.
14. 14Which OBIEE capability enables developers to build Aggregate tables?

    1. AAggregate Persistence Wizard
    2. BExpression Builder
    3. CTable Builder
    4. DQuery Analyzer
15. 15When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?

    1. ALogical Key
    2. BParentLevel
    3. CChildLevel
    4. DDynamic Key
16. 16What are the two types of Repository Variables?

    1. ASystem
    2. BNon System
    3. CStatic
    4. DDynamic
17. 17Under what circumstances would you model within the BI environment to include transactional data directly?

    1. AWhen the customer needs near real-time data to support decision making in a fast changing environment
    2. BWhen the customer is not prepared to spend budget on data-warehousing
    3. CWhen the complexity of operational schema does not allow modeling in the BI repository
    4. DWhen it is not possible to query against a transactional system
18. 18What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?

    1. AEdit Analysis
    2. BRefresh All
    3. CEdit Prompts and Levels
    4. DPublish
19. 19Which three components are part of a cluster server?

    1. AMaster Server
    2. BRepository Publishing Directory
    3. CPrimary Cluster Controller
    4. DWeb Server
    5. EServer request Controller
20. 20If Security attributes conflict, what happens?

    1. AThe user or application role is granted the minimum security attribute
    2. BThe user or application role is granted the maximum security attribute
    3. CThe user or application role is granted No security attribute
    4. DThe user or application role is granted the Fully Restrictive security attribute
21. 21How do Dynamic Repository Variables differ from Static Repository Variables?

    1. ADynamic Repository Variables are not initialized by the Initialization Block.
    2. BDynamic Repository Variables cannot be used in the Expression Builder.
    3. CDynamic Repository Variables can be changed by data that is returned from queries.
    4. DDynamic Repository Variables cannot be used in a CASE statement.
22. 22The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

    1. AThe physical layer defines the objects and relationships that the OracleBIServer needs to writenative queries against each physical data source.
    2. BSeparating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
    3. CThe model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
    4. DThe presentation layer defines the relationship thatis needed to create the DML.
23. 23Which two options are included in Oracle BI Server cache management techniques?

    1. AUsing NQSConfig.ini to manually edit the parameters
    2. BScheduling Server password
    3. CMaximum Number of Rows to Download to Excel
    4. DInspecting the cache reports
    5. EManage access to Subject Areas
24. 24To add multiple sources to on existing logical table dimension in the Business Model and
    Mapping layer, the source of the data must first exist in which option?
    

    1. APresentation Layer
    2. BBusiness Aggregate Layer
    3. CPhysical Layer
    4. DWeb Catalog
25. 25A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?

    1. AStores
    2. BOrders
    3. CProducts
    4. DTime
26. 26What is the first step when creating an Aggregate table in the OBI repository?

    1. ATest the Aggregate table by using Analysis
    2. BSpecify the Fact table that you want to aggregate
    3. CUse Job Manager to run the Aggregate script
    4. DCreate a dedicated Connection Pool
27. 27Where is Oracle Mapviewer installed?

    1. AIn the same domain as OBIEE on the web application server
    2. BNever on the same domain as OBIEE on the web application server
    3. COn the Database server
    4. DOn its own application server
28. 28When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?
    

    1. AIt defines the granularity of the dimension.
    2. BIt determines the actual value of the dimension.
    3. CIt creates a new session variable.
    4. DIt creates a foreign key relationship.
29. 29Which component is responsible for determining the device that receives the alerts for a given user account?

    1. ADashboard
    2. BiBot
    3. CAlerts
    4. DDelivery Profiles
30. 30What are the two disadvantages of implementing Query Caching?

    1. AReduction in BI server processing time
    2. BCache results being old
    3. CStorage space for cache
    4. DIncreased network traffic
    5. ENeeds a lot of administrators time

Description

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

Author

xd xdd

Language

Español

Views

37

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Oracle Analytics Cloud and OBIEE