Exam Content

The examination consists of 69 Questions. Candidates should score 62% to clear the examination.

Formats of Question

• Single Response Multiple-choice questions: Only One correct response from the given options best suits the statement or answers the question.
• Multiple Response Multiple-choice questions: Two or More Correct response from the given options best suits the statement or answers the question.

Exam Duration

Candidates will have 105 minutes for attempting 69 questions. So, it becomes important for the candidates to time-box the exam and restrict spending too much time on one question or one topic.

Exam Results

The Oracle 1z0-531 certification is a pass or fail examination and the candidate has to score a minimum of 62% to be termed as pass in the certification exam.

Candidates will receive an email with the result from Oracle within 30 minutes of completing the Certification exam. Exam results are also available on the CertView web portal and the candidate can visit the portal and login to the CertView account to view the exam results and get further details.

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.

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

• 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

• 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

• 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

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

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

• 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

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

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