Practice Exam Missed Questions Flashcards
Which of the following is valid about Published Data Source when you sign in Tableau Server Site?
You can see all data on Tableau Server Site which you have access
All server content is published, accessed, and managed on a per-site basis. Each site has its own URL and its own set of users (although each server user can be added to multiple sites). Each site’s content (projects, workbooks, and data sources) is completely segregated from content on other sites.
You need to open *twb file on your Tableau desktop. Choose the appropriate section to open it.
Since *twb is a file, you need to look for the answer in the “To a File“ section. There is “twb file“ type listed so you need to choose the “more…“ option to open it.
You are given a task to combine these two data sources but keep duplicate records. Choose the appropriate custom SQL statement.
Both columns have Event ID and State Column but one has a Sales Column and the other has a value column
UNION ALL combines the data by performing a union and includes any duplicate records. In this example, records in the Data1 table are unioned with the records in the Data2 table, any duplicate records are included, and all fields are included.
SELECT * FROM [Data1]
UNIONALLSELECT * FROM [Data2]
Ad- hoc calculations
Ad-hoc calculations are valid for creating trend lines, forecasts, reference lines, bands, and distributions.
Can’t be used with groups, sets, hierarchies, parameters, rows, columns, marks or page shelves.
Only one ad-hoc calculation can be open at a time.
You have a Profit.tsv file. Which section do you choose to open it in Tableau Prep Builder?
Text file
TSV stands for “Tab Separated Values,“ and one of the text files (*.txt, *.csv, *.tab, *.tsv).
What best describes how this FIXED expression works in a view?
Calculates the total sum of sales
{FIXED : SUM([Sales])} – This calculation gives total sales since no dimension is specified.
Choose the correct answer:
RANK(_______)
A. SUM([Sales]) or B. (sales)
SUM([Sales])
All fields must be aggregate or constant when using table calculation functions.
You want a 3 axis line chart with sales, profit, and quantity. All with date on the x axis
Drag Date to the Columns, Measure Values to the Rows, and Measure Names to the Colors.
A new box will appear with measure values and you can add sales, profit, and quantity there.
Examples of LOD expressions
{SUM([Sales])}
{INCLUDE [Category] : AVG([Profit])}
{EXCLUDE [Date] : MAX([Revenue])}
{FIXED : SUM([Sales])}
If your data source in the data pane has a quare logo with a flower looking thing in it
The workbook is connected to a data source that has been published to Tableau Server.
In Tableau Server, what is the minimum frequency at which you can schedule a data extract refresh?
Every hour
Types of actions you can set in Tableau
Filter, Highlight, Go to URL, Go to Sheet, Change Parameter, Change set Values
If Tableau Prep Builder samples the data in the input step, which of the following occurs?
The sampled data is used in the flow, but the entire data set is used to create the output.
Twitter Column has data @chris_cortes
but you need the expected result to be Chris with the first name being capital
PROPER(SPLIT(MID([twitter],2), “_”, 1 ))
Discrete fields give Categorical Palettes. Continuous fields give Quantitative Palettes
Discrete fields give Categorical Palettes. Continuous fields give Quantitative Palettes
