Download Tableau Certification Prep Tableau Certification Prep and more Exams Advanced Education in PDF only on Docsity!
Tableau Certification Prep
Tableau Certification Prep
T/F Dates and times are automatically placed in the dimension area of the data pane? (for relational data sources) - correct answer True ________ dates represent the chronological progression of time. - correct answer Continuous _______ dates show the data organized by date units. - correct answer Discrete _____ dates show up as blue pills. - correct answer Discrete _____ dates show up as green pills. - correct answer Continuous Data source files contain: - correct answer 1. A single connection or multiple connections
- Modified data attributes
- Calculated fields, sets, and/or parameters T/F Data source files are reusable? - correct answer True. Data attributes can be changed using the __________. - correct answer Metadata grid _______ is a relationship of two tables in a single database using a common field. - correct answer A Join ______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join. - correct answer A Blend
______ is a relationship across two different databases or text tables based on a common field. - correct answer A cross database join _____ appends rows fro different tables with the same column names. - correct answer A Union Use a ________ when you want to analyze data that exists in 2 separate tables within the same database - correct answer Join Use a ________ when your data exits in different data sources. - correct answer Blend or cross database join Full Outer Joins return ______ records from each table and displays _____ where there is no match. - correct answer All Nulls When using multiple data sources, the primary connection shows up as: - correct answer Blue T/F: The Average function in Tableau aggregates NULL values as 0's. - correct answer False. Null values are ignored. The Data Interpreter helps prepare ______ data for analysis - correct answer Excel T/F Context Filters are executed after data source filters. - correct answer True T/F An aggregated calculation can be multiplied by a non-aggregated constant - correct answer True T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field. - correct answer False
T/F Sets are fields created on existing dimensions. - correct answer True T/F Sets cannot be used as a filter. - correct answer False, sets can be used a filter. T/F Combined sets allow you to compare multiple sets to one another to determine intersections or differences across the sets. - correct answer True T/F Context filters improve performance when the data source is large. - correct answer True T/F Context filters do not use temp tables to reduce query size. - correct answer False, context filters use temp tables to reduce query size T/F Calculated fields are processed locally by tableau. - correct answer False, calculated fields are processed in the database T/F Table calculations are performed locally by tableau. - correct answer True T/F Comments in Tableau are denoted using - - correct answer False, syntax comments are denoted by // in tableau T/F In the formula editor, field names are represented with [Purple Text]. - correct answer False, field names appear in [orange text] and parameters appear in [purple text] T/F You will need to use an aggregated when data from multiple dimensions doesn't a consistent level of detail. - correct answer True T/F When applying ATTR([]) to a field null values are ignored. - correct answer True T/F when using Min() or MAX() if either argument is null then the function returns null. - correct answer True
T/F LOD calcs use data source level queries. - correct answer True T/F EXCLUDE AND INCLUDE functions behave relative to the view's current level of detail. - correct answer True T/F The include function calculates the results at a level greater than the lod present in the visualization. - correct answer False - the include function calculates the results at a level lower than the LOD present in the Viz. T/F The EXCLUDE function calculates the results at a level greater than the LOD present in the Viz. - correct answer True T/F the default behavior for a table calc is to apply the calculation across the row, giving the row a grand total of 100%. - correct answer True T/F A moving average smooths short-term fluctuations in data to display clear long- term trends - correct answer True T/F Parameters are specific to a data source or worksheet. - correct answer False - parameters are not data source or worksheets specific T/F ATTR() is an aggregate function. - correct answer True A __________ _______________ _________________ is a user-defined data subset from a data source. - correct answer tableau data extract When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract. - correct answer incremental What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis? - correct answer bar in bar A ________ graph is a variation of a bar chart. - correct answer bullet
T/F To add a trend line to a view, only the x-axis has to be a numeric value (also includes date/time fields) - correct answer False. Both axes must contain a field that can be interpreted as a number. T/F there are 3 different model types for trend lines. - correct answer False - there are 4 models
- Linear
- Log
- Exponent
- Poly/degree T/F The is only one way to view summary data for a trend line. - correct answer False - There a 3 ways to view the data
- Hovering over the trend line to show the tool tip
- Right clicking on the trend line > selecting describe trend line
- Analysis menu > describe trend line model Average reference lines can be applied to the ____, each _____, or each ______. - correct answer Table, pane, cell T/F there is only one option for adding a forecast - correct answer True T/F You cannot forecast time series data in tableau. - correct answer False - you can forecast time series data by using an exponential smoothing model. T/F Forecasting is not supported for multidimensional data sources. - correct answer True Before you begin building a dashboard you should create a ______. - correct answer Sketch What is the 5 second rule? - correct answer In 5 seconds or less, you can clearly understand the primary data story on the dashboard
Filters, ______, and ________ all allow for user input options. - correct answer Actions, parameters T/F Adding instructions to your dashboard enhances and guides the user experience. - correct answer True T/F Filters can be modified to appear like an instruction. - correct answer True T/F A Reference Band cannot be based on two fixed points. - correct answer False T/F A Reference Distribution plot cannot be along a continuous axis. - correct answer False Which of the following is not a Trend Line model
- Linear
- Exponential
- Binomial
- Log - correct answer Binomial is not a trend line model Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? - correct answer Yes by using a web page object T/F The Highlighting action can be disabled for the entire workbook. - correct answer True - From the toolbar the Highlighting action can be disabled for the entire workbook. T/F 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. - correct answer False - A sheet can be used within a story directly.
(T/F) Tableau can create worksheet-specific filters - correct answer True What does the blox in a box plot represent? - correct answer The range of the middle half of the data points A pareto chart is a type of chart - correct answer containing both bars and a line graph What is an alternative to a Tile dashboard layout? - correct answer Floating You want to email a packaged workbook containing a Tableau Dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email? - correct answer Tableau Reader A visual best practice is that if you are using a color gradient to represent a continuous variable which can be negative or positive, you should use a - correct answer two color range The interquartile range is the difference between the _______ quartile and the _________ quartile. - correct answer 3rd and 1st The 50th percentile is also called - correct answer the median, or 2nd quartile The 25th percentile is also called - correct answer the first quartile ___________ is a technique in Tableau which will identify marks with similar characteristics - correct answer Clustering What is used to assess trendline significance? - correct answer p-value
You may create a context filter to - correct answer Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance. Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter. You can think of context filters as an _____________ filter - correct answer An independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter. You should not use context filters when - correct answer 1. your data set is heavily indexed
- using the Include joined tables only when referenced option in the Tables dialog box To improve performance of context filters: - correct answer 1. Using a single context filter that significantly reduces the size of the data set is much better than applying many context filters. In fact, if a filter does not reduce the size of the data set by one-tenth or more, it is actually worse to add it to the context because of the performance cost of computing the context.
- Complete all of your data modeling before creating a context. Changes in the data model, such as converting dimensions to measures, require recomputing the context.
- Set the necessary filters for the context and create the context before adding fields to other shelves. Doing this work first makes the queries that are run when you drop fields on other shelves much faster.
- If you want to set a context filter on a date you can use a continuous date. However, using date bins like YEAR(date) or context filters on discrete dates are very effective. If you see a duplicate data after doing a join you can - correct answer Change the join condition or do a data blend (in some situations)
A continuous pill on the color shelf will create a - correct answer gradient A discrete pill on the color shelf will create a - correct answer color palette, where each unique value is assigned a color For maps, a measure on color defaults to a __________ map - correct answer filled For maps, a dimension on color defaults to a _________map - correct answer symbol Filtering on a discrete pill - correct answer brings up options related to the specific list of values for that pill Filtering on a continuous measure pill - correct answer asks first if we want to filter at the row-level or aggregate level, then brings up options of continuous ranges A crossdatabase join - correct answer joins the data at the row level Data blending sends _______ queries to ________ sources and aggregates the results to a common level back to Tableau - correct answer separate, separate A bar chart is great for comparison and ranking because it - correct answer encodes quantitative values as length on the same baseline, making it extremely easy to compare values The benefit to running a correlation analysis is that - correct answer it's a great place to start identifying relationships between measures. Be mindful that a correlation doesn't guarantee a relationship The benefit to running a distribution analysis is that it - correct answer shows how your quantitative values are distributed across their full quantitative range ________ charts are a good alternative to pie charts in part to whole analysis - correct answer bar
Maps are often best paired with - correct answer another chart that details what the map displays A rule of thumb is to put the most important data on the _________ axis and less important data on _____________ - correct answer x or y axis color, size, or shape Bullet chart definition - correct answer A chart that combines a bar chart with reference lines to create a great visual comparison between actual and target numbers Limit the number of colors and shapes in one view to ______ so that you can distinguish them and see important patterns - correct answer 7- If you have multiple filters, try to group them together with a - correct answer layout container Benefits of highlighting on dashboards - correct answer 1. lets you quickly show relationships between values in a specific area or category - even across multiple views
- preserves the context of the rest of the points Dashboard filters are great ways to enable _______ and _________ - correct answer multi-level data exploration user driven data analysis The best way data format for Tableau analysis is that it is: - correct answer 1. as granular as possible rather than aggregated (i.e. daily data over monthly)
- organized like a database table (rather than a column-oriented table such as crosstab)
- stripped of extraneous information (anything that's not the data and its headers)
A combined (or shared) axis chart) - correct answer uses multiple measures on the same axis and highlights the relationship between measures Crosstabs are useful for - correct answer the most common representations of data, and are useful for viewing numeric values Highlight Tables - correct answer color encoded crosstabs. Call attention to very high or low data values and are useful for showing detailed values in text, while emphasizing outliers and patters in color
