Sisense BI Sisense BI Data Modeling & Analytics 2 — Questions and Answers
Question 1: What is a 'Live Connect' data model in Sisense?
- A model that queries the source database directly at runtime without pre-building an ElastiCube (Correct answer)
- A real-time chat feature between analysts
- A streaming data pipeline for IoT sensors
- A connection to live social media feeds
Correct answer: A model that queries the source database directly at runtime without pre-building an ElastiCube
Sisense Live Connect executes SQL queries directly against the source database at query time, bypassing ElastiCube for always-current data at the cost of query speed.
Question 2: In Sisense, what does the 'JAQL' query language stand for?
- JSON Analytical Query Language (Correct answer)
- Java Aggregation Query Layer
- Join-Aggregate-Query Logic
- JSON API Query Library
Correct answer: JSON Analytical Query Language
JAQL (JSON Analytical Query Language) is Sisense's native query format used internally and via the API to define data queries for widgets.
Question 3: Which Sisense data connector would you use to import data from a REST API?
- Custom connector or REST API connector (Correct answer)
- JDBC connector
- FTP file import
- ElastiCube direct sync
Correct answer: Custom connector or REST API connector
Sisense provides a REST API connector (or custom connectors via the SDK) to pull data from external REST endpoints into ElastiCube.
Question 4: What is the role of 'data blending' in Sisense analytics?
- Combining data from multiple sources or ElastiCubes within a single dashboard or widget (Correct answer)
- Encrypting data at rest in ElastiCube
- Merging two user accounts into one
- Averaging metric values across time periods
Correct answer: Combining data from multiple sources or ElastiCubes within a single dashboard or widget
Data blending in Sisense allows a single dashboard to pull metrics from multiple ElastiCubes or data sources, enabling cross-source analysis.
Question 5: What is a 'dimension' in Sisense data modeling?
- A categorical field used to slice and group quantitative measures (Correct answer)
- A numeric metric that is aggregated in charts
- A date column used only for filtering
- A calculated formula column
Correct answer: A categorical field used to slice and group quantitative measures
Dimensions in Sisense are descriptive attributes (e.g., region, product category) used to segment and group measures in visualizations.
Question 6: What does 'table indexing' in Sisense ElastiCube do?
- Creates index structures on columns to accelerate filter and join query performance (Correct answer)
- Numbers the rows in a table sequentially
- Exports the table to an indexed CSV file
- Assigns row-level security rules to each record
Correct answer: Creates index structures on columns to accelerate filter and join query performance
ElastiCube indexing builds internal lookup structures on specified columns, significantly speeding up filter operations and table join execution.
Sisense BI Sisense BI Data Modeling & Analytics 2
What is a 'Live Connect' data model in Sisense?