


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Tableau Certification Exam------------Tableau Certification Exam
Typology: Exams
1 / 4
This page cannot be seen from the preview
Don't miss anything!



Which of the following is the best reason to use a live connection instead of an extract - correct answer You need to refresh the data as often as possible. Which file type saves both the connection information (for example the database server address), calculations and groups that you've added, along with an extract of the data? - correct answer .tdsx Which of the following are most likely to reduce the size of an extract - correct answer Check the "Aggregate data to visible dimensions" option. Select the "Hide All Unused Fields" After adding one table to the canvas, what steps should you follow to create a relationship with a second table located on a different database? - correct answer Click the Add link to the right of the Connections heading in the Left pane. Switch between data connections in the Left pane, then drag out the desired table to the canvas and release it. A relationship is most similar to which type of join? - correct answer Outer Which of the following can be used to combine tables at different levels of granularity without duplicating data? - correct answer Blend Relationship Default formatting can be set for which of the following - correct answer Numbers and Dates Which type of chart would be most appropriate for showing the relationship between two measures? - correct answer Scatter Chart You have a bar chart showing monthly revenue by store. What should you do to combine the bars for two of the stores? - correct answer create a group
You have created a polygon map and would like to be able to see all major cities shown on the map. How should you show these? - correct answer You have created a polygon map and would like to be able to see all major cities shown on the map. How should you show these? You have a scatter plot that uses different symbols to represent different product sub-categories. What steps should you take to replace the symbol for Bookcases with a square? - correct answer Click the Shapes mark, then select bookcases and the square shape. Click Okay. In the data pane, select default properties then Shape. In the menu that appears, select bookcases and the square shape. Click Okay. You wish to organize related dimensions into a series of different levels. Which feature should you use? - correct answer Hierarchy Which of the following describe the steps needed to do a manual sort? - correct answer Right-click the pill for the dimension you'd like to sort. Select Sort, then Manual. Use the arrows to manually sort and click okay. Click a header and drag it to the new location. You have a line chart showing total sales by year. How can you change this to a bar chart? - correct answer On the Show Me menu, select horizontal bars. On the Marks card, select Bar from the drop-down list. You have a crosstab view showing the average listing prices for homes by zipcode. What would be the best way to update the view to remove zip-codes with average listing prices about 300,000? - correct answer Add a measure filter on the listing price Your workbook has two different data sources, both sharing a field called "Business Name." How can a single filter be used to filter both data sources on this field? - correct answer Select the "All using this data source" option for the filter
You've created a crosstab view with dimensions and an aggregated measure. What steps should you take to export the crosstab to Excel? - correct answer Select Worksheet > Export > Crosstab to Excel Which of the following will create an axes when it is added to the row or column shelf? - correct answer A continuous measure and a continuous dimension You have a line chart showing the number of motor vehicle accidents per month. You drag the "accident type" dimension to the color measure. How does this change the line chart? - correct answer The number of lines on the chart will increase. The heights of the lines will decrease.