BIEE基础考试试题.docVIP

Q1. When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly? A. The lowest level of aggregation B. The highest level of aggregation C. Multiple levels of aggregation D. Independently from aggregation level Q2. The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________. A. $10,000 B. 0 C. 1 D. Year Q3. The administration tool is the developers interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true? A. Changes to the repository can only be carried out in offline mode. B. Multiple developers can work on one repository at the same time.Results can be merged later on. C. All aspects of security are being held in the repository file. D. Opening the rpd.filein online mode results in performance Issues for the application user. Q4. ple of a Session Variable? A. ETL Load Date B. User Organization C. OLAP DSN D. Top Customers by Revenue Q5. Which option is used to enter the rank function when creating a new rank measure? A. Initialization Block B. Expression Builder C. Connection Pool D. Web Catalog Q6. One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. ple of a Dynamic Repository Variable? A. Year B. Month C. Quarter D. CurrentMonth Q7. A users BI Home page provides one-click access to which three options? A. Create new content B. Oracle BI online documentation C. Catalog search functionality D. Dashboard layout editor E. Business model metadata Q8. Which are the three types of tables available to physical tables in the physical layer? A. Physical Table B. Stored Proc C. Select D. View E. Table Q9. Which two options are valid Repository Variable names? A. USER B. CurrentDay C. CurrentMonth D. Date Q10. Cache in OBIEE is used to_____. Select the two Answer. A. improve performance of Dashboards