Download Free Salesforce Analytics-DA-201 Exam Questions & Answer
Online VALID Analytics-DA-201 Exam Dumps File Instantly
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 46
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
- A. Add a tooltip
- B. Enable captions
- C. Annotate March 2020
- D. Drag the growth rate to Text on the Marks card
Answer: C
Explanation:
To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet.
Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. References: https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations_create.htm
To add a comment to a specific point on a line chart, such as March 2020 in the provided visualization, you would use the 'Annotate' feature. Right-clicking on the data point for March 2020 and selecting 'Annotate' allows you to add a text annotation directly to the chart, which can be used to highlight and comment on that particular data point.
NEW QUESTION # 47
You have the following worksheet.
You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
* SUM([Sales])
* LOOKUP(SUM([Sales]), -1)
* PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function
NEW QUESTION # 48
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
- A. Convert the date to Exact Date
- B. Select Show Misting Values for the dale
- C. Convert the date to Continuous
- D. Convert the date to Attribute
Answer: C
Explanation:
References: https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro
/desktop/en-us/dates_continuous.htm https://help.tableau.com/current/pro/desktop/en-us/formatting.htm To ensure the dates are shown in a continuous axis, you should convert the date to a continuous field. This will display the months in a sequence without any breaks, which is needed for showing a trend over time like the cumulative sum of sales.
NEW QUESTION # 49
You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?
- A. Set the Choose Region parameter to Single Value (list)
- B. Add the Choose Region parameter to the Pages card
- C. Add the [Region] = [choose Region) formula to the Filters card
- D. Add Region to the Fitters card
Answer: C
Explanation:
https://kb.tableau.com/articles/howto/filtering-data-with-a-parameter?lang=fr-fr After creating a parameter named Choose Region, you want to use it to filter the chart based on the user's selection. To do this, you would create a calculated field with the formula [Region] = [Choose Region] and add this calculated field to the Filters card. This will dynamically filter the chart to display data only for the region that matches the user's selection in the Choose Region parameter.
NEW QUESTION # 50
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. Condition
- B. Top
- C. Wildcard
- D. General
Answer: C
NEW QUESTION # 51
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If
'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.
The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.
In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since
"Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.
For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.
Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.
NEW QUESTION # 52
When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?
- A. The object gets deleted from the dashboard.
- B. The object disappears from the item hierarchy.
- C. The layout automatically adjusts to fill the space.
- D. The hidden object remains in the same position but is grayed out.
Answer: C
NEW QUESTION # 53
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 Date.
Add the calculated field to the extract filter. - B. Create a custom SOL query to define the data source and create a calculated field based on Start Date.
Add the calculated field to the extract filter. - C. Create a custom SOL query that references Stan Date in the WHERE clause.
- D. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.From the Data pane, add the calculated field to the data source filter
Answer: A
NEW QUESTION # 54
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If
'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.
The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.
In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since
"Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.
For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.
Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.
NEW QUESTION # 55
A Data Analyst has a dataset that contains the fallowing rows of sales data.
The analyst needs to return a value of TRUE if a month has sales greater than $50,000; otherwise, the formula must return a value of FALSE.
Which two formulas achieve this goal? (Choose two.)
- A. SUM([Sales]) IN (50000)
- B. IF [Sales] > 50000 THEN TRUE ELSE FALSE END
- C. [Sales] > 50000
- D. MAX([Sales], 50000)
Answer: B,C
NEW QUESTION # 56
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 Date.
From the Data pane, add the calculated field to the data source filter - B. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.
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 Date.
Add the calculated field to the extract filter. - D. Create a custom SOL query that references Stan Date in the WHERE clause.
Answer: B
NEW QUESTION # 57
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Answer:
Explanation:
Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every
[Category], which means that the ranking will reset for each category. References: https://help.tableau.com
/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro
/desktop/en-us/calculations_calculatedfields_lod_rank.htm
NEW QUESTION # 58
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
* FIRST ()
* 0
* COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm
NEW QUESTION # 59
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
To add a column that shows the day of the week for each row, you should complete the formula as follows:
DATENAME
(
'weekday'
, [Order Date])
The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions
To add a column that shows the day of the week for each row, you should complete the formula as follows:
DATENAME
(
'weekday'
, [Order Date])
The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions
NEW QUESTION # 60
You want to create the following dashboard that will contain two sheets.
What should you do?
- A. Drag both sheets to the dashboard and add a background lo each sheet.
- B. Add both sheets lo a horizontal container and add a border to the container.
- C. Add a border to both sheets and add both sheets to a horizontal object.
- D. Drag both sheets to the dashboard and add a border to each sheet.
Answer: B
NEW QUESTION # 61
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 Deselect
- B. Right-click Sheet2 and select Add to Dashboard.
- C. From the context menu of Sheet3. select Remove Dashboard item
- D. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- E. Drag Sheet2 to the dashboard.
Answer: E
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 area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.
NEW QUESTION # 62
......
Analytics-DA-201 Exam Dumps For Certification Exam Preparation: https://www.trainingdump.com/Salesforce/Analytics-DA-201-practice-exam-dumps.html
100% Pass Guaranteed Download Tableau Data Analyst Exam PDF Q&A: https://drive.google.com/open?id=1qztaSVDADnxnn34kU-ou180nwkyCN5gW