IS5113 FINAL EXAM & LAB

1.Which of the following functionalities joins every record of the dataset with every other record of another dataset?

cartesian product

2. Which of the following types of Tableau data spreads of a single row over multiple coloums?

 Wide

3. In Tableau, which of the following functions provides the use with the ability to reference value in other rows?

 Lookup()

4. Which of the following keys in tableau provides an option to autocomplete a word?

Tab

5. In Tableau, Which of the following tread models follows an S-shapes curve?

Polynomial

6. In Tableau, which of the following models helps in predicting and visualizing the future values?

Forecasting

7. Which of the following types of tableau data spreads a measure of a single row over multiple columns?

Wide

8. Which of the following functionalities joins ever record of the dataset with every other record of another dataset?

Cartesian product

9. Which of the following keys is used for joining the fact tables to the related dimesion?

Surrogate

10. Which of the following features of Tableau defines a collection of record from the data source?

Set

11. Which of the following software provides the user with a platform to view, interpret, and make key decision based on the data while working within the cycle of analytics?

 Tableau

12. Which of the following steps of the analytics cycle provides the user with the ability to create fully interactive dashboards using visualizations and insights?

Data storytelling

13. In Tableau, which of the following techniques defines the geographic regions created by the users?

Custom territory

14.Which of the following components of the Tableau sheet interface provides the user with the basic functionalities such as to add a data source, save, undo, and redo?

Toolbar

15. Which of the following data source connectors provides the user with the ability to remove and join any data sources using programming languages?

 Extract API

16. Which of the following features of Tableau stores information about the connections and all the available fields?

Data source

17. Which of the following functionalities is used to concatenate data tableau?

union

18. Which of the following Tableau feature contains values that determine value that level of at detail at which the measures are aggregated?

Dimensions

19. Which of the following extracts allows the user to add only the new rows of data based on the specified fields?

Incremental refresh3

20. Which of the following products allows the user to interact with the visualizations, dashboards, and created in the tableau Desktop?

Tableau Reader

21. In Tableau, which of the following fields contains distinct and disparate value?

Discrete

22. Which of the following Tableau product is installed on one of more host machines?

Tableau Server

23. Which of the following types uses differing widths of the bars to communicate additional information about the data?

 Marimekko

24. Which of the following of tableau is an arrangement of individual visualization along with of other components on a single canvas?

Dashboard

25. In Tableau, which of the following steps is responsible for starting the flow with from the file, tables, views, or custom SQL?

Input

26. Which of the following tableau features is responsible for eliminating the unnecessary joins from the queries?

join culling

27. Which of the following types of formats includes font, alignment, sharing, border, and lines?

 Sheet

28. Which of the following techniques of Tableau allows the user to create a smaller subset of records for providing rapid feedback?

Data sampling

29. Which of the following distribution options of the Tableau server provides the user with the ability to programmatically export data in different formats?

REST API

30. Which of the following tabs of the filter window allows the user to match the string values?

 Wildcard

31. Which of the following visualization types allows the user to compare the values across different categories?

Bar chart

32. Which of the following clustering algorithms is uses by Tableau to group similar data points?

K-means

33. Which of the following chart types shows how the parts are successively built up to whole?

Waterfall

34. Which of the following functionalities mergers the disparate data sources?

Cross database join

35. Which of the following of Tableau provide the user with the ability to drill down to the details?

viz in Tooltip

36. Which of the following types of calculator allows the user to perform aggregations that results in the value at a row-level?

Level of detail

37. Which of the following file extension specifies a Tableau data source extracted file?

tdsx

38. Which of the following set types is a list of value for one or more dimensions?

Fixed

39. Which of the following techniques of data visualization for adding a bit of intentional to a visualization?

Jittering

40. Which of the following features of Tableau helps in revealing the patterns occurring over time for bringing life to data storytelling?

Animated visualization

41. Which of the following visualization types is used for understanding the of events with a duration?

Gantt chart

42. Which of the following annotations is associated with a specific symbol in the view?

Mark

43. In Tableau, Which of the following keyboard shortcuts is used to exit the presentation mode?

 F7

44. Which of the following levels of formatting allows the user to make global changes?

Workbook

45. Which of the following line charts is the most commonly used and displays the motion of the value over time?

Time series

46. Which of the following Tableau objects defines simple as well as complex geographic areas?

Spatial

47. Which of the following features of Tableau defines a series of logical steps and changes that can be applied to the data from input to output?

Data flow

48. Which of the following keys creates a copy of the field while moving it from one shelf to another?

Ctrl

49. Which of the following features of tableau allows the user to construct sets of various dimensional values that can be used as a primary source?

Data scaffolding

50. Which of the following features of Tableau enables the user to find groups or individual data points based on various selections made by the user?

 Clustering

51. Which of the following components of the Tableau dashboard window allows the objects on the dashboard?

Grip

52. Which of the following functions in Tableau is used to break a string into multiple value?

SPLIT()

53. Which of the following functions groups in Tableau of the decision-making function?

Logical

54. Which of the following features in Tableau is used to store a single or a global value?

Parameter

55. Which of the following tabs in Tableau is used to box and whisker plots?

 Analytics 

56. Which of the following calculations in Tableau can be applied to the fields that are used as a measure in the view?

Quick Table Calculations

57. Which of the following features of the Tableau server allows the user to schedule periodic emails of a screenshot the dashboard?

 Subscribe

58. Which of the following Table calculation functions begins with the value of 1 and keeps increasing by one moving along a given direction within a given scope?

 Index()

59. Which of the following object types is the default for all the objects added to the dashboard?

 Tiled

60. Which of the following background user a reversed sequential color palette?

 Black

61. Which of the following features of tableau allows the user to impart a data story while working with different views, filters , parameters, and images collectively?

 Dashboard

62. In tableau, which of the following steps allows the user to join two branches o the flow based on one or more key fields?

 Join

63. Which of the following features of tableau is referred to as view and is single data visualization?

Sheet 

64. Which of the following sections in tableau is by default used for placing the calculations with a numeric result?

Measures 

65. Which of the following features of tableau is initiated by the user and triggers response?

Action

66. Which of the following tableau add-ons provides the user with the ability to monitor and troubleshoot and present a visual experience for cleaning and shaping data?

Tableau prep

67. Which of the following file extensions represents a spatial file in tableau?

.Kml

68. in Tableau, which of the following statistical measures defines the probability of obtaining the same trend without taking the dimensions into account?

 P-value

69. Which of the following windows keyboard shortcuts in tableau neglects the cache and refreshes the data from its source?

F5

70. Which of the following terms in Tableau defines the boundaries within a table Calculation can reference other value?

Scope 

71. Which of the following palettes assigns a starting as an ending number that provides a full intensity that provides a full intensity for both the color ranges?

 Diverging

72. In Tableau, which of the following file extensions used to save a package workbook?

.twbx

73. Which of the following fields on the Tableau shelf in the view uses a Table Calculation?

Delta

74. Which of the following data types forms up the data hierarchy?

 Date part

75. In Tableau, Which of the following techniques is used to dynamically show or hide the views on a dashboard?

Sheet swapping

76. Which of the following types of level of details calculations is used to omit the defined dimensions from the view?

Exclude

77. Which of the following types of bar charts is used for comparing a measure a goal?

Bullet graph

78. How many entries are allowed by a format string in Tableau?

 Three

79. The multiple mark types are located beside other on which two shelves in Tableau?

Rows, Columns

80. In Tableau, Which of the following modes helps the users in building flows, adding steps, making changes, and interacting with the data?

Design

81. Which of the following actions focuses on specific marks and headers in one or more views?

Highlight 

82. Which of the following calculations is slower than the Boolean numeric calculations?

 String

83. Which of the following features of Tableau helps the user to quickly the confidence intervals, percentages, percentiles, quantiles, and standard deviations of the dataset?

Distributions

84. Which of the following Tableau utilities provides the user with the ability to export data, images, or documents via the command line?

Tabcmd 

85. Which of the following direction options when used on tables increments index over the entire table?

table (across) 

86. Which of the following approaches to building a dashboard indicates the good versus the poor performance?

 key performance indicators

87. Which of the following visualization types displays the part-to-whole relationships?

Pie chart 

88. In Tableau, which of the following functions operates across all the rows in the partition at once and performs the aggregation of the first levels row in the Tableau sheet?

window_sum() 

89. Which of the following keys should the hold down while dragging an object to convert it from tiled to floating or vice versa?

 shift

90. Which of the following query languages provides a standard way of defining queries related to the data based on the arrangement of different fields in the view?

 Visual Query Language 

91. In Tableau, Which of the following steps steps defines the ultimate destination for the cleaned and transformed data?

output 

92. Which of the following trend models displays a steady increase or the value of the variables over the period of time?

Linear

93. Which of the following fields contains disparate value?

Discrete 

94. Which of the following charts user multiple mark types in the same visualization?

 Combination chart

95. Which of the following types of joins is used to return only the matching records form both the tables?

 Inner

96. Which of the following features of Tableau consists of a code that is made up of different functions, operations, and reference to the other fields?

Calculation 

97. Which of the following calculations in Tableau, allows the user to add the calculated fields to the shelves in a single view?

Ad hoc

98.Which of the following visualization types is used for displaying the hierarchical relationships?

