OBIEE Developer with Dashboard Assessment

1.

3 points

Which three of the following are components of a cluster server?

A. Master server

B. repository publishing directory

C. Primary cluster controller

D. Web server

E. Server request controller

2.

1 point

You would like to plot two sets of number to see the correlation between two variables. Which of the following charts would best suit your needs?

A. Bar Charts

B. Area Charts

C. Pareto Charts

D. Scatter Charts

E. Radar Charts

3.

1 point

Which three of the following are true of the oracle BI Security Capabilities?

A. Authentication in Oracle BI is the process by which the oracle BI Server verifies that a user indeed the right person who has the right to log in

B. Access to repository objects and some web catalog objects can be controlled but data that appear in dashboards and reports cannot be controlled

C. You can bypass Oracle BI Security by setting AUTHENTICATION_TYPE in the NQSConfig.ini to BYPASS_NQS

D. Administrators cannot set a limit on the time it takes the system to execute a query

E. Administrator can control when users will be able to query the database by disabling query functionality.

4.

1 point

Which two statements are TRUE of data-level security?

A. Data-level security allows control over data seen by an end user in report.

B. Defining user and group access allows you to control data-level security

C. Data-level security requires separate reports for each user in order to display different results for each user.

D. Data-level security is implemented using only two prebuilt initialization blocks(Primary Owner ID and Primary Position ID)

5.

1 point

Which three statements are true about cache manager?

A. It can be used to view the contents of cache entries.

B. It is active in online and offline mode.

C. It can be used to purge entries by user.

D. It can be used to purge entries by physical table.

E. Can be used to specify maximum cache size.

F. Can be used to specify location of cache files.

6.

1 point

Your customer has indicated that the data displayed on a particular dashboard is not refreshed at a sufficient rate. You know that some(but not all) of the data in the underlying data warehouse is updated hourly the rest of the data is updated daily.

A. Turn off caching on the hourly updated physical tables.

B. Turn off caching on the hourly updated logical tables.

C. Reduce cache expiration time on all physical tables to reflect the data update frequency

D. Employ use of an event polling table to force a cache refresh of the hourly updated data

E. Restructure the logical business model such that physical sources with different refresh rates are not associated within a logical join

F. refer to NQQuery.log to determine the location of the cache-data files(s) and write a script to periodically remove these cache files

7.

1 point

What are two common issues that prevent successful aggregate table processing?

A. Aggregation content is not specified correctly.

B. Aggregate dimension sources are physically joined to aggregate fact table sources at the same level

C. A dimensional source exists at the same level as a fact table source

D. Aggregate dimension sources do not contain a column that maps to the primary key of the dimension hierarchy level

E. The number of elements are specified for the dimension hierarchy levels

8.

2 points

ABC wants to see total products by region by year without doing run-time calculation, Which two of the following would ABC use to solve this business challenge?

A. Create physical tables in a data source that store pre-calculated measures for grouping of data

B. build aggregates for all possible level combinations

C. build an aggregate for a fact source only

D. build aggregates for both dimension and fact sources

9.

2 points

Which two of the following are not recommended when working with the catalog manager?

A. Give every user the access to catalog manger

B. Install catalog manger on windows

C. Modify the web catalog in the online mode

D. stop the oracle BI presentation services before opening the analytics catalog manager

E. Stop the oracle BI server

10.

1 point

In which Oracle-recommended implementation stage would you gather business requirements?

A. Define

B. Discover

C. Design

D. Build

E. Validate

F. Deploy

11.

2 points

The BI server architect has created two more logical columns in the business models and mapping layer and dragged then to the presentation layer. She saved the repository and restarted BI server and web service. When she opens the web catalog, she does not see the new columns that she created in the repository. Which two of the following could she do?

A. In analytics web, click the "reload server metadata" Link

B. Open the analytics administration tool and save the repository again

C. Open the analytics administration tool and check in all objects

D. Restart the oracle BI presentation services service

12.

3 points

Which tree of the following can be done using the expression builder utility?

A. Synchronize aliases

B. Copy a business model with a presentation catalog

C. Update the Physical layer

D. Create Aggregations

E. Create physical complex joins

F. Create a calculation measure using existing logical or physical columns as object in formula

13.

1 point

You would like to examine which columns in the presentation layer map to a specific table in the business model. Which of the following utilities would you use?

A. Oracle BI Answers

B. Query Repository from the analytics administration Tool

C. Online Help of the analytics Administration Tool

D. Physical Table Diagram from the analytics administration Tool

14.

1 point

ABC's Database administrator has divided its region table into several tables so that the west region is in one table and all the other regions are stored in another table. What kind of partitioning is used?

A. Fact-Based

B. Level-Based

C. Mixed

D. Complex

15.

2 points

Which two of the following are ways to add a briefing book?

A. from the admin page under activities, select schedule briefing book

B. from the bottom of the dashboard page, click the add to briefing book button.

C. from oracle BI delivers, select New briefing book

D. Click the add to briefing book link that appears with an individual request on the dashboard.

16.

2 points

Which two of the following are Oracle recommended leading practices to enhance performance?

A. Design requests that use complex queries

B. Avoid designing dashboards that return too much data

C. Use caching to improve query speed

D. Avoid using Guided Navigation unless the dataset will be huge

17.

1 point

Select Three items that may be displayed in dashboards.

A. Documents

B. Alert from oracle BI delivers

C. web sites

D. Images, Charts, tables, text, folders

E. Saved analytics requests

18.

1 point

Which of the following is NOT true of consistency check?

A. It guarantees that the business model is correctly built

