Jul-2024 Download Free Latest Exam TCP-SP Certified Sample Questions
Prepare for your exam certification with our TCP-SP Certified Tibco
NEW QUESTION # 12
What is a "tag" in Spotfire?
- A. Captured knowledge from one or many data sources
- B. Snapshot of the state of an analysis
- C. Annotations attached to marked rows
- D. A text box that can be added on top of visualization
Answer: C
Explanation:
Tags are annotations that can be attached to marked rows in a data table. Each row can only contain a single tag from each tag collection, but the document can contain many tag collections simultaneously. A tag collection is basically a column containing a set of different tags, or annotations. Tags can be used for filtering the data, creating lists, or transferring knowledge from one analysis to another. References: What are Tags?, How to Work with Tags
NEW QUESTION # 13
Which of the following features allows users to create scripts that can perform a calculation and return the results to an analysis?
- A. Save a script in TIBCO Spotfire Analyst client
- B. Add Data Function through TIBCO Spotfire Server
- C. Register a Calculated Column
- D. Use Data Functions
Answer: D
Explanation:
Data functions are scripts that can perform any type of calculation and return the results to an analysis. They can be created using R, Python, or other languages, and they can take input from data tables, columns, or properties, and output data tables, columns, or properties. Data functions can be executed on demand, automatically, or triggered by markings or filters. Data functions can be added to an analysis using the Tools > Register Data Functions menu option in the Spotfire Analyst client, or using the Add Data Function option in the Spotfire Server web interface. References: What are data functions?, Spotfire Data Function Library:
Python and R Scripts for Data Analysis, Linear Regression in R | A Step-by-Step Guide & Examples
NEW QUESTION # 14
Which is the right level of permission to be set for a folder in a library?
- A. Access + Full Control
- B. Access + Modify
- C. Browse + Access
- D. Browse + Modify
Answer: 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
NEW QUESTION # 15
Which three of the following are property control types?
Choose 3 answers
- A. Drop-down lists
- B. Sliders
- C. Hyperlinks
- D. Buttons
- E. List boxes
- F. Bookmarks
Answer: A,B,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 - TIBCO Software4
NEW QUESTION # 16
Where is the smallest rectangle in the treemap visualization positioned?
- A. Top-left corner
- B. Top-right corner
- C. Bottom-right corner
- D. Bottom-left corner
Answer: C
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
NEW QUESTION # 17
Which visualization type is like a cross table which contains color instead of numbers?
- A. Heat map
- B. Parallel coordinate plot
- C. Treemap
- D. Scatter plot
Answer: A
Explanation:
A heat map is a visualization type that is similar to a cross table, but instead of displaying numbers, it displays colors that represent the values in the cells. A heat map can be used to show the distribution of data across two or more categories using a color gradient. A heat map can also be colored by a third column, which can be selected from the Color by drop-down list in the Cross Table Properties dialog. A heat map can have different color schemes applied to different color scheme groupings, which are containers for one or more axis values that share the same color scheme. To learn more about coloring in cross tables and heat maps, see Coloring in Cross Tables and Heat Maps. References: Cross Table Properties - Colors, Coloring in Cross Tables and Heat Maps, Specifying text color and background color for cross table cells, How to set a custom color scheme for a particular column.
NEW QUESTION # 18
Which two are not permission levels for a Spotfire Library folder?
Choose 2 answers
- A. Browse + Access + Modify
- B. Modify
- C. Browse + Access
- D. Access
- E. Browse
Answer: B,D
Explanation:
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
NEW QUESTION # 19
Which custom expression function is used by when you auto-bin a numeric column?
- A. BinBySpecifieLimits()
- B. AutoBinNumeric()
- C. AutoBinByLimitsO
- D. BinByStdDev()
- E. BinByEvenDistributionQ
Answer: 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
NEW QUESTION # 20
What file extension is used when saving a Spotfire analysis?
- A. -DXP
- B. -HTML
- C. XLSX
- D. XML
- E. CSV
Answer: A
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 - TIBCO Software
NEW QUESTION # 21
Which namespace contains classes used to interact with visualizations in a document?
- A. Spotfire.Dxp.Application.AnalyticItems
- B. Spotfire.Dxp.Application.VisualCollection
- C. Spotfire.Dxp.Application.Visualizations
- D. Spotfire.Dxp.Application.Visuals
- E. Spotfire.Dxp.Application.Tools
Answer: D
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
NEW QUESTION # 22
Which statement about details visualization is NOT true?
- A. A details visualization can only be created for a Table visualization
- B. A details visualization is used to drill down into the data in multiple steps
- C. A details visualization can be placed anywhere within the page
- D. A details visualization consists of data which is limited depending on what is marked in one or more visualizations
Answer: A
Explanation:
A details visualization is a special case of a limited visualization, which shows data that depends on what is marked in one or more other visualizations (the master visualizations). A details visualization can be used to drill down into the data in multiple steps. The details visualizationcan be any type of visualization, not only a table, and it can be placed anywhere within the page, just like any other visualization. To create a details visualization, you need to right-click in the master visualization and select Create Details Visualization and the type of visualization to use as details visualization from the pop-up menu. If there are more than one related data table available in your analysis, the Create Details Visualization dialog will appear, where you can select which data table to use for the details visualization. References: What is a Details Visualization?, Details on Create Details Visualization
NEW QUESTION # 23
The Expression shortcut "Cumulative Sum" uses which expression?
- A.
- B.
- C.
- D.
Answer: B
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
NEW QUESTION # 24
Which of the following are types of action controls?
Choose 3 answers
- A. Images
- B. Buttons
- C. Scripts
- D. Links
Answer: B,C,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
NEW QUESTION # 25
Which of the following products does TIBCO Streaming include?
Choose 3 answers
- A. TIBCO StreamBase Server
- B. TIBCO LiveView Server
- C. TIBCO Spotfire Server
- D. TIBCO StreamBase Studio
Answer: A,B,D
Explanation:
TIBCO Streaming is a product family that combines the features of TIBCO StreamBase and TIBCO LiveView (formerly Live Datamart). TIBCO StreamBase Studio is a powerful Eclipse-based IDE that allows developers to create, test, and deploy streaming applications using a graphical language called EventFlow. TIBCO LiveView Server is a component that enables continuous querying and live data visualization for streaming data. TIBCO StreamBase Server is the core engine that executes streaming applications and provides high performance, scalability, and fault tolerance. TIBCO Spotfire Server is not part of TIBCO Streaming, but it can integrate with TIBCO Spotfire Data Streams, which is a Spotfire add-on product that uses the same technology as TIBCO LiveView Server. References: TIBCO Streaming Information, TIBCO Streaming | TIBCO Access Point, Community Product: TIBCO Streaming
NEW QUESTION # 26
What is listed in a Spotfire visualization mod's <code>mod-manifest.json</code> file?
Choose 2 answers
- A. Axisdefinitionsand placement
- B. Visualizations affected by the mod
- C. CORS configuration data
- D. All files included in the mod
Answer: A,D
Explanation:
The <code>mod-manifest.json</code> file is a JSON file that defines the metadata and configuration of a visualization mod. It contains information such as the name, ID, version, description, and author of the mod, as well as the files used by the mod, such as HTML, CSS, JavaScript, and images1. The
<code>mod-manifest.json</code> file also specifies the axis definitions and placement for the mod, which determine how the data columns are mapped to the visualization and how the axis selectors are displayed in the user interface2. Therefore, the options A (All files included in the mod) and D (Axis definitions and placement) are correct. The other options are not listed in the <code>mod-manifest.json</code> file. CORS configuration data is not relevant for visualization mods, as they are not web services that need to handle cross-origin requests3. Visualizations affected by the mod is not a property of the mod itself, but rather a result of how the mod is used in an analysis. References: 1: Mod manifest - TIBCOSoftware1, 2: Axis definitions and placement - TIBCO Software2, 3: Cross-Origin Resource Sharing (CORS) - MDN Web Docs3
NEW QUESTION # 27
Which data relationship algorithm compares two numerical values?
- A. Kruskal-Wallis
- B. Linear regression
- C. Anova
- D. Chi-square
Answer: B
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
NEW QUESTION # 28
Which of the following statements about parallel coordinate plot is NOT true?
- A. Parallel coordinate plots can be limited by one or morefiltering
- B. A parallel coordinate plot maps each row in the data table as a bar
- C. Each column in a parallel coordinate plot uses a different scale
- D. The values in parallel coordinate plot are always normalized
Answer: B
Explanation:
A parallel coordinate plot maps each row in the data table as a line, or profile. Each attribute of a row is represented by a point on the line. This makes parallel coordinate plots similar in appearance to line charts, but the way data is translated into a plot is substantially different1. Therefore, statement B is not true, as it incorrectly describes the parallel coordinate plot as using bars instead of lines. References: What is a Parallel Coordinate Plot?
NEW QUESTION # 29
Which property control type adds a text box where users can type a new value for the linked property?
- A. List box
- B. Input field
- C. Labels
- D. Drop-down list
- E. Slider
Answer: B
Explanation:
An input field is a property control type that adds a text box where users can type a new value for the linked property. An input field can be used with any property type, such as string, integer, real, or date. An input field allows users to enter custom values that are not predefined in a list or a slider. An input field can also be used to filter data based on partial string matching12. References:
* Details on Property Control - TIBCO Software
* Adding a property control to a text area - TIBCO Software
NEW QUESTION # 30
Which one of the following can be inserted into a text area?
- A. Visualizations
- B. Dynamic item
- C. Calculated column
- D. Data table
- E. Custom expression
Answer: B
Explanation:
A text area is a component that can be added to a page in Spotfire to provide text, images, links, buttons, property controls, filters, and dynamic items1. A dynamic item is a small visualization that can display an aggregated view of some data, such as a calculated value, asparkline, an icon, or a bullet graph2. A dynamic item can be inserted into a text area by using the Insert Dynamic Item option in the text area toolbar3. The other options are not valid items that can be inserted into a text area. A calculated column, a data table, and a custom expression are data-related concepts that can be used in Spotfire to create or manipulate data tables and columns4. A visualization is a graphical representation of data that can be added to a page as a separate component5. References: How to Use the Text Area, Dynamic Items - TIBCO Software, How to Insert a Dynamic Item, Data in Analysis - TIBCO Software, Visualizations - TIBCO Software
NEW QUESTION # 31
Which function category contains node navigation functions?
- A. Binning functions
- B. OVER Functions
- C. Statistical Functions
- D. Spatial Functions
Answer: B
Explanation:
Node navigation functions are used to reference specific records or groups of records in a hierarchy or an axis.
They are part of the OVER category of functions, which are used to group data in calculations. Some examples of node navigation functions are All(), Previous(), Next(), Parent(), and Intersect()12. The other function categories do not contain node navigation functions. Statistical functions are used to perform statistical tests and calculations, such as Corr(), TTest(), and Anova()3. Binning functions are used to create bins or groups of values, such as BinByCount(), BinByDateTime(), and BinBySize()4. Spatial functions are used to perform spatial calculations and operations, such as ST_Area(), ST_Contains(), and ST_Distance()5. References: 1: Node navigation - TIBCO Software1, 2: Using Node Navigation in Spotfire The Analytics Corner2, 3: Statistical Functions - TIBCO Software, 4: Binning Functions - TIBCO Software, 5: Spatial Functions - TIBCO Software
NEW QUESTION # 32
Identify the function of the Pivot transformation
- A. Pivots column values to summarize correlated data
- B. Pivots column values into rows of data
- C. Pivots row values into columns of data
- D. Pivots row values to eliminate duplicates
Answer: C
Explanation:
A pivot transformation is one way to transform data from a tall/skinny format to a short/wide format. The data is distributed into columns, usually aggregating the values. This means that multiple values from the original data end up in the same place in the new data table. A pivot transformation requires selecting row identifiers, column titles, values and aggregation methods, and optionally transfer columns and aggregation methods12. The function of the pivot transformation is to pivot row values into columns of data, based on the chosen parameters34. References:
* Pivoting Data - TIBCO Software
* Details on Pivot Data - TIBCO Software
* Transforming Data - TIBCO Software
* Transforming Data - TIBCO Software
NEW QUESTION # 33
Which three of the following are types of input or output parameters for a data function?
Choose 3 answers
- A. Table
- B. Value
- C. Visualization
- D. Column property
- E. Column
- F. Document property
Answer: B,E,F
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?
NEW QUESTION # 34
What is the purpose of importing Spotfire modules in IronPython code?
- A. To create scripts in Spotfire
- B. To write scripts in a specific language
- C. To load more data into the analysis
- D. To use the Spotfire APIs and related objects
Answer: D
Explanation:
Importing Spotfire modules in IronPython code is done to use the Spotfire APIs and related objects. The Spotfire APIs provide access to various features and functionalities of the Spotfire platform, such as data tables, visualizations, filters, markings, document properties, etc. By importing the relevant modules, such as Spotfire.Dxp.Application, Spotfire.Dxp.Data, Spotfire.Dxp.Framework, etc., the IronPython code can manipulate and interact with these objects12. The other options are not the purpose of importing Spotfire modules in IronPython code. To load more data into the analysis,the data import methods can be used, such as AddFile, AddDatabase, AddOdbcDataSource, etc.3 To create scripts in Spotfire, the script editor can be used, which allows writing IronPython code without importing any modules. To write scripts in a specific language, the language option can be selected from the script editor, such as IronPython or R.
References: 1: Using the Spotfire API - TIBCO Software1, 2: IronPython Scripting in TIBCO Spotfire® - TIBCO Software2, 3: Data Import Methods - TIBCO Software3, : Creating and Running Scripts - TIBCO Software
NEW QUESTION # 35
Which language are action control scripts written in?
- A. IronPython
- B. C#
- C. HTML
- D. C++
Answer: A
Explanation:
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
NEW QUESTION # 36
......
Free Tibco TCP-SP Exam 2024 Practice Materials Collection: https://www.pass4leader.com/Tibco/TCP-SP-exam.html
TCP-SP Exam Info and Free Practice Test All-in-One Exam Guide Jul-2024: https://drive.google.com/open?id=1aqwc594-xDi2m7jpHhAf-iq8BUuf8gWP