Practice with Analytics-DA-201 Dumps for Tableau Data Analyst Certified Exam Questions & Answer
REAL Analytics-DA-201 Exam Questions With 100% Refund Guarantee
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION # 25
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?
- A. INCLUDE
- B. AVG
- C. RUNNING_AVG
- D. EXCLUDE
Answer: D
NEW QUESTION # 26
You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?
- A. The My Content area of Tableau web pages
- B. The Notification area of Tableau Prep
- C. The Data Source page of Tableau Desktop
- D. The Shared with Ma page
Answer: A
Explanation:
To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References: https://help.tableau.com/current/pro
/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm In Tableau, the "My Content" area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the
"My Content" area to resume it.
NEW QUESTION # 27
A Data Analyst has the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
- A. Select Remove Dashboard Item from the drop-down menu of Sales over time.
- B. Deselect Use as Filter from drop-down menu of Profits by State
- C. Select Ignore Actions from the drop-down menu of Sales over time.
- D. Select Deselect from the drop-down menu of Sales over time.
Answer: C
NEW QUESTION # 28
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Manual Selection
- B. Spelling
- C. Pronunciation
- D. Common Characters
Answer: D
Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.
NEW QUESTION # 29
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. From the More actions menu of Materials, select Valid in the Show values section.
- B. From the More actions menu of Materials, filter the selected values.
- C. From the More actions menu of Materials, select Group Values, and then select Spelling.
- D. For the data type of the Material field, select Custom, and then select Role1.
Answer: C,D
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
* Use Data Roles to Validate your Data - Tableau
* New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 30
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 # 31
You have the following visualization.
Answer:
Explanation:
Explanation:
NEW QUESTION # 32
You have the Mowing two tables that contains data about the books in a library.
Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?
- A. Full outer join
- B. left join
- C. Right join
- D. Inner join
Answer: A
Explanation:
To combine the two tables that contain data about books in a library and ensure that all the data is retained, you should use a full outer join. A full outer join is a type of join that returns all rows from both tables, regardless of whether there is a match or not. If there is no match, null values are filled in for the missing fields.
To perform a full outer join, you need to do the following steps:
* Connect to both tables as your data sources in Tableau. You can use either live or extract connections.
* Drag one table to the canvas and drop it on top of another table. This will create a join between them based on a common field.
* Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will change the join type to full outer join and show all rows from both tables.
* Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each clause. You can also change or rename fields by clicking on them.
The other types of joins are not correct for this scenario. An inner join returns only the rows that have a match in both tables, which will exclude any books that are missing from either table. A left join returns all rows from the left table and only the matching rows from the right table, which will exclude any books that are only in the right table. A right join returns all rows from the right table and only the matching rows from the left table, which will exclude any books that are only in the left table. References: https://help.tableau.com
/current/pro/desktop/en-us/joining_tables.htm https://help.tableau.com/current/pro/desktop/en-us/join_types.
htm
When combining two datasets that are both incomplete and where it's important to retain all data from both sources, a full outer join is appropriate. This type of join ensures that all records from both tables are included in the combined dataset, even if there are no matching records in the other table.
NEW QUESTION # 33
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?
- A. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
- B. Bring in the secondary data source as a union.
- C. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
- D. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
Answer: D
Explanation:
* Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
NEW QUESTION # 34 
You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
What should you do?
- A. Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.
- B. Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.
- C. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.
- D. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
Answer: C
NEW QUESTION # 35
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
- A. Drag Region to Tooltip on the Marks card
- B. Right-click a in the chat, select Annotate and then select Mark.
- C. Right-click a bar in the chart select Mark Label and then select Always show.
- D. Edit the aliases for City.
Answer: A
Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.
NEW QUESTION # 36
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: TOTAL (Sales)}
- B. {FIXED: SUM Sales}
- C. {FIXED: [Region] SUM Sales}
- D. {Fixed: [Region]: TOTAL Sales}
Answer: B
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 # 37
A Data Analyst has the following primary data source that contairis a dimension named Dorm_Code.
The analyst receives the following secondary data source that contains updated dorm codes.
The analyst needs 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 the analyst do?
- A. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name, select Replace References, and then select Dorm Name New.
- B. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dorm_Name_New] in the calculation window.
- C. Bring in the secondary data source as a union.
- D. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source.
Answer: A
NEW QUESTION # 38
A Data Analyst has the following chart that shows the cumulative volume of sales from various dates.
The analyst wants the months to appear as shown in the following chart.
What should the analyst do?
- A. Convert the date to Attribute
- B. Convert the date to Exact Date
- C. Change the Sort Order
- D. Convert the date to Continuous
Answer: D
NEW QUESTION # 39
You have a dataset that contains sates data. The following is a sample of the data.
You need 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 the goal Choose two
- A. SUM{[Sales]) IN (50000)
- B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- C. MAX< [Sales], 50000)
- D. [Sales] > 50000
Answer: B,D
Explanation:
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. References: https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us
/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX
NEW QUESTION # 40
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. From the More actions menu of Materials, select Valid in the Show values section.
- B. From the More actions menu of Materials, filter the selected values.
- C. From the More actions menu of Materials, select Group Values, and then select Spelling.
- D. For the data type of the Material field, select Custom, and then select Role1.
Answer: C,D
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
* Use Data Roles to Validate your Data - Tableau
* New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 41
A Data Analyst has a data source that contains the following columns:
he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?
- A. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
- B. Drag the LOD expression to the Filters shelf.
- C. Right-click the State dimension filter, and then click Add to Context.
- D. Right-click the State dimension filter, and then click Attribute.
Answer: C
NEW QUESTION # 42
A Data Analyst has the following dataset in Microsoft Excel.
The analyst is using Data Interpreter to cleanse the dataset. Data Interpreter provides the following results.
How many rows of data will be ingested into Tableau as values?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 43
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 # 44
......
PDF Download Salesforce Test To Gain Brilliante Result!: https://www.crampdf.com/Analytics-DA-201-exam-prep-dumps.html
Get Special Discount Offer on Analytics-DA-201 Dumps PDF: https://drive.google.com/open?id=16p--NiJ-VlPrDRLqerVtg0QEWKQcvR9m