OneStream Certified Professional (OCP) - Lead
Architect R1 Exam
1. Cube Design – Types & Use Cases
Q: Which cube type should you use to store account balances by period and entity for reporting
and consolidation?
A. Dimension Cube
B. Data Cube
C. Aggregate Cube
D. Mapping Cube
Answer: B. Data Cube
Explanation: Data Cubes hold transactional/financial data across multiple dimensions like
Accounts, Periods, Entities—ideal for reporting and consolidations
stuvia.com+3docsity.com+3docsity.com+3.
2. Dimension Relationships
Q: Which cube type is best-suited for modeling hierarchical relationships (e.g., organizational
structures)?
A. Data Cube
B. Dimension Cube
C. Mapping Cube
D. Hierarchy Cube
Answer: B. Dimension Cube
Explanation: They define hierarchies and metadata for dimensions like Org, Account, and Time
stuvia.com+3docsity.com+3docsity.com+3.
3. Mapping Integrations
Q: You need to map source system dimensions to your OneStream dimensions during ETL.
Which cube type will you use?
A. Dimension Cube
B. Data Cube
C. Mapping Cube
D. Integration Cube
, Answer: C. Mapping Cube
Explanation: These cubes map external system values to OneStream dimensions to maintain
consistency 2020381.fs1.hubspotusercontent-na1.net+6stuvia.com+6stuvia.com+6.
4. Performance Optimization
Q: To accelerate retrieval speed and reduce latency, which approach is best?
A. Use a highly detailed single Data Cube
B. Pre-aggregate data in Aggregate Cubes
C. Normalize data across many cubes
D. Use deeper dimension hierarchies
Answer: B. Pre-aggregate via Aggregate Cubes
Explanation: Aggregate Cubes store summarized data to improve query performance
udemy.com+7stuvia.com+7docsity.com+7.
5. Data Separation Strategy
Q: For retaining historical versus current data without impacting performance, which is optimal?
A. One cube with time partitioning
B. Separate cubes for historical and current data
C. Dimension flagging
D. Use Exchange Rate Cube
Answer: B. Separate cubes for historical & current
Explanation: Segregating enhances performance and manageability
docsity.com+1stuvia.com+1udemy.com.
6. Maintainable Business Logic
Q: Where should you store reusable calculations and business logic?
A. Data Cube
B. Dimension Cube
C. Formula Cube
D. Mapping Cube
Answer: C. Formula Cube
Explanation: Formula Cubes centralize calculations for reusability across models
linkedin.com+9stuvia.com+9docsity.com+9.
7. Consolidation Members
Architect R1 Exam
1. Cube Design – Types & Use Cases
Q: Which cube type should you use to store account balances by period and entity for reporting
and consolidation?
A. Dimension Cube
B. Data Cube
C. Aggregate Cube
D. Mapping Cube
Answer: B. Data Cube
Explanation: Data Cubes hold transactional/financial data across multiple dimensions like
Accounts, Periods, Entities—ideal for reporting and consolidations
stuvia.com+3docsity.com+3docsity.com+3.
2. Dimension Relationships
Q: Which cube type is best-suited for modeling hierarchical relationships (e.g., organizational
structures)?
A. Data Cube
B. Dimension Cube
C. Mapping Cube
D. Hierarchy Cube
Answer: B. Dimension Cube
Explanation: They define hierarchies and metadata for dimensions like Org, Account, and Time
stuvia.com+3docsity.com+3docsity.com+3.
3. Mapping Integrations
Q: You need to map source system dimensions to your OneStream dimensions during ETL.
Which cube type will you use?
A. Dimension Cube
B. Data Cube
C. Mapping Cube
D. Integration Cube
, Answer: C. Mapping Cube
Explanation: These cubes map external system values to OneStream dimensions to maintain
consistency 2020381.fs1.hubspotusercontent-na1.net+6stuvia.com+6stuvia.com+6.
4. Performance Optimization
Q: To accelerate retrieval speed and reduce latency, which approach is best?
A. Use a highly detailed single Data Cube
B. Pre-aggregate data in Aggregate Cubes
C. Normalize data across many cubes
D. Use deeper dimension hierarchies
Answer: B. Pre-aggregate via Aggregate Cubes
Explanation: Aggregate Cubes store summarized data to improve query performance
udemy.com+7stuvia.com+7docsity.com+7.
5. Data Separation Strategy
Q: For retaining historical versus current data without impacting performance, which is optimal?
A. One cube with time partitioning
B. Separate cubes for historical and current data
C. Dimension flagging
D. Use Exchange Rate Cube
Answer: B. Separate cubes for historical & current
Explanation: Segregating enhances performance and manageability
docsity.com+1stuvia.com+1udemy.com.
6. Maintainable Business Logic
Q: Where should you store reusable calculations and business logic?
A. Data Cube
B. Dimension Cube
C. Formula Cube
D. Mapping Cube
Answer: C. Formula Cube
Explanation: Formula Cubes centralize calculations for reusability across models
linkedin.com+9stuvia.com+9docsity.com+9.
7. Consolidation Members
