Skip to main content

IS5113 Week 1 Pre Assessment Quiz

 

1. Keith has created some reports in tableau that include charts and row data. He wants to change the color of the headers to crimson and increase the font size of the titles to 19px. Which of the following levels of formatting should he use to make the desired changes?

 A)      .Rich-text




2. Which of the following tableau tables contains the textual and descriptive for various related entities ?

  A).  Dimension

A. 





3. In tableau prep, which of following components is used for indicating the logical flow of the data?

A). Step 




4. Which of the following of the Tableau server allows the user to save the current state of the dashboard based on the selections, filters, and parameter values?

A) View



5. olivia has prepared a line graph which shows the trends of two companies for the sale of mobile phones. She wants to add some additional marks in the chart at points where the sales are at the top. Which of the following types of annotations should she use to achieve this?

A).Area 





6. In Tableau, which of the following data types does not contain records for certain values?

A) .  Sparse



7. Which of the following tableau features is responsible for dynamically showing and hiding the view on a dashboard?

A). Sheet selection


8. Which of the following Tableau products is a data presentation tool that aims to automate the cleaning process to help the user visually shape the data ?

A). Tableau Prep



9. Robert was assigned a project which took around 90 days to complete. He has been asked by his manager to provide the complete timeline details of the activities performed by his team in a visual form. Which of the following chart types should he use to fulfil the task?

A). Gantt 



10. Serra, a data administrator, wants to link tables of data together on row-by-row basis. Which of the following Tableau features will help Serra perform the task?

A). Joins





11. In Tableau, which of the following distinctions defines the lowest level of the table?

A). Cell



12. which of the following types of sets is enumerated for a single dimension based on the conditional specified by the user?

A). Dynamic



13 Clark works as an economic analyst in XYZ company. He has been asked to analyze the overall economic situation of the country. He wants to know the percentage increase or decrease in the GDP growth rate of the current year as compared to the previous year. Which of the following chart types should he use to accomplish this task?

A). Bar-in-bar  




14. Which of the following file extensions is used to save an extract file?

A).  .hyper



15. Thomas has been provided with some related to the properties located in different blocks of a city. He has been asked to provide the average rent of the properties per block. Which of the following level of detail types should he use to the result?

A). Fixed


16. Martin has plotted a bar graph displaying the sales for different products made by a company. He wants to provide some additional details like category, sub-category, name of the product, and the discount offered whenever he clicks or hovers over any bar in the graph. Which of the following tableau features should he use to display the information?

A). Tooltip 



17. In tableau, which of the following panes provides the user with the options to add average reference lines, box plats, trend lines, and forecasts to the visualizations?

A). Analytics   



18. Which of the following features of the Create parameter window interface provides the user with the ability to limit the scope of the permissible values?

A). Allowable values 



19. Which of the following file types can be exported from OLAP databases?

A). Local cube



20. Eliza, an analyst in a cinema production, wants to visualize the performance of the films nominated for the academy awards against the other films released in corresponding year. Which of the following chart types should she use to carry out the task?

A). Scatter plot


21. In tableau, which of the following calculations provides the user with the ability to write a calculated field to be joined in joins?

A). Join



22. Benjamin is having sales data of the previous year. He needs to display the total sales value for each month in the  calendar type view. Which of the following tableau features should he use to obtain the result?

A). Data scaffolding


23. Which of the following features is the heart of tableau?

A). Data visualization


24. Which of the following tableau objects helps the user to adjust the spacing between the dashboard items?

A). Blank


25. Which of the following tableau features provides the user the ability to focus on the marks in a view by selecting the values from the dropdown menu?

A). Data highlighter 


26. Which of the following joins in tableau returns the common records between the joining tables?

A). Inner



27. A five-star hotel provides booking offers to its guests. The manager to the hotel has asked jeff, a financial analyst, to provide a list of guests who had checked-in in the last month and highlight those guests who availed offers while booking online. Which of the following types of calculations should jeff use to accomplish the task?

