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

RSUM in Sisense calculates a running (cumulative) sum of a measure across ordered rows in a table or chart.

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

The schema view in Sisense ElastiCube Manager provides a visual canvas where analysts drag tables, define joins, and structure the analytical data model.

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

Column-level security in Sisense lets administrators hide specific fields from designated users or groups, preventing unauthorized access to sensitive data.

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

The Sisense REST API provides endpoints to query data using JAQL, trigger ElastiCube builds, manage users, and automate operations programmatically.

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

Measures in Sisense are quantitative numeric fields (e.g., revenue, quantity) that are summarized through aggregation functions in widgets.

Sisense BI Practice Test

Sisense BI Practice Test

Sisense BI Sisense BI Data Modeling & Analytics 3