Pass Your Exam With 100% Verified Analytics-DA-201 Exam Questions
Analytics-DA-201 Dumps PDF - Analytics-DA-201 Real Exam Questions Answers
NEW QUESTION # 43
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
- A. Machines
G Phones - B. Copiers
- C. Furnishings
- D. Accessories
- E. Bookcases
- F. Chairs
- G. Tables
Answer: A,D,G
Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
NEW QUESTION # 44
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
check the steps below in explanation.
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.
References: 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
NEW QUESTION # 45
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
- A. The padding
- B. The position
- C. The size
- D. The border
- E. The background
Answer: A
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:
* Format Dashboards - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 46
You have the following dashboard.
Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?
- A. From the context menu of Profits by Stale deselect Use as Filter
- B. From the context menu of Sales over lime select Remove Dashboard Item
- C. From the context menu of Sales over time select Deselect
- D. From the context menu of Sales over time select Ignore Actions
Answer: D
Explanation:
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.
In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.
The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.
htm
On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default.
To restrict the filter action to only affect the Detail table and not the 'Sales over time' chart, you would modify the action settings. By selecting "Ignore Actions" from the context menu of the 'Sales over time' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.
NEW QUESTION # 47
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
check the steps below in explanation.
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.
References: 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
NEW QUESTION # 48
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
- A. The data source must use a live connection.
- B. The data must be extracted.
- C. The data source must be stored as a hyper file.
- D. The credentials must be embedded.
Answer: B,D
Explanation:
To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Embedding Database Credentials
* Tableau Help: Extract Your Data
NEW QUESTION # 49
You have the following dashboard that contains two visualizations.
You want to show only one visualization at time. Users must be able to switch between visualizations.
What should you me?
- A. Show/hide buttons
- B. Dashboard actions
- C. Worksheet actions
- D. A parameter and a calculated filed
Answer: A
Explanation:
In Tableau, you can manage the visibility of different visualizations on a dashboard using various techniques.
Among the options provided, the most straightforward method to allow users to switch between two visualizations is to use show/hide buttons.
Here's why each option is or isn't suitable for the requirement:
A). A parameter and a calculated field: While it's possible to use a parameter and a calculated field to control which visualization is displayed, it requires creating a calculated field that responds to a parameter and then using that field to filter the view. This method can become complex and is not as user-friendly for simply showing and hiding visualizations.
B). Worksheet actions: Worksheet actions in Tableau typically allow users to interact with the data within a visualization, such as filtering data or highlighting related data points when clicking or hovering. They are not designed to control the visibility of entire visualizations on a dashboard.
C). Show/hide buttons: Show/hide buttons are a feature specifically designed to manage the visibility of dashboard elements. When you create a show/hide button, it can be configured to display or hide a particular visualization, container, or any other dashboard element when clicked. This provides a very intuitive interface for users to switch between visualizations.
D). Dashboard actions: Dashboard actions, like worksheet actions, are used to create interactions between sheets, such as filtering data or navigating to other sheets or URLs based on user interactions. They are not intended for toggling the visibility of visualizations.
Therefore, the correct answer is C. Show/hide buttons as they provide a user-friendly way to switch between visualizations on a dashboard without the need for complex calculations or actions that aren't meant for this purpose. The show/hide button feature is specifically designed for toggling visibility and offers a simple and effective solution for the requirement.
NEW QUESTION # 50
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data''
Answer:
Explanation:
NEW QUESTION # 51
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
- A. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'END - B. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. IF [Subject] = 'Science' THEN 'Sciences'
ELSEIF [Subject] = 'English' THEN 'Humanities'
ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'
ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'
END - D. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences')
Answer: A,C
NEW QUESTION # 52
A Data Analyst has the following worksheet, with Profit data for Categary and Sub-Categury.
The analyst executed the following calculated field at the Total level:
COUNTD( IF ( INCLUDE [Sub-Category]: SUM([Profit]) < 0 THEN [Category] END ) What is the result?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 53
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. General filter
- B. Top filter
- C. Wildcard filter
- D. Condition filter
Answer: D
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. References:
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop
/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 54
You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type.
You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References:
* Create Dashboard Layouts for Different Device Types - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 55
You have a data source that contains 20 tables.
You want the tables to be organized within the Data pane based on the type of data contained within the tables.
What should you use?
- A. Folders
- B. Sets
- C. Hierarchies
- D. Groups
Answer: A
Explanation:
To organize the tables in the Data pane based on the type of data contained within the tables, you should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data pane according to your preference. You can create folders by right-clicking on the fields or tables you want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into existing folders. You can name the folders according to the type of data they contain, such as sales, customer, product, etc. Folders can help you find and access the fields or tables you need more easily and efficiently. References:
* Organize and Customize Fields in the Data Pane - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 56
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 # 57
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)
Answer:
Explanation:
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
References:
Add Show/Hide Buttons - Tableau
Layout Containers - Tableau
NEW QUESTION # 58
Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?
- A. [Customer ID] : { [Purchase Date] }
- B. MIN([Purchase Date])
- C. [Customer ID] : MIN([Purchase Date])
- D. { FIXED [Customer ID] : MIN([Purchase Date]) }
Answer: D
NEW QUESTION # 59
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
- A. From the Server menu, select Publish Data Source.
- B. From the File menu, select Export Packaged Workbook.
- C. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
- D. From the Server menu, select Publish Workbook.
Answer: D
Explanation:
To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Publish a Workbook
NEW QUESTION # 60
You have the following view.
You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.
Which type of filter should you use?
- A. General
- B. Wildcard
- C. Top
- D. Condition
Answer: B
NEW QUESTION # 61 
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. Select the top 10 bars, and then change the color by selecting 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. 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.
Answer: C
NEW QUESTION # 62
You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type.
You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References:
* Create Dashboard Layouts for Different Device Types - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 63
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the File menu select Import Workbook
- B. From the File menu select New
- C. From the Data menu select New Data Source
- D. From the Data menu select Replace Data Source
Answer: C
Explanation:
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us
/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm When connecting to a dataset in Tableau Desktop, you would go to the 'Data' menu and select 'New Data Source'. This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.
NEW QUESTION # 64
A Data Analyst has the following two tables named Orders and Returns.
The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.
Which type of join should the analyst perform in Tableau Prep?
- A. Unmatched only join
- B. Full join
- C. Left join
- D. Inner join
Answer: D
NEW QUESTION # 65
......
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Analytics-DA-201 Dumps 100 Pass Guarantee With Latest Demo: https://www.testsimulate.com/Analytics-DA-201-study-materials.html