Pass the Tibco TIBCO Certified Professional TCP-SP Questions and answers with CertsForce

According to the official documentation, there are four levels of permissions that can be set for a folder in the library: Access, Browse + Access, Browse + Access + Modify, and Full Control12. Therefore, the options A (Access) and C (Modify) are not valid permission levels by themselves. Access only allows the user to execute information links in the folder, but not browse or open the contents1. Modify is not a standalone permission level, but a part of Browse + Access + Modify, which allows the user to modify and save items in the folder1. References: 1: Setting Folder Permissions - TIBCO Software1, 2: Permissions - TIBCO Software2

 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

Information links are predefined database queries, specifying the columns to be loaded into the internal data engine of TIBCO Spotfire, and any filters needed to reduce the size of the data table prior to visualization1. Information links are created and saved in thelibrary on the Spotfire Server, where they can be accessed by other users2. Information links are not stored on the local machine, as they are not files or settings, but rather structured requests for data2. References:

Information Links - TIBCO Software

Creating an Information Link - TIBCO Software

Information Links - TIBCO Software

Changes in Spotfire version 10: How to add an Information link to an existing analysis

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

To create a new filtering scheme, you need to access the File > Document Properties dialog box. From there, you can go to the Filtering Schemes tab and click New… to name and create a new filtering scheme. You can also change the filtering scheme for a certain page from the menu at the top of the Filters panel12. References:

Filtering Schemes

Details on Filtering Scheme Properties

Spotfire Filtering issues

Changing the filtering scheme to use on a page

 TERR functions are a subset of the built-in expression functions in Spotfire that invoke the TERR engine for advanced statistical analysis. You can find them in the Function list of the Custom Expressions or Insert Calculated Column dialog box, under the category Statistical functions. TERR functions have the prefix TERR_ or TERRAggregation_ followed by the Spotfire data type of the output. For example, TERR_Real, TERRAggregation_String, etc. You can also register your own TERR scripts as expression functions and assign them to a custom category. References: Built-In TERR Expression Functions in Spotfire, Registering the TERR Script as an Expression Function

 This will insert the value of the property as a text string in the expression. The other options are either invalid syntax or refer to data table or column properties, which are different from document properties. References: Properties in Expressions, Details on Document Properties

Comparison circles are a way to display whether or not the mean values for various categories (boxes in the box plot) are significantly different from each other. The circles are drawn with their centers at the mean value for the box to which they correspond. If the circles for different groups do not overlap, the means of the two groups are generally significantly different. If the circles have a large overlap, the means are not significantly different. References: What are Comparison Circles? - TIBCO Software

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

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