1. William has been asked to prepare a consolidated report in tableau containing data of his organization related to financial trends that are part of form of flat files. which of the following file types can he use for achieving his target?
A.
Spatial files
Text files
Excel documents
2. John wants to narrate a story to the end-users using the different related views which upon combining in a sequence will form a complete .which of the following components of Tableau would help him complete the task?
A.Dash board
3. John works as a data analyst for an XYZ company. He has created a view in Tableau for the presentation.His manager has asked him to visualization type of the objects and fields already present in the view. which of the following tableau components will help him acccomplish?
A.Show me
4. In Tableau, which of the following visualization types allows user to understand part-to-whole relationships?
A.Stacked bar chart5. Which of the following sections provide the user wit the options to preview based on the target device?
A.Size,sheets and objects
6. Andrew workers as a data analyst for an organization. One of the teammates is on an emergency leave, and the client has requested information basis. He wants to locate the taks, performance, and queries executed by his college so that he can provide accurate information requested client. which of the following features of Tableau would help him accomplish the task?
A.Performance recorder
7. which of the following are the benefits of visual query Language?
A.
It transforms the user actions into a database query
Makes it possible to visualize the data simultaneously with actions
It allows the user to explore the dataset
8. Max works as a data administrator. Her uses statistical tools,such as SAS and R, to generate files. Which of the following file extension will by using those statistical tools?
A.
.Say
.Sas7bdat
.Rdata
9. Which of the following Tableau features summarizes the information about all the available fields?
A.Metadata
10. In Tableau, which of the following ways can be used to creat an extract?
A.
Select extract radio button on the Data source screeen
Right-click the data source on the Data pane and select the Extract data ...option
Developers can create an extracat using the Tableau Data extract API
11.David works as a data analyst. He wants to view the sales data for the last five financial years of the company to analyze the sales and of the following file types should he use to save the extracated data in a binary file?
A.
.Tde
12. Susan, a data analyst, is working on a project for a superstore having multiple outlets. She has been asked to provide the details of the outline highest sales and profits in the current year. which of the following visualization types will help her accomplish the task?
A.Heat map
13. Daniet is working on a project for a departmental store having four different outlets. He has been asked to plot a graph illustrating the profit chain of outlets during the current finacial year. Which of the following chart types should he opt to accomplish the task?
A.Area
14.Which of the following are the prerequisites for creating a non-cartesian chart type?
A.
No continuous fileds must be used on Rows or columns
Use any field as a measure on size
The mark type must be changed based on the desired chart type
15.Wilson, a business analyst, wants to view the summary of the sales distribution for his company acrosss the subcategories along with the distribution of each subcategory. Which of the followeing visualization types should he opt to accomplish the goal?
A.Box plot
16.Which of the following code snippets will return the domain name from the provided email address?
A.SPLIT('abc@gmail.com,"@",2)
17. Jason has some data related to sales from different regions year wise. He wants calculate the percentage of sales from california over for which he has applied the formula?
A.Tableau calculation cannot mix aggregate and non-aggregate arguments.
18. In Tableau, which of the following acations are performed by a parameter?
A.
Changing size of the bin
Alterting the results of calculation
Passing values to a custom SQL Statement
19. In Tableau, which of the following methods are used for creating a parameter?
A.
USe the drop-down menu next to Dimensions in the data pane,and then select the create paramter option
Use the drop-down menu on the field or set select create, and then click on the parameter ..option
Right-click on an empty area in the data pane and select the Create parameter option
20.Giselle is working as a data manager for a sales corporation. She has to create a detailed report of the sales acativity, where she has to shop sales year for the past years. For this, she needs to perform a few calculations on the data such as runnning total, ,moving average . Which of the following caluculations should she use to accomplish the task?
A.Quick Table calculations
21.Kaelyn, a data analyst, is working on a project for a supermart. She has been asked to provide a detailed sales performance report for each hihglighting the outlet having the highest sale in the previous month. Which of the following Table calculation types will help her perform?
A.Fixed
22.Derek has been provided with a huge dataset of bank transactions for different account holders. He has applied multiple filters to get record certain criteria in Tableau. Now he has been asked to extracat the top ten transacation details from the filtered recrods to be displayed on the following functions should he use to achieve this result?
A.Index()
23.Jennifer works as a data analyst.She has prepared a working hours report for the previous month of all the employees working in the organisation are some missing entries in the report as the worling hours of some employees were not captured by the system. She needs to fill in those based on the nearby values. Which of the following Tableau features should she opt to accomplish the task?
A.Domain padding
24. Which of the following points need to be taken into consideration while working with addressing and partioning?
A.
The user can speicify the sort order
The at the level option in the edit table calculation dialog box allows the user to speicfy a level at which the table calculation
The restrating every option allows the user to maintain the fine-tuning of the oredering.
25. Which of the following levels of formating allows the user to change the fonts, alignments,shading,and numbers and date formats?
A.Field
26. Dennis, a data analyst, has beeen asked to plot a graph displaying the per captia income of the states in a country using the range of a particular the lighter tone indicating the lowest per captia income and the darker shade of the same color signifying the higest per captia income. which of the following color palettes will help him accomplish the task?
A.Sequential
27. In Tableau, which of the following applications are related to the Viz in Tooltip?
A.
It allows the end-user to view parts of the whole within a broader context
It drills down into the details
It can show the diifferent aspects of the data
28. Rondal has some data related to flight bookings. He has prepared two sheets in Tableau, one containing a list of the countries showing the flights landing in that country and another sheet shows a map displaying the average cost of the flight bookings country-wise. He wants to sheet by using the map as a filter for the first sheet in an interactive way. Which of the following approaches of building a dashboard will her the combined sheet in single view?
A.Exploratory
29. Presley has prepared six sheets in Tableau that contain different types of data. He wants to display all of the six sheets on the dashboard a ensure that each of the sheets occupies relatively the same amount of space and appears in a square grid layout. Which of the following should he use to get the desired result?
A.Tiled layout
30. In Tableau, which of the following story components capture the filters and selctions made by the user on a sheet without changing its?
A.Story point
31.In tableau, which of the following methods are utilized for adding a trend line?
A.
From the menu ,select analysis, and afterward, select the trend lines option and show trend lines choice
RIght-click on the empty area in the pane of the view,and the select show trend lines
Drag and drop the trend on the desired trend model
32.watson works in a stock market exchange and provides consultancy to new members who want to be a part of it. He wants to preare a members of his consultancy for the sales of the company for the last five months to analyze the possible future market value of the company people can make investments accordingly. The data shows a rapid change in the rate of value for the given period. Which of the following should he implement to accomplish the task?
A.Logarithmic
33.In Tableau, which of the following applications belong to a cluster group?
A.
A cluster group can be aliased
The individual members of a cluster group can be moved among the groups
The cluster groups can be used in the calculated fields
34.In Tableau, which of the following constraints are responsible for disabling the forecast model?
A.
The view aggregation and the forecast aggregation are not compatible
The view does not use a Table Calculation
The view uses a relational database
35.In Tableau, which of the following keys are responsible for ensuring a good data structure to work with ?
A.
Every measure contained in the source should match the level of detail or possibly be at a higher level of detail
Every record of a source data connection shoud be at a meaningful level of detail
36.A survey was conducted by a private firm regarding the coomon activities performed by people going home to work across the city. Collected the survey data in a one-row-per-respondent format. Due to this, it has become challenging for him to analyze the survey data as questions there is a separate column. Which of the following data strucuture should he consider to reshape the dataset?
A.Tall
37.Harry, a data analyst, is working on a college placement module. He has been provided with the student, course, and the company details as tables. He has been asked to combine the data of all the tables and store the placement details in a single table. Which of the following data he use to combine all the detaiils of different tables in a single table?
A.Star schema
38.Oliver is provided with an Excel sheet containing some unstructured data. The sheet contains the product details for a hundred items and same sheet contains some transactional data. Oliver has been asked to separate both the data sets and import them intpseparate files use . Which of the following Tableau components should he use to accomplish the task?
A.Data interpreter
39.Liam is working on a data source that gives the rank of a sport based on the sum of skills needed for that sport like strength, power,speed number of skills is more, so it takes upt too many columns of the dataset to work-on. Liam wants to convert these column wise data into row be easier for him to work and analyze. Which of the following primary steps of the Tableau prep should he use to perform the task?
A.Pivot
40.Henry is provided with the furniture sales data for the last five months in different data sources. He has been asked to import these and combine them in one to carry out further calculations and analysis. Which of the following steps should he use to combine the different?
A.Union
41.David has collected the data related to the pandemic cases across the world form different data sources and had combined them into one this combined data into tablea, he found are some of the rows in the data set where the same country name is written in different "United States". "USA" . "US". He wants to make the data consistent so that he can perform calculations and analysis on them. which of the should he use to make the data consistent?
A.Clean
42.Charles, who works in the admission division of a college is working a report in Tableau. He needs to provide the details of the students academic scores throughout the semesters. The data source for student details provided to him contains some invalid data like the students in the roll number column, improper email format used, and so forth. He needs to rapidly this invalid data to work with the report. wch of the following features willl help identify such data?
A.Data roles
43.Ryan is provided with a data set that contains the employment data of an industry for the year 2014-2019 for New york city. He wants to distribution and the changnes in various indsutries, and display the result in the form of a abar chart with some stylistic visulalization to represent value. Which of the following types of charts should he use to represent the data in a stylist way
A.Lollipop chart
44.Stell, a data analyst, is provided with the dataset of a college showing the details of the admissions that took place in the last five years. Since asked to plot a graph repsresenting the change in the number of admissions from the year 2015 to 2019 in an interactive way. Which of the following types should she use to show the change between the two data points?
A.Dumbbell
45.Aiden, a deputy finance manager, uses Tableau for managing the sales related data for his organization. He has to conduct a seminar represents sales trends of the company for the last ten years and also show predictive analysis of the values in the coming future. Which of the following visualisation types should he use to represent the desired trend?
A.Line
46.In Tableau, which of the following appliations are related to emeregency?
A.
Layering the visualizations on top of each other and over background images
Floating multiple worksheets on top of each other and still be able to see each layer
Overlaying transparent worksheets onto a dashboard background image
47.In Tableau, which of the following modes allows the users to view the dashboards in fullscreen by hiding all the toolbars,panes and authors.
A.Presentation
48.A customer service center uses Tableau Software to manage the data for its customers. They have used a hostel version of the software of the server configuration and maintenance and also provides an opition to work remotely. As the software is a hosted version so it facilities connect to any data source anywhere. Which of the following Tableau is being used by the organization?
A.Tableau online
49.A fianancial institution has decided to add a new subject, Tableau,to its curriculum. This subject will be including topics such as the different types,views,dashboards,Tableau products that will he used real-life scenarios. Which of the following Tableau products will be best purpose.?
A.Tableau public
50.Which of the following considerations should be kept in mind while publishing a visualization to Tableau Public?
A.
(With Tableau desktop and the proper permisssions, the user can save and open workbooks to and from Tableau public using the selecting options under Tableau public.)
(With the free tableau public client, the user can only save workbooks to and from the web)
(Workbooks saved to Tableau public client the user can contain any number of data source connections , but they must all be extracated and more than 15 million rows of extracted data each)
Comments
Post a Comment