Online Access Free Analytics-DA-201 Exam Questions

You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

• A.Right-click a in the chat, select Annotate and then select Mark.
• B.Drag Region to Tooltip on the Marks card
• C.Right-click a bar in the chart select Mark Label and then select Always show.
• D.Edit the aliases for City.

You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link named " Click here to know more! " as shown in the following exhibit.

Correct Answer:

Which series of functions contains only string functions?

• A.PROPER, CEILING, COUNT
• B.MIN, CONTAINS, LEN
• C.LEFT, FIRST, LAST
• D.FIND, DATEADD, NOW

A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.

Which technique should the analyst use as the first step to achieve this in Tableau Prep?

• A.A wildcard search to pivot in the Pivot step
• B.An Aggregate step to reshape the data
• C.A wildcard search for multiple tables in the Input step
• D.A Rows to Columns Pivot step

In which step of Tableau Prep Builder can a Data Analyst create a single table based on a matching pattern of multiple file names?

• A.Join
• B.Union
• C.New Rows
• D.Input