Skip to main content

IS5113 FINAL EXAM & LAB


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

A) cartesian product



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

A) Wide


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

A) Lookup()


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

A) Tab


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

A) Polynomial


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

A) Forecasting


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

A) Wide


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

A) Cartesian product


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

A) Surrogate


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

A) 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?

A) 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?

A) Data storytelling



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

A) 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?

A) 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?

A) Extract API



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

A) Data source


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

A) union


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

A) Dimensions


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

A) Incremental refresh


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

A) Tableau Reader


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

A) Discrete


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

A) Tableau Server


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

A) Marimekko


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

A) Dashboard


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

A) Input


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

A) join culling


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

A) Sheet


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

A) 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?

A) REST API


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

A) Wildcard


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

A) Bar chart


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

A) K-means


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

A) Waterfall


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

A) Cross database join


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

A) 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?

A) Level of detail


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

A) .tdsx


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

A) Fixed

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

A) Jittering

Uploading: 96919 of 96919 bytes uploaded.

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

A) Animated visualization


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

A) Gantt chart


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

A) Mark


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

A) F7


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

A) Workbook


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

A) Time series


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

A) 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?

A) Data flow


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

A) 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?

A) 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?

A) Clustering


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

A) Grip


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

A) SPLIT()


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

A) Logical


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

A) Parameter


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

A) Analytics 


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

A) 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?

A) 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?

A) Index()


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

A) Tiled


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

A) 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?

A) 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?

A) Join


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

A) Sheet 


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

A) Measures 


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

A) 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?

A) Tableau prep


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

A) .Kml


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

A) P-value


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

A) F5


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

A) 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?

A) Diverging 


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

A) .twbx




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

A) Delta

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

A) Date part


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

A) Sheet swapping


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

A) Exclude


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

A) Bullet graph


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

A) Three

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

A) 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?

A) Design

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

A) Highlight 


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

A) 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?

A) Distributions 



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

A) Tabcmd 


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

A) table (across) 



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

A) key performance indicators


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

A) 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?

A) 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?

A) 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?

A) Visual Query Language 


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

A) output 


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

A) Linear


93. Which of the following fields contains disparate value?

A) Discrete 


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

A) Combination chart



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

A) 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?

A) Calculation 


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

A) Ad hoc


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

A) Treemap

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

A) Data densification 


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

A) Script 


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

A) Spark Lines


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

A) Shading



RESULT





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


Dashboard

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

Parameter


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


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


F7and 


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


Story

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

.tdsx

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

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

Time series

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

Bar chart

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

Tiled

 Which of the following fields contains disparate value?

Discrete

Which of the following direction options when used on tables increments Index over the entire table?

Table (across)

Which of the following terms in Tableau defines the boundaries within which a Table Calculation can reference other values?

Scope

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

      Input


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

Analytics

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


Design


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


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


Viz in Tooltip


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


Discrete


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


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


Tableau Server


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


Gantt chart


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()


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


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


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

Spark Lines


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


Which of the following functionalities merges the disparate data sources?


Cross database join


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

Exclude


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


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


In Tableau, which of the following chart types displays a change of value from one period to another?

Slope

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


Which of the following set types is a list of values for one or more dimensions?


Fixed


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


Inner


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


Subscribe


Which of the following clustering algorithms is used by Tableau to group similar data points?


K-means


Which of the following file extensions represents a spatial file in Tableau?


.kml


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


Custom territory


Which of the following Windows keyboard shortcuts in Tableau neglects the cache and refreshes the data from its source?


F5


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


Marimekko


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


Data sampling


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

Measures

Which of the following Tableau features is responsible for eliminating the unnecessary joins from the queries?


Join culling


Which of the following techniques of data visualization is used for adding a bit of intentional noise to a visualization?


Jittering


Which of the following features of Tableau is referred to as view and is single data visualization?


Sheet


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


Shading


Which of the following keys is used for joining the fact tables to the related dimension?


Surrogate


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



Tableauand


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

Grip


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


Bullet graph


Which of the following types of Tableau data spreads a measure of a single row over multiple columns?


Wide


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


Spatialand


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


Data source

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

Logical

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


Markand


 Which of the following date types forms up the date hierarchy?


Date part


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


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


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


Window_Sum()


Which of the following functionalities is used to concatenate the data tables?


Unionand

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

Scriptand

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

Key Performance Indicators

Which of the following features of Tableau is initiated by the user and triggers a response?

Actionand

 In Tableau, which of the following features defines the arrangement of the visualizations on a single canvas?

Dashboard

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

Pie chart

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

Joinand

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

Linear

Which of the following Tableau terms indicates that the missing values or records are filled-in?

Data densification

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


Distributions

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

Outputand

 In Tableau, which of the following trend models follows an S-shaped curve?

Polynomialand 

In Tableau, which of the following file extensions is used to save a packaged workbook?


.twbx

Which of the following background uses a reversed sequential color palette?

Black

Which of the following products allows the user to interact with the visualizations, dashboards, and stories created in the Tableau Desktop?


Tableau Reader

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


Incremental refresh

Which of the following types of formatting includes font, alignment, shading, border, and lines?

Sheetand

 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

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

Ctrl

Which of the following charts uses multiple mark types in the same visualization?

Combination chart

Which of the following calculations is slower than the Boolean and numeric calculations?

Stringand

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

Ad hoc

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


Deltaand

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

Waterfalland

 Which of the following keys in Tableau provides an option to autocomplete a word?

Tab

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

Wildcardand

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

Rows, Columns

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

SPLIT()

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

Treemapand

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

Workbookand

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

Tabcmd

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

Table

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

Forecasting

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

Threeand

 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

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

Animated visualization

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


Dimensionsand

 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

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


Cartesian product


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?


Calculationand 






















































































































































































































 

Comments

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand

GE5163 Week8 ( Final Exam ) Quize's

  A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating.      Occurrence = 4      Severity = 8      Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh