Free Practice Questions for Salesforce Analytics-DA-201 Exam

Replace Data Source

Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.

To replace the data source, you need to do the following steps:

Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the original data source.

Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.

Select the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

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. References:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either ‘Sciences’ or ‘Humanities’. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign ‘Humanities’ to any subject that contains ‘Science’ in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with ‘Computer Science’ and ignore the other subjects. References:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:

Creating a Story - Tableau

New in 9.0: Formatting the Story Points Navigator - Tableau

Tableau Certified Data Analyst Study Guide