Analytics-DA-201 Salesforce Exam Questions and Free Practice Test

Question 25

- (Topic 1)
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet. What should you do from Tableau Desktop?

A. From the Data menu select New Data Source

B. From the Data menu select Replace Data Source

C. From the File menu select Import Workbook

D. From the File menu select New

Correct Answer:A

Question 26

- (Topic 3)
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?

A. Create a data source based on the Excel worksheet and create a calculated field based on Start Dat

B. Add the calculated field to the extract filter.

C. Create a custom SOL query to define the data source and create a calculated field based on Start Dat

D. Add the calculated field to the extract filter.

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

F. Create a data source based on the Excel worksheet and create a calculated field based on Start Dat

G. From the Data pane, add the calculated field to the data source filter

Correct Answer:A

Question 27

- (Topic 3)
You have the following primary data source that contains a dimension named Dorm_Code.
Analytics-DA-201 dumps exhibit
You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?

A. Bring in the secondary data source as a union.

B. Bring in the secondary table as a left join to the primary data sourc

C. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window

D. Bring in the secondary data source by using relationship

E. From the Data pane, right- click Dorm_Name select Replace References, and then select Dorm_Name_New

F. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

Correct Answer:C

Question 28

- (Topic 3)
You have the following dataset.
Analytics-DA-201 dumps exhibit
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) )

Correct Answer:B

Question 29

- (Topic 3)
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
· Every record must have a full name.
Which type of join should you use?

A. Inner

B. Left

C. Full outer

D. Union

Correct Answer:B

Question 30

- (Topic 3)
You have the following bar chart.
Analytics-DA-201 dumps exhibit
You want the chart to appear as shown in the Mowing exhibit.

What should you add?

A. A reference band

B. A reference line

C. An average line

D. A distribution band

Correct Answer:B

START Analytics-DA-201 EXAM