Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with ValidTests

Exam Analytics-DA-201 Premium Access

View all detail and faqs for the Analytics-DA-201 exam

Go to Exam

Viewing page 4 out of 6 pages

Viewing questions 31-40 out of questions

Questions # 31:

A Data Analyst is creating an annual report in Microsoft Word.

In Tableau Desktop, the analyst built a chart in a worksheet.

The analyst wants to create an image of the chart to add to the annual report.

Which two options should the analyst use to create the image? (Choose two.)

Options:

Export As Version option from the File menu

Copy option from the Worksheet menu

Export option from the Worksheet menu

Copy Image option from the Dashboard menu

Export Image option from the Dashboard menu

Expert Solution

Questions # 32:

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?

Options:

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.

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

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.

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.

Expert Solution

Questions # 33:

You have the following chart that sorts states by the number of products each state has purchased.

Question # 33

Which formula should you use to include a number with the position of each state within each region?

Options:

FIRST ()

INDEX ()

WINDOW_SUM(SUM ([Quantity]))

LOOKUP (SUM ([Quantity]))

Expert Solution

Questions # 34:

You have a dashboard that is configured for desktop browsers.

You want to customize a layout for mobile users.

Which option should you select first? (Click the appropriate Option in the Answer Area.)

Question # 34

Options:

Expert Solution

Questions # 35:

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:

Image

Ask Data

Extension

Download

Navigation

Expert Solution

Questions # 36:

A Data Analyst has the following dashboard.

Question # 36

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.

The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.

What should the analyst do?

Options:

Select Remove Dashboard Item from the drop-down menu of Sales over time.

Select Ignore Actions from the drop-down menu of Sales over time.

Select Deselect from the drop-down menu of Sales over time.

Deselect Use as Filter from drop-down menu of Profits by State

Expert Solution

Questions # 37:

You have the following dataset that contain null values in the Profits field.

Question # 37

You want the data to appear as shown in the following table.

Question # 37

Which two formulas achieve the goal? Choose two.

Options:

ZN ([Profits])

ISNULL ([Profits])

IFNULL [(profits] ,0)

IF [Profits] != null then [Profits] END

Questions # 38:

A Data Analyst is using containers on a dashboard.

How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?

Options:

Use the Layout tab to set the size of each object

Float the objects and manually adjust the size

Adjust the size of each object individually

Use the distribute evenly option

Questions # 39:

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.

Question # 39

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

Options:

A wildcard search for multiple tables in the Input step

An Aggregate step to reshape the data

A Rows to Columns Pivot step

A wildcard search to pivot in the Pivot step

Questions # 40:

You create the following worksheet

Question # 40

The Pick Measure parameter contains the following list of values

Question # 40

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:

Case [Pick Measure]

WHEN 1 then ([Sales])

WHEN 2 then ([Profit])

END

Case AVG([Pick Measure])

WHEN [Sales] then 1

WHEN [Profit] then 2

END

Case [Pick Measure:

WHEN [Sales] then 1

WHEN [Profit] then 2 END

Case STFMEPick Measure])

WHEN " Sales " then ([Sales])

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

Viewing page 4 out of 6 pages

Viewing questions 31-40 out of questions

Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with ValidTests

Exam Analytics-DA-201 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options: