Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: merry71

Free Salesforce Certified Tableau Data Analyst Practice Questions

Question # 11

A Data Analyst has a sales dataset that contains the following fields.

Question # 11

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.

Options:

A.  

Product Name

B.  

Customer Region

C.  

Revenue

D.  

Order Date

E.  

Quantity

Discussion 0
Question # 12

What is required to publish a data source to Tableau Server or Tableau Cloud from Tableau Desktop?

Options:

A.  

A Creator site role

B.  

Administrator permissions on the server

C.  

A Tableau Public account

D.  

View permissions on the project

Discussion 0
Question # 13

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.

Options:

A.  

Change the data source to an extract before you publish.

B.  

Embed the credentials when you publish the workbook.

C.  

Remove all the data source filters before you publish.

D.  

Export the data to a .csv before you publish.

E.  

Configure the local file permissions to the workbook file, and then publish the workbook.

Discussion 0
Question # 14

A Data Analyst has the following worksheet, with Profit data for Categary and Sub-Categury.

Question # 14

The analyst executed the following calculated field at the Total level:

COUNTD( IF ( INCLUDE [Sub-Category]: SUM([Profit] ) < 0 THEN [Category] END )

What is the result?

Options:

A.  

3

B.  

2

C.  

0

D.  

1

Discussion 0
Question # 15

You have the following dataset.

Question # 15

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.)

Question # 15

Options:

Discussion 0
Question # 16

You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.

You need to ensure that the extract also refreshes on the last day of the month at 18:00.

What should you do?

Options:

A.  

From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.

B.  

From Tableau Server, select Schedules, and change the priority of the existing schedule.

C.  

From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.

D.  

From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

Discussion 0
Question # 17

A Data Analyst has the following view.

Question # 17

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

Which type of filter should the analyst use?

Options:

A.  

Top

B.  

General

C.  

Condition

D.  

Wildcard

Discussion 0
Question # 18

You have a workbook that connects to a database. The database requires authentication.

You plan to publish the workbook and schedule a daily refresh of the data.

Which two conditions must be met to schedule the refresh? Choose two.

Options:

A.  

The credentials must be embedded.

B.  

The data source must be stored as a hyper file.

C.  

The data source must use a live connection.

D.  

The data must be extracted.

Discussion 0
Question # 19

You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.

What should you do from Tableau Desktop?

Options:

A.  

From the Data menu select New Data Source

B.  

From the Data menu select Replace Data Source

C.  

From the File menu select Import Workbook

D.  

From the File menu select New

Discussion 0
Question # 20

In a dataset, you have a string field named Name that contains unnecessary semicolons.

Which function should you use to remove the semicolons from the Name field?

Options:

A.  

TRIM

B.  

CONTAINS

C.  

REPLACE

D.  

SPLIT

Discussion 0

Analytics-DA-201 PDF

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

Analytics-DA-201 Testing Engine

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

Analytics-DA-201 PDF + Testing Engine

Analytics-DA-201 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions