Halloween Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

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

Viewing page 4 out of 7 pages
Viewing questions 31-40 out of questions
Questions # 31:

in which three formats can you export a worksheet from the Worksheet menu? Choose three

Options:

A.

.png


B.

.html


C.

.xlsx


D.

.txt


E.

.pptx


F.

.csv


Expert Solution
Questions # 32:

A Data Analyst is frequently asked to report on events that have a single row per day but may have missing days in the dataset. The analyst needs to fill the gaps in the data between two dates.

What should the analyst use to do this in Tableau Prep?

Options:

A.

Union


B.

Pivot


C.

New Rows


D.

Aggregate


Expert Solution
Questions # 33:

A Data Analyst has the following chart that shows the cumulative volume of sales from various dates.

Question # 33

The analyst wants the months to appear as shown in the following chart.

Question # 33

What should the analyst do?

Options:

A.

Convert the date to Exact Date


B.

Change the Sort Order


C.

Convert the date to Continuous


D.

Convert the date to Attribute


Expert Solution
Questions # 34:

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:

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.


Expert Solution
Questions # 35:

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:

A.

Export As Version option from the File menu


B.

Copy option from the Worksheet menu


C.

Export option from the Worksheet menu


D.

Copy Image option from the Dashboard menu


E.

Export Image option from the Dashboard menu


Expert Solution
Questions # 36:

A Data Analyst plans to create the following dashboard.

When a user clicks the envelope icon, an email addressed to support@example.com must open.

Which type of action should the analyst use?

Question # 36

Options:

A.

Go to URL


B.

Change Set Values


C.

Filter


D.

Go to Sheet


Expert Solution
Questions # 37:

A Data Analyst has the following view.

Question # 37

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


Expert Solution
Questions # 38:

You create the following worksheet

Question # 38

The Pick Measure parameter contains the following list of values

Question # 38

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


Expert Solution
Questions # 39:

You have a dataset that contains people and the awards they have won.

Question # 39

Which formula should you use to get the number of different types of awards that have been won?

Options:

A.

COVAR({Award})


B.

COUNTD({Award})


C.

COUNTD {(NAME])


D.

MAX {(Award})


E.

INDEX()


Expert Solution
Questions # 40:

You have the following table.

Question # 40

You need each record to alternate between grey and white.

What should you change in the Format Shading pane?

Options:

A.

the row banding size to 1


B.

the column banding size to 1


C.

the row banding size to 3


D.

the column banding size to 3


Expert Solution
Viewing page 4 out of 7 pages
Viewing questions 31-40 out of questions