Question 1

In a Tableau workbook, you are tasked with calculating the total quarterly sales for each salesperson in each region. The data includes sales figures for multiple salespersons across different regions.What is the best approach to achieve this calculation?

Options :

A : Aggregate total sales at the global level, then use filters to view sales by salesperson and region

B : Use an INCLUDE Level of Detail (LOD) expression to sum sales for each salesperson within each region

C : Create a calculated field that sums up sales for each salesperson, irrespective of region

D : Implement a WINDOW_SUM function to calculate the total sales across all regions and salespersons

Answer: B

Question 2

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 3

A Tableau consultant is working on a sales analysis project. The client needs to identify which sales transactions were above the average transaction value for each month.What type of calculation is needed to identify these transactions in Tableau?

Options :

A : A calculated field that flags transactions above the monthly average using a basic arithmetic calculation

B : A window average calculation to compare each transaction against the average for that month

C : A fixed level of detail (LOD) expression to calculate the average transaction value per month, and then flag transactions above this average

D : A percentile rank calculation to identify transactions in the top percentile for each month

Answer: C

Question 4

Your organization is using Tableau’s Data Catalog to support its governance strategy.How can the Data Catalog assist in ensuring that only certified and approved data sources are used for analysis?

Options :

A : Implement Data Catalog to automatically update and certify new data sources

B : Use Data Catalog to provide detailed metadata and certification status of data sources, helping users identify approved sources

C : Configure Data Catalog to delete uncertified data sources automatically

D : Leverage Data Catalog to increase the storage capacity for certified data sources only

Answer: B

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

Free Analytics-Con-301 Mock Exam – Practice Online Confidently

Buying Options: