OCA OCP Oracle Certification Exam Braindumps

7. What do the logical joins do?  Choose two.
A. They help the Analytics Server choose best physical path between multiple physical tables in each logical table
B. They calculate measurable quantities
C. They are always the same as the physical joins
D. They determine cardinality between logical tables
Answer: AD   

Siebel7.7 Analytics Server Architect Professional Core Exam

8. 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. It finds logical columns that are not mapped to physical sources
D. It checks for undefined logical join conditions
Answer: A   

9. To set the number of elements at each level of a dimension, which number would you use?
A. The number of columns in a logical table
B. The number of levels in a dimension
C. The number of dimensions in a business model
D. The number of tables in a physical model
E. The number of distinct rows in a physical column
Answer: E   

10. Which of the following is NOT necessary when specifying the most economical source?
A. Create a new physical table source manually
B. Create a new logical table source manually
C. Select the physical table
D. Specify the content
Answer: A   

11. 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 a new physical column using the Calculation Wizard
E. Use the Calculation Wizard to create a new column comparing two existing columns
Answer: D   

12. ABC wants to measure its revenue based on the country, region, and city by setting up columns to measure CountryRevenue, RegionRevenue, and CityRevenue. Which measure type is ABC using?
A. Attribute hierarchy
B. Fact hierarchy
C. Rank measure
D. Level-based measure
E. Share measure
Answer: D   

13. ABC is a multinational corporation. It wants to measure its revenue based on the country, region, and city by setting up columns to measure CountryRevenue, RegionRevenue, and CityRevenue. Where would ABC's server architect set the grand total level?
A. Country
B. Region
C. City
D. None of the above; It needs to create an All-Country Grandtotal level and set it there
Answer: D   

14. Which of the following are true of the prebuilt Siebel Analytics Repository? Choose three.
A. Prebuilt database objects map to Siebel OLTP or Siebel RMW but not both
B. Prebuilt connection pools reduce the overhead of connecting to a database
C. Many prebuilt star schemas support the prebuilt Siebel Analytics applications
D. Repository variables are prebuilt and therefore cannot be changed
E. Measures can come from multiple stars and case statements determine correct data sources to access
Answer: BCE