Sisense BI ElastiCube Management & Data Connectivity 2

Question 1

What is the purpose of ElastiCube clustering in a Sisense deployment?

Accepted Answer

To provide high availability and load balancing across multiple ElastiCube Server instances

Answer

ElastiCube clustering allows multiple ElastiCube Server instances to serve the same ElastiCube, providing high availability, failover, and load distribution across servers.

Question 2

How can custom SQL queries be incorporated into an ElastiCube schema in Sisense?

Accepted Answer

By using the Custom SQL Table option within ElastiCube Manager

Answer

ElastiCube Manager includes a Custom SQL Table option that lets users write SQL to define virtual tables, providing flexibility beyond standard drag-and-drop connectors.

Question 3

What is a calculated column in a Sisense ElastiCube?

Accepted Answer

A derived column created using a formula expression and stored during the build process

Answer

A calculated column is defined using formula expressions in ElastiCube and is computed and stored during the build process, making queries faster than run-time calculations.

Question 4

Which build type should be selected when only the structure of tables in the ElastiCube has changed but no data changes occurred?

Accepted Answer

Schema Changes Only

Answer

'Schema Changes Only' updates the ElastiCube's structural metadata without reloading all data, making it faster when only column types, names, or relationships changed.

Question 5

What is the recommended approach in Sisense for connecting to cloud SaaS data sources like Salesforce or Google Analytics?

Accepted Answer

Use Sisense's native cloud connectors available in ElastiCube Manager

Answer

Sisense provides native cloud connectors in ElastiCube Manager for major SaaS platforms, enabling direct scheduled data ingestion without manual exports.

Sisense BI Practice Test

Sisense BI Practice Test

Sisense BI ElastiCube Management & Data Connectivity 2