Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free Salesforce Certified Tableau Data Analyst Practice Questions

Exams4sure Dumps

Exam style questions across every Analytics-DA-201 domain

Last Update 3 days ago
Total Questions : 212

Start with our free Analytics-DA-201 practice questions, carefully crafted to mirror the domains, phrasing, and difficulty of the real Tableau Data Analyst exam. Each Analytics-DA-201 exam question comes with a detailed rationale that explains not just which answer is correct but why the others fall short. That's how concepts stick. Use the free set to benchmark yourself: identify your Salesforce weak domains, see where you're losing marks, and build a focused study plan in minutes.

Analytics-DA-201 PDF

Analytics-DA-201 PDF (Printable)
$54.25
$154.99

Analytics-DA-201 Testing Engine

Analytics-DA-201 PDF (Printable)
$59.5
$169.99

Analytics-DA-201 PDF + Testing Engine

Analytics-DA-201 PDF (Printable)
$74.55
$212.99
Question # 41

You are creating a new dashboard.

You need to add a button to the dashboard that allows users to export the dashboard as an image.

Which type of object should you use?

Options:

A.  

Image

B.  

Ask Data

C.  

Extension

D.  

Download

E.  

Navigation

Discussion 0
Question # 42

You have the following primary data source that contains a dimension named Dorm_Code.

Question # 42

You receive the following secondary data source that contains updated dorm codes.

Question # 42

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.

What should you do?

Options:

A.  

Bring in the secondary data source as a union.

B.  

Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window

C.  

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New

D.  

Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

Discussion 0
Question # 43

You have the following dashboard.

Question # 43

When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Question # 43

Options:

Discussion 0
Question # 44

You have a data source that contains 20 tables.

You want the tables to be organized within the Data pane based on the type of data contained within the tables.

What should you use?

Options:

A.  

Folders

B.  

Hierarchies

C.  

Sets

D.  

Groups

Discussion 0
Question # 45

A Data Analyst loads a dataset from Microsoft Excel. The following is a sample of the data.

Question # 45

FullName contains student names. Some names contain a first name and a last name. Some names contain a first name, a middle name, and a last name.

The analyst needs to divide FullName into three separate fields: one for the first name, one for the middle name, and one for the last name. The solution must minimize effort for the analyst.

What should the analyst do?

Options:

A.  

Use Data Interpreter.

B.  

Use the Custom Split option for the first name and the last name and create a calculated field for the middle name.

C.  

Use the Split option.

D.  

Use the Custom Split option and specify a space as the delimiter.

Discussion 0
Question # 46

A Data Analyst has the following two tables named Orders and Returns.

Question # 46

The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.

Which type of join should the analyst perform in Tableau Prep?

Options:

A.  

Left join

B.  

Unmatched only join

C.  

Inner join

D.  

Full join

Discussion 0
Question # 47

You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.

The following is a sample of the data.

Question # 47

You want to improve the performance of the views by including only animals of a particular type.

To which filter should you add the Type field on the worksheet?

Options:

A.  

Dimension filler

B.  

Table calculation filter

C.  

Context filter

D.  

Measure filter

Discussion 0
Question # 48

You create the following worksheet

Question # 48

The Pick Measure parameter contains the following list of values

Question # 48

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.

Which formula is used in the Selected Measure calculated field lo switch between measures?

Options:

A.  

Case [Pick Measure]

WHEN 1 then ([Sales])

WHEN 2 then ([Profit])

END

B.  

Case AVG([Pick Measure])

WHEN [Sales] then 1

WHEN [Profit] then 2

END

C.  

Case [Pick Measure:

WHEN [Sales] then 1

WHEN [Profit] then 2 END

D.  

Case STFMEPick Measure])

WHEN " Sales " then ([Sales])

WHEN " Profit " then ([Profit]) e::i

Discussion 0
Question # 49

You have a table that contains four columns named Order Date, Country, Sales, and Profit.

You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of

Wednesday.

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

Question # 49

Options:

Discussion 0
Question # 50

A Data Analyst needs to create a dashboard to show sales rep revenue tracking against goals. The revenue data source has already been published to the corporate Tableau site. The goals data is stored in a Microsoft Excel file and must be updated on a regular basis by the sales managers.

How should the analyst set up the data sources to meet these requirements?

Options:

A.  

Log in to the Tableau site and create a new workbook. Upload the Excel file and connect to the published revenue data source.

B.  

Ask the Enterprise Resource Planning (ERP) developers to add new fields to the employee records to store the sales rep goals. Update the existing revenue data source to include the new fields.

C.  

Create a new workbook in Tableau Desktop and connect to both the published revenue data and an extract of the Excel file. Publish the new workbook to the Tableau site.

D.  

Connect to the Excel file using Tableau Desktop and publish the data source to the Tableau site, then schedule it to refresh. Create a new workbook and connect to both the revenue and goals data sources.

Discussion 0

Free Exams Sample Questions