Salesforce Analytics-DA-201 Exam Questions Instant Access

Question 1

SIMULATION

Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.

Create a histogram on the Quantity field by using bin size of 3.

Acheck the steps below in explanation

Answer : A

To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.

Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.

Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.

Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.

Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.

Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.

Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.

Question 2

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?

AWildcard

BCondition

CGeneral

DTop

Answer : A

Question 3

You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

AAugust

BOctober

CDecember

DNovember

Answer : D

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

Question 4

You have the following dataset in Microsoft Excel.

You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

A10

B20

C17

D15

Answer : C

Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:

It removes the first three rows and the last two rows that contain headers and footers.

It splits the merged cells in column A and fills in the missing values with ''Fiction'' or ''Non-Fiction''.

It does not remove or change any other rows or cells.

Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers. Reference: https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm

Based on the Data Interpreter's results and the provided Excel dataset screenshot, the number of rows of data that will be ingested into Tableau as values is 17. The Data Interpreter has identified and excluded headers and footers, and the rows with actual data are considered for analysis.

Question 5

How are the colors configured for the map?

AA sequential color gradient

BA diverging color palette that has five stepped colors

CA diverging color palette that has six stepped colors

DA single color gradient

Answer : B

Question 6

You have a dashboard that contains a parameter named Start Date.

You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.

What should you do?

ACreate a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

BCreate a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.

CCreate a custom SOL query that references Stan Date in the WHERE clause.

DCreate a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter

Answer : A

Question 7

A colleague provides a Data Analyst with access to a folder that has the following files:

Sales.csv

Book1.json

Sales.tds

Export.mdb

Which file can contain information for connecting to an external data source, such as an SQL Server database?

ASales.csv

BSales.tds

CExport.mdb

DBook1.json

Answer : A

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