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?
Answer(s): C
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.
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.
You have the following dataset in Microsoft Excel.You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.How many rows of data will be ingested into Tableau as values?
Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:It removes the first three rows and the last two rows that contain headers and footers. It splits the merged cells in column A and fills in the missing values with "Fiction" or "Non-Fiction".It does not remove or change any other rows or cells.Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers.
https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htmBased on the Data Interpreter's results and the provided Excel dataset screenshot, the number of rows of data that will be ingested into Tableau as values is 17. The Data Interpreter has identified and excluded headers and footers, and the rows with actual data are considered for analysis.
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?
Answer(s): B
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.htmTo 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.
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?
Answer(s): A
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.
https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm https://help.tableau.com/current/pro/desktop/en-us/join_types.htmWhen 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.
HOTSPOT (Drag and Drop is not supported)You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.You have a worksheet that shows the orders from 2019.You need to configure the worksheet to show the orders from 2020 without reloading the data.Which option should you select?
Replace Data SourceReplace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the dat a. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.To replace the data source, you need to do the following steps: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 original 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 the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
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
Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Certified Tableau Data Analyst content, but please register or login to continue.