Data Analyst Practice Exam 1 Leave a Comment / By LearningTableau / December 27, 2022 Data Analyst Practice Exam 1 Tableau's Data Analyst exam is currently in Beta and will remain in beta until October 6th. The beta version features 59 knowledge-based items and 13 lab questions. We will update this practice exam to correspond to the current version offered by Tableau. To simulate the exam experience, answer the knowledge-based questions without using Tableau or a web browser. Click "Next" to go to the first question. 1. You created a calculated field called Index with the formula INDEX (). You used the field in the chart as shown below. There is confusion among your audience between INDEX and RANK. How would you explain to your audience the difference between RANK and INDEX? INDEX deals with the value of the record. INDEX deals with physical position in the view. RANK returns a value based on the value of an expression None of the above. 2. You connected to a data source which is excel based and “Use Data Interpreter” feature comes up as shown below. It will interpret your file and define where the fields and values of your dataset are. It will automatically create relationships between the datasets. You'll see a "Review the Results" link. Clicking will open a file that explains how your data source was interpreted. It will automatically publish the datasets to a Tableau Server. There is no effect 3. You create a pie chart for customer segments in sample superstore dataset. Part of the requirement is to show the segments with their % contribution to the overall profit. The pie chart should be like the one shown below Drag Segment to label, Profit to label, Change the profit label to a quick table calculation and select Percent of Total Drag Segment to Tooltip, Profit to Tooltip, Change the profit label to a quick table and select Percent of Total. If you create a pie chart it will be automatically labeled by the Measures and Dimensions you used. Drag Segment to label, Profit to Detail, Change the profit label to a quick table calculation and select Percent of Total. None 4. You want to rebuild a workbook using a new data source, you plan to replace the data source. What is the correct order of steps you will undertake to replace the data source given the listed steps below? Open a workbook that connects to the original data source. In the Replace Data Source dialog box, select the Current data source and the replacement data source. Go to the sheet tab and select Data > Replace Data Source. On the Data Source page, drag a table to the canvas to set up the data. Select Data > New Data Source and then connect to the new data source. When finished, click OK. 1, 2, 3, 4, 5, 6 1, 5, 4, 3, 2, 6 1, 5, 3, 2, 4, 6 1, 3, 2, 4, 5, 6 None 5. You have created a chart showing sales by year and category for Superstore dataset as below You would like the chart to show the sales value above each bar, as shown below. How will you accomplish the task? [select all that apply] On the Marks card, Click Label, and then select Show mark labels. On the Marks card, Drag Sales to Detail On the Marks card, Drag Sales to Tooltip On the Marks card, Drag Sales to Label On the Marks card, Drag Sales to Size 6. You want to track the average number of days between the Order Date and the Ship Date by Ship Mode. The visual should give the user flexibility of choosing basing on day, week, month or year. Which function can you use to produce the above results? DATEDIFF (‘day’, [Order Date], [Ship Date], ‘Sunday’) DATEDIFF (‘month’, [Order Date], [Ship Date], ‘Sunday’) DATEDIFF (‘week’, [Order Date], [Ship Date], ‘Sunday’) DATEDIFF (‘Parameter’, [Order Date], [Ship Date], ‘Sunday’) DATEDIFF ([Parameter], [Order Date], [Ship Date], ‘Sunday’) None 7. You want to create the following chart that shows profit by subcategory. The graph should be sorted from the lowest to the highest and color coded from red to green. What sequence of steps will you take configure the chart? Drag Profit to Color, Edit Colors from the context menu, Select the Profit measure, and choose the ascending sort button in the toolbar. Drag Sub-Category to Color, Edit Colors from the context menu, Select the Profit dimension, and choose the ascending sort button in the toolbar. Drag Sub-Category to Color, Edit Colors from the context menu, Right click (control-click on Mac) the Sub-Category dimension in the columns tab, and choose the sort from the drop down menu. Drag Profit to Color, Edit Colors from the context menu, Right click (control-click on Mac) the Profit measure in the columns tab, and choose the sort from the drop down menu. None 8. You have Orders table in Microsoft SQL Server as shown below. You want to create a custom SQL Query to limit the data to only East or West regions. What should you do accomplish this task in Tableau?A. When connected to SQL Server, Right click the Orders table, Select Custom SQL Query and write the following query:SELECT * FROM orders WHERE region = 'East' + region = 'West'B. When collected to SQL Server, Double click New Custom SQL and write the following query:SELECT * FROM orders WHERE region = 'East' or region = 'West'C. When collected to SQL Server, Double click New Custom SQL and write the following query:SELECT * FROM orders WHERE region = 'East' and region = 'West'D. When collected to SQL Server, Double click New Custom SQL and write the following query:SELECT * FROM orders WHERE region = ‘East’, WHERE region = 'West' A B C D None 9. There is a requirement to create a table in Tableau Desktop that shows Total Sales by Region and by Segment as shown below. You have created a flow in Tableau Prep as shown below. What other steps will you add to accomplish the task? Add a Clean Step, Drag Region and Segment to Grouped Fields, Drag Sales to Aggregated Fields, Add Output Step and run it with Output type as .hyper, finally open the .hyper file in Tableau Desktop. Add an Aggregate Step, Drag Sales to Grouped Fields, Drag Region and Segment to Aggregated Fields, Add Output Step and run it with Output type as .hyper, finally open the .hyper file in Tableau Desktop. Add a New Rows Step, Drag Sales to Grouped Fields, Drag Region and Segment to Aggregated Fields, Add Output Step and run it with Output type as .hyper, finally open the .hyper file in Tableau Desktop. Add a Pivot Step, Drag Sales to Grouped Fields, Drag Region and Segment to Aggregated Fields, Add Output Step and run it with Output type as .hyper, finally open the .hyper file in Tableau Desktop. Add an Aggregate Step, Drag Region and Segment to Grouped Fields, Drag Sales to Aggregated Fields, Add Output Step and run it with Output type as .hyper, finally open the .hyper file in Tableau Desktop. None 10. A company that deals with hiring out different types of vehicles has their monthly revenue by vehicle type as shown in the table. They would want the data to be transformed and have a separate column for each vehicle type instead, so that the data will be easier to analyse. What actions can you take in Tableau Prep to accomplish the task? Drag the table that you want to pivot to the Flow Select a Revenue field from the left pane and drag it to the Field to aggregate for new columns section in the Pivoted Fields pane Click the plus icon, and select Add Pivot from the context menu. Select a Vehicle Types from the left pane, and drag it to the Field that will pivot rows to columns section in the Pivoted Fields Connect to your data source. In the Pivoted Fields pane, select Rows to Columns from the drop-down list. In the Pivot Results pane, review the results. 5, 1, 6, 3, 4, 2, 7 5, 1, 3, 6, 4, 7, 2 5, 1, 3, 6, 4, 2, 7 1, 3, 6, 4, 2, 7, 5 3, 6, 4, 2, 7, 5, 1 None 11. You have the following dataset: You want to create the following line chart. How should you create the line chart? Drag Date dimension to columns, Right click Date pill and select exact date, Drag Sales field to rows, Right click Sales pill, pick Quick Table Calculation and Running Total Drag Date dimension to columns, Right click Date pill and select exact date, Drag Sales field to rows, Analytics tab, pick Quick Table Calculation and Running Total Drag Date dimension to columns, Right click Date pill and change to continuous, Drag Sales field to rows, Analytics tab, pick Quick Table Calculation and Running Total Drag Date dimension to columns, Drag Sales field to rows, Right click Sales pill, pick Quick Table Calculation and Running Total None 12. You want to create a map based on the drinks dataset. The map is shown below. You now want to convert the map to a filled map. What will you do to convert the map to filled map? Select Map on the Marks card drop down list. Drag Country to Label. Drag Country to Size. Select Filled Map on the Marks card drop down list. None 13. Which of the following statements is true about Unions in Tableau? The tables must come from the same connection. The tables may come from the different connection. The tables must come from the different connection. You have to specify a where clause to be able to Union the tables None 14. Tableau can connect to various data sources including relational databases. When connecting to most relational datasources what is the most common mandatory information required? Server name and Initial SQL statement Initial SQL statement and Database name Initial SQL Statement and Authentication Server name and Authentication None 15. You have the following dataset: Which formula should you use to find the most recent order date for each customer? MAX ([Order Date]) {FIXED[Customer Name]:[Order Date]} {FIXED[Customer Name]:MAX([Order Date])} {FIXED[Customer Name]:[Order Date] = ‘Last’} {MAX([Order Date]): FIXED[Customer Name]} None 16. You have a line chart the Monthly sales for the Consumer segment for the year 2020. However you want to see the trend based on previous 30 data points from the current value. The line should show the following output What actions will you take to come up with the chart? Right click (control-click on a Mac) anywhere in the graph and pick Moving Average Right click (control-click on a Mac) on the dimension MONTH(Order Date), Quick Table Calculation, Moving Average, Edit Table Calculation, on the pop-up dialogue box change previous value to 30. Right click (control-click on a Mac) anywhere in the graph, Forecast and pick Moving Average Right click (control-click on a Mac) on the measure SUM(Sales), Quick Table Calculation, Moving Average, Edit Table Calculation, on the pop-up dialogue box change previous value to 30. None 17. You want to report year to date (YTD) sales by subcategory.What calculation will you put in the calculated field YTD?A. If [Order Date] <= TODAY() OR DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY()) THEN [Sales] ENDB. If [Order Date] > TODAY() OR DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY()) THEN [Sales] ENDC. If [Order Date] <= TODAY() AND DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY()) THEN [Sales] ENDD. If [Order Date] <= TODAY() AND DATETRUNC( "month", [Order Date]) = DATETRUNC("year", TODAY()) THEN [Sales] END A B C D None 18. You want to create a set that shows top 10 customers. The requirement is that when a new customer enters top 10 the sets should automatically show that. How will you accomplish that using sets? Select the top 10 customers on the view, then hover over one of the dimension members, click on the Venn diagram icon that appears, and choose “Create Set…” Select the top ten customers, on the Marks card select Set. Click on the Customer name, then choose Set from Analytics tab Right click (control-click on a Mac) on the Customer name dimension the hovering over “Create”, and clicking “Set…”. None 19. You created the line chart below that shows sales and another line that is used to predict median sales. What function and chart configuration are used to create the line chart? The MODEL_PERCENTILE function in calculated field and Dual axis chart configuration. The MODEL_QUANTILE function in calculated field and Dual axis chart configuration. The PREDICT_MEDIAN function in calculated field and Dual axis chart configuration. The PREDICT_QUANTILE function in calculated field and Dual axis chart configuration. None 20. Given a line graph showing profit by month of order date, what should you do to show a forecast for the next 3 years? Go on Format menu item, Select Forecast options, change Forecast length to 3 years and click Ok. Go on Worksheet menu item, select Forecast, Right click anywhere in the chart, Select Forecast options, change Forecast length to 3 years and click Ok. Go on Analytics tab, Drag Forecast to the chart, Right click anywhere in the chart, Select Forecast options, change Forecast length to 3 years and click Ok. Go on File menu, New Forecast, Select Forecast options, change Forecast length to 3 years and click Ok. None 21. You are creating new dashboard and you have added two sheets to the dashboard in containers as shown below. What steps were taken to come up with that dashboard? Select Horizontal Drag the container to the dashboard. Under Objects on the Dashboard pane, Add views and objects to the layout container. Select Vertical 4, 5, 3, 2 3, 5, 2, 4 3, 2, 4, 1 3, 1, 2, 4 None 22. You have created a map showing Taxi pick up in Manhattan in New York City as shown below. What extra configurations can you do to change it to a heat map that is shown below? Change to Density on Show Me tab. Select Density from Marks card dropdown, change colour Density Multicolour Light, change Intensity and Opacity. Right click (control-click on a Mac) the map and change to Density map. Go on Map menu item and select Density map. None 23. Your users want to be able to navigate from one view to another view in a dashboard. How should you configure the requirement? Specify how people viewing the dashboard will run the action. Click Dashboard > Actions Select source sheet Specify a name for the action Add Action Specify the Target sheet >Then click OK Go to Sheet 4, 1, 5, 2, 3, 7, 6 2, 5, 7, 4, 3, 1, 6 2, 1, 5, 4, 3, 6, 7 4, 7, 2, 5, 3, 1, 6 None 24. You have been requested to add a company logo on the dashboard that you are creating. How will you add the company logo? On Dashboard tab drag Image to the canvas, choose and image, check Fit Image and Centre Image then Ok. On File menu item select Import Image. On Dashboard menu item select Import Image. Right click (control-click on a Mac) the Dashboard choose an image, check Fit Image and Centre Image then Ok. None 25. You want to do padding to one of the dashboard contents. You want to adjust padding for only one side. What should you do? Untick all sides equal and then adjust the padding. Change size from Fixed to Automatic. Change the dashboard layout to Floating Use Inner Padding only. None 26. Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)] You have the following highlight table showing profit Sub-Category and by Region. You want to create the following heat map. How should you configure the marks for the heat map? Drag Profit to -Label, Double click color, Edit Colors dialog box, in the Palette field select Red-Green Diverging from the drop-down list, Use Full Color Range, Apply and Ok. Drag Profit to Size, Double click color, Edit Colors dialog box, in the Palette field select Red-Green Diverging from the drop-down list, Use Full Color Range, Apply and Ok Drag Profit to Detail, Double click color, Edit Colors dialog box, in the Palette field select Red-Green Diverging from the drop-down list, Use Full Color Range, Apply and Ok Drag Region to Color, and Sub-Category to Color. None 27. You are publishing a data source to tableau online. When will you consider using an extract? When performance is not important. When you do not want it to have scheduled refresh. When publishing data to Tableau Online that it cannot reach directly. Enabling functionality the data source does not inherently support. None of the above None 28. You want to rank your data such that if rows have the same value they share the rank that is assigned to the first instance of the value and no rank values are skipped so that you will see consecutive rank values. Which RANK function should you use? RANK() RANK_MODIFIED() RANK_DENSE() RANK_PERCENTILE() None 29. The table below shows quarterly sales. When LAST() is computed within the Date partition what will be the output for the year 2021 Q2? 6 2 5 0 None 30. You have the following data set: When you calculated the average amount you discover that the result is not including the missing data. You want to calculate the Average Amount. What formula should you use? AVG(ZN([Amount])) ZN(AVG([Amount])) AVG([Amount]) AVG(IFNULL([Amount],0)) Time's upTime is Up!
