Question #1
Where is the smallest rectangle in the treemap visualization positioned?
- A . Bottom-left corner
- B . Top-right corner
- C . Top-left corner
- D . Bottom-right corner
Correct Answer: D
D
Explanation:
A treemap visualization is a way of displaying large amounts of hierarchically structured data. The space in the visualization is split up into rectangles that are sized and ordered by a quantitative variable. The treemap in Spotfire uses a squarified algorithm, which means that the rectangles in the treemap range in size from the top left corner of the visualization to the bottom right corner, with the largest rectangle positioned in the top left corner and the smallest rectangle in the bottom right corner. For hierarchies, that is, when the rectangles are nested, the same ordering of the rectangles is repeated for each rectangle in the treemap. References: What is a Treemap?, Creating a treemap
D
Explanation:
A treemap visualization is a way of displaying large amounts of hierarchically structured data. The space in the visualization is split up into rectangles that are sized and ordered by a quantitative variable. The treemap in Spotfire uses a squarified algorithm, which means that the rectangles in the treemap range in size from the top left corner of the visualization to the bottom right corner, with the largest rectangle positioned in the top left corner and the smallest rectangle in the bottom right corner. For hierarchies, that is, when the rectangles are nested, the same ordering of the rectangles is repeated for each rectangle in the treemap. References: What is a Treemap?, Creating a treemap
Question #2
Which is the right level of permission to be set for a folder in a library?
- A . Access + Full Control
- B . Browse + Modify
- C . Browse + Access
- D . Access + Modify
Correct Answer: C
C
Explanation:
The right level of permission to be set for a folder in a library depends on the intended use of the folder and its contents. However, the most common and recommended level is Browse + Access, which allows the user or group to access and browse the folder contents, and open and use items found in such folders, but not save or modify them1. This level of permission ensures that the folder and its items are visible and usable, but not editable or deletable by unauthorized users or groups. It also allows the folder to show subfolders, if the user or group has Browse + Access permission for the subfolders as well2. The other levels of permission are either too restrictive or too permissive for most scenarios. For example, Access + Full Control would allow the user or group to execute information links, modify and save items, and change permissions for the folder and its contents, but not browse the folder contents or open analysis files1. This level of permission is usually reserved for the Library Administrator group, which has full control of the entire library2Browse + Modify would allow the user or group to browse and access the folder contents, and also modify items or save new items, but not change permissions for the folder and its contents1. This level of permission is suitable for collaborative work, where multiple users or groups can edit and save items in the same folder. However, it also poses a risk of accidental or intentional deletion or modification of items by unauthorized users or groups Access + Modify would allow the user or group to execute information links, and also modify items or save new items, but not browse the folder contents, open analysis files, or change permissions for the folder and its contents1. This level of permission is rarely used, as it limits the visibility and usability of the folder and its items, while allowing modification and saving of items.
References:
* Setting Folder Permissions
* Permissions
* Editing Folder Permissions
* How to report on library permissions
C
Explanation:
The right level of permission to be set for a folder in a library depends on the intended use of the folder and its contents. However, the most common and recommended level is Browse + Access, which allows the user or group to access and browse the folder contents, and open and use items found in such folders, but not save or modify them1. This level of permission ensures that the folder and its items are visible and usable, but not editable or deletable by unauthorized users or groups. It also allows the folder to show subfolders, if the user or group has Browse + Access permission for the subfolders as well2. The other levels of permission are either too restrictive or too permissive for most scenarios. For example, Access + Full Control would allow the user or group to execute information links, modify and save items, and change permissions for the folder and its contents, but not browse the folder contents or open analysis files1. This level of permission is usually reserved for the Library Administrator group, which has full control of the entire library2Browse + Modify would allow the user or group to browse and access the folder contents, and also modify items or save new items, but not change permissions for the folder and its contents1. This level of permission is suitable for collaborative work, where multiple users or groups can edit and save items in the same folder. However, it also poses a risk of accidental or intentional deletion or modification of items by unauthorized users or groups Access + Modify would allow the user or group to execute information links, and also modify items or save new items, but not browse the folder contents, open analysis files, or change permissions for the folder and its contents1. This level of permission is rarely used, as it limits the visibility and usability of the folder and its items, while allowing modification and saving of items.
References:
* Setting Folder Permissions
* Permissions
* Editing Folder Permissions
* How to report on library permissions
Question #3
Which three of the following are property control types? Choose 3 answers
- A . Bookmarks
- B . Hyperlinks
- C . List boxes
- D . Drop-down lists
- E . Sliders
- F . Buttons
Correct Answer: C D E
C D E
Explanation:
Property controls are devices that can change the content of a property in an easy way. They can be inserted in a text area and configured to use the values from a data table or a fixed list. There are six types of property controls available in TIBCO Spotfire: label, input field, drop-down list, list box, slider, and button1. Out of these, the options C (list boxes), D (drop-down lists), and E (sliders) are valid property control types. The other options are not property control types. Bookmarks are used to save and restore the state of an analysis2. Hyperlinks are used to link to external web pages or documents3. Buttons are used to execute scripts or actions4.
References: 1: Details on Property Control – TIBCO Software1, 2: Bookmarks – TIBCO Software2, 3: Hyperlinks – TIBCO Software3, 4: Buttons – TIB
CO Software4
C D E
Explanation:
Property controls are devices that can change the content of a property in an easy way. They can be inserted in a text area and configured to use the values from a data table or a fixed list. There are six types of property controls available in TIBCO Spotfire: label, input field, drop-down list, list box, slider, and button1. Out of these, the options C (list boxes), D (drop-down lists), and E (sliders) are valid property control types. The other options are not property control types. Bookmarks are used to save and restore the state of an analysis2. Hyperlinks are used to link to external web pages or documents3. Buttons are used to execute scripts or actions4.
References: 1: Details on Property Control – TIBCO Software1, 2: Bookmarks – TIBCO Software2, 3: Hyperlinks – TIBCO Software3, 4: Buttons – TIB
CO Software4
Question #4
Which custom expression function is used by when you auto-bin a numeric column?
- A . BinByEvenDistributionQ
- B . AutoBinNumeric()
- C . AutoBinByLimitsO
- D . BinBySpecifieLimits()
- E . BinByStdDev()
Correct Answer: B
B
Explanation:
AutoBinNumeric() is a custom expression function that is used when you auto-bin a numeric column. This function creates a binned column where the value range is divided into intervals based on the number of unique values and the distribution of the data. The function takes one argument, which is the column to bin, and returns a string column with the bin labels. The function is equivalent to right-clicking on a column selector and selecting Auto-bin
Column, which creates a temporary, automatic binning on an axis. The function can be used in custom expressions to create permanent binned columns or to apply binning to other visualizations. References: AutoBinNumeric, How to Use Binning
B
Explanation:
AutoBinNumeric() is a custom expression function that is used when you auto-bin a numeric column. This function creates a binned column where the value range is divided into intervals based on the number of unique values and the distribution of the data. The function takes one argument, which is the column to bin, and returns a string column with the bin labels. The function is equivalent to right-clicking on a column selector and selecting Auto-bin
Column, which creates a temporary, automatic binning on an axis. The function can be used in custom expressions to create permanent binned columns or to apply binning to other visualizations. References: AutoBinNumeric, How to Use Binning
Question #5
What are the three different types of properties that can be linked to a property control? Choose 3 answers
- A . Document Properties
- B . Text Area Properties
- C . Data Table Properties
- D . Column Properties
- E . Visualization Properties
Correct Answer: A C D
A C D
Explanation:
Property controls are devices that can change the content of a property in an easy way. They can be linked to three different types of properties: document properties, data table properties, and column properties.
Document properties are properties that are defined for the entire analysis and can be used in expressions, scripts, or filters. Data table properties are properties that are defined for a specific data table and can be used in expressions or scripts. Column properties are properties that are defined for a specific column in a data table and can be used in expressions or scripts. Text area properties and visualization properties are not types of properties that can be linked to a property control, but rather properties of the text area or visualization itself. References: Details on Property Control, Dependent Property Controls in TIBCO Spotfire®
A C D
Explanation:
Property controls are devices that can change the content of a property in an easy way. They can be linked to three different types of properties: document properties, data table properties, and column properties.
Document properties are properties that are defined for the entire analysis and can be used in expressions, scripts, or filters. Data table properties are properties that are defined for a specific data table and can be used in expressions or scripts. Column properties are properties that are defined for a specific column in a data table and can be used in expressions or scripts. Text area properties and visualization properties are not types of properties that can be linked to a property control, but rather properties of the text area or visualization itself. References: Details on Property Control, Dependent Property Controls in TIBCO Spotfire®
Question #6
What file extension is used when saving a Spotfire analysis?
- A . -HTML
- B . -DXP
- C . XLSX
- D . XML
- E . CSV
Correct Answer: B
B
Explanation:
A Spotfire analysis is saved as a file with the extension .dxp, which stands for Data eXploration Project. This file contains the data, visualizations, pages, filters, markings, and other settings of the analysis. A .dxp file can be opened in Spotfire Analyst or Spotfire Web Player, or uploaded to Spotfire Server for sharing and collaboration. References: Extending Spotfire® – TIBCO Software, File data sources – TIBCO Software, Extensions – TIB CO Software
B
Explanation:
A Spotfire analysis is saved as a file with the extension .dxp, which stands for Data eXploration Project. This file contains the data, visualizations, pages, filters, markings, and other settings of the analysis. A .dxp file can be opened in Spotfire Analyst or Spotfire Web Player, or uploaded to Spotfire Server for sharing and collaboration. References: Extending Spotfire® – TIBCO Software, File data sources – TIBCO Software, Extensions – TIB CO Software
Question #7
Which of the following are types of action controls? Choose 3 answers
- A . Links
- B . Scripts
- C . Images
- D . Buttons
Correct Answer: A B D
A B D
Explanation:
Action controls are components that can be added to a text area to perform various actions when clicked. They can be either links, buttons, or images. The actions can include opening TIBCO Spotfire tools, applying bookmarks, navigating to a certain page or visualization, executing scripts, or refreshing data functions1. Scripts are custom actions that use the IronPython scripting functionality to automate tasks or extend the functionality of Spotfire2. Images are not a type of action control, but they can be used as the appearance of an action control1. References: Details on Action Control, IronPython Scripting in TIBCO Spotfire
A B D
Explanation:
Action controls are components that can be added to a text area to perform various actions when clicked. They can be either links, buttons, or images. The actions can include opening TIBCO Spotfire tools, applying bookmarks, navigating to a certain page or visualization, executing scripts, or refreshing data functions1. Scripts are custom actions that use the IronPython scripting functionality to automate tasks or extend the functionality of Spotfire2. Images are not a type of action control, but they can be used as the appearance of an action control1. References: Details on Action Control, IronPython Scripting in TIBCO Spotfire
Question #8
Transforming an underlying Data Table from Short/Wide to Tall/Skinny format is known as
- A . Calculation
- B . Unpivot
- C . Renaming Columns
- D . Pivot
- E . Normalization
Correct Answer: B
B
Explanation:
Unpivoting is a transformation method that changes the data table from a short/wide format to a tall/skinny format. This means that multiple columns are combined into one or a few columns, and the number of rows increases accordingly. Unpivoting can be useful when you want to analyze the distribution of data across different categories or values, or when you want to apply other transformations or calculations on the data.
Unpivoting can be done either when loading data or after the data has been loaded into Spotfire. To unpivot data, you need to select which columns to keep as they are (category columns) and which columns to merge into one or more value columns (value columns). You can also specify the names of the new columns and the data types of the value columns. References: Unpivoting Data, Transforming Data, Spotfire Tips & Tricks: Normalize/Standardize your data with Spotfire
B
Explanation:
Unpivoting is a transformation method that changes the data table from a short/wide format to a tall/skinny format. This means that multiple columns are combined into one or a few columns, and the number of rows increases accordingly. Unpivoting can be useful when you want to analyze the distribution of data across different categories or values, or when you want to apply other transformations or calculations on the data.
Unpivoting can be done either when loading data or after the data has been loaded into Spotfire. To unpivot data, you need to select which columns to keep as they are (category columns) and which columns to merge into one or more value columns (value columns). You can also specify the names of the new columns and the data types of the value columns. References: Unpivoting Data, Transforming Data, Spotfire Tips & Tricks: Normalize/Standardize your data with Spotfire
Question #9
Which two of the following are can be passed lo a script via a parameter? Choose 2 answers
- A . Markings
- B . Visualizations
- C . Filtering Schemes
- D . Pages
Correct Answer: B D
B D
Explanation:
According to the documentation, you can define script parameters for IronPython scripts in action controls and JavaScript parameters when you edit HTML of a text area. The type of parameter can be a simple data type such as a text string, an integer, etc., or it can be a visualization, page or data table in the current analysis.
Therefore, visualizations and pages are two valid types of parameters that can be passed to a script. Markings and filtering schemes are not listed as possible parameter types. References: Details on Add/Edit Script Parameter, Using Scripts in the Text Area
B D
Explanation:
According to the documentation, you can define script parameters for IronPython scripts in action controls and JavaScript parameters when you edit HTML of a text area. The type of parameter can be a simple data type such as a text string, an integer, etc., or it can be a visualization, page or data table in the current analysis.
Therefore, visualizations and pages are two valid types of parameters that can be passed to a script. Markings and filtering schemes are not listed as possible parameter types. References: Details on Add/Edit Script Parameter, Using Scripts in the Text Area
Question #10
Which three of the following are types of input or output parameters for a data function? Choose 3 answers
- A . Column
- B . Document property
- C . Column property
- D . Table
- E . Value
- F . Visualization
Correct Answer: A B E
A B E
Explanation:
A data function is a reusable calculation that can be applied to data in a Spotfire analysis. A data function can have input and output parameters that define how the data function interacts with the data and the analysis.
The input parameters specify what data or values are required for the data function to run, and the output parameters specify what data or values are returned by the data function.
The types of input or output parameters for a data function are1:
* Column: A column parameter represents a single column of data from a data table. A column parameter can be used as input to provide a vector of values to the data function, or as output to create a new column in the data table or overwrite an existing column. A column parameter can have a data type such as real, integer, string, or boolean.
* Document property: A document property parameter represents a value that is stored in the analysis document and can be used to control various aspects of the analysis, such as filters, markings, colors, etc. A document property parameter can be used asinput to provide a scalar value to the data function, or as output to create a new document property or overwrite an existing document property. A document property parameter can have a data type such as real, integer, string, boolean, date, or time.
* Value: A value parameter represents a scalar value that is entered by the user or calculated by the data function. A value parameter can be used as input to provide a constant or variable value to the data
* function, or as output to return a single value from the data function. A value parameter can have a data type such as real, integer, string, boolean, date, or time.
The other options, column property, table, and visualization, are not valid types of input or output parameters for a data function.
References:
* Details on Data Functions – Parameters
* Configuring Data Function Parameters
* How to select/deselect inputs/outputs/parameters in Statistica Data Function for Spotfire
* How to pass input from Spotfire to Statistica Data Function?
A B E
Explanation:
A data function is a reusable calculation that can be applied to data in a Spotfire analysis. A data function can have input and output parameters that define how the data function interacts with the data and the analysis.
The input parameters specify what data or values are required for the data function to run, and the output parameters specify what data or values are returned by the data function.
The types of input or output parameters for a data function are1:
* Column: A column parameter represents a single column of data from a data table. A column parameter can be used as input to provide a vector of values to the data function, or as output to create a new column in the data table or overwrite an existing column. A column parameter can have a data type such as real, integer, string, or boolean.
* Document property: A document property parameter represents a value that is stored in the analysis document and can be used to control various aspects of the analysis, such as filters, markings, colors, etc. A document property parameter can be used asinput to provide a scalar value to the data function, or as output to create a new document property or overwrite an existing document property. A document property parameter can have a data type such as real, integer, string, boolean, date, or time.
* Value: A value parameter represents a scalar value that is entered by the user or calculated by the data function. A value parameter can be used as input to provide a constant or variable value to the data
* function, or as output to return a single value from the data function. A value parameter can have a data type such as real, integer, string, boolean, date, or time.
The other options, column property, table, and visualization, are not valid types of input or output parameters for a data function.
References:
* Details on Data Functions – Parameters
* Configuring Data Function Parameters
* How to select/deselect inputs/outputs/parameters in Statistica Data Function for Spotfire
* How to pass input from Spotfire to Statistica Data Function?
Question #11
In Spotfire’s IronPython langauge, what does the <code>Document.Pages</code> object represent?
- A . A collection of the web pages where the analysis is published
- B . A collection of the pages in the current document
- C . The system pagefile
- D . A collection of documents accessing sub-objects in the tree of the model
Correct Answer: B
B
Explanation:
The <code>Document.Pages</code> object represents a collection of the pages in the current document. It is an instance of the PageCollection class, which provides methods and properties to access, add, remove, or reorder the pages. Each page is an instance of the Page class, which contains the title, visuals, filtering scheme, and other properties of the page. The <code>Document.Pages</code> object can be used in IronPython scripts to iterate over the pages, navigate to a specific page, or modify the pages programmatically. References: PageCollection Class, Page Class, Navigate Pages using IronPython in Spotfire®
B
Explanation:
The <code>Document.Pages</code> object represents a collection of the pages in the current document. It is an instance of the PageCollection class, which provides methods and properties to access, add, remove, or reorder the pages. Each page is an instance of the Page class, which contains the title, visuals, filtering scheme, and other properties of the page. The <code>Document.Pages</code> object can be used in IronPython scripts to iterate over the pages, navigate to a specific page, or modify the pages programmatically. References: PageCollection Class, Page Class, Navigate Pages using IronPython in Spotfire®
Question #12
Which visualization type can trigger an action when clicked?
- A . Table visualization
- B . Cross table
- C . Line chart
- D . Graphical table
Correct Answer: D
D
Explanation:
A graphical table is a visualization that combines the features of a table and a bar chart. It can display values, icons, images, and sparklines in a grid layout. A graphical table can also trigger an action when clicked, such as opening a tool, applying a bookmark, or navigating to a page or a visualization. This can be configured by adding an action control to the graphical table from the text area menu. Other visualization types, such as table, cross table, and line chart, do not have this functionality by default, but they can be customized using scripts or mods to enable actions when clicked. References: Graphical Table, Details on Action Control, Actions
D
Explanation:
A graphical table is a visualization that combines the features of a table and a bar chart. It can display values, icons, images, and sparklines in a grid layout. A graphical table can also trigger an action when clicked, such as opening a tool, applying a bookmark, or navigating to a page or a visualization. This can be configured by adding an action control to the graphical table from the text area menu. Other visualization types, such as table, cross table, and line chart, do not have this functionality by default, but they can be customized using scripts or mods to enable actions when clicked. References: Graphical Table, Details on Action Control, Actions
Question #13
A box plot can visualize which three of the following statistical measures? Choose 3 answers
- A . Moving average
- B . % of total
- C . Cumulative sum
- D . Standard deviation
- E . Variance
- F . Median
Correct Answer: D E F
D E F
Explanation:
A box plot is a graphical tool to visualize key statistical measures, such as median, mean and quartiles1. The median is the middle value of the data, which divides the data into two equal halves. The variance is a measure of how spread out the data is, calculated as the average squared deviation from the mean. The standard deviation is the square root of the variance, which has the same unit as the data.
A box plot can show these three measures by using the following elements2:
* The band in the middle of the box indicates the median.
* The bottom and top of the box indicate the first and third quartiles, which are the medians of the lower and upper halves of the data. The difference between the third and first quartiles is called the interquartile range (IQR), which is a measure of variability similar to the standard deviation.
* The bottom and top of the whiskers represent the minimum and maximum values within 1.5 times the IQR from the first and third quartiles. Any values outside this range are considered outliers and are shown as individual points. The length of the whiskers is related to the variance of the data, as larger variance implies more spread out data and longer whiskers.
* The mean is denoted by a small circle, which may or may not be inside the box depending on how skewed the data is. The mean is another measure of central tendency, which is the average value of the data. The distance between the mean and the median reflects the symmetry of the data distribution.
References:
* What is a Box Plot?
* Box Plot
D E F
Explanation:
A box plot is a graphical tool to visualize key statistical measures, such as median, mean and quartiles1. The median is the middle value of the data, which divides the data into two equal halves. The variance is a measure of how spread out the data is, calculated as the average squared deviation from the mean. The standard deviation is the square root of the variance, which has the same unit as the data.
A box plot can show these three measures by using the following elements2:
* The band in the middle of the box indicates the median.
* The bottom and top of the box indicate the first and third quartiles, which are the medians of the lower and upper halves of the data. The difference between the third and first quartiles is called the interquartile range (IQR), which is a measure of variability similar to the standard deviation.
* The bottom and top of the whiskers represent the minimum and maximum values within 1.5 times the IQR from the first and third quartiles. Any values outside this range are considered outliers and are shown as individual points. The length of the whiskers is related to the variance of the data, as larger variance implies more spread out data and longer whiskers.
* The mean is denoted by a small circle, which may or may not be inside the box depending on how skewed the data is. The mean is another measure of central tendency, which is the average value of the data. The distance between the mean and the median reflects the symmetry of the data distribution.
References:
* What is a Box Plot?
* Box Plot
Question #14
Which namespace contains classes used to interact with visualizations in a document?
- A . Spotfire.Dxp.Application.Tools
- B . Spotfire.Dxp.Application.VisualCollection
- C . Spotfire.Dxp.Application.AnalyticItems
- D . Spotfire.Dxp.Application.Visualizations
- E . Spotfire.Dxp.Application.Visuals
Correct Answer: E
E
Explanation:
The Spotfire.Dxp.Application.Visuals namespace contains classes used to configure visualizations and text areas in a page1. These classes include the abstract base class Visualization, which represents a common base for all visualizations, and its derived classes, such as BarChart, BoxPlot, MapChart, ScatterPlot, etc. Each visualization class exposes properties and methods to access and modify the settings and data of the visualization, such as axes, colors, shapes, filters, markings, etc. The Spotfire.Dxp.Application.Visuals namespace also contains classes for text areas, which are used to display text, images, or HTML content on a page, and classes for various components of visualizations, such as axes, legends, reference lines, etc.
References:
* Spotfire.Dxp.Application.Visuals Namespace
* Visualization Class
* Spotfire® Document Model Framework API Overview
E
Explanation:
The Spotfire.Dxp.Application.Visuals namespace contains classes used to configure visualizations and text areas in a page1. These classes include the abstract base class Visualization, which represents a common base for all visualizations, and its derived classes, such as BarChart, BoxPlot, MapChart, ScatterPlot, etc. Each visualization class exposes properties and methods to access and modify the settings and data of the visualization, such as axes, colors, shapes, filters, markings, etc. The Spotfire.Dxp.Application.Visuals namespace also contains classes for text areas, which are used to display text, images, or HTML content on a page, and classes for various components of visualizations, such as axes, legends, reference lines, etc.
References:
* Spotfire.Dxp.Application.Visuals Namespace
* Visualization Class
* Spotfire® Document Model Framework API Overview
Question #15
Which two layers of a map chart visualization allow data marking? Choose 2 answers
- A . Map layer
- B . Theme layer
- C . Marker layer
- D . Feature layer
- E . Image layer
Correct Answer: C D
C D
Explanation:
Data marking is the process of selecting items or rows in a visualization to view details or manipulate them. In a map chart visualization, data marking can be applied to two layers: the marker layer and the feature layer.
The marker layer displays data points as markers or pies on the map, and the feature layer displays geographic features such as countries, regions, or states. Both layers allow data marking by clicking or dragging on the map, or by using axis marking on the scale labels. The map layer, the theme layer, and the image layer do not support data marking, as they are used to display the background map, the color scheme, and the custom images respectively.
References:
* Marking in Visualizations1
* Explanation of marking and how it is displayed in visualizations in TIBCO Spotfire2
* Map Chart Properties – Data – Map with Markers or Pies3
C D
Explanation:
Data marking is the process of selecting items or rows in a visualization to view details or manipulate them. In a map chart visualization, data marking can be applied to two layers: the marker layer and the feature layer.
The marker layer displays data points as markers or pies on the map, and the feature layer displays geographic features such as countries, regions, or states. Both layers allow data marking by clicking or dragging on the map, or by using axis marking on the scale labels. The map layer, the theme layer, and the image layer do not support data marking, as they are used to display the background map, the color scheme, and the custom images respectively.
References:
* Marking in Visualizations1
* Explanation of marking and how it is displayed in visualizations in TIBCO Spotfire2
* Map Chart Properties – Data – Map with Markers or Pies3
Question #16
The Expression shortcut "Cumulative Sum" uses which expression?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Correct Answer: C
C
Explanation:
The expression shortcut "Cumulative Sum" uses the expression Sum([Column]) THEN Sum([Value]) OVER (AllPrevious([Axis.X])).
This expression calculates the sum of the values in a column, and then calculates the cumulative sum of those values over all previous values on the X-axis. This is equivalent to option C in the image you sent1. References:
* Cumulative Sum
C
Explanation:
The expression shortcut "Cumulative Sum" uses the expression Sum([Column]) THEN Sum([Value]) OVER (AllPrevious([Axis.X])).
This expression calculates the sum of the values in a column, and then calculates the cumulative sum of those values over all previous values on the X-axis. This is equivalent to option C in the image you sent1. References:
* Cumulative Sum
Question #17
Which data relationship algorithm compares two numerical values?
- A . Chi-square
- B . Anova
- C . Linear regression
- D . Kruskal-Wallis
Correct Answer: C
C
Explanation:
Linear regression is a data relationship algorithm that compares two numerical values by fitting a linear equation to the observed data. It measures the strength and direction of the relationship between the dependent variable (Y) and the independent variable (X) by calculating the slope and the intercept of the line. It also provides a p-value that indicates the significance of the relationship1. The other options are not data relationship algorithms that compare two numerical values. Chi-square is used to compare categorical columns by testing the independence of the frequencies in a contingency table2. Anova is used to compare the mean values of a numerical column across different groups defined by a categorical column3. Kruskal-Wallis is used to compare the ranks of a sortable column across different groups defined by a categorical column.
References: 1: Linear Regression – TIBCO Software1, 2: Chi-square – TIBCOSoftware2, 3: Data Relationships Anova Algorithm – TIBCO Software3, : Kruskal-Wallis – TIBCO Software
C
Explanation:
Linear regression is a data relationship algorithm that compares two numerical values by fitting a linear equation to the observed data. It measures the strength and direction of the relationship between the dependent variable (Y) and the independent variable (X) by calculating the slope and the intercept of the line. It also provides a p-value that indicates the significance of the relationship1. The other options are not data relationship algorithms that compare two numerical values. Chi-square is used to compare categorical columns by testing the independence of the frequencies in a contingency table2. Anova is used to compare the mean values of a numerical column across different groups defined by a categorical column3. Kruskal-Wallis is used to compare the ranks of a sortable column across different groups defined by a categorical column.
References: 1: Linear Regression – TIBCO Software1, 2: Chi-square – TIBCOSoftware2, 3: Data Relationships Anova Algorithm – TIBCO Software3, : Kruskal-Wallis – TIBCO Software
Question #18
Which of the following is not a filter type in Spotfire?
- A . ItemFilter
- B . Toggle Filter
- C . Range Filter
- D . Radio Button Filter
Correct Answer: B
B
Explanation:
A toggle filter is not a filter type in Spotfire, but a way to switch between two filter settings for a column. A toggle filter can be created from the right-click menu of a filter, and it will appear as a button in the filters panel. The filter types in Spotfire are determined by the data type of the column, and they can be changed by right-clicking the filter and selecting Filter type. The available filter types are: Item Filter, Range Filter, Radio Button Filter, Check Box Filter, List Box Filter, Slider Filter, Text Filter, Date Filter, Time Filter, and Expression Filter. References: Changing filter type, Filtering Data, Filtering Schemes
B
Explanation:
A toggle filter is not a filter type in Spotfire, but a way to switch between two filter settings for a column. A toggle filter can be created from the right-click menu of a filter, and it will appear as a button in the filters panel. The filter types in Spotfire are determined by the data type of the column, and they can be changed by right-clicking the filter and selecting Filter type. The available filter types are: Item Filter, Range Filter, Radio Button Filter, Check Box Filter, List Box Filter, Slider Filter, Text Filter, Date Filter, Time Filter, and Expression Filter. References: Changing filter type, Filtering Data, Filtering Schemes
Question #19
Which of the following join operators is not available in the Information Designer?
- A . Right Outer join
- B . Unique Join
- C . Left Outer Join
- D . Right Single Match Join
- E . Inner Join
Correct Answer: B
B
Explanation:
A unique join is a type of join that eliminates duplicate rows from the result set. It is not available in the Information Designer, as it is not a standard SQL join operator. The join operators that are available in the Information Designer are: inner join, left outer join, right outer join, full outer join, left single match join, right single match join, and freehand join12. These join operators can be used to define how rows in different tables relate to one another, and can be reused in multiple information links3. References: Creating a Join in Information Designer, Freehand Joins in Information Designer, Overview of Joins in Information Designer
B
Explanation:
A unique join is a type of join that eliminates duplicate rows from the result set. It is not available in the Information Designer, as it is not a standard SQL join operator. The join operators that are available in the Information Designer are: inner join, left outer join, right outer join, full outer join, left single match join, right single match join, and freehand join12. These join operators can be used to define how rows in different tables relate to one another, and can be reused in multiple information links3. References: Creating a Join in Information Designer, Freehand Joins in Information Designer, Overview of Joins in Information Designer
Question #20
What is TIBCO Streaming?
- A . An analytics platform for real-time applications
- B . A component of TIBCO Spotfire Statistics Services
- C . SaaS platform for streaming application development
- D . A combination of Streambase Server, Statistica Studio and LiveView Server
Correct Answer: A
A
Explanation:
TIBCO Streaming is an enterprise-grade, cloud-ready streaming analytics platform for quickly building real-time applications at a fraction of the cost and risk of alternatives1. TIBCO Streaming enables you to analyze, continuously query, and act on IoT and other streaming data at lightning fast speeds2. TIBCO Streaming is an assembly of TIBCO software technologies in a single licensable collection, which includes TIBCO StreamBase, TIBCO LiveView, TIBCO LiveView Web, TIBCO LiveView Desktop, and TIBCO Artifact Management Server3. TIBCO Streaming provides a full-featured Eclipse-based IDE, a visual programming language, and development tools that support a full development cycle4.
References: TIBCO Streaming, TIBCO Streaming Trial – Windows, What is TIBCO Streaming?, TIBCO Streaming Software – Runtime Overview
A
Explanation:
TIBCO Streaming is an enterprise-grade, cloud-ready streaming analytics platform for quickly building real-time applications at a fraction of the cost and risk of alternatives1. TIBCO Streaming enables you to analyze, continuously query, and act on IoT and other streaming data at lightning fast speeds2. TIBCO Streaming is an assembly of TIBCO software technologies in a single licensable collection, which includes TIBCO StreamBase, TIBCO LiveView, TIBCO LiveView Web, TIBCO LiveView Desktop, and TIBCO Artifact Management Server3. TIBCO Streaming provides a full-featured Eclipse-based IDE, a visual programming language, and development tools that support a full development cycle4.
References: TIBCO Streaming, TIBCO Streaming Trial – Windows, What is TIBCO Streaming?, TIBCO Streaming Software – Runtime Overview