ONESTREAM CERTIFIED PROFESSIONAL (OCP) – LEAD ARCHITECT R1 COMPLETE EXAM PREPARATION; VERIFIED PRACTICE QUESTIONS WITH ANSWERS AND EXPLANATIONS

1. What is the Application Metadata Loader's (AML) purpose in
OneStream?
A. Load data
B. Manage security
C. Load metadata via XML or Excel
D. Execute business rules
Answer: C
Explanation: The AML allows users to load metadata into OneStream
applications using XML or Excel files.


2. Which OneStream component is responsible for modeling data and
dimensions?
A. Cube Views
B. Business Rules
C. Application Metadata
D. Transformation Rules
Answer: C
Explanation: Application Metadata includes all structural components like
dimensions, members, and cubes.


3. What is a "Workflow Profile" in OneStream?
A. A financial model
B. A user interface
C. A set of tasks assigned to users
D. A metadata view
Answer: C

,Explanation: Workflow Profiles define the specific tasks and processes users
need to follow during data collection and reporting.


4. What language is primarily used for scripting in OneStream business
rules?
A. Python
B. VB.NET
C. JavaScript
D. SQL
Answer: B
Explanation: OneStream business rules are written in VB.NET.


5. What does the Cube Root dimension represent?
A. The parent dimension of the entity
B. The starting point for cube navigation
C. The highest level in the hierarchy
D. The default dimension used in data extraction
Answer: B
Explanation: The Cube Root is the top-most dimension from which cube
structures derive.


6. How many cube types can be defined in OneStream?
A. One
B. Multiple
C. Unlimited
D. Only three per application
Answer: C
Explanation: There is no hard limit; multiple cube types can be defined based
on business requirements.


7. What is the function of Transformation Rules?
A. Aggregate financial results
B. Map source values to target values
C. Generate dashboards

,D. Configure user access
Answer: B
Explanation: Transformation Rules are used to map source data (e.g., account
codes) to the OneStream application's target structure.


8. Which role is required to perform metadata import/export?
A. End User
B. System Administrator
C. Workflow Manager
D. Power User
Answer: B
Explanation: System Administrators have full privileges, including metadata
management.


9. What are Extensible Documents in OneStream?
A. Reports built in Excel
B. Custom HTML pages
C. Reports with embedded business logic
D. Data integration tools
Answer: C
Explanation: Extensible Documents are dynamic reports that integrate real-
time data and business logic.


10. Which feature allows real-time data entry validation in OneStream?
A. Transformation Rules
B. Business Rules
C. Data Management Jobs
D. Cube Views
Answer: B
Explanation: Business Rules can validate or manipulate data in real time as
users input data.


11. What is a Cube View used for?

, A. ETL processes
B. Managing metadata
C. Displaying financial data from the cube
D. Assigning user roles
Answer: C
Explanation: Cube Views are used to visualize and interact with data stored in
the cubes.


12. What is the purpose of the Extensibility Framework in OneStream?
A. To manage user security
B. To create static reports
C. To allow customization without affecting the core
D. To build external databases
Answer: C
Explanation: The Extensibility Framework allows for customization (e.g., XF
MarketPlace solutions) without altering core functionality.


13. What is the recommended way to promote metadata changes between
environments?
A. Manual editing
B. Copy-paste
C. Export/Import XML files
D. SQL queries
Answer: C
Explanation: Using XML files to export/import metadata ensures consistency
between environments.


14. A Dashboard in OneStream is used to:
A. Load metadata
B. Build ETL pipelines
C. Visualize and interact with key data
D. Manage transformation rules
Answer: C
Explanation: Dashboards offer interactive data visualization and user
interaction interfaces.