Free Salesforce Analytics-DA-201 Practice Test & Real Exam Questions
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?
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
A Data Analyst creates the following story that contains two story points.
The analyst wants to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should the analyst use?
The analyst wants to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should the analyst use?
Correct Answer: B
Vote an answer
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
You want to make the workbook available in Tableau Online.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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?
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?
Correct Answer:
Explanation:
Replace Data Source
Replace 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 data. 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.
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
A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
Correct Answer: D
Vote an answer
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
Correct Answer: A,E
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
Correct Answer: A
Vote an answer
