Connecting to & Preparing Data

c. Left

This type of join will include all values from the left table: a. Inner b. Right c. Left d. Blend

b. The workbook does not include any fields with a geographic role of state, city, country, or zip code

If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following: a. The workbook does not include a map b. The workbook does not include any fields with a geographic role of state, city, country, or zip code c. The workbook does not include custom geocoding d. All locations are ambiguous or unknown

a. Add at least one field from the primary data source to your view. Then, in the Data pane, click the data source that you want to designate as the secondary data source and click the broken link icon.

After setting up two data source connections, how can you create a blend? a. Add at least one field from the primary data source to your view. Then, in the Data pane, click the data source that you want to designate as the secondary data source and click the broken link icon. b. On the data sources pane, drag tables from both connections onto the canvas. Then click the venn diagram and select the blending fields. c. On the data source page, double-click New Blend to set up the blend. Drag a table from the left pane to the blend dialog box. d. Select Data, then Edit Relationships, then Select the secondary data source in the Secondary data source pane, select Custom in the relationships list, and then click the Add button.

c. Fields in the union that do not have matching field names will contain null values.

When creating a union between tables, what will happen if the field names do not match? a. Tableau will return an error message, explaining that you must modify the tables so that all tables used in the union have the same field names. b. Tableau will automatically merge the fields, combining fields with similar field names. c. Fields in the union that do not have matching field names will contain null values. d. Fields with non-matching field names will be dropped, so that the union will contain only those fields with matching field names

c. alias

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides? a. field renaming b. hierarchy c. alias d. group

b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx)

Which file type can include an extract? Select all that apply. a. Data Source (.tds) b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx) d. Workbooks (.twb)

b. Which fields are hidden d. The default aggregation for a field

Which of the following is an example of metadata that can be managed in Tableau? Select all that apply. a. The data type of the data in the source database b. Which fields are hidden c. The number of rows in the data d. The default aggregation for a field

a. Selecting "Multiple Table" rather than "Single Tables"

Which of the following is most likely to reduce the size of the extract? a. Selecting "Multiple Table" rather than "Single Tables" b. Using the incremental refresh option c. Materialize calculations with the "Compute Calculations Now" option d. Removing an filter

d. Sort

Which of the following is not a default property which can be set for a measure? a. Number Format b. Color c. Aggregation d. Sort

b. You want to save the default field properties such as number formats and sort order.

Which of the following is the best reason to create a saved data source as a .TDS file? a. Those who wish to use the data do not have access to the underlying data. b. You want to save the default field properties such as number formats and sort order. c. You want to save a snapshot of the data that will not update even when the underlying data changes. d. You need to apply an aggregation that takes too long when using a live connection.

a. Live connection

Which of the following should be used if, for security purposes, you'd like users to enter their database credentials in order to access the workbook: a. Live connection b. Extract c. Hyper d. Packaged data source

d. Blending

Which of the following uses a primary and secondary data source? a. Cross-database joins b. Unions c. Aggregation d. Blending

c. Set the type back to string, then try date conversion functions like DateParse and Date

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work? a. Edit your computer's date settings to that they correspond to the format of the date you're trying to use in Tableau b. Instead of setting the field to Date, set to Date & Time c. Set the type back to string, then try date conversion functions like DateParse and Date d. Switch the metadata grid, then right click the field and select "date format settings"