What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
Correct Answer: B
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends: In addition to handling calculations slightly differently, there are some limitations on secondary data sources. You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.
Question 27
True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.
Correct Answer: B
Graphical user interface, application Description automatically generated Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them. If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.
Question 28
What is the minimum amount of RAM recommended for any production use of Tableau Server?
Correct Answer: C
Explanation The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server. These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.
Question 29
Larger image What is this view referred to as in Tableau?
Correct Answer: C
Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace. The Data pane includes: Dimension fields - Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments. Measure fields - Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency. For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green. Calculated fields - If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields. For more information on calculated fields, see Create Custom Fields with Calculations. Sets - Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets. Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau. Parameters - Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.
Question 30
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
Correct Answer: B
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access. Create a .twbx with file-based data sources 1) Select File > Save As. 2) Specify a file name for the packaged workbook in the Save As dialog box. 3)Select Tableau Packaged Workbooks on the Save as type drop-down list. 4) Click Save. 5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose. The following files are included in packaged workbooks: --> Background images --> Custom geocoding --> Custom shapes --> Local cube files --> Microsoft Access files --> Microsoft Excel files --> Tableau extract files (.hyper or .tde) --> Text files (.csv, .txt, etc.)
