Online Access Free Analytics-DA-201 Practice Test

The following table displays the row-level data in a Tableau data source:

A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?

• A.An error
• B.50
• C.15
• D.12

You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.
What should you select?

• A.Extract Refreshes
• B.Connections
• C.New
• D.Connected Workbooks

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

• A.Change the data source to an extract before you publish.
• B.Embed the credentials when you publish the workbook.
• C.Configure the local file permissions to the workbook file, and then publish the workbook.
• D.Remove all the data source filters before you publish.
• E.Export the data to a .csv before you publish.

You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?

• A.From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.
• B.From the context menu of Detail table, select Ignore Actions.
• C.From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
• D.From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?

• A.The hidden object remains in the same position but is grayed out.
• B.The layout automatically adjusts to fill the space.
• C.The object disappears from the item hierarchy.
• D.The object gets deleted from the dashboard.