New Dumps4PDF Analytics-DA-201 Exam Questions| Real Analytics-DA-201 Dumps Updated on Oct 28, 2025
Analytics-DA-201 Braindumps – Analytics-DA-201 Questions to Get Better Grades
NEW QUESTION # 37
You are creating an annual report in Microsoft Word.
In Tableau Desktop, you build a chart in a worksheet.
You want to create an image of the chart that you can add to the annual report.
What are two ways to create the image? Choose two.
- A. From the Worksheet menu, use the Export option.
- B. From the Dashboard menu, use the Export Image option.
- C. From the Dashboard menu, use the Copy Image option.
- D. From the File menu, use the Export As Version option.
- E. From the Worksheet menu, use the Copy option.
Answer: A,E
Explanation:
To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc. References:
* Export Views from Tableau Desktop to Another Application
* Copy and Paste Views from Tableau Desktop to Another Application
NEW QUESTION # 38
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 # 39
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Manual Selection
- B. Pronunciation
- C. Spelling
- D. Common Characters
Answer: C
Explanation:
Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.
NEW QUESTION # 40
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 be stored as a hyper file.
- B. The data must be extracted.
- C. The data source must use a live connection.
- 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 # 41
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 # 42
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. ISNULL ([Profits])
- B. IFNULL [(profits] ,0)
- C. IF [Profits] != null then [Profits] END
- D. ZN ([Profits])
Answer: B,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 # 43
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?
- A. Number format and Shading
- B. Dashboard Height and Width pixel settings
- C. Fonts and Lines
- D. Fonts and Color Palette
Answer: C
NEW QUESTION # 44
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, 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.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
NEW QUESTION # 45
Which option must a Data Analyst enable to build the following table to add quarterly totals?
- A. Add Pane Totals
- B. Add All Subtotals
- C. Show Column Grand Totals
- D. Show Row Grand Totals
Answer: B
NEW QUESTION # 46
A Data Analyst has received a request to provide a dashboard related to employee time logs. The employees are entering their time using mobile devices throughout the day and data is stored in a cloud-based database.
The end users would like to receive data on their dashboard in as close to real-time as possible.
How should the analyst best create a data source to meet these requirements?
- A. Create a connection to the database using Tableau Desktop and retrieve an extract of the data. Publish the data source from Tableau Desktop to Tableau Cloud and schedule the refresh of the extract.
- B. Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection and disable any firewalls on the database.
- C. Create a connection to the database to retrieve the data using Tableau Bridge. Schedule the refresh of the data extract to 15 minutes.
- D. Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection, ensuring the database firewall has been configured to allow connections from Tableau Cloud.
Answer: D
NEW QUESTION # 47
You have a data source that contains the following columns.
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)
Answer:
Explanation:
To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters
NEW QUESTION # 48
You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?
- A. From the My Content overview page, modify the alert.
- B. From the worksheet, modify the subscription.
- C. From the My Content overview page, modify the subscription.
- D. From the dashboard overview page, modify the subscription.
Answer: C
NEW QUESTION # 49
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
- A. All the data sources published to the Tableau Server
- B. All the data sources published to the site within the folders to which you have access
- C. All the data sources published to the Tableau Server within the folders to which you have access
- D. All the data sources published to the site
Answer: B
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. References: https://help.tableau.com/current/pro/desktop/en-us
/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm When signed in to Tableau Server from Tableau Desktop, you'll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau's permission and project structure mean that you won't see all data sources from the entire server unless you have permissions to do so.
NEW QUESTION # 50
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Drag Location to Size on the Marks card
- B. Change the opacity to 75%
- C. Change the mark type to Map
- D. Change the mark type to Density
- E. Drag Population to Size on the Marks card
Answer: D
Explanation:
The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.
Here's the explanation for each option:
A). Change the mark type to Density: This is the correct answer because changing the mark type to 'Density' in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades.
B). Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient.
C). Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map.
D). Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration.
E). Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map.
To achieve the visualization shown in the second image, the mark type must be changed to 'Density,' which will produce a heat map-like effect where the color intensity represents the concentration of data points.
Therefore, the correct answer is A. Change the mark type to Density.
To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.
NEW QUESTION # 51
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. Add the [Region] = [choose Region) formula to the Filters card
- B. Add the Choose Region parameter to the Pages card
- C. Set the Choose Region parameter to Single Value (list)
- D. Add Region to the Fitters card
Answer: A
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 # 52
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. IF [Sales] > 50000 THEN TRUE ELSE FALSE END
- B. [Sales] > 50000
- C. MAX([Sales], 50000)
- D. SUM([Sales]) IN (50000)
Answer: A,B
NEW QUESTION # 53
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. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source.
- B. Bring in the secondary data source as a union.
- C. 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.
- D. 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.
Answer: C
NEW QUESTION # 54
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
* Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
* Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
* Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
* Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
* Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.
References: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm https://help.
tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_create.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_percentoftotal.htm
NEW QUESTION # 55
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 # 56
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. Sales.hyper
- B. Book1.twb
- C. Sales.csv
- D. Export mdb
Answer: A
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 # 57
......
Analytics-DA-201 Exam Dumps - Try Best Analytics-DA-201 Exam Questions: https://testinsides.dumps4pdf.com/Analytics-DA-201-valid-braindumps.html