MOCK EXAM 1

Question 1

1. Which of the following statements about data blend is correct? (Only 1 is true)
2. To create a blend in a workbook with a single data source, bring a field the data source to the sheet—it becomes the primary data source. Switch to the same data source and use a field on the same sheet—it becomes a secondary data source.
3. To create a blend in a workbook with at least two data sources, bring a field from one data source to the sheet—it becomes the primary data source. Switch to the other data source and use a field on the same sheet—it becomes a secondary data source.
4. To create a blend in a workbook with at least two data sources, bring a field from one data source to the sheet—it becomes the primary data source. Take another field from the same data source and put it on the same sheet—it becomes a secondary data source.
5. None of the above

Question 2

2. Which of the following methods of sharing a Tableau dashboard enables data refresh?
   - Publishing to Tableau Server
   - Opening in Tableau Reader
   - Exporting as an image
   - Saving as an extract file

Question 3

3. Which objects can be added to a dashboard? (Select all that apply)
   -An image
   -A text box
   -A web page
   -A blank object

Question 4

5. Student table contains a numeric column called Student_ID which has following values. What will be the output for CONTAINS(STUDENT_id,9) function when used in a calculated field

Question 5

Which of the following is correct about joins and data blending?
A. Data blending simulates a traditional Right join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.

B. Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.

C. Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A bend combines the data and then aggregates. A join aggregates and then combines the data.

D. Data blending simulates a full outer join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data

Question 6

Which of the following statements are true about Interactive elements? (Two options are possible)

A. URL actions is one of the elements that can be added to a dashboard to enhance the interactivity of dashboard reports

B. Tableau Dashboard reports can be made Interactive by enabling a configuration option ENABLE_INERACTIVITY to TRUE at Tableau Server

C. Filter actions is one of the elements that can be added to a dashboard to enhance the interactivity of dashboard reports

D: None of the above

Question 7

Which of the following statement is true about joining tables with fields having different data types?

A. When you want to perform a join between two tables, the data type of the fields you join on can be the same but is not mandatory.

B. When you want to perform a join between two tables, the data type of the fields you join on must be the same. In cases when the data type of the fields are not the same, you have to modify the database column data type in the database before performing the join.

C. When you want to perform a join between two tables, the data type of the fields you join on must be the same. In cases, when the data type of the fields are not the same, you can use custom SQL to change the data type (cast) the field before performing the join.

D.When you want to perform a join between two tables, the data type of the fields you join on does not matter since Tableau automatically casts the types of fields.

Question 8

The tables initially available to union are scoped to the connection you’ve selected. If you want to union more tables that are located outside of the current folder (for Excel, text, JSON, .pdf files) or in a different workbook (for Excel worksheets), select one or both check boxes (mentioning the option to search in Parent or Sub Folders) in the Union dialog box to expand your search.

A. True

B. False

Question 9

Which statement about changes in Default Aggregation is correct?
A. You can set default aggregations for published data sources. The default aggregation is set when the data source is initially published.

B. You cannot set default aggregations for published data sources. The default aggregation is set when the data source is initially published.

C. You can set default aggregations for published data sources. In order to set the default aggregations for published data sources, you can the Site Admin role.

D. You cannot set default aggregations for published data sources. The default aggregation is set when the data source is initially published. In order to change the aggregation level, you have to delete the published data source and republish it after modification.

Question 10

Which of the following statements about Wild card union option is correct?

A. Wild card union option should be used in case you want to combine tables that have a different structure and similar names

B. Wild card union option should be used in case you want to combine tables that are at a different level of detail and have similar names

C. Wild card union option should be used in case you want to combine tables that are in different types of data sources and have similar names

D. Wild card union option should be used in case you want to combine tables that have the same structure and similar names

Question 11

We are using different types of data connection, identify which connection type will allow to create extract? (Select all applicable options)
A. Join
B. Blend
C. Cross database join
D. Union

Question 12

