Question 1

During a Tableau project, a consultant notices that the data extracted from an external API into Tableau Desktop is incomplete, missing several key fields that are present in the API.What should be the first step in troubleshooting this data extraction issue?

Options :

A : Reconfigure the entire data connection in Tableau Desktop

B : Verify the API query or the data extraction logic to ensure all required fields are included

C : Check for updates to Tableau Desktop that might resolve data extraction bugs

D : Immediately contact the API provider to report a data inconsistency issue

Answer: B

Question 2

A consultant is designing a Tableau dashboard for a retail client to analyze daily sales data. The client wants the dashboard to reflect sales changes as they occur throughout the day.Which type of calculation should the consultant primarily use in the Tableau workbook for this purpose?

Options :

A : Static calculations that are predefined in Tableau Prep

B : Responsive calculations in the Tableau workbook that update in real-time with data changes

C : Calculations based solely on historical sales data, updated monthly

D : Manual calculations updated by the client at the end of each day

Answer: B

Question 3

A Tableau workbook connected to a large database is experiencing slow response times. You identify that a particular view is causing long query times due to its use of multiple resource-intensive calculated fields.What is the most effective way to improve the performance of this view?

Options :

A : Add more indexes to the database tables

B : Optimize the calculated fields to be less resource-intensive

C : Increase the network bandwidth between Tableau Server and the database

D : Use a larger number of filters in the view to reduce data volume

Answer: B

Question 4

You are creating a Tableau report to analyze customer purchasing behavior. The report requires a calculation of the average purchase value per customer, but only for those who have made more than five purchases.Which combination of calculations would accurately fulfill this requirement?

Options :

A : Use a FIXED LOD expression to calculate the total purchase value per customer and divide it by the total number of purchases for each customer using a BASIC calculation

B : Implement a calculated field using COUNTD to count the number of purchases per customer, and then use a WINDOW_AVG function to calculate the average purchase value for customers with more than five purchases

C : Create a nested LOD expression: first, use a FIXED LOD to identify customers with more than five purchases, then use another FIXED LOD to calculate the average purchase value for these customers

D : Apply a BASIC calculation to find the average purchase value for all customers and then use a filter to display only customers with more than five purchases

Answer: C

Question 5

When evaluating a retail company’s data structure in preparation for Tableau implementation, what aspect should the consultant examine to ensure the data supports effective inventory management?

Options :

A : The color coding used in the company-s inventory reports

B : The depth and timeliness of inventory data, including stock levels and supply chain details

C : The personal preferences of the retail company-s CEO regarding data reporting formats

D : The geographical distribution of the company-s retail outlets

Answer: B