Analytics-DA-201 by Salesforce Actual Free Exam Q&As

Question 1

You publish a dashboard tut uses an attract. 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?

A. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule. B. From Tableau Server. select Schedules and change the priority of the existing schedule C. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month D. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

A Data Analyst has the following dataset:

The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)

A. IF ENDSWITH([Subject], ' Computer Science ' ) THEN ' Sciences ' ELSE ' Humanities ' END B. IF [Subject] = ' Science ' THEN ' Sciences '
ELSEIF [Subject] = ' English ' THEN ' Humanities '
ELSEIF [Subject] = ' Social Studies ' THEN ' Humanities '
ELSEIF [Subject] = ' Computer Science ' THEN ' Sciences '
END C. CASE [Subject]
WHEN ' Computer Science ' THEN ' Sciences '
WHEN ' English ' THEN ' Humanities '
WHEN ' Social Studies ' THEN ' Humanities '
END D. IIF((CONTAINS([Subject], ' Science ' ) = TRUE), ' Humanities ' , ' Sciences ' )

Discussion 0

Correct Answer: B,C Vote an answer

Question 3

You use a quick table calculation lo calculate the moving average of a measure named Sales.
You need to calculate the moving averages of the last three years.
Which setting should you change in the Table Calculation dialog box? {Click the appropriate Option in the Answer Area)

Discussion 0

Correct Answer:

Question 4

A Data Analyst needs to add a custom color palette to Tableau Desktop for use across multiple workbooks.
The palette must reflect the company ' s branding.
What should the analyst do?

A. Define new shapes for the colors of the custom color palette and copy the shapes to the Shapes folder in My Tableau Repository. B. Select Worksheet Formatting from the Format menu for the worksheet. From the color picker, select Shading, and then select the colors. C. Select the colors from the color picker and click Add to Custom Colors. D. Modify the XML tags in the Preferences.tps file in My Tableau Repository.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?

A. Left B. Full outer C. Union D. Inner E. Left only

Discussion 0

Correct Answer: E Vote an answer

Question 6

A Data Analyst would like to receive the draft results of a colleague ' s Tableau Prep flow to start work on a dashboard before it has been published.
What should the analyst do to accomplish this?

A. Open Tableau Desktop and make a connection to Tableau Prep, then choose the colleague ' s flow that the analyst wants to connect to. B. On the Tableau Desktop Connect page, under To a File, choose " More ... " , and browse for the colleague ' s .tf file on the local file system. C. Have the colleague output the results of the flow to a .hyper file. Create a new workbook in Tableau Cloud, choose Files on the Connect to Data page, and upload the .hyper file from the computer. D. Have the colleague output the results of the flow to a .hyper file. On the Tableau Desktop Connect page, under To a File, choose " More ... " , and browse for the .hyper file on the local file system.

Discussion 0

Correct Answer: D Vote an answer

Question 7

A Data Analyst has the following bar chart.

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

What should the analyst add?

A. A reference band B. A distribution band C. A reference line D. An average line

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. A Tableau Public account B. Administrator permissions on the server C. View permissions on the project D. A Creator site role

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

You want to create the following dashboard that will contain two sheets.

What should you do?

A. Drag both sheets to the dashboard and add a border to each sheet. B. Drag both sheets to the dashboard and add a background lo each sheet. C. Add both sheets lo a horizontal container and add a border to the container. D. Add a border to both sheets and add both sheets to a horizontal object.

Discussion 0

Correct Answer: C Vote an answer

Question 10

You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two

A. Customers of 2020 B. Top N Customers C. Sellers of 2020 D. Top N Products

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Salesforce Certified Tableau Data Analyst - Analytics-DA-201 Exam Practice Test