Free Analytics-DA-201 Practice Test Questions and Answers (2026) | Cert Empire Practice Questions

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data

source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an

existing one. You can specify the frequency and time of the refresh, as well as any custom options or

credentials. New will create a new data source, Connected Workbooks will show you which

workbooks use this data source, and Connections will show you which tables or files are connected

to this data source. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm

https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To ensure that the data is updated every hour on Tableau Server, you would need to go to the

"Extract Refreshes" option. Here, you can schedule the data extracts to refresh at the desired

frequency, which in this case would be every hour.

:

To make Sales appear automatically as shown in the second table, you should change the default

number format of the Sales field. The default number format is how Tableau displays a field when

you drag it to a worksheet. You can change the default number format by right-clicking on the field

and selecting Default Properties > Number Format from the menu. This will open a dialog box where

you can choose a category, such as Currency or Percentage, and customize the options, such as

decimal places or prefixes.

In this case, you want to change the default number format of Sales to Currency with zero decimal

places and a custom prefix of “S”. This will make Sales appear as “S” followed by the rounded value in

thousands.

The other options are not correct for this scenario. Changing the data type of Sales to String will not

affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change

the default number format of Sales, but create a new field that you have to drag to a worksheet.

Converting Sales to Attribute will return only one value for each partition of data, which will not

show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/enus/formatting.htm https://help.tableau.com/current/pro/desktop/en-

us/formatting_change_default.htm

To achieve the formatting as shown in the example, where sales figures are displayed with a "K" to

represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need

to adjust the default number format of the Sales field in Tableau. By changing the default number

format, every instance where the Sales field is used would automatically reflect this new formatting.

This is more efficient than creating a calculated field as it preserves the numeric nature of the field,

allowing for further numerical operations and aggregations.

The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise

the formula must return a value of false, are:

B . IIF(SUM([Sales]) > 50000, TRUE, FALSE) D. [Sales] > 50000

The IIF function is a logical function that returns one value if a condition is true, and another value if

the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum

of sales for a month is greater than $50,000. The function will return TRUE if the condition is true,

and FALSE if the condition is false.

The comparison operator > is a logical operator that returns TRUE if the left operand is greater than

the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which

means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales

are greater than $50,000, and FALSE otherwise.

The other options are not correct for this scenario. The IN function is a logical function that returns

TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]),

which is not in the set of values (50000). The function will always return FALSE. The MAX function is

an aggregation function that returns the maximum value in a field or expression. In this case, the

field or expression is [Sales], 50000, which is not valid syntax. The function will return an error.

Reference: https://help.tableau.com/current/pro/desktop/enus/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-

us/operators.htm https://help.tableau.com/current/pro/desktop/enus/functions_functions_aggregate.htm#MAX

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_104_img_1.jpg

. Explanation: To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps: Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source. 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 Superstore data source. Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table. Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name. Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name. Reference: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm https://help.tableau.com/current/pro/desktop/en-us/split.htm https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm

. Explanation: To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet. Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source. 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 existing 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 Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement. Reference: https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm https://help.tableau.com/current/pro/desktop/en-us/datasource_replace_workbook.htm

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_18_img_3.jpg

The correct order of the three actions is: Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf. Aggregate the date to month and year. From the Analytics pane, drag Forecast to the worksheet. The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default. The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month. The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card. The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast. Reference: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro/desktop/enus/functions_functions_statistical.htm#MODEL_QUANTILE

1) Open Tableau prep 2) Create a new column ... 3) Union the sales ... 4) Join the sales ... Reference: https://help.tableau.com/current/prep/en-us/prep_get_started.htm https://help.tableau.com/current/prep/en-us/prep_union.htm https://help.tableau.com/current/prep/en-us/prep_clean.htm https://help.tableau.com/current/prep/en-us/prep_join.htm