B. You can check the whole repository's consistency or just a business model's consistency

C. If finds logical columns that are not mapped to physicals sources

D. It checks for undefined logical join conditions

19.

2 points

Which three of the following are true of iBots?

A. They are driven by events

B. They can execute scripts

C. They can trigger workflow

D. They can directly trigger Assignment Manger

E. They cannot be subscribed

20.

1 point

Which of the following is NOT true of a star schema?

A. The facts are quantifiable

B. The fact table has several foreign key columns composed of the primary keys of the related dimensional tables

C. A fact table is linked to related dimension tables

D. Dimension tables are normalized

E. Dimension tables usually have a one-attribute primary key such as product ID for products

21.

1 point

Row-wise initialization is enabled to initialize

A. Multiple values

B. Multiple users

C. multiple sessions

D. multiple variables

22.

2 points

ABC corporation's data warehouse has a sales data fact table with columns containing the following
. Market

. Period
. Product Type

. Units
. Dollars

They want to include data on average unit revenue in their ad hoc reports. Which two of the following are valid ways to accurately fulfill this requirement?

A. Modify the underlying physical data warehouse table to include a column for average unit revenue, modify the ETL process to calculate and store this value, and modify the logical and physical models in the repository to include this column

B. modify the physical model in the repository and add a derived metric column to store this value. Define this column as dollar divided by units. Add a corresponding Column in the logical data model and associate with the newly added physical Model column

C. Modify the logical model in the repository and ad a newly metric column define this column as calculation of dollars divided by units from physical mode.

D. Modify the logical model in repository and add the derived metric column. Define this column as calculation of dollars divided by units from the logical model.

23.

1 point

You would like to customize the text elements that appear in BI answer, BI delivers, and on dashboard pages. Which of the following would you use?

A. Cascading styles sheets

B. DHML Message files

C. XML messages files

D. Oracle BI presentation services Web template items

24.

2 points

Which two oracle BI components contain security information regarding permission and privileges?

A. The web catalog

B. The repository

C. The file NQSconfig.ini

D. The file NQServer.ini

E. The file Instanceconfig.xls

25.

1 point

Which of the following would NOT be the best candidate for business intelligence tools such as oracle BI Enterprise Edition?

A. Analyzing data that reside in many systems

B. Analyzing data that require accessing millions of records

C. Interactive and dynamic reporting

D. Merging two excel files for operational processing

E. Meeting the differing requirement for data access depending upon the users' role and privileges

26.

1 point

Which default drive is created in ODBC system DSN during installation of Oracle BI Server and Presentation services?

A. Analytics

B. WebAnalytics

C. BIAnalytics

D. AnalyticsWeb

E. PresentationWeb

27.

1 point

Which of the following is one of the Oracle-recommended Analytics implementation leading practice?

A. Use an iterative approach

B. Assign logical column name the same as the physical table column name

C. Make several catalogs map to the several different subject areas

D. There should be 1:1 mapping between physical facts and dimension table and logical fact and dimension table

E. Define expression and keys when setting a complex join in a business model

28.

1 point

How are project conflicts resolved in a multi-user development environment?

A. Multiple users cannot work on projects at the same time. Users must regulate which projects are checked out in order to not create a conflict.

B. Conflicts are resolved during the check in process

C. Always deleted local changes when checking in files to avoid conflicts

D. The administration tool locks projects on the server to avoid conflicts

29.

1 point

Which of the following is NOT one of the ways to define physical foreign keys and joins?

A. Crete them using Joins Manage > Action > New > Foreign Key

B. In the business model and mapping layer, right click the model folder>Physical diagram and navigate to any of the paths

C. In the physical layer, right-click the database>Physical diagram and navigate to any of the paths that are not grayed out

D. In the file menu , Select Create > Joins

30.

2 points

Which of the following tasks can you perform in the catalog manager?

A. set permission for web catalog items

B. Mange privileges and right given to groups and users

C. Set authentication options

D. Manage web group and Users

31.

2 points

Which two of the following could be the disadvantages of implementing query caching?

A. Improved performance

B. Potential for cached results being stale

C. Disk space for the cache

D. Increased network traffic

E. Reduction in BI server processing overhead

32.

1 point

Which three of the following are some of the leading practices when modeling the Business model and mapping layer?

A. Combine all attributes that describe a single entity

B. Create system ODBC in this layer

C. Delete logical columns that map to keys of physical dimension tables

D. Delete key columns as they will not be exposed to the analytic WE UI

E. Make the logical columns names unique within a subject area

F. Make sure that extension tables are accessed only when necessary

33.

2 points

Which two statements are accurate descriptions of the oracle BI configuration files?

A. NQServer.log records information about query results.

B. NQQuery.log specifies which repositories to load and whether to enable or disable query caching

C. NQSconfig.ini contains metadata that represents the analytical model and is divided into three layers

D. The name of the web catalog to use is specified in the instanceconfig.xlm file on the web server

E. DBfeatures.ini is used by BI server to optimize query generation.

34.

1 point

ABC wants to track the difference between the amount billed and the amount collected from its customers for every quarter. Which of the following methods would NOT be used in this situation?

A. Create a new logical column in the business model

B. Create a new column in the presentation layer

C. Use existing physical columns as objects in a formula

D. Create the calculation wizard to create a new column Comparing two existing column

E. Create a new physical column using the calculation wizard

35.

1 point

Data is stored in facts and dimensions

A. at the lowest level of aggregation

B. at the highest level of aggregation

C. at multiple levels of aggregation

D. independently from aggregation level