You need to change the values of a dimension without creating a new field. What should you do?
Correct Answer: C
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
Question 12
You have the following dataset. Which grouping option should you use m Tableau Prep to group al five names automatically?
Correct Answer: D
To group all five names automatically, you should use Manual Selection as a grouping option in Tableau Prep. Manual Selection is a feature that allows you to select values from your data and group them together based on your criteria. You can use Manual Selection by clicking on Group Values in Profile pane > Manual Selection from the menu. This will open a dialog box where you can select values from your data and assign them to a group. In this case, you want to group all five names together based on their spelling variations. You can use Manual Selection by selecting all five values from your data and assigning them to a group named "Harry Potter". This will create a new field named Grouped Field that contains "Harry Potter" as one value. The other options are not correct for this scenario. Pronunciation is a feature that groups values based on how they sound, but it may not work well with names or uncommon words. Spelling is a feature that groups values based on common spelling errors or typos, but it may not recognize all variations or synonyms. Common Characters is a feature that groups values based on the number of characters they share, but it may not capture the meaning or context of the values. Reference: https://help.tableau.com/current/prep/en-us/prep_group.htm https://help.tableau.com/current/prep/en-us/prep_group_manual.htm
Question 13
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?
Correct Answer: C
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-6d1f1 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.
Question 14
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2. You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook. Which object should you add to the dashboard?
Correct Answer:
The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation. Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it. You can learn more about navigation objects and how to use them in this article: https://help.tableau.com /current/pro/desktop/en-us/dashboards_navigation.htm
Question 15
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.
Correct Answer:
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
