Sisense BI Sisense BI Data Modeling & Analytics 3

Question 1

Which Sisense function would you use to calculate a running total in a formula?

Accepted Answer

RSUM (running sum)

Answer

CUMULATIVE

Answer

TOTAL

Answer

ROLLINGAVG

Question 2

In Sisense, what is the 'schema' view in ElastiCube Manager used for?

Accepted Answer

Visually designing the data model by connecting tables and defining relationships

Answer

Viewing raw SQL logs from source queries

Answer

Managing user roles and permissions

Answer

Scheduling automated data refreshes

Question 3

What does 'column-level security' allow a Sisense data admin to do?

Accepted Answer

Restrict specific users or groups from viewing certain fields within a dataset

Answer

Encrypt individual columns with a unique key

Answer

Prevent widgets from sorting by specific columns

Answer

Hide columns from the ElastiCube build log

Question 4

What is the Sisense 'Elasticube REST API' primarily used for?

Accepted Answer

Programmatically querying ElastiCube data, managing builds, and automating administrative tasks

Answer

Uploading raw data files via HTTP

Answer

Rendering dashboards server-side as images

Answer

Connecting Sisense to external BI tools

Question 5

What is a 'measure' (fact) in Sisense data modeling?

Accepted Answer

A numeric value that is aggregated using functions like SUM, AVG, or COUNT

Answer

A text label applied to chart axes

Answer

A filter condition applied at the table level

Answer

A table that stores lookup reference data

Question 6

Which Sisense feature allows you to define a hierarchy (e.g., Year > Quarter > Month) for drill-down navigation?

Accepted Answer

Date/dimension hierarchy definition in ElastiCube or widget drill hierarchy

Answer

Cascading filters

Answer

Nested pivot tables

Answer

BloX drill templates