최신Salesforce Certified Tableau Data Analyst - Analytics-DA-201무료샘플문제
문제1
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
Every record must have a full name.
Which type of join should you use?
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
Every record must have a full name.
Which type of join should you use?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
정답: A
문제3
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
You have a workbook that uses an extracted data source.
You publish the workbook to Tableau Server.
Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.
You have a workbook that uses an extracted data source.
You publish the workbook to Tableau Server.
Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.
정답: A,B,E
문제5
A Data Analyst would like to receive the draft results of a colleague's Tableau Prep flow to start work on a dashboard before it has been published.
What should the analyst do to accomplish this?
A Data Analyst would like to receive the draft results of a colleague's Tableau Prep flow to start work on a dashboard before it has been published.
What should the analyst do to accomplish this?
정답: D
문제6
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?
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?
정답: B
문제7
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
정답:
check the steps below in explanation.
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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 Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
* Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
* Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
* Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm https://help.tableau.com/current/pro
/desktop/en-us/maps_howto_filled.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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 Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
* Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
* Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
* Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm https://help.tableau.com/current/pro
/desktop/en-us/maps_howto_filled.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm
문제8
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
정답: A