Download OneStream Implementation (OCA) Topic-Wise Question Bank and more Exams Information Technology in PDF only on Docsity!
ONESTREAM IMPLEMENTATION (OCA) —
TOPIC-WISE QUESTION BANK
**1. Platform Architecture & Design (10 Questions)
- Which component is responsible for handling consolidation, workflow, and calculations?** A. Application Server B. Web Server C. Finance Engine D. SQL Server The Finance Engine performs calculations, consolidation logic, and cube processing. 2. OneStream applications are stored primarily in which database? A. Oracle DB B. MySQL C. SQL Server D. PostgreSQL OneStream uses Microsoft SQL Server as its backend platform. 3. Which environment is recommended for building and testing major structural changes? A. Production B. Development C. User Acceptance Testing
D. Training Development is used for structural design and Intensive changes.
4. What is the purpose of an Application Server in OneStream? A. Data storage B. Processing business rules and managing cube calculations C. User login authentication D. Running dashboards Application Server executes calculations and rules. 5. Metadata is stored in which area of the database? A. Warehouse B. Stage tables C. Application database tables D. Security schema Metadata is stored in the app-specific SQL database. 6. What type of server configuration is required for high user concurrency? A. Single server B. Multiple load-balanced web servers C. Virtual desktop D. Read-only replica Load balancing improves concurrency and performance. 7. Which item is NOT part of the OneStream platform? A. Extensible Dimensionality B. Marketplace Solutions C. Cube Views
A. Faster data loads B. Different levels of detail across entities C. More dashboards D. Additional workflows It allows extensions so different entities can have different detail levels.
12. Which dimension is typically extensible? A. Time B. Scenario C. Account D. Consolidation rule Account dimension is often extended for entity-specific details. 13. Entity extensions allow… A. Extra workflows B. Additional child members for certain entities C. Faster consolidations D. Cube security Entity extensions provide entity-specific members. 14. Which dimension is usually not extended? A. Time B. Account C. UD dimensions D. Entity Time is fixed and cannot be extended. 15. Dimension extensibility reduces the need for:
A. SQL servers B. Multiple applications C. Access rights D. Marketplace solutions Extensions help avoid multiple applications.
16. An extended member belongs to: A. Only the specified entities B. All entities C. Only top-level consolidation D. Account dimension only Extensions are entity-specific. 17. Which view aggregates extended members for reporting? A. Cube View Management B. Parent Consolidation Members C. Workflow Profile D. Import Profiles Parent hierarchies aggregate extended structures. 18. What happens if a calculation references an extended member not defined for an entity? A. Error B. Data duplication C. It ignores the calculation D. Logs warning only Undefined members resolve to NoData. 19. Extensible Dimensionality supports which reporting approach?
23. Transformation rules perform what action? A. Delete data B. Convert source values to target metadata C. Build workflows D. Manage forms Rules map source to target. 24. Import profiles control: A. Entity hierarchies B. Security C. Data source + transformation + load settings D. Scenario parameters Import profiles link the integration chain. 25. Drill-back is used to: A. Refresh metadata B. Trace data back to source system C. Delete source files D. Manage scenarios Drill-back provides data lineage. 26. When a data load is rejected, the reason is usually found in: A. Security logs B. Dashboards C. Event Viewer / Load errors D. Cube View Load logs capture errors. 27. Which item controls period locking during data load?
A. Grid profile B. Workflow status C. Cube View D. Transformation rule Workflow locks prevent overwrite.
28. A NoData result after import usually means: A. File corrupted B. Missing transformation mapping C. Timeout D. Security block Transformation must map every field. 29. Which mode loads data into staging? A. Validate B. Refresh C. Parse only D. Commit Parse mode populates staging without posting. 30. A Load Profile is executed in which sequence? A. Transform → Data Source → Load B. Load → Transform → Data Source C. Data Source → Transform → Load D. Validate → Transform → Load Correct pipeline order. 4. Workflow (10 Questions)
A. Security B. Workflow steps C. Dashboards D. Staging Forms are embedded in workflow tasks.
36. Which Workflow type is used for operational changes? A. Standard B. Cube View C. Extensible D. Admin Extensible workflows support more steps. 37. Workflow sign-off controls: A. Calculation events B. Data locking and submission C. User login D. Dashboards Sign-off controls submission. 38. Workflow channels tell users: A. Metadata updates B. Where to perform data actions C. Dashboard timing D. Calculation speed Channels organize workflows. 39. A certification step is used to:
A. Transform data B. Validate data accuracy C. Load metadata D. Import audit logs Certifications ensure data approval.
40. Which option resets workflow status? A. Refresh Cube B. Reset Workflow Unit C. Rebuild Metadata D. Delete Scenario Reset restores starting state. **5. Cube Design (10 Questions)
- What is the primary performance driver of a cube?** A. Dashboards B. Dimensionality (number and size of dimensions) C. File size D. Workflow delays Dimension size strongly affects performance. 42. Which dimension is mandatory? A. UD B. Account C. Channel D. Marketplace Account is required.
A. Data source B. SQL staging C. Cube (finance engine) D. Marketplace Cube Views display cube data.
48. Sparse data is best managed using: A. Long hierarchies B. Reduction of UD usage C. Extra workflows D. Wider grids Too many UD members cause sparsity. 49. Formula-based accounts are calculated during: A. Data load B. Cube calculation stage C. Metadata build D. Dashboard refresh Formulas run during cube calculation. 50. To improve retrieval speed, use: A. More UD dimensions B. Larger hierarchies C. Fewer dynamic calculations D. Longer workflows Dynamic calcs slow retrieval. 6. Security (10 Questions)
51. Security is applied at which level? A. Entire application only B. Cube + Workflow + Metadata C. Data source only D. Dashboards only OneStream uses layered security. 52. Access Permissions are assigned to: A. Accounts only B. Users only C. Security Groups D. Dashboards Groups manage permissions. 53. A Workflow role gives: A. Dashboard rights B. Load/Confirm/Certify abilities C. Security admin rights D. Cube build rights Workflow roles define data-entry steps. 54. Which security level restricts data viewing? A. Server B. Member Security C. Dashboard D. Import profile Member security limits metadata access. 55. Which user has full unrestricted access?
A. Lock workflow B. Member view rights only C. Certify rights only D. Import rights View rights allow read-only access.
60. Sensitive data visibility is controlled by: A. Dashboard pages B. Conditional formatting C. Security filters D. Cube Views Filters restrict access. **7. Business Rules & Calculations (10 Questions)
- Business Rules are written in:** A. SQL B. XML C. VB.NET D. Python OneStream uses VB.NET for rules. 62. A Finance Rule is used for: A. Metadata build B. Dashboards C. Financial calculations D. Transformation logic Finance Rules govern calculations.
63. A dynamic calculation executes: A. During load B. At query time C. Metadata build D. Security login Dynamic calcs run on retrieval. 64. Which rule type handles workflow validations? A. Form Rule B. Business Rule - Workflow C. Transformation D. Dashboard Rule Workflow rules validate submissions. 65. Cube Calculations run when: A. Dashboards refresh B. Data is consolidated or scenario recalculated C. Users log in D. Data is exported Calc runs triggered by consolidation. 66. Best practice for performance is to: A. Use many dynamic calcs B. Push logic into stored cube calculations C. Use Excel D. Add more UDs Static cube calcs are faster than runtime. 67. A Custom Calculation rule is invoked using:
71. Dashboard Data Adapters retrieve data from: A. Data source B. SQL database only C. Cube or SQL or REST D. Security panel Adapters can get multiple data types. 72. Cube Views are used for: A. Metadata B. Rules C. Financial/operational reporting D. User security Cube Views are primary reporting tools. 73. A Dashboard component that displays charts is: A. Connector B. Visual Tile C. Workflow step D. Data Management Visual Tiles present graphics. 74. Cube View POV allows: A. Scenario creation B. User-based filtering C. SQL scripting D. Dashboards only POV gives user selection. 75. A Form Template is mainly used for:
A. Security B. Data entry C. Metadata creation D. SQL queries Forms collect data.
76. Conditional formatting is used in: A. Rules B. Cube Views C. Metadata D. Workflow Cube Views support conditional formatting. 77. Which object is used for report grouping? A. Workflow B. Scenario C. Row sets D. Transformation Row sets group rows. 78. OneStream Quick Views operate in: A. Dashboards B. Workflow C. Excel Add-In D. SQL Quick Views are Excel-based reporting. 79. Parameters can be used in Cube Views to:
