01. On a BSO cube, an implementer is tuning which dimensions are dense and which are sparse to manage block size and calculation performance.
Which statement reflects a sound general approach?
a) Dense and sparse tags apply only to ASO reporting cubes, never to the block-storage BSO model
b) The Account dimension must always be tagged sparse, no matter how densely or sparsely it is populated
c) All dimensions should be marked dense, so the cube keeps the total number of stored blocks as low as possible
d) Densely populated dimensions such as Period are typically dense, while large sparsely populated dimensions are sparse
02. Why are procedural business-rule calculations such as allocations and copies typically run against the BSO cube rather than the ASO reporting cube?
a) BSO cubes cannot serve reporting queries and so calculations must run there
b) ASO automatically runs allocations and copies whenever a form is saved
c) BSO supports the procedural block calculations and data input those rules require
d) ASO is a read-only reporting store and cannot hold the input those rules require
03. What is the primary role of Smart View in a Planning implementation?
a) The platform service that schedules maintenance snapshots and nightly jobs
b) An Office add-in for ad-hoc grid analysis and report retrieval against EPM cubes
c) The calculation engine that runs business-rule allocations and aggregations on the BSO cube
d) The security tool that provisions users and groups and assigns their roles
04. During a security review, the team finds that many casual data-entry users were granted Service Administrator to avoid access issues.
Which remediation aligns with sound security practice?
a) Re-register the same users again with the Service Administrator role
b) Convert every data-entry form in the application to read-only for all users
c) Leave the broad administrator grants in place since they prevent access tickets
d) Reassign those users to the User role with only the artifact access they need
05. Which set correctly lists seeded Planning modules an implementer can enable?
a) Financials, Workforce, Capital, Projects, and Strategic Modeling
b) Financials, Consolidation, Eliminations, Journals, and Ledgers
c) Smart View, Calculation Manager, Migration, Jobs, and Data Integration
d) Viewer, User, Power User, Administrator, and Identity Administrator
06. A standard requirement is to allocate a total expense pool down to cost centers on a BSO cube on demand.
Which construct is the natural fit?
a) A Smart Push defined on the source data form
b) A business rule built in Calculation Manager
c) A data map run on demand to the ASO reporting cube
d) A cell-level security rule on the expense accounts
07. Leadership wants three personas to each see a focused landing experience, but the underlying forms, rules, and data must stay identical and singly maintained.
Which approach best satisfies both goals?
a) Create three renamed copies of every form and rule for each persona
b) Give each persona a different Scenario member and split the data three ways
c) Duplicate the entire application three times and maintain one copy per persona
d) Build one set of shared objects and expose them through three role-specific navigation flows
08. Before a risky configuration change, an administrator wants a full backup of the environment’s artifacts and data that can be restored if needed.
Which artifact provides this?
a) A runtime prompt
b) A navigation flow
c) The maintenance snapshot
d) A form validation rule
09. Where are business rules and rulesets designed in Cloud EPM Planning?
a) In the Smart View add-in
b) In Calculation Manager
c) In the Data Integration Workbench
d) In the navigation flow designer
10. Finance needs pixel-perfect, formatted management reports that can be bundled into books and distributed, while analysts separately need to do ad-hoc grid analysis inside Excel.
Which two tools respectively serve these needs?
a) Data Integration for the formatted books; a data map for the ad-hoc Excel analysis
b) Calculation Manager for the formatted books; a navigation flow for the ad-hoc Excel analysis
c) Reports (Management Reporting) for the formatted books; Smart View for the ad-hoc Excel analysis
d) Smart View for the formatted books; Reports for the ad-hoc Excel analysis
The Oracle Planning + AI Implementation Professional (1Z0-1080-26) Sample Question Set is designed to help you prepare for the Oracle Planning + AI 2026 Certified Implementation Professional certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-1080-26 Certification Practice Exam.
