Oracle 1Z0-531 Exam Syllabus Topics:

Reference: http://www.oracle.com/partners/en/products/database/essbase-exam-1z0-531/index.html

Topics to Cover

Oracle 1z0-531 certification exam is based on the learnings, key topics, and activities encountered during oracle pieces of training and implementations.

Following are the major topics along with the sub-skills, a candidate should cover while preparing for the examination. These topics will give the candidates a clear view of which topics and skills inclusive, one should focus on for the certification.

Note: The list and details are not an all-inclusive content list. Oracle reserves the right to change and update the content (topics and sub-skills) at any point in time.

• Smart View Explain Smart View Use Smart View for retrieving data

• Essbase Administration Describe the files Essbase.cfg and Essbase.sec Describe the settings for the above-mentioned files Analyze and Retrieve Essbase log files Manage Essbase security via Administration Services Manage Essbase security via Shared Services Recovery and Back up of Block Storage Databases Use MaxL for Automate database processes Use substitution variables and location aliases

• Fundamentals of Essbase Application Creation Knowledge of creating a manual outline for applications Build dimensions from sources Ability to load initial data within applications Use calculations and aggregations Ensure and assign security standards

• Knowledge of Calculation Scripts Identify calculation script syntax Describe script behavior for ASO and BSO data structures Design scripts based on requirements

• Block Storage Database Explain block storage calculations Ability to explain default database calculation order Knowledge of data blocks Describe indexing of data blocks Interpret statistics from the database Identify when data blocks will be created Identify and explain the calculation process of the block storage database Optimize database for block storage Identify and implement best practices for block storage design Explain load techniques for block storage optimization

• Overview of Oracle Essbase Technology Knowledge of Multidimensional Analysis Knowledge of Oracle Essbase

• Aggregate Storage Database Understanding the difference between aggregate storage, block storage, or a combined solution and when to deploy either of them Convert block storage to aggregate storage Create, load, and pre-aggregate storage databases How to partition the database in combined, block and aggregate storage solutions Use MDX to write member formulas Understanding of management tasks for aggregate storage databases Partition block and aggregate storage databases Describe and implement aggregate storage design best practices Describe multiple hierarchies and the use of Shared Members

• Essbase Studio Describe the functionality of Essbase studio Knowledge of adding and removing joins between tables Design drill through reports

The candidate needs to go through and be proficient in every topic.