Sisense BI Sisense BI Data Modeling & Analytics

Question 1

What is a Sisense 'ElastiCube'?

Accepted Answer

A proprietary in-memory columnar data store optimized for analytics queries

Answer

A cloud-based data lake storage system

Answer

An ETL pipeline orchestration tool

Answer

A NoSQL document database

Question 2

In Sisense ElastiCube, what is the purpose of defining a 'relationship' between two tables?

Accepted Answer

To join tables so that data from both can be used together in queries and widgets

Answer

To replicate one table into another for backup

Answer

To restrict which users can access each table

Answer

To synchronize data refresh schedules between tables

Question 3

Which join type is supported in Sisense ElastiCube table relationships?

Accepted Answer

Left join (many-to-one)

Answer

Full outer join only

Answer

Cross join only

Answer

Right join only

Question 4

What is a 'custom formula' (calculated field) in Sisense?

Accepted Answer

A user-defined expression that computes a new metric from existing fields using Sisense formula syntax

Answer

A SQL stored procedure imported from the source database

Answer

A Python script that runs during ElastiCube build

Answer

A scheduled aggregation job that runs nightly

Question 5

What does the 'ElastiCube build' process do in Sisense?

Accepted Answer

Imports, processes, and indexes source data into the ElastiCube in-memory store

Answer

Deploys the Sisense application to production servers

Answer

Compiles the dashboard layout into static HTML

Answer

Generates PDF exports of all dashboards

Question 6

Which Sisense feature allows incremental data loading to reduce build time?

Accepted Answer

Accumulative (incremental) build

Answer

Full rebuild only

Answer

Live connection mode

Answer

Snapshot import