Which of the following statements are true about visualizations in tooltips? (select all that apply)

A. More than one visualization can be embedded within the same tooltip

B. A Visualization in a tooltip must use the same data source as the sheet in which it appears

C. It is Possible to adjust the size of visualization embedded into a tooltip

D. Sheets cannot be embedded into tooltips whereas dashboard can be embedded into a tooltip

Question 13

A good reason to use a wildcard union would be when (Select the correct option)

A. You receive weekly data sources (excel files) that have different structures and the files name contain the word ’Sales’

B.You receive weekly data sources (excel files) that have the same structure and the files name contain the word ’Sales’

C.You want to connect to data, such as daily error reports, that have been split up by date

D. You want to pivot on the dates in one table.

Question 14

Which of the following statements about context filters are not correct? (Select 3 options)

A. Changes in the data model, such as converting dimensions to measures, does not require re-computing of the context filter.

B. 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.

C. Using a single context filter that significantly reduces the size of the data is not recommended rather it is much better applying many context filters.

D.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.

C. Context filters does not affect any query performance improvements when you use the Assume Referential Integrity option in the Data menu of the data source.

D. If your data set is heavily indexed, context filters may not provide performance improvement and may actually cause slower query performance.

Question 15

43. Which method can you use to resolve format mismatches between fields in a broken join?
    A. A union
    B. A join calculation
    C. A pivot
    D. An alias

Question 16

We can use worksheets to create a Viz in Tooltip. Can Stories be used in the tooltip? (True/False)
A.True
B.False

Question 17

Which statement about combining of Sets is correct?
A. To combine two sets, they must be based on the same Measure
B.To combine two sets, they must be based on the same Calculated Field
C.To combine two sets, they must be based on the same Dimension
D.To combine two sets, they must be based on the same Context Filter
E.To combine two sets, they must be based on the same Categorical Filter

Question 18

Which of the following statements about union of tables is true?
To union your data in Tableau data source, the tables should come from different Connections.
To union your data in Tableau data source, the tables must come from the same connection.
To union your data in Tableau data source, the tables may come from same Connection.
None of the Above

Question 19

You are working with Excel worksheets and you want to union all Excel worksheets that end with “2016” in its name outside of the current folder. Mention which of the following statement is true for above mentioned scenario?
It is not possible since searching files outside of the current folder is not possible in UNION
It is not possible since searching files outside of the grand folder is not possible in UNION
It is possible to search files outside of the current folder but searching inside is not possible in UNION
It is possible to search files outside the current folder in UNION

Question 20

Which LOD expressions declare dimensions to omit from the view level of detail And this level of detail expressions are useful for ‘percent of total’ or ‘difference from overall average’ scenarios. They are comparable to such features as Totals and Reference Lines. (Select the correct Option)
A.INCLUDE
B.EXCLUDE
C.FIXED
D.INCLUDED

Question 21

Identify the type of annotation that does not exist in the Tableau:
A. Mark
B. Point
C. Area
D. Region

Question 22

In Trend lines, which statistical measure defines how well the trend fits the data?
A. R - Squared
B. H - Value
C. Z- Squared
D. P - Value

Question 23

Which Statements about cross database joins are true? (Select two)
Cross database join is only available for the same data connection types
Cross database join requires key fields or indexed fields.
Cross database join allows extracts on the combined data.
Cross database join appends rows from different tables.

Question 24

Which of the following is true about forecasting?
Forecasting is only possible when there is at least one measure in the view.
Forecasting is only possible when there are at least two measures in the view.
Forecasting is only possible when there is at most one measure in the view.
Forecasting is not possible when there is any measure in the view.

Question 25

Forecasting is not supported for views based on multidimensional data sources. In addition, the view cannot contain any of the following (select all that apply)
Table calculations
Disaggregated measures
Percent calculations
Grand Totals or Subtotals
Date values with aggregation set to Exact Date
Calculated Fieldsorecasting is not supported for views based on multidimensional data sources. In addition, the view cannot contain any of the following (select all that apply)
Table calculations
Disaggregated measures
Percent calculations
Grand Totals or Subtotals
Date values with aggregation set to Exact Date
Calculated Fields

Question 26

Which statement about default sort order is true?
A. You can set a default sort order for the values within a categorical field so that every time you use the field in the view, the values will be sorted correctly. If you use the same field in the filter, you have to reapply the sort in the filter again.

B. You cannot set a default sort order for the values within a categorical field whereas this feature works only for numerical fields

C. You can set a default sort order for the values within a categorical field so that every time you use the field in the view, the values will be sorted correctly. The default sort order also controls how the field values are listed in a filter in the view.

D. Default sort order works for a field only if you have used it in the view.

Question 27

Which of the following rule related to collation used in cross-database join is incorrect?

A.If a column uses collation standards of the International Components for Unicode (ICU), Tableau uses the collation of the other column.

B. If all columns use collation standards of the ICU, Tableau uses the collation of the column of the right table.

C. If no columns use collation standards of the ICU, Tableau uses a binary collation. A binary collation means the locale of the database and data type of the columns determine how string values should be compared and sorted.

D. If all columns use collation standards of the ICU, Tableau uses the collation of the column of the left table.

Question 28

Which of the following statement is true about LOD Expressions?
A. LOD expressions must use the fields that are in the view.
LOD expressions always result in a measure.
LOD expressions always calculate the result in the same aggregation level as the views level of detail.
LOD expressions can be used to calculate the results at level more aggregated than the views level of detail.

Question 29

4. Select the statements which are correct for dashboard? (Select all that apply)
   A Dashboard helps to explore relationships in data
   Dashboard facilitates to display multiple worksheets at once
   Main purpose of a dashboard is to reduce the size of workbook
   In a dashboard multiple Views can interact with one another

Question 30

5. How to add custom shapes in Tableau ?
   Go to Tableau folder in program files and click on defaults folder and then click Shape folder and copy your custom image.
   Go to Tableau repository in the documents folder and copy the custom image in the Shapes Folder
   On the Marks card, click on the Shapes and then select More shapes and copy your custom image.
   None of the Above

Question 31

6. You are using a relative date filter in your visualization, and it is set as Last 3 months data. Which 3 months data Tableau will show?
   Last three month from the date you created the visualization
   Last three months relative to the anchor date
   Last three months from the day you had created the workbook
   Last three months from the available data in the database

Question 32

12. Context filters are evaluated before other filters in the view and should be used to help force an order of operations, and they are really helpful to improve query performance. (True / False)
    True
    False

Question 33

When you apply a filter, you get many options from the small dropdown menu shown below. Which of the following statement correctly reflects the functionality of filter option All values in context?
Select this option on the context filter to only display values that pass through the context of the view.
When one of the filters in the view is a context filter, select this option on a different filter to only display values that pass through the context filter.
When one of the filters in the view is a context filter, select this option on a context filter to only display values that pass through the context.
None of the above

Question 34

20. Dimension increases the granularity of the view and Measures are always aggregated. (True / False)
    True
    False

Question 35

21. You want to put a logic to find out the top N products on the basis of the profit for Central region. Which of the following statements makes sense related to mentioned scenario?
    Use Table Calculations
    Apply context filter to region
    Add Product Name to context filter
    Add Sales to context filter

Question 36

26. Which of the following is not a table calculation?
    Rank
    Running Sum
    Percent of Total
    Moving Average

Question 37

29. Select the correct annotation type which is referred in the following text:
    _______________ Annotations are not associated with any particular mark, in fact, these annotations are commonly used to call out several marks.
    When you select ___________ annotation, several resize handles and two text handles display.
    Point
    Area
    Mark
    Region

Question 38

Cross-database filters can require multiple queries when values are updated. Enable the Show Apply Button option on filters to let users apply the filter after making their selections. (True/ False)
True
False