Passleader 1Z0-526 VCE Dumps Covers All The Knowledge Points Of The Real Exam

Comments are closed

Vendor: Oracle
Exam Code: 1Z0-526
Exam Name: Oracle Business Intelligence Foundation 10 Essentials

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.

Answer: ACE

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

Answer: E

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

Answer: A

A Rank measure is _____________

A.    Defined in the presentation layer only
B.    Defined on a Logical table and referenced in the presentation layer
C.    Defined in the on a physical table and referenced in the logical and presentation layers
D.    computed in the ETL process

Answer: B

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

Answer: ABC

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

Answer: BC

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

Answer: A

Which two of the following are true regarding the aggregate Persistence Wizard?

A.    It automates the creation and initial population of aggregates.
B.    It is can be used to persist dynamic repository variables to the back end database.
C.    It can be used to configure the BI server metadata layer.
D.    It can be used to configure Dashboards.
E.    It can be used to configure Answer Report

Answer: AC

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

Answer: D

ABC’s Human resources department would like to add to store employee data so that all changes in each employee’s marital status are saved, and not just one prior version of the history. Which would best meet ABC’s requirements?

A.    Type I slowly changing dimension
B.    Type II slowly changing dimension
C.    Type III slowly changing dimension
D.    None of above

Answer: B

Passleader 1Z0-526 VCE Dumps Covers All The Knowledge Points Of The Real Exam


Comments are closed.