Certified Tableau Consultant practice questions, page 3 of 3, with answer review and explanations.
Question 11
A client wants to know which Tableau products to use to meet the following requirements. Regulatory requirements state that all data must remain in the on-premises datacenter. Prepare large datasets, including cleaning, shaping, and combining data sources. Develop dashboards to deliver insights on the data. Which solution should the consultant recommend?
Use Tableau Prep to prepare the data. Use Tableau Desktop to build data visualizations. Use Tableau Server to secure and share visualizations across the organization.
Use Tableau Prep to prepare the data. Use Tableau Desktop to build data visualizations. Use Tableau Cloud to secure and share visualizations across the organization.
Use Tableau Desktop to model the data. Use Tableau Desktop to build data visualizations. Use Tableau Cloud to secure and share visualizations across the organization.
Use Tableau Desktop to model the data. Use Tableau Prep to build data visualizations. Use the JavaScript API to secure and share visualizations across the organization.
Question 12
A client’s fiscal calendar runs from February 1 through January 31. How should the consultant configure Tableau to use the client’s fiscal calendar when building date charts?
Edit the data source and set the Fiscal Year in the data preview window.
Right click on the Date axis in charts and select Use Fiscal Calendar.
Edit the data source Date Properties, then update the Default Properties of the Date Fields.
Create Calculated Fields using the FISCALQUARTER() and FISCALYEAR() functions.
Question 13
A company has a Tableau dashboard that visualizes healthcare cost trends over time. The dashboard is connected to an extracted data source that uses Custom SQL to join two tables: a Claims table storing healthcare claims and a Members table storing member demographics. Each member can have many records in the Claims table, and each member can also have many records in the Members table. Stakeholders at the company discover that the dashboard shows inaccurate trending data. Members’ claim costs are multiplied by the number of records the members have in the Members table. A consultant must resolve this issue while optimizing dashboard performance and ease of maintenance. Which approach should the consultant use to solve this issue and meet the requirements?
Replace the Custom SQL with a relationship between two Logical Tables: Members and Claims.
Use Level of Detail (LOD) calculations to ensure that claim costs are captured at the right granularity.
Use Table Calculations to ensure that claim costs are captured at the right granularity.
Replace the Custom SQL with a join between two Physical Tables: Members and Claims.
Question 14
A customer migrated from Tableau Server to Tableau Cloud. However, there is still private network data behind the corporate firewall that Tableau Cloud needs to access securely. Which data connection strategy should a Tableau consultant advise with minimal software maintenance by the customer?