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.
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
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
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
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
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
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
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
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?
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
Passleader 1Z0-526 VCE Dumps Covers All The Knowledge Points Of The Real Exam