Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . When should you use data blending to combine data?A . When the data will be in multiple worksheets within a workbook B .

1. When should you use data blending to combine data?A. When the data will be in multiple worksheets within a workbook B. When using data source that cannot be combined with the default method of using a relationship C. When the data is from same connection D.When the data has the same structure but it is for different time period.
2. When should you use a union to combine data? A. when the data is at different levels of detail. B. When the data comes from different data connections. C. When the data will be used to add new field columns. D. When the data has the same structure
3. A field named Product has a format of ID-Name-Description. you plan to separate the field into two fields and use a hyphen ("-") as a separator. What action will result in only one new field that contains Description? A. A custom split on "-" and the last column of the Product field B. A default split on the Product field. C. A csuton split on "-" and the first column of the Product field. D. A custom split on "-" and all columns of the Product field
4.A teacher has a table named Class that contains the names of the students in the teacher's class and a table named After-School that contains the names of the students in the school's after-school program. The Class table is on the left and the After-school table is on the right. Which type of join should you use to build a view that displays only the students in the class that ateen the after-school program. A. Left B.Inner when C. Right D. Full outer
5. When should you use an extract instead of a live connection? A. When data sources are hosed on-premises. B. when you plan to use Tableau Prep Builder. C. When maximum security is required for the data. D. when connections to a database are By very slow.
6. By default, what does Tableau do when you connect to data? A. Creates new tables in the data source. B. Brings your actual data file into Tableau. C. Creates a live connection to the data. D. Creates an extract, or snapshot, of the data
7.You are building a view that includes Cost and Sale Price data. When you add the Cost field to the view, a prefix of $ is included. When you add the Sale Price field to the view, no prefix is included. But you want the $ prefix to be included for the Sale Price field, too. What should you do? A. edit the attributes for the Sale Price field. B. Change the data type for the Sale Price field. C. Edit the default properties for the Sale Price field. D. Create an alias for the Sale Price field.
8. You have made changes to the structure of a data set, such as renaming fields used in the view. This has resulted in broken references in your vuz, What step should you take to fix the broken references? A. delete the renamed field B. reconnect to the data source. C. close and reopen the worksheet. D. replace all reference.
9. what would you select if you wanted your prep sample to return a representative sample from all rows? A. the default sample size B. a sampling method of quick select C. a sample size of a fixed number of rows D. a sampling method of random sample
10. You have a table named Rainfall_1 and a table named Rainfall_2. You need to combine the data from the two tables in Tableau Prep. The combined table must match the structure in Rainfall_2. What should you do first? A. Combine the two tables by using a union. B. In RainFall_1, pivot rows to columns C. In Raindall_1, pivot columns to rows D. Combine the two tables by using a join

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions