Tag Archives: Exam 1Z0-531 Q&A

Exam Title: Oracle Essbase 11 Essentials
Exam Number: 1Z0-531
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 105 minutes
Number of Questions: 69
Passing Score: 62%
Validated Against: This exam has been validated against Oracle Essbase 11.1.2.1.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Resources available to partners only
Training Opportunities for Oracle Partner Network Members
Oracle Essbase 11.1.1: Bootcamp
OPN Guided Learning Path: Oracle Essbase Implementation Specialist
Training Resources by Exam Topics

Overview of Oracle Essbase
Describe multidimensional analysis
Describe Oracle Essbase

Essbase Application Creation Fundamentals
Perform manual outline creation
Build dimensions from sources
Perform initial data loads
Use calculations and aggregations
Assign security

Block Storage Databases
Describe block storage calculations
Describe the default database calculation order
Describe data blocks
Describe how data blocks are indexed
Interpret database statistics
Describe when data blocks are created
Describe the block storage database calculation process
Tune and optimaize block storage databases
Describe and implement block storage design best practices
Describe BSO load techniques

Essbase Administration
Describe the file Essbase.cfg and its settings.
Describe the file Essbase.sec and its settings.
Identify and interpret Essbase log files
Manage Essbase security via Administration Services
Manage Essbase security via Shared Services
Back up and recover Block Storage Databases
Automate database processes with MaxL
Describe and use substitution variables and location aliases

Smart View
Describe Smart View
Retrieve Data using Smart View

Aggregate Storage Databases
Describe when to deploy aggregate storage, block storage, or a combined solution
Convert block storage to aggregate storage
Create, load, and pre-aggregate aggregate storage databases
Employ database partitioning in combined block/aggregate storage solutions
Write member formulas using MDX
Perform 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

Working with Caluculation Scripts
Identify correct and incorrect calculation script syntax
Describe calculation script behavior for various ASO data structures
Describe calculation script behavior for various BSO data structures
Design calculation scripts to meet specified requirements

Essbase Studio
Describe functionality of Essbase studio
Add and delete joins between tables
Create drill through reports

---

QUESTION 1
Which six files are involved in database recovery for block storage option after a database crash?

A. Essn.pag – data
B. Essn.ind – index
C. Essn.dat
D. Temp.dat
E. Dbname.esm – kernel file that contains control information for db recovery
F. Dbname.tct – transaction control table
G. Dbname.ind – free fragment file for data and index free fragments
H. DBname.otl
I. Metadata folder

Answer: A,B,E,F,G,H

Explanation:
Reference:https://docs.google.com/viewer?a=v&q=cache:gg97eNiYC5EJ:download.oracle.com/doc
s/cd/E10530_01/doc/epm.931/hfm_backup.pdf+Oracle+Essbase+11+files+are+involved+in+datab
ase+recovery+for+block+storage+option+after+a+database+crash&hl=en&gl=in&pid=bl&srcid=AD
GEESiaLpMxmtXkShigMfg6Tq-lHEYjDlA9lQA4RvDDk8GPha1uxkgzqmyFMiuYr-
9RyGrSKqS3S3O4snNtDoRtlrL3jkCO6qyrO54cT_eO_lkUDC6xjXRJ8wsstbXZvA6VnccpT9B1&sig
=AHIEtbS8j8hlh9hKrEm0ipmWV1sjMdj4cA

---

QUESTION 2
Which two options would provide a better design for the following accounts and metrics?

A. If there are a small number of accounts that require FTE and Expense dollars, split Accounts
and Metrics into 2 dimensions
B. If there are a large number of accounts that require FTE and Expense dollars, split Accounts
and Metrics into 2 dimensions
C. If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts
and Metrics into 2 dimensions
D. Ifblock size is large, then keep Accounts and Metrics as one dimension with a dense dimension

Answer: B

Explanation: https://www.scribd.com/doc/40391863/10-Hardcore-Essbase-Tuning-Tips-You-Ve-
Never-Heard-Before

---

QUESTION 3
Identify the two true statements about incremental loading.

A. Allows for real time data access for end users.
B. Creates*subscribes* along the main slice in the database.
C. Materialization of slices is required to provide users the correct query results.
D. Different materialized views may exist within a slice as compared to the main slice of
thedatabase.

Answer: C,D

---

QUESTION 4
You should back up the following three for ASO.

A. Hyperion_Home \common
B. Essbaseinstallfolder\bin
C. ARBORPATH\app\appname
D. Essbaseinstallfolder \locale
E. Essbase.sec
F. Essbase.cfg

Answer: C,E,F

Explanation:
https://docs.google.com/viewer?a=v&q=cache:MXHPDeHWl5YJ:download.oracle.com/docs/cd/E12
825_01/epm.111/epm_backup_recovery_11111.pdf+Aggregate+storage+applications+(ASO)+bac
kup+Essbaseinstallfolder+%5Capp%5Cappname&hl=en&gl=in&pid=bl&srcid=ADGEESj8WeUjkx3
1E52J6ZO1oI-z_uLR5yX9WdQ-k2c2YpLrTbVF3OqyXMD5e1hnqcwMngA9wWkPUKRtPNRWB
Qn4EC69Lo2gziBIhL29czy9Oad5PzreJFe7
bBsfjcAfPGKMjfz-gQ1&sig=AHIEtbRXdFBZwAWib5PvJfE1ElMY8oIrzw
https://docs.google.com/viewer?a=v&q=cache:gg97eNiYC5EJ:download.oracle.com/docs/cd/E105
30_01/doc/epm.931/hfm_backup.pdf+Oracle+Essbase+11+files+are+involved+in+database+reco
very+for+block+storage+option+after+a+database+crash&hl=en&gl=in&pid=bl&srcid=ADGEESiaL
pMxmtXkShigMfg6Tq-lHEYjDlA9lQA4RvDDk8GPha1uxkgzqmyFMiuYr-
9RyGrSKqS3S3O4snNtDoRtlrL3jkCO6qyrO54cT_eO_lkUDC6xjXRJ8wsstbXZvA6VnccpT9B1&sig
=AHIEtbS8j8hlh9hKrEm0ipmWV1sjMdj4cA

---

QUESTION 5
You have the following analysis requirement. Products roll up to Product Family which rolls up to
Product Category. You also need to group Products by Product Manager. Product Managers may
manage one or more Products across product families. You do not need to create reports with
Product Manager by Product Family. You need to secure products by Product Manager for
planning submissions.
You consider Shared members as a solution because of which two options?

A. Shared members provide cross tab reporting (Product Manager in the rows and Product
Familyacross the column)
B. Shared members provide additional categorization but results in a smaller database then if
youwere to add Product Manager as a separate dimension
C. You can assign security to shared members
D. Shared members can be assigned to sparse members only

Answer: B,C

Explanation: https://www.oracledatabase12g.com/wpcontent/
uploads/book/Oracle%20Essbase%20&%20Oracle%20OLAP.pdf
page 95