A). Ad-hoc



28. Which of the following types of values is used to define aggregated values that can be summed, averaged, counted, or have a minimum or maximum?

A). Measure 



29. Which of the following programming languages is commonly used by the analysts for data cleansing and manipulation?

A). Python 


30. Which of the following territories is useful in providing long-term solutions?

A). Field-defined



31. Which of the following tableau components is used by clustering algorithm to determine related data points?

A). Variable 


32 In tableau, which of the following features are the key aspects of the formatting window?

 A). 1. The fields drop-down in the upper-tight corner allows the user to fine-tune formatting at the field level.

2. The icons on the top match the selection options of the format menu.

3. The title of the window provides the user with the context for the formatting selections. 


33. Which of the following file extensions saves XML file that specifies the map services and configuration.

A).  .Tms


34. In tableau, which of the following methods are used for creating table calculations?

A). 1.From the drop-down menu for the active field used as a numeric aggregate in the view, select the quick calculation option

2. create a calculated field and use the table calculation functions for writing custom table calculations

3.  from the drop-down menu for the active field used as a numeric aggregate in the view, select the Add Table calculation option, and then select the calculation type.



35. What is the primary objective of a dashboard?

A). To communicate data to the audience with an intended result


36. Patrick has been provided with the dataset of bank transactions for the last five months. He needs to provide the count of the account holders who have made transactions of the amount greater then $3000 in the last month along with the aggerate value of those transactions. Which of the following functions should he use to accomplish the task?

A) TOTAL()


37. which of the following components of the tableau prep builder provides the user with the options for training and resources?

A). Discover



38. Caroline is working on a tableau project where she to prepare a report showing a list of employee details working as a customer support executive with the latest total count of tickets resolved by them since their data of joining. She needs to fetch ticket count data from the MySQL server which she has to run an SQL query inside Tableau. Which of the following function groups can she use to pass a raw SQL query to the tableau data source?

A). Pass-through 



39. In tableau, which of the following tabs displays different data source connections in the same workbook?

A). Data 


40. Which of the following Tableau objects provides the user with the ability to add controls and objects to the dashboards?

A). Extension



41. Which of the following Tableau actions underlines specific marks and headers in the view?

A). Highlight


42. Allison has appeared for the Tableau test scheduled by her university. She has correctly attempted all the questions but got stuck on one. This question contains an image that gives an overview of the table calculations having a question mark along with one o the curved arrows showing the flow. Which of the following types of results should Allison choose to replace the question mark given in the image with the correct answer?

A)  Aggregated


43. In tableau, which of the following trend models is used to plot a curve line for a dependent variable that increases at a predetermined rate?

A). power


44. Which of the following are the steps of the data analytics cycle?

A). 1. Data preparation

2. Data storytelling

3. Data analysis


45. Which of the following components of tableau defines a collection of dashboards or single views arranged to convey a narrative from the dataset?

A). Story 


46. Catherine works for an e-commerce company. She is asked to provide a chart showing the total sales of electronic items of different brands for the previous year. Which of the following chart types will help her accomplish the task?

A). Stacked bar


47. An organization wants to create a centralized data source for its employees so that they can operate on the data sets collectively on tableau. This approach will also provide more security to the data and ease in collaboration with the other data sources. Which of the following tableau products should be used in this scenario?

A). Tableau server 


48. Dylan is working on the sales dataset of a superstore. He wants to prepare to analyze the monthly sales trends based on the duration of the sales. The duration value indicates a certain state that exists only for a certain period of time and then moves to another state. Which of the following visualization types should he use to accomplish the task?

A). Jump Line


49. Which of the following distribution options allows programmatic interactions with the tableau server?

A). REST API


50. Which of the following file extensions is used to save a tableau prep packaged flow file stores the definition of the steps and changes of a data flow?

A). Tflx 











































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