EMT Practice Test

1. Question Content...

---

Question1: The default path for all supporting files, data sources, icons, logs etc is in ______________________

Question2: What are two use cases for a story? Choose two.

Question3: When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Question4: A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

Question5: Which of the following can you add a reference line to?

Question6: We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

Question7: If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Question8: By default, measures placed in a view are aggregated by ______________

Question9: Which of the following are valid Dashboard size options?

Question10: Which of the following is NOT a valid official data source in Tableau Desktop?

Question11: What are three benefits of using an extract as compared to a live connection to a data source? Choose three.

Question12: Which one of the following is a dimension?

Question13: What is created by a calculated field that has a formula of SUM(Sales)/SUM(Profit)?

Question14: Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Question15: Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf.
Which of the following would create a stacked bar chart?

Question16: The calculation [Ship Date] - [Order Date] will return _______________

Question17: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question18: You create the following visualization.

What is the first step to create the visual grouping of the 10 marks shown in blue?

Question19: DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

Question20: How can you set the default properties of a field to Currency?

Question21: Which of the following are valid ways to add Totals to a view?

Question22: Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

Question23: Most viewers scan content starting at the _____________ of a page.

Question24: You have the following visualization.

Which set type is created when you select the Create Set option?

Question25: Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

Question26: Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Question27: Given a map, which of the following fields can be placed on Size,Shape,Detail,Color

Question28: Which statement accurately describes a join?

Question29: What are two benefits of using a live connection to a data source as compared to an extract? Choose two.

Question30: At a minimum, what do you need to create a simple scatter plot?

Question31: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question32: A field that shows average home values for the United States in 2016 is most likely :

Question33: You need to invert the color intensity of a quantitative range. Which option should you use?

Question34: Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Question35: Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

Question36: Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient

Question37: When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Question38: You may create a context filter to:

Question39: A Tableau Support case can be opened in which of the following valid ways?

Question40: You have a scatter plot visualization.
What should you do to configure the visualization as a density map?

Question41: True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

Question42: According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Question43: Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Question44: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question45: In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.

Question46: True or False : Bins can be created on dimensions

Question47: What does it imply if a field has a blue background?

Question48: Which two functionalities can you provide to consumers by adding a parameter to a visualization? Choose two.

Question49: By default, what does Tableau do when you connect to a data source?

Question50: When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Question51: What does the following icon do in Tableau?
Larger image

Question52: You are creating a combined axis chart.
Where should you drag the second measure after dragging the first measure to the Rows shelf?

Question53: How can you add color to marks in the view in Tableau?

Question54: Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Question55: Dimensions containing ____________ and ____________ values cannot be continuous.

Question56: ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Question57: The icon associated with the field that has been grouped is a ______________

Question58: ________________ can only create header. _______________ will create header and axis both.

Question59: The row and column shelves contain ___________________

Question60: True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Question61: When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point

. Which feature helps us fix this issue?

Question62: Which Sub-Category had the least Profit in the Office Supplies category?

Question63: Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?

Question64: Which of the following are valid ways to italicize Tooltip content in Tableau?

Question65: Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

Question66: You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

Question67: A Tableau Data Source File (.tds) contains which of the following?

Question68: Which of the following calculations DO NOT need a quick table calculation?

Question69: Are animations enabled by default in Tableau?

Question70: Which of the following 2 columns CANNOT be deleted in Tableau?

Question71: Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

Question72: What is the one most important thing you should do after creating a Dual-axis chart?

Question73: If you use a percent difference Quick Table Calculation, what value will be the first data value?

Question74: What are three geographic roles that you can assign to a field? Choose three.

Question75: You have the following string value: Sales Data.
Which calculated field produces an output of Sales?

Question76: When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Question77: Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

Question78: Which two types of fields appear blue? Choose two.

Question79: Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Question80: Which of the following would you use to connect to multiple tables in a single data source at once?

Question81: When using a data source that has relationships, how can you add a join between two or more tables?

Question82: _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

Question83: You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

Question84: When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Question85: Which mark type is used in a highlight table?

Question86: _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Question87: You can use the __________________ in Tableau to clean / organise your data.

Question88: What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Question89: Which of the following is a valid way to create Sets in Tableau?

Question90: True or False: The Highlighting action can be disabled for the entire workbook.

Question91: For a relative date filter, the default anchor is _________________

Question92: Which of the following are True for Measure Names?

Question93: What will the following function return?
LEFT("Tableau", 3)

Question94: Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Question95: Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Question96: How can you format an axis as Bold in Tableau?

Question97: When creating a date filter in Tableau, to what does Anchor refer?

Question98: You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32).
What should you include in the calculation?

Question99: Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

Question100: Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

Question101: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question102: Which of the following are stored in a .tds file? Choose 3.

Question103: True or False: When relating tables, the fields that define the relationships must have the same data type.

Question104: What are two correct methods for creating a visual group? Choose two.

Question105: You need to access options to change a dimension's color palette.
In addition to the Marks card, what else can you use?

Question106: How does Tableau know at which level to aggregate values?

Question107: Which of the following are required to create a trend line?

Question108: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question109: In which of the following scenarios would having a live connection be more beneficial than using an extract?

Question110: What is a Tableau story point?

Question111: Which aggregation is available without requiring a table calculation or calculated field?

Question112: True or False: It is possible to change the Geographic Role of a dimension

Question113:
You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Question114: Which of the following are compelling reasons to use a Stacked Bar Chart?

Question115: True or False: A reference line cannot be added from the Analytics Pane

Question116: By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Question117: Which two options can you use to change the device layout of a dashboard? Choose two.

Question118: Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Question119: In order to avoid any confusions, what should you do after creating a Dual-axis chart?

Question120: When creating an extract, what are three options for specifying how much data to extract? Choose three.

Question121: To connect Tableau to a CSV data source what type of connection should you use?

Question122: You need to display the complete list of potential data connections when you connect to a server. What action should you perform?

Question123: A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Question124: You just added this field to the Columns shelf.

What will this create?

Question125: To use a quick table calculation, which of the following programming languages do you need to know?

Question126: Which two types of aggregations can be applied to string fields? Choose two.

Question127:

Question128: To display data that has both negative and positive quantitative values, Tableau Desktop will display marks by using__________________as the default.

Question129: Which of the following describes the best way to change the formatting at a workbook level?

Question130: Which of the following can you use to create a Histogram?

Question131: True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.

Question132: Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

Question133: You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf.
How can you make a stacked bar chart?