Download ONESTREAM CERTIFIED PROFESSIONAL (OCP) – LEAD ARCHITECT R1 COMPLETE EXAM PREPARATION; VERI and more Exams Advanced Education in PDF only on Docsity!
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
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.
15. Where are OneStream Marketplace solutions installed from? A. Windows Store B. XF Marketplace C. GitHub D. Local disk Answer: B Explanation: The XF Marketplace contains pre-built OneStream solutions for common business needs. 16. Which of the following is used for connecting OneStream to external systems like ERPs? A. Dashboard Editor B. XF Integration Connectors C. XF Marketplace D. Cube Views Answer: B Explanation: Integration Connectors enable data integration with ERP and other systems. 17. Which component handles consolidation and elimination logic? A. Workflow B. Transformation Rules C. Cube Logic D. Consolidation Business Rules Answer: D Explanation: Consolidation Business Rules manage financial consolidations including intercompany eliminations. 18. What is a Data Management Sequence in OneStream? A. A metadata validation tool B. A sequence of transformation steps C. A set of business rules D. A sequence of data load tasks Answer: D
C. Step-by-step report creation for users D. Improved metadata mapping Answer: C Explanation: Guided Reporting assists users in building custom reports through a guided process.
23. What feature supports versioning of metadata in OneStream? A. Workflow Snapshots B. Metadata Audits C. Application Snapshots D. Cube Views Answer: C Explanation: Application Snapshots store versioned backups of application structure and metadata. 24. OneStream supports which deployment models? A. On-prem only B. Cloud only C. Hybrid only D. On-prem, cloud, and hybrid Answer: D Explanation: OneStream can be deployed in any of the above models depending on customer needs. 25. Which OneStream object holds member formulas and scripts? A. Dashboard Component B. Business Rule C. Cube View D. Workflow Step Answer: B Explanation: Business Rules contain logic for calculations, validations, and automation. 26. What does the “Consolidation Origin” dimension track in OneStream? A. Type of currency used B. Source of the consolidated data
C. Version control D. Consolidation method applied Answer: B Explanation: Consolidation Origin tracks the source of data in the consolidation process, helping identify its origin (e.g., loaded, input, calculated).
27. What is the best method to secure a Dashboard component in OneStream? A. SQL Permissions B. Workflow Profiles C. Object Security Groups D. System Settings Answer: C Explanation: Object Security Groups are used to assign permissions to specific objects like dashboards. 28. In OneStream, what does “XFBR” stand for in business rules? A. XML Format Binding Rules B. Excel Format Based Rules C. OneStream Formula Engine D. OneStream Business Rule Functions Answer: D Explanation: XFBR refers to reusable Business Rule functions that return values dynamically based on context. 29. What OneStream feature allows you to automate jobs such as data loads or consolidations? A. Task Scheduler B. Workflow Tracker C. Security Manager D. Application Importer Answer: A Explanation: The Task Scheduler automates recurring tasks such as data integration, processing, and reporting.
Answer: B Explanation: Currency conversion and financial consolidation logic go into Consolidation Rules.
34. Which security method allows restriction of member-level access within a dimension? A. Role-Based Access B. Workflow Security C. Member Security D. Task Profile Security Answer: C Explanation: Member Security can restrict access down to specific dimension members for more granular control. 35. What does the “Scenario” dimension typically define? A. Cube root hierarchy B. User security profiles C. Versioning of data (e.g., Actual, Budget) D. Workflow timing Answer: C Explanation: The Scenario dimension defines the nature and version of the data such as Actual, Forecast, or Budget. 36. What is the purpose of a “Connector” in OneStream? A. Create Dashboards B. Define metadata C. Link external data sources for integration D. Convert currency rates Answer: C Explanation: Connectors are used to link OneStream to external data sources like ERPs or databases for integration. 37. In OneStream, what does a “Form Template” provide?
A. Static user dashboard B. Reusable formatting and layout structure for Cube Views C. A connector to SAP D. Authentication settings Answer: B Explanation: Form Templates define reusable layout structures for Cube Views, especially input forms.
38. Where are Workflow Profile security permissions managed? A. Member List B. Transformation Rules C. Security Roles D. Application Server Answer: C Explanation: Workflow Profile access is controlled via Security Roles that assign tasks and responsibilities. 39. What is a “Data Unit” in OneStream? A. A currency measurement B. A unique combination of workflow dimensions C. A dashboard component D. A storage format Answer: B Explanation: A Data Unit is a unique intersection of dimensional members used to store and control data in workflows. 40. Which dimension allows configuration of various currencies? A. Account B. Scenario C. Currency D. Time Answer: C Explanation: The Currency dimension is used for assigning, converting, and reporting in various currencies.
Explanation: XF Marketplace offers pre-packaged apps such as Account Reconciliation and People Planning.
45. What is the use of the “Global Time” dimension in OneStream? A. Define holidays B. Align different time zones C. Provide a standard time dimension for reporting D. Convert fiscal years Answer: C Explanation: Global Time ensures a uniform time structure across workflows and reports. 46. What does a Form Profile contain? A. User permissions B. Cube Views for data entry C. Metadata records D. Consolidation logic Answer: B Explanation: Form Profiles group together Cube Views that users utilize for data entry or review. 47. Which of the following can be used to track audit changes in OneStream? A. Audit Reports B. Cube Views C. Dashboards D. Scenario Types Answer: A Explanation: Audit Reports show changes in data, metadata, and security for compliance tracking. 48. OneStream’s “Drill-Down” feature is best used to: A. Execute SQL queries B. View metadata
C. View detailed source data D. Define transformation logic Answer: C Explanation: Drill-Down allows users to view the underlying data behind reported figures.
49. Which of the following can be used to store multiple related applications? A. Workflow Groups B. Application Group C. System Platform D. Application Container Answer: D Explanation: Application Containers group multiple related OneStream applications under one logical structure. 50. What is the primary benefit of using member formulas? A. Control security B. Create dashboards C. Define custom logic at the member level D. Automate metadata imports Answer: C Explanation: Member formulas allow you to embed calculations and logic directly into dimension members. 51. What is the main purpose of the “Scenario Type” in OneStream? A. Assign user permissions B. Define workflow profile C. Determine how data is calculated and stored (e.g., periodic or YTD) D. Control currency type Answer: C Explanation: Scenario Types specify storage and calculation logic, such as periodic vs. year-to-date (YTD) data handling. 52. What is a recommended practice before importing metadata into a production environment?
56. What does an "Import Template" allow in OneStream? A. Map security roles B. Schedule tasks C. Define how files are parsed and loaded D. Format Cube Views Answer: C Explanation: Import Templates define how incoming files are processed and mapped during data integration. 57. What is a “Sealed Application” in OneStream? A. A security tool B. A completed workflow C. A deployed XF Marketplace solution with restricted modification D. A snapshot file Answer: C Explanation: A sealed application is a packaged solution from the XF Marketplace that is locked for editing. 58. The Time dimension in OneStream supports: A. Only calendar years B. Custom fiscal structures C. Only 12-month formats D. Static configurations Answer: B Explanation: OneStream allows configuration of custom fiscal calendars as well as standard time structures. 59. Which process eliminates the effect of internal transactions between entities? A. Transformation B. Validation C. Intercompany Elimination D. Workflow Finalization Answer: C
Explanation: Intercompany elimination removes internal transactions from consolidated financials.
60. Which OneStream tool allows for editing of business rules? A. Security Manager B. Dashboard Editor C. Business Rule Editor D. Metadata Import Answer: C Explanation: The Business Rule Editor is used to develop and maintain custom logic using VB.NET. 61. What is the function of the Audit Log in OneStream? A. Monitor application usage B. Configure dashboards C. Track changes to data and metadata D. Secure workflows Answer: C Explanation: The Audit Log records all significant changes for compliance and tracking purposes. 62. A “Form Template” in OneStream provides: A. Application backup B. A reusable input layout for Cube Views C. Metadata import function D. A connector to ERP Answer: B Explanation: Form Templates standardize the layout for data entry across multiple forms. 63. Which OneStream object contains reusable code snippets that return values in Cube Views or Dashboards? A. XFBR String Rules B. Form Profiles
A. Cube View Filters B. Member Alias Table C. Transformation Rules D. Dashboard Grid Answer: B Explanation: Member Alias Tables allow members to have dynamic labels, such as localized names.
68. What dimension stores currency conversion rates? A. Time B. Entity C. Currency D. Account Answer: C Explanation: The Currency dimension is responsible for managing exchange rates. 69. Which OneStream object supports setting up journal entries? A. Metadata Manager B. Cube Views C. Journal Templates D. Workflow Profiles Answer: C Explanation: Journal Templates are used for entering and managing journal entries. 70. What is the best way to ensure metadata conforms to business rules during import? A. Use validation in Excel B. Use Data Quality rules C. Apply Transformation logic D. Run Metadata Validation Answer: D Explanation: The Metadata Validation process checks for consistency, completeness, and correctness.
71. What is the purpose of the Stage in a Workflow Profile? A. Execute security scans B. Validate dashboards C. Define the status of data input D. Provide reporting templates Answer: C Explanation: Workflow Stages represent steps such as data load, validation, and submission in the data process. 72. Which OneStream feature allows version control of entire applications? A. Audit Logs B. Data Management Sequences C. Application Snapshots D. Workflow Tracker Answer: C Explanation: Application Snapshots are versioned backups of application structure and data. 73. Which report type can integrate Excel-like formulas into OneStream? A. Cube View B. XFBR C. Extensible Document D. Audit Report Answer: C Explanation: Extensible Documents support dynamic Excel-like reports integrated with OneStream data. 74. A Dashboard Component can be linked to: A. Security Roles only B. Form Profiles only C. Business Rules, Cube Views, and Data Adapters D. Cube Root only Answer: C
