Salesforce Analytics-DA-201 Exam Practice Test Instant Access

Question 1

A Data Analyst has created a Tableau Prep flow that is ready to be used. The output will be used by a colleague to build a dashboard on Tableau Cloud or Tableau Server.

Where should the analyst output the data to?

ACRM Analytics

BSalesforce Data Cloud

CA Tableau data extract file

DA published data source

Answer : D

Question 2

You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

A(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))

B(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )

C(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))

D(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Answer : B

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

Question 3

You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

A{FIXED: [Region] SUM Sales}

B{FIXED: SUM Sales}

C{Fixed: [Region]: TOTAL Sales}

D{FIXED: TOTAL (Sales)}

Answer : B

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

Question 4

You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

APronunciation

BSpelling

CManual Selection

DCommon Characters

Answer : D

Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as 'John Smith' and 'Smith, John' because they both generate the key 'hijmnost'. Since this algorithm doesn't consider pronunciation, the value 'Tom Jhinois' would have the same key 'hijmnost' and would also be included in the group.

Question 5

A Data Analyst needs to develop a Sales Dashboard that users can access through a computer or by phone and tablet using the same URL link.

How should the analyst create dashboards that are formatted for specific devices?

AUse floating containers on the dashboard so that the content shifts responsively to adjust for each device.

BAdd device layouts for the dashboard so that appropriate layouts are shown based on the device.

CCreate a workbook for each device type and let the users know which one to open on which device.

DSet the dashboard size to Automatic and let Tableau adjust the layout automatically for each device size.

Answer : B

Question 6

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

A.png

B.html

C.xlsx

D.txt

E.pptx

F.csv

Answer : A, C, E

Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:

.png for exporting images of the visualizations

.xlsx for exporting data in a format that can be opened with Microsoft Excel

.pptx for creating PowerPoint presentations with the visualization embedded

These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.

Question 7

A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:

{ FIXED [Region] : SUM([Sales]) }

The analyst has a view that has a dimension filter on the State column to exclude five states.

What should the analyst do to ensure the five states are also excluded from the LOD expression?

ADrag the LOD expression to the Filters shelf.

BChange the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.

CRight-click the State dimension filter, and then click Attribute.

DRight-click the State dimension filter, and then click Add to Context.

Answer : D

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