Salesforce Analytics-DA-201 Daily Practice Exam New 2026 Updated 176 Questions
Use Valid Analytics-DA-201 Exam - Actual Exam Question & Answer
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
NEW QUESTION # 62
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. NAMEUSERNAME()
- B. ISFULLNAMETableu_USER_NAME))=USERNAME()
- C. NAME Tableau-USER-NAME)
- D. USERNAME()=(Tableau_USER_NAME)
Answer: D
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau.
ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]
/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of
"S". References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.
tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.
com/current/pro/desktop/en-us/calculations_calculatedfields.htm
In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user's username.
NEW QUESTION # 63
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
NEW QUESTION # 64
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Answer:
Explanation:
check the steps below in explanation.
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.
References: 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
NEW QUESTION # 65
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. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
- C. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
- D. (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
Answer: C
Explanation:
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
NEW QUESTION # 66
When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?
- A. The object disappears from the item hierarchy.
- B. The layout automatically adjusts to fill the space.
- C. The hidden object remains in the same position but is grayed out.
- D. The object gets deleted from the dashboard.
Answer: B
NEW QUESTION # 67
You have the following dataset that contain null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.
- A. ZN ([Profits])
- B. ISNULL ([Profits])
- C. IF [Profits] != null then [Profits] END
- D. IFNULL [(profits] ,0)
Answer: A,D
Explanation:
Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.
References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.
com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_logical.htm#ISNULL
NEW QUESTION # 68
How should a Data Analyst sort data by Sales across multiple dimensions in Tableau?
- A. Use the Sets feature to combine dimensions and then sort one of the fields.
- B. Right-click on each dimension, choose Sort, then select data source order in the options.
- C. Right-click on the rightmost dimension, choose Sort, then select nested in the options.
- D. Use the Group feature to combine dimensions and then sort the grouped field.
Answer: C
NEW QUESTION # 69
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
* Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
* Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
* Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
* Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
* Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
* Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband_edit.htm
NEW QUESTION # 70
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, 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 Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
* Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
* Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
* Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
* Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 71
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
- A. COUNTD {(NAME])
- B. COVAR({Award})
- C. MAX {(Award})
- D. INDEX()
- E. COUNTD({Award})
Answer: E
Explanation:
To get the number of different types of awards that have been won, you should use the formula COUNTD ({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.
The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX ({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. References:
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.
tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.
NEW QUESTION # 72
A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?
- A. Full outer
- B. Left only
- C. Union
- D. Left
- E. Inner
Answer: B
NEW QUESTION # 73
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
- A. {Fixed: [Region]: TOTAL Sales}
- B. {FIXED: TOTAL (Sales)}
- C. {FIXED: SUM Sales}
- D. {FIXED: [Region] SUM Sales}
Answer: C
Explanation:
The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be
{SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL
NEW QUESTION # 74
You have a sales dataset that contains the following fields.
You need to analyze the average revenue per product in different regions over time.
Which two fields should be measures? Choose two.
- A. Quantity
- B. Order Date
- C. Revenue
- D. Customer Region
- E. Product Name
Answer: A,C
Explanation:
To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:
* Dimensions and Measures, Blue and Green - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 75
You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?
- A. Page Setup
- B. Export As PowerPoint
- C. Export As Version
- D. Share
- E. Print
Answer: A
NEW QUESTION # 76
What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?
- A. Bullet Graph
- B. Box Plot
- C. Scatter Plot
- D. Histogram
Answer: B
NEW QUESTION # 77
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
Answer:
Explanation:
Explanation:
1) Open Tableau prep
2) Create a new column ...
3) Union the sales ...
4) Join the sales ...
References: 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
NEW QUESTION # 78
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
- A. November
- B. December
- C. October
- D. August
Answer: A
Explanation:
Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.
NEW QUESTION # 79
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?
- A. Publish the dashboard to Tableau Public
- B. Export the dashboard as a .twbx
- C. Print the dashboard to PDF
- D. Publish the dashboard to Tableau Server
Answer: D
Explanation:
To share a dashboard that contains confidential information about patients health and needs to always be up to date for a team of healthcare workers, you should publish it to Tableau Server. This will allow you to control who can access and interact with your dashboard, as well as schedule automatic refreshes of your data source or extract. Publishing to Tableau Public would expose your data to anyone on the internet, printing to PDF would not update your data, and exporting as a .twbx would require sending a large file that might not be compatible with other versions of Tableau. References: https://help.tableau.com/current/pro/desktop/en-us
/publish_workbooks_share.htm https://help.tableau.com/current/pro/desktop/en-us
/publish_workbooks_tableauserver.htm
When sharing sensitive and confidential information that needs to be kept up-to-date, such as patient health data for a team of healthcare workers, the best practice is to publish the dashboard to Tableau Server. Tableau Server is designed for secure, controlled access and can be configured to ensure that data is refreshed as needed. Publishing to Tableau Public is not secure for confidential data, printing to PDF or exporting as a .
twbx does not allow for live data updates.
NEW QUESTION # 80
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. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- 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
Answer: C,D
Explanation:
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
NEW QUESTION # 81
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?
- A. Dashboard Height and Width pixel settings
- B. Fonts and Lines
- C. Number format and Shading
- D. Fonts and Color Palette
Answer: B
NEW QUESTION # 82
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3, select Remove Dashboard Item.
- B. Right-click Sheet2 and select Add to Dashboard.
- C. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- D. Drag Sheet2 to the dashboard.
- E. From the context menu of Sheet3, select Deselect.
Answer: D
Explanation:
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard where the current sheet (Sheet3) is. This will replace the existing visualization with the new one.
NEW QUESTION # 83
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
Answer:
Explanation:
Explanation:
1) Open Tableau prep
2) Create a new column ...
3) Union the sales ...
4) Join the sales ...
References: 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
NEW QUESTION # 84
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
- A. Top
- B. Condition
- C. Wildcard
- D. General
Answer: C
NEW QUESTION # 85
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Export mdb
- B. Book1.twb
- C. Sales.csv
- D. Sales.hyper
Answer: D
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.
tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com
/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us
/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-
9a3c-4a0b-8e6c-6d1f1f7c2b7e
In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
NEW QUESTION # 86
......
Test Engine to Practice Analytics-DA-201 Test Questions: https://actualtest.updatedumps.com/Salesforce/Analytics-DA-201-updated-exam-dumps.html