Q1. A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access:

Group 1: Viewers who cannot see any information on profitability

Group 2: Viewers who can see profit and profit margin

Group 3: Viewers who can see profit margin but not the value of profit

Which approach should the consultant use to provide the required level of access?

Q2. A client wants to see data for only the most recent day in the dataset that is updated intermittently. The solution should offer the best caching performance.

Which approach should the consultant use to produce the desired results?

Q3. A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:

Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}

The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.

The client asks a consultant to rewrite the calculation so the result meets their expectation.

Which calculation should the consultant use?

Q4. A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes:

All files have the same schema.

Multiple files have something in common among their file names.

Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

Q5. A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect:

IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END

Which calculation will produce the correct result?