From the drop-down menu of Sales over time, the analyst selects Ignore Actions.
Several days later, the analyst wants to filter both Sales over time and Detail table by selecting a datapoint on the map.
What should the analyst do?
ASelect Use as Filter from the drop-down menu of Sales over time, and then deselect Use as Filter.
BSelect Ignore Actions from the drop-down menu of Detail table.
CDeselect Use as Filter from the drop-down menu of Profits by state, and then select Use as Filter.
DSelect Filters from the drop-down menu of Sales over time, and then select Enable Auto Update.
The analyst plans to create a dashboard that will be filtered to shown only data that is relevant to a specific Tableau user based on the Tableau_User_Name field.
The analyst needs to create a boolean calculated field to place on the data source filter.
Which formula should the analyst use for the filter?
ACASE SUM ([Profit])>0 -WHEN TRUE THEN “Profitable”ELSE “Unprofitable”END
BCASE [Category]WHEN “Furniture” AND Profit >0 THEN “Profitable Furniture”WHEN “Furniture” AND Profit <0 THEN “Unprofitable Furniture”END
CCASE [Profit]WHEN >0 THEN “Profitable”WHEN <0 THEN “Unprofitable”END
DCASE [Category]WHEN “Furniture” OR “Office Supplies” THEN “Nonelectronics”ELSE [Category]END
A Data Analyst has the following dataset:
Which Level of Detail (LOD) expression should the analyst use to calculate the grand total of all the regions?
A{ FIXED : TOTAL(Sales) }
B{ FIXED : SUM(Sales) }
C{ FIXED [Region]: TOTAL(Sales) }
D{ FIXED [Region]: SUM(Sales) }
Question 6
Create Content
0
Question 7
Create Content
Question 8
Connect to and Transform Data
Question 9
Explore and Analyze Data
Question 10
Publish and Manage Content on Tableau Server and Tableau Cloud
Question 11
Explore and Analyze Data
Question 12
Explore and Analyze Data
Question 13
Explore and Analyze Data
Question 14
Connect to and Transform Data
Question 15
Explore and Analyze Data
Question 16
Connect to and Transform Data
Question 17
Explore and Analyze Data
Question 18
Connect to and Transform Data
Question 19
Explore and Analyze Data
Question 20
Publish and Manage Content on Tableau Server and Tableau Cloud
Question 21
Explore and Analyze Data
Question 22
Create Content
Question 23
Create Content
Question 24
Explore and Analyze Data
Question 25
Publish and Manage Content on Tableau Server and Tableau Cloud
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
A Data Analyst wants to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should the analyst use?
AImage
BHorizontal
CSheet
DWeb page
A Data Analyst wants to create the following dashboard.
How should the analyst lay out the objects on the dashboard?
ADrag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
BAdd both sheets to the dashboard. Set Fit to Fix width.
CDrag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
DDrag a blank object to the dashboard and add both sheets to the dashboard. Set Fir to Entire view.
A Data Analytics has the following dataset that contains null values in the Profits field.
The analyst wants the data to appear as shown in the following table.
Which two formulas achieve this goal? (Choose two.)
AIF [Profits] !=null then [Profits] END
BISNULL ([Profits])
CIFNULL ([Profits],0)
DZN([Profits])
A Data Analyst has a dataset that contains people and the awards they have won.
Which formula should the analyst use to get the number of people who won an award?
ACOUNTD([Name])
BCOUNT([Name])
CATTR([Name])
DCOVAR([Name])
EMAX([Name])
A Data Analyst is the owner of an alert.
The analyst receives an email notification that the alert was suspended.
Where should the analyst go to resume the suspended alert?
AThe Notifications area in Tableau Prep
BThe Data Source page in Tableau Desktop
CThe Shared with Me page on Tableau Cloud or Server
DThe My Content are on Tableau Cloud or Server
A Data Analyst has the following dataset.
The analyst needs to analyze the relationship between math scores and history scores as shown in the following exhibit.
Which three actions should the analyst perform? (Choose three.)
ADrag in a Trend Line from the Analytics Pane.
BAdd History Score and Math Score to the Marks card.
CDrag Student ID to Detail on the Marks card.
DRight-click the y axis, and then select Add Reference Line.
EAdd Math Score to the Rows shelf and History Score to the Columns shelf.
A Data Analyst has the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
A Data Analyst applied a dimension filter to a worksheet with FIXED Level of Detail (LOD) calculations.
How does this filter affect the worksheet?
AThe dimension filter is carried out first before computing the FIXED LOD calculation.
BThe dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation.
CThe dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation.
DThe dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation.
What does a Web Data Connector allow a Data Analyst to do?
AScrape data from an HTML table.
BPublish data to the company website.
CCapture website traffic.
DConnect to an API.
Which function should a Data Analyst use to aggregate total regional sales for a dataset regardless of what is in the view?
AFIXED
BINCLUDE
CEXCLUDE
DSUM
A Data Analyst has the following dataset the contains sales for the month of May.
The analyst plans to create a data extract from the dataset.
The analyst wants to extract data only from stores that have 500 or more in total sales.
What should the analyst do?
ACreate an extract filter on Store Number and select Condition by field Sales.
BCreate an extract filter on Store Number and select Top by field Store Number.
CCreate an extract filter on Store Number and select Top by field Sales.
DCreate an extract filter on Store Number and set the At least value.
A Data Analyst has a sales dataset that contains the following fields.
The analyst needs to analyze the average revenue per item sold in different regions over time.
Which two fields should the analyst measure? (Choose two.)
ARevenue
BCustomer Region
CProduct Name
DQuantity
EOrder Date
What happens within Tableau Prep Builder when a Data Analyst selects Publish as Data Source for a flow output step?
AThe flow output is saved to the database
BThe flow output is saved locally as a Tableau Data Source
CThe flow output is published as a data source on the server
DThe flow is published to the Tableau Server environment.
A Data Analyst has the following line chart that shows the average sales by month.
Which month had the biggest increase in average sales compared to the previous month in 2019?
AAugust
BNovember
CDecember
DOctober
A Data Analyst has the following two tables.
Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?
AOuter join
BLeft join
CInner join
DRight join
A Data Analyst is working with the following dataset.
The analyst is trying to build a box plot showing the distribution of discounts offered to different vendors (something that will look like the following box plot).
Which action does the analyst need to take next to achieve the desired box plot?
AChange AVG(Discount) field aggregation to Count Distinct.
BAdd Invoice Number to the Marks card detail shelf.
CAllow whiskers to extend to the maximum extent of the data.
DCovert AVG(Discount) field to Discrete.
A Data Analyst has the following map that shows profits per state in the United States.
How are the colors configured for the map?
AA diverging color palette that has five stepped colors
BA single color gradient
CA sequential color gradient
DA diverging color palette that has six stepped colors
A Data Analyst has the following dashboard that contains two visualizations.
The analyst wants to show only one visualization at a time. Users must be able to switch between visualizations.
What should the analyst use?
AA parameter and a calculated field
BShow/hide buttons
CWorksheet actions
DFilter actions
A Data Analyst has a data source with row data for service calls and their activity log.
Which calculation allows the analyst to count the calls that have never had a technician assigned to them?
ACOUNT ( IF {INCLUDE [Activity Name]: NOT ‘Assign Technician’ } THEN [Call ID] END )
BSUM( {FIXED [Call ID]: IF MAX( [Activity Name]= ‘Assign Technician’) THEN 0 ELSE 1 END } )
CCOUNT( {FIXED [Call ID]: IF [Activity Name]<> ‘Assign Technician’ THEN 1 ELSE 0 END } )
A Data Analyst has a workbook that connects to a database. The database requires authentication.
The analyst plans to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? (Choose two.)