Sisense BI ElastiCube Management & Data Connectivity 1 — Questions and Answers
Question 1: What type of storage architecture does Sisense's ElastiCube use to deliver fast analytical query performance?
- Row-based relational storage
- Document-based NoSQL storage
- Columnar in-memory storage (Correct answer)
- Graph-based network storage
Correct answer: Columnar in-memory storage
ElastiCube uses columnar in-memory storage (Sisense's In-Chip technology) which allows it to scan and aggregate large datasets extremely quickly.
Question 2: Which ElastiCube build type only processes records that have been added or modified since the last successful build?
- Full Build
- Schema Changes Only
- Accumulative Build (Changes Only) (Correct answer)
- Metadata Sync
Correct answer: Accumulative Build (Changes Only)
The Accumulative Build (Changes Only) processes only new or modified records, significantly reducing build time for large datasets with incremental changes.
Question 3: What is the primary role of the ElastiCube Server in the Sisense architecture?
- Hosting the Sisense web application UI
- Storing user authentication credentials
- Managing and serving ElastiCube data to dashboard queries (Correct answer)
- Processing ETL transformations from source systems
Correct answer: Managing and serving ElastiCube data to dashboard queries
The ElastiCube Server manages running ElastiCubes and responds to query requests from the Sisense application layer that power dashboards.
Question 4: In Sisense ElastiCube Manager, how are relationships between tables typically defined?
- By writing SQL JOIN statements manually
- By editing XML configuration files
- By setting foreign key constraints in the source database
- By drawing visual connection lines between fields in ElastiCube Manager (Correct answer)
Correct answer: By drawing visual connection lines between fields in ElastiCube Manager
ElastiCube Manager provides a visual, drag-and-drop interface where users define table relationships by connecting fields with lines.
Question 5: What occurs during a Full Build of an ElastiCube?
- Only new records added since last build are processed
- Only schema metadata is updated without reloading data
- Changed fields are recalculated using the existing data
- All data is cleared and reloaded from scratch from all sources (Correct answer)
Correct answer: All data is cleared and reloaded from scratch from all sources
A Full Build completely clears existing data and reloads everything from all source systems from scratch, ensuring a completely fresh and accurate dataset.
Question 6: Which file extension does Sisense use to store ElastiCube schema definitions?
- .ecdata
- .sischema
- .cube
- .ecschema (Correct answer)
Correct answer: .ecschema
Sisense stores ElastiCube schema definitions in .ecschema files, which describe the data model's structure, tables, and relationships.
Question 7: What Sisense feature allows administrators to automate ElastiCube builds on a recurring schedule?
- ElastiCube Scheduler (Correct answer)
- Build Automation Manager
- Data Refresh Cron
- Pipeline Orchestrator
Correct answer: ElastiCube Scheduler
The ElastiCube Scheduler is Sisense's built-in tool that allows administrators to configure automatic build schedules such as daily or weekly refreshes.
Sisense BI ElastiCube Management & Data Connectivity 1
What type of storage architecture does Sisense's ElastiCube use to deliver fast analytical query performance?