Analytics-DA-201問題集、Salesforce実際の試験問題

質問 1

When using the INCLUDE Level of Detail (LOD) calculation, where should the dimension referenced by the INCLUDE function be located on the sheet?

A. Filters Shelf

B. Marks Card

C. Rows or Columns Shelf

D. Not in the View

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 2

You have the following dataset.

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

A. IF ENDSWITH ( [Subject], ' Computer Science ' ) THEN ' Sciences ' ELSE ' Humanities ' END

B. IIF(( CONTAINS ([Subject], ' Science ' ) = TRUE) , ' Humanities ' , ' Sciences ' )

C. CASE [Subject]
WHEN ' Computer Science ' THEN ' Sciences '
WHEN ' Science ' THEN ' Sciences '
WHEN ' English ' THEN ' Humanities '
WHEN ' Social Studies ' THEN ' Humanities '
End

D. IF [Subject]- ' Science ' THEN ' Sciences '
ELSEIF [Subject]= ' English ' THEN ' Humanities '
ELSEIF [Subject]- ' Social Studies ' THEN ' Humanities '
ELSEIF [Subject]= ' Computer Science ' THEN ' Sciences '
END

正解: C,D

解説: (PassTest メンバーにのみ表示されます)

質問 3

You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

A. Wildcard filter

B. General filter

C. Top filter

D. Condition filter

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 4

You have a data source that contains 20 tables.
You want the tables to be organized within the Data pane based on the type of data contained within the tables.
What should you use?

A. Hierarchies

B. Groups

C. Sets

D. Folders

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 5

A Data Analyst has the following dashboard.

The analyst wants a specific web page to open in the default web browser when a user clicks the sheet.
What should the analyst do?

A. Add a Go to URL action and set Run action on to Menu.

B. Add a navigation button and set the dashboard as the destination.

C. Add a Go To Sheet action and set the dashboard as the destination.

D. Add a Go to URL action and set Run action on to Select.

E. Add a web page object and enter the URL.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?

A. Fonts and Lines

B. Fonts and Color Palette

C. Dashboard Height and Width pixel settings

D. Number format and Shading

正解: A

質問 7

You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?

正解:

Explanation:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide

質問 8

When should a Data Analyst use a Treemap in Tableau?

A. To analyze the distribution of a measure over time

B. To show the correlation between two continuous variables

C. To visualize the change in a measure across different regions in a map

D. To display hierarchical data with nested categories

正解: D

質問 9

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. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales] ) ), -4) )

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

正解: B

解説: (PassTest メンバーにのみ表示されます)

Salesforce Certified Tableau Data Analyst - Analytics-DA-201 模擬練習