Which three normalization options are available when a data table is added and a normalization transformation step is applied? Choose 3 answers
Correct Answer: A,B,C
Normalization is a transformation that adjusts the values in one or more columns of a data table to a common scale, such as between 0 and 1, or with a mean of 0 and a standard deviation of 1. Normalization can be useful for comparing data from different sources, removing outliers, or preparing data for further analysis. Spotfire provides several methods for normalizing data, which are briefly described below1: * Z-score calculation: This method transforms the values in each column by subtracting the mean and dividing by the standard deviation. The resulting values have a mean of 0 and a standard deviation of 1, and are also known as standard scores or z-scores. This method is useful for comparing data that have different units or scales, or for identifying outliers that deviate from the mean by more than a certain number of standard deviations. * Normalize by standard deviation: This method transforms the values in each column by dividing by the standard deviation. The resulting values have a standard deviation of 1, but the mean is not changed. This method is useful for comparing the variability or dispersion of data across columns, or for reducing the effect of outliers on the mean. * Normalize by mean: This method transforms the values in each column by dividing by the mean. The resulting values have a mean of 1, but the standard deviation is not changed. This method is useful for comparing the relative magnitude or proportion of data across columns, or for scaling the data to a common unit. * Normalize by mode: This method transforms the values in each column by dividing by the mode, which is the most frequent value. The resulting values have a mode of 1, but the mean and standard deviation are not changed. This method is useful for comparing the frequency or popularity of data across columns, or for scaling the data to a common unit. * Normalize by median: This method transforms the values in each column by dividing by the median, which is the middle value when the data are sorted. The resulting values have a median of 1, but the mean and standard deviation are not changed. This method is useful for comparing the central tendency or location of data across columns, or for scaling the data to a common unit. To add a normalization transformation to a data table, either when loading a new data table or after the data is already in Spotfire, follow the steps described in the references23. References: * Details on Normalization * Spotfire Tips & Tricks: Normalize/Standardize your data with Spotfire * How to Use the Map Chart
Question 7
Which of the following join operators is not available in the Information Designer?
Correct Answer: B
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 8
Which language are action control scripts written in?
Correct Answer: C
Action control scripts are written in IronPython, which is an implementation of the Python programming language that runs on the .NET Framework. IronPython allows you to access the Spotfire API and create custom actions or tools for your analysis1. You can add action control scripts to a text area and link them to buttons, links, or images2. You can also use JavaScript in HTML mode to add interactivity to your text area3. References: * Using Scripts in the Text Area - TIBCO Software * Scripting - TIBCO Spotfire 7.6 - BEGINNER - Skillsoft * Details on Insert JavaScript and JavaScript Example Scripts - TIBCO Software
Question 9
What are the three types of input parameters used in the scripts? Choose 3 answers
Correct Answer: A,C,D
Input parameters are used to pass values from the analysis to the script. They can be of three types: page or data table in the current analysis, action control, or data type. Page or data table in the current analysis allows the script to access a specific page or data table by name. Action control allows the script to be triggered by a user action, such as clicking a button or selecting a value from a list. Data type allows the script to accept a value of a specific data type, such as text string, integer, date, etc. Visualization is not a type of input parameter, but rather an object that can be accessed by the script using the Document.ActivePageReference.Visuals property. References: Spotfire Analyst Scripting, How to Get Values of the Input Parameters of a Data Function in TIBCO Spotfire® Using IronPython Scripting
Question 10
Which one of the following statements does not refer to TIBCO Enterprise Runtime for R (TERR)?
Correct Answer: D
TIBCO Enterprise Runtime for R (TERR) is an enterprise-grade analytic engine that is fully compatible with the R language and embedded in Spotfire1. It extends the reach of R by allowing users to deploy their R code on a commercially supported and robust platform withoutthe need to rewrite their code2. It also resolves many limitations in R, such as memory management, performance, and scalability3. It is not a proprietary multi-paradigm programming language and numeric computing environment, but rather a reimplementation of the R language using C++4. The statement that describes TERR as such is incorrect and does not refer to TERR. References: Spotfire® Enterprise Runtime for R - TIBCO Software, What is TERR? How to get started with TERR in Spotfire. - TIBCO Software, TIBCO® Enterprise Runtime for R FAQ - TIBCO Software, TIBCO® Enterprise Runtime for R (TERR) - TIBCO Software
