A consultant is working with a Tableau Server customer. The customer asks the consultant if there is a need to upgrade their instance of Tableau Server that was installed over 1 year ago.
Which two situations justify the need for an upgrade? Choose two.

• A. The security team has a report of bugs and security vulnerabilities in older versions of Tableau
• B. The need to access new features and improvements from Tableau Cloud
• C. Compatibility with newer Tableau Desktop and Prep Builder versions that users might want to install
• D. Users are complaining of performance; the upgrade will reduce the server's hardware requirements

A consultant used Tableau Data Catalog to determine which workbooks will be affected by a field change.
Catalog shows:
* Published Data Source # 7 connected workbooks
* Field search (Lineage tab) # 6 impacted workbooks
The client asks: Why 7 connected, but only 6 impacted?

• A. The field being altered is not used in the seventh workbook.
• B. The consultant lacked sufficient permissions to see the seventh workbook.
• C. The seventh workbook is connected via Custom SQL so it didn't appear in the list.
• D. The field is used twice in a single workbook.

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there is a performance difference among these three data types.
What should the consultant tell the customer?

• A. Integers are fastest, followed by Booleans, and then strings.
• B. Booleans are fastest, followed by integers, and then strings.
• C. Strings are fastest, followed by integers, and then Booleans.
• D. Strings, integers, and Booleans all perform the same.

A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?

• A. [Sales]
  >
  { FIXED [Order ID] : SUM([Sales]) }
• B. { FIXED [Order ID] : SUM([Sales]) }
  >
  { INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }
• C. { FIXED [Order ID] : SUM([Sales]) }
  >
  { FIXED [Region] : SUM([Sales]) }
• D. { FIXED [Order ID] : SUM([Sales]) }
  >
  { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?

• A. CASE [Sector Parameter]
  WHEN 1 THEN "green"
  WHEN 2 THEN "yellow"
• B. SUM([Profit])/SUM([Sales])
• C. POWER(ZN(SUM([Sales]))/
  LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))- 1END
• D. ZN([Sales])*(1 - ZN([Discount]))