Treemap

99. Which of the following Tableau terms incident that the missing values or records are filed-in?

 Data densification 

100. In tableau, which of the following functions allows integration with the R analytics platform or Python?

Script 

101. In Tableau, which of the following visualization types uses multiple small strokes designed for rapid reading and comparison?

Spark Lines

102. Which of the following format options provides the user with the ability for row and column banding?

Shading

103. Which of the following features of Tableau is an arrangement of individual visualizations along with the other components on a single canvas?

Dashboard

104. Which of the following features in Tableau is used to store a single or a global value?

Parameter

105. Which of the following query languages provides a standard way of defining queries related to the data based on the arrangement of different fields in the view?

Visual Query Language

106. In Tableau, which of the following keyboard shortcuts is used to exit the presentation mode?

F7and 

107. Which of the following features of Tableau allows the user to narrate a tale using the interactive snapshots of dashboards and views?

Story

108. Which of the following file extensions specifies a Tableau Data Source extracted file?

.tdsx

109. Which of the following Tableau add-ons provides the user with the ability to monitor and troubleshoot and present a visual experience for cleaning and shaping data?

Tableau Prep

110. Which of the following line charts is the most commonly used and displays the motion of the values over time?

Time series

111. Which of the following visualization types allows the user to compare the values across different categories?

Bar chart

112. In Tableau, which of the following modes helps the users in building flows, adding steps, making changes, and interacting with the data?

Design

113. Which of the following calculations in Tableau can be applied to the fields that are used as a measure in the view?

Quick Table Calculations

114. Which of the following features of Tableau provides the user with the ability to drill down to the details?

Viz in Tooltip

115. In Tableau, which of the following fields contains distinct and disparate values?

Discrete

116. Which of the following keys should the user hold down while dragging an object to convert it from tiled to floating or vice versa?

Shift

117. Which of the following Tableau products is installed on one or more host machines?

Tableau Server

118. Which of the following visualization types is used for understanding the sequence of events with a duration?

Gantt chart

119. Which of the following Table Calculation functions begins with the value of 1 and keeps increasing by one moving along a given direction within a given scope?

Index()

120. Which of the following features of Tableau enables the user to find groups or individual data points based on various selections made by the user?

Clustering

121. Which of the following data source connectors provides the user with the ability to remove and join any data sources using programming languages?

Extract API

122. In Tableau, which of the following visualization types uses multiple small strokes designed for rapid reading and comparison?

Spark Lines

123. Which of the following components of the Tableau Sheet interface provides the user with the basic functionalities such as to add a data source, save, undo, and redo?

Toolbar

124. Which of the following functionalities merges the disparate data sources?

Cross database join

125. Which of the following types of level of detail calculations is used to omit the defined dimensions from the view?

Exclude

126. Which of the following features of Tableau allows the user to construct sets of various dimensional values that can be used as a primary source?

Data scaffolding

127. In Tableau, which of the following statistical measures defines the probability of obtaining the same trend result without taking the dimensions into account?

P-value

128. Which of the following tabs of the Filter window allows the user to match the string values?

Wildcard

129.  The multiple mark types are located beside each other on which two shelves in Tableau?

Rows, Columns

130. Which of the following functions in Tableau is used to break a string into multiple values?

SPLIT()

131. Which of the following visualization types is used for displaying the hierarchical relationships?

Treemap

132.  Which of the following levels of formatting allows the user to make global changes?

Workbook

133.  Which of the following Tableau utilities provides the user with the ability to export data, images, or documents via the command line?

Tabcmd

134.  Which of the following calculations is performed after the initial query in Tableau?

Table

135. In Tableau, which of the following models helps in predicting and visualizing the future values?

Forecasting

136. How many entries are allowed by a format string in Tableau?

Three

 137. Which of the following distribution options of the Tableau Server provides the user with the ability to programmatically export data in different formats?

REST API

138. Which of the following features of Tableau helps in revealing the patterns occurring over time for bringing life to data storytelling?

Animated visualization

139. Which of the following Tableau features contains values that determine the level of detail at which the measures are aggregated?

Dimensions

140.  Which of the following steps of the analytics cycle provides the user with the ability to create fully interactive dashboards using visualizations and insights?

Data storytelling

141. Which of the following functionalities joins every record of the dataset with every other record of another dataset?

Cartesian product

142. Which of the following features of Tableau consists of a code that is made up of different functions, operations, and references to the other fields?

Calculation

143. Which of the following palettes assigns a starting as well as an ending number that provides a full intensity for both the color ranges?

Diverging

144. Which of the following types of calculation allows the user to perform aggregations that result in the value at a row-level?

Level of detail

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG

Leave a Reply

Your email address will not be published. Required fields are marked *