[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-526 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-526
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation 10.1.3 Essentials

Question No: 11

Data is stored in facts and dimensions

  1. at the lowest level of aggregation

  2. at the highest level of aggregation

  3. at multiple levels of aggregation

  4. independently from aggregation level

Answer: A

Question No: 12

If you wish to drill down on a column heading, where would you add this functionality?

  1. Select column properties and choose the column format tab

  2. Modify the physical Layer of the rpd

  3. Edit the Column Formula

  4. Select Column Properties and Choose the Conditional Format Tab

Answer: A

Question No: 13

Which two of the following object-level security configurations are NOT done in the BI Administration Tool?

  1. Assign users to a web catalog group

  2. Create a new repository group

  3. Create a new user in the repository

  4. Create a Web catalog group

  5. Assign Privileges

Answer: A,D Explanation:

The correct answers are A and D. In the source below, you can see that BI admin tool can do all of the tasks except assigning users to a web catalog group and creating a web catalog group.

Source: http://www.solutionbeacon.com/OBIEE_P.pdf

Question No: 14

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

  1. The facts are quantifiable

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

  3. A fact table is linked to related dimension tables

  4. Dimension tables are normalized

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

Answer: D

Question No: 15

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

  1. Define

  2. Discover

  3. Design

  4. Build

  5. Validate

  6. Deploy

Answer: A

Question No: 16

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

  1. Improved performance

  2. Potential for cached results being stale

  3. Disk space for the cache

  4. Increased network traffic

  5. Reduction in BI server processing overhead

Answer: B,C

Question No: 17

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

  1. Synchronize aliases

  2. Copy a business model with a presentation catalog

  3. Update the Physical layer

  4. Create Aggregations

  5. Create physical complex joins

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

Answer: D,E,F

Question No: 18

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?

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

  2. build aggregates for all possible level combinations

  3. build an aggregate for a fact source only

  4. build aggregates for both dimension and fact sources

Answer: A,D

Question No: 19

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

  1. 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.

  2. Conflicts are resolved during the check in process

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

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

Answer: B

Question No: 20

Row-wise initialization is enabled to initialize

  1. Multiple values

  2. Multiple users

  3. multiple sessions

  4. multiple variables

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-526 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-526 Dumps

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

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.