Winter Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Salesforce Analytics-DA-201 - Salesforce Certified Tableau Data Analyst

Page: 1 / 7
Total 212 questions

You have a data set that contains three columns named Sales, Profit, and Quantity.

You need to build the following scatter plot.

A Data Analyst has the following chart that shows the sum of sales made in different cities.

The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.

What should the analyst do?

A.

Right-click on SUM(Sales) in the Columns and select Include in Tooltip.

B.

Drag Sales to Tooltip on the Marks card and change Aggregation to Average.

C.

Drag Sales to Tooltip on the Marks card and modify the Tooltip text.

D.

Right-click on SUM(Sales) in the Columns and change Aggregation to Average.

You have the following dashboard that contains two visualizations.

You want to show only one visualization at time. Users must be able to switch between visualizations.

What should you me?

A.

A parameter and a calculated filed

B.

Worksheet actions

C.

Show/hide buttons

D.

Dashboard actions

You have the following view.

You want to filter the view lo show only records that have a movie name starting with the word. " The " . You must achieve the goal without writing any formulas.

Which type of filter should you use?

A.

Wildcard

B.

Condition

C.

General

D.

Top

What is a key benefit of using parameter actions in Tableau?

A.

They allow users to turn parameters into filters on the dashboard.

B.

They create a static view of the data without any interactivity.

C.

They restrict user interaction to predefined filters.

D.

They allow users to dynamically change calculated fields based on selections.

A Data Analyst needs to update an existing dashboard. The current dashboard shows financial results data, and users have asked for a comparison of budgets to be added to the dashboard. A new data source has been created that includes both the actual costs and budgets and was published to the corporate Tableau site.

How should the analyst update the existing dashboard?

A.

Create a copy of the existing workbook, open it in Tableau Desktop, and connect to the new data source. Update each sheet, using fields from the new data source.

B.

Edit the existing workbook on the Tableau site and connect to the new data source. Blend the new data source with the existing data source.

C.

Create a new workbook in Tableau Desktop and connect to the new data source. Copy and paste all the tabs from the old workbook into the new one.

D.

Edit the existing workbook on the Tableau site and connect to the new data source. From the Data menu, choose Replace Data Source.

A Data Analyst has a website that displays data in a table format.

The analyst wants to connect to the data of the website by using the least amount of effort.

What should the analyst use to connect to the data?

A.

ODBC connector

B.

Clipboard

C.

Web data connector

D.

CSV file

You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.

You have a worksheet that shows the orders from 2019.

You need to configure the worksheet to show the orders from 2020 without reloading the data.

Which option should you select?

You have the following dataset.

You need to generate the results in the Day field.

How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

A Data Analyst has received a request to provide a dashboard related to employee time logs. The employees are entering their time using mobile devices throughout the day and data is stored in a cloud-based database. The end users would like to receive data on their dashboard in as close to real-time as possible.

How should the analyst best create a data source to meet these requirements?

A.

Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection and disable any firewalls on the database.

B.

Create a connection to the database to retrieve the data using Tableau Bridge. Schedule the refresh of the data extract to 15 minutes.

C.

Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection, ensuring the database firewall has been configured to allow connections from Tableau Cloud.

D.

Create a connection to the database using Tableau Desktop and retrieve an extract of the data. Publish the data source from Tableau Desktop to Tableau Cloud and schedule the refresh of the extract.