Question 1

A consultant is evaluating the data lineage in a client’s existing data warehouse to prepare for Tableau integration.What is a crucial aspect to assess in this evaluation?

Options :

A : The visual appeal of the current data warehouse-s interface

B : The complexity of relationships and transformations within the data warehouse

C : The brand of servers used for the data warehouse

D : The physical location of the data warehouse servers

Answer: B

Question 2

A Tableau consultant is designing a dashboard for a client who wants to track the average time to sell products after their release. The data includes product release dates and sale dates.Which calculation should the consultant implement to meet this requirement in Tableau?

Options :

A : A calculated field to count the number of days between the product release date and the sale date for each product

B : A level of detail (LOD) expression to find the average number of days from release to sale for all products

C : A table calculation to calculate running average time from release to sale for each product category

D : A fixed calculation to compare the release and sale dates for each product

Answer: B

Question 3

You use a performance recording to diagnose a slow Tableau workbook and discover that the most time-consuming part is “Computing Layouts” for multiple complex dashboards.What is the most effective approach to improve the performance of these dashboards?

Options :

A : Simplify the dashboard layouts by reducing the number of complex visualizations

B : Upgrade the hardware of the Tableau Server for better performance

C : Convert the data sources from live connections to extracts

D : Rebuild the dashboards using only basic visualizations

Answer: A

Question 4

In a Tableau workbook, you’ve used a WINDOW_SUM calculation to show a running total of sales. However, users report that the running total resets unexpectedly when changing pages of a paginated report.What is the most likely reason for this issue?

Options :

A : The calculation is not correctly referencing the entire data set across pagination

B : There is an error in the formula of the WINDOW_SUM calculation

C : The workbook lacks the computational power to handle the WINDOW_SUM calculation across multiple pages

D : The data source does not support WINDOW_SUM calculations across multiple pages

Answer: A

Question 5

In a Tableau workbook, you need to calculate the average sales for each product category, but only for stores that are in the top 10% in terms of overall sales volume.Which approach should you use to accurately perform this calculation?

Options :

A : Use a FIXED LOD expression to calculate total sales per store, then use a RANK function to identify the top 10% of stores, and finally calculate the average sales for each category within these stores

B : Implement a FIXED LOD expression to calculate the average sales per category across all stores, then apply a filter to select the top 10% of stores

C : Apply a FIXED LOD expression to first calculate the average sales per category, then use a nested FIXED LOD to focus on the top 10% of stores

D : Utilize an INCLUDE LOD expression to calculate average sales per category, then use a filter to limit the calculation to the top 10% of stores

Answer: A

Higher Test Marks with Free Online Analytics-Con-301 Exam Practice

Buying Options: