Sisense BI Sisense BI Data Modeling & Analytics 1 — Questions and Answers
Question 1: What is a Sisense 'ElastiCube'?
- A proprietary in-memory columnar data store optimized for analytics queries (Correct answer)
- A cloud-based data lake storage system
- An ETL pipeline orchestration tool
- A NoSQL document database
Correct answer: A proprietary in-memory columnar data store optimized for analytics queries
ElastiCube is Sisense's in-memory columnar database engine designed to store and rapidly query large analytical datasets.
Question 2: In Sisense ElastiCube, what is the purpose of defining a 'relationship' between two tables?
- To join tables so that data from both can be used together in queries and widgets (Correct answer)
- To replicate one table into another for backup
- To restrict which users can access each table
- To synchronize data refresh schedules between tables
Correct answer: To join tables so that data from both can be used together in queries and widgets
Relationships in Sisense ElastiCube define how tables are joined, enabling widgets to query across multiple related tables simultaneously.
Question 3: Which join type is supported in Sisense ElastiCube table relationships?
- Left join (many-to-one) (Correct answer)
- Full outer join only
- Cross join only
- Right join only
Correct answer: Left join (many-to-one)
Sisense ElastiCube uses left join semantics (many-to-one) when connecting fact tables to dimension tables in its data model.
Question 4: What is a 'custom formula' (calculated field) in Sisense?
- A user-defined expression that computes a new metric from existing fields using Sisense formula syntax (Correct answer)
- A SQL stored procedure imported from the source database
- A Python script that runs during ElastiCube build
- A scheduled aggregation job that runs nightly
Correct answer: A user-defined expression that computes a new metric from existing fields using Sisense formula syntax
Custom formulas in Sisense let users create new calculated metrics by writing expressions using Sisense's formula language within the ElastiCube or widget.
Question 5: What does the 'ElastiCube build' process do in Sisense?
- Imports, processes, and indexes source data into the ElastiCube in-memory store (Correct answer)
- Deploys the Sisense application to production servers
- Compiles the dashboard layout into static HTML
- Generates PDF exports of all dashboards
Correct answer: Imports, processes, and indexes source data into the ElastiCube in-memory store
The ElastiCube build process extracts data from connected sources, applies transformations, and loads it into the compressed in-memory columnar store.
Question 6: Which Sisense feature allows incremental data loading to reduce build time?
- Accumulative (incremental) build (Correct answer)
- Full rebuild only
- Live connection mode
- Snapshot import
Correct answer: Accumulative (incremental) build
Sisense's accumulative build mode appends only new or changed records to the ElastiCube, significantly reducing build duration for large datasets.
Sisense BI Sisense BI Data Modeling & Analytics 1
What is a Sisense 'ElastiCube'?