Analytics-DA-201 Free Practice Test

DRAG DROP - (Topic 3)
You have the following calculated fields in a worksheet. [Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

FILL IN THE BLANK - (Topic 2)
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

Solution:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the CategoryPercentage worksheet.
Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
You have the following two tables.


Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?

1. A. Left join
2. B. Right join
3. C. Inner join
4. D. Outer join

Correct Answer: A

- (Topic 3)
The following table displays the row-level data in a Tableau data source:

A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?

1. A. 12
2. B. 50
3. C. 15
4. D. An error

Correct Answer: A

- (Topic 3)
You have the following primary data source that contains a dimension named Dorm_Code.

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?

1. A. Bring in the secondary data source as a union.
2. B. Bring in the secondary table as a left join to the primary data sourc
3. C. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
4. D. Bring in the secondary data source by using relationship
5. E. From the Data pane, right- click Dorm_Name select Replace References, and then select Dorm_Name_New
6. 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