0% Consultant – Free Exam This Free Exam addresses 17 of 39 topics of the course outline. All 39 Topics are covered in the full set of 5 Exams series and here is the Google Sheet to show you that visibility This Tableau Certified Consultant Free practice exam is a simulation with few sample Questions that need to be completed in 120 minutes. Passing score is 75 %. 1 / 17 Cons-F-T-10 Identify the correct statement? In order to highlight a specific dimension in your dashboard sheet without filtering out the other data points. You can use the Highlight filter action. But it works only when you are connected with a live data source. In order to highlight a specific dimension in your dashboard sheet without filtering out the other data points. You can use the Parameter filter action. In order to highlight a specific dimension in your dashboard sheet without filtering out the other data points. You can use the Highlight filter action. In order to highlight a specific dimension in your dashboard sheet without filtering out the other data points. You can use the dashboard navigation filter action. Your given answer is wrong Your given answer is correct Solution In order to highlight a specific dimension in your dashboard sheet without filtering out the other data points. You can use the Highlight filter action. All other options are in correct. For reference you can study the concept from the following https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_advanced.htm 2 / 17 Cons-F-T-1016 – Tableau Server has three sites Finance, Marketing, and Strategic. When moving to the cloud what architecture you can advise. 2 instances and three sites each 1 instance and three site Three instances and three sites on each Three instances and one site on each Your given answer is wrong Your given answer is correct Solution 1 instance and three site would be appropriate option for the given scenario We recommend the following article to go through for enhancing your knowledge on the blue prints topic https://help.tableau.com/current/blueprint/en-us/bp_move_to_cloud.htm 3 / 17 Cons-F-T-6. Identify the correct statement Tableau catalog is an option to index all the content on the Tableau site, including workbooks, data sources, and flows. Tableau data dictionary is an option to organize and index all the content on the Tableau site, including workbooks, data sources, and flows. Metadata is an option to organize and index all the content on the Tableau site, including workbooks, data sources, and flows. Askdata is an option to organize and index all the content on the Tableau site, including workbooks, data sources, and flows. Your given answer is wrong Your given answer is correct Solution Tableau catalog is an option to index all the content on the Tableau site, including workbooks, data sources, and flows. 4 / 17 Cons-F-T-9 While working with a consulting company, they ask you to have a visualization that can show their sales team members along with their targets assigned and their achievement. What type of visualizations do you think can be worked out for the given scenario? (select all that apply) A Pareto chart can be plotted to show the sales team, their target value, and achievement A bar-in-Bar chart can be plotted to show the sales team, their target value, and achievement A stacked Bar chart can be plotted to show the sales team, their target value, and achievement A bullet chart can be plotted to show the sales team, their target value, and achievement Your given answer is wrong Your given answer is correct Solution A bar-in-Bar chart can be plotted to show the sales team, their target value, and achievement A bullet chart can be plotted to show the sales team, their target value, and achievement 5 / 17 Cons-F-T-5: You work for a consulting company, One of your clients wants to share their newly developed dashboards with their customers who do not have Tableau licenses as of now. What would you advise them so the customers can use the insights given in the dashboards? You can advise the client to suggest the customers take Tableau licenses in order to view the dashboard packaged files You can advise the client to suggest a basic license to its customers so they can view the dashboards You can advise the client to suggest using Tableau reader to view your packaged files for the dashboards to view You can advise the client to suggest a Tableau cloud license to its customers so they can view the dashboards Your given answer is wrong Your given answer is correct Solution You can advise the client to suggest using Tableau reader to view your packaged files for the dashboards to view 6 / 17 Cons-F-T-1085: You are working with a client on building visualization for employees. The data set provided to you is an excel file which has a column which data in this format <Country>.<DepartmentName>.<EmployeeCount> Faisalabad.Finance.23Lahore.Finance.54Punjab.Finance.67 You need to use them in the view showing the count of employees as a bar graph. In order to use it, you need to extract the count in the form of a measure, how can you extract this information? (Select the most appropriate way a consultant should opt) You can use the split function and use the period (.) sign as a column separator and then use the field created by the split function which contains the count of employees. You should use the END function to extract the rightmost digits and use it as a calculated field. You have to advise the client to modify the data in Excel file and give information in the form of three columns instead of providing in a single column You can use the TRIM function and discard the country and department information keeping only the employee count Your given answer is wrong Your given answer is correct Solution You can use the split function and use the period (.) sign as a column separator and then use the field created by the split function which contains the count of employees. 7 / 17 Cons-F-T-1007 – Below are two exhibits, One shows the existing format of the data and the other shows the expected data format. Which tool you should use to achieve the desired results most suitably and efficiently? Existing Format of Data Customer ID Product Purchased CAN-2015-15001 Alpha IND-2019-15002 Beta PAK-2024-15003 Gamma USA-2025-15004 Theeta Needed Format Customer ID Product Purchased Location Customer Sequence CAN-2015-15001 Alpha CAN 15001 IND-2019-15002 Beta IND 15002 PAK-2024-15003 Gamma PAK 15003 USA-2025-15004 Theeta USA 15004 Use Tableau Prep to achieve this result Use a calculated field to get the job done Use Database Level Customization to convert data into the needed format Split Function of the Tableau Desktop Your given answer is wrong Your given answer is correct Solution Split Function of the Tableau Desktop we recommend the following article to further enhance your knowledge https://help.tableau.com/current/pro/desktop/en-us/split.htm 8 / 17 Cons-F-T-1011 – It is noticed that some users are accessing the reports for which they are not allowed. Upon checking it is found that the parent folder has restricted access but it is not applied to the nested folders and reports under the project due to which users have access to the reports in child folders. In order to give the controlled access, you apply the permission to the nested folder, What action it will do? It will notify the users to whom the access will be revoke Permission will not applicable to the users unless they logoff and login Applying the the permission will immediately revoke permission with a notification to users Applying the the permission will immediately revoke permission without any notification Your answer is wrong Your answer is correct Solution Permission will not applicable to the users unless they logoff and login This is a very important topic and more questions can be expected from this topic, we recommend to go through following link to have more knowledge and grip on the subject https://help.tableau.com/current/server/en-us/permissions_projects.htm 9 / 17 Cons-F-T-7 You visit one of your customers where self-service is enabled and users are able to access the published data sources and create views as per their business need but they share that they are having a problem identifying the accurate data sources as there are many data sources related to the same domain, how can you help them in this situation? Ask them to adopt the categorize the data sources and keep only one data source per domain to avoid the confusion Ask them to certify the published data sources Ask them to adopt the right naming convention with the date stamp to identify the latest one Ask them to create a monthly house-keeping deleting all un-used and stale data sources and keeping only the updated ones Your given answer is wrong Your given answer is correct Solution Ask them to certify the published data sources 10 / 17 Cons-F-T-1001 – A Dashboard has been developed and the client wants that when the user makes a login to the salesforce, he should see the newly developed Tableau Dashboard. How you can achieve it User Tableau Einstein to embed your dashboard into Salesforce Embed tableau dashboard in the Salesforce Create links and show to user after his login Create favorites in Salesforce to open the Tableau Dashboard Your given answer is wrong Your given answer is correct Solution Embed tableau dashboard in the Salesforce You can easily embed Tableau views into Salesforce Lightning pages using the Tableau Viz Lightning web component that is available from the Salesforce AppExchange. When you edit a Lightning page, you simply drag and drop the Tableau Viz Lightning web component onto the page and then provide the URL for the Tableau view. You can embed Tableau views from Tableau Server, Tableau Cloud, or Tableau Public. The Tableau Viz Lightning web component supports all versions of Tableau. Using the Tableau Viz Lightning web component, Salesforce administrators and developers can quickly integrate Tableau dashboard into Salesforce pages. We strongly recommend to read the article given below in full as you can expect more questions related to Salesforce and Tableau in the exam For Reference see the link below https://help.tableau.com/current/pro/desktop/en-us/embed_ex_lwc.htm 11 / 17 Cons-F-T-1002 – A Client wants to create a custom dashboard that should be able to show the data sources used most frequently in the environment. As a consultant how can you achieve the development of this dashboard? (Select the most appropriate answer) Use the Tableau Repository to get the needed information to be used in the dashboard Use Data Management tool to get the desired information Use the Tableau Catalog to get the desired information Use PreBuilt Admin View Available on the Tableau Server Use GraphiSQL to get the related data and use it the dashboard Your given answer is wrong Your given answer is correct Solution You can get this information either through connecting Tableau Repository or by using the pre-built admin views. Since in the question they are asking to develop a custom dashboard that can done by connecting to Tableau Repository and using it as a data source so appropriate answer would be through connecting Tableau Repository We recommend you study the following two article to enhance your exposure for the topic https://community.tableau.com/s/question/0D54T00000C5SCsSAN/how-to-find-data-source-access-views-count-from-repository https://help.tableau.com/current/server/en-us/adminview_datasources.htm 12 / 17 Cons-F-T-1003 – There is a dashboard developed to show the trend of customers and their insurance claims. In the database sources , it is a join for two tables Claims and Customers. Upon checking, the client complains that the trend is showing incorrect results. Note that the Claims table contains many claims for customers and the Customers table contains many customers. What action you would take to investigate the issues and how to fix it? User the Relations to get the correct results Use the blend option to connect to tables Use the Cross Database join to connect the tables Use the Physical Joins to fix the issues Your given answer is wrong Your given answer is correct Solution User the Relations to get the correct results As questions shows that data in both tables have many to many relation so using RELATION would be an appropriate option for the given scenario 13 / 17 Cons-F-T-11: You are working for a client and they need to prepare an animated visualization to highlight changing patterns in the data. This visualization has a few simple charts which should quickly transition to show any value changes when the end users interact with quick filters. Advise if it is possible and if yes how would you achieve it? This type of animation is possible if we have an advanced license of Tableau Desktop. This animation is very much possible and we need to use the synchronous animation style in order to bring the effect of what the client is asking. This animation is very much possible and we need to use the sequential animation style in order to bring the effect of what the client is asking. This animation is very much possible and we need to use the simultaneous animation style in order to bring the effect of what the client is asking. Your given answer is wrong Your given answer is correct Solution This animation is very much possible and we need to use the simultaneous animation style in order to bring the effect of what the client is asking. 14 / 17 Cons-F-T-1008 – A Client had extract-based data source already published on the Tableau Server, There was a migration and a change in a recent update in the Published data source is not working fine, How can you restore the previously published data source. Make sure to opt for the method to has minimal impact on the business users. Go with Online Edit option where users will not impacted with any change Download the latest, fix the issue and republish it again Download the Previous version, refresh it and upload again Go to restore the older version from the Tableau Server Delete the latest one and Publish Again Your given answer is wrong Your given answer is correct Solution Download the Previous version, refresh it and upload again. For a variety of reasons—for example, extracts commonly are on refresh schedules—a previous revision of a data source will not include the extract as it was published at the time. To restore the extract, you can download the previous revision of the data source (in .tdsx format), open it in Tableau Desktop, and re-publish the extract. We recommend reading this article https://help.tableau.com/current/pro/desktop/en-us/qs_revision_history.htm 15 / 17 Cons-F-T-8 – You visit a customer who is in the process of analyzing the tornado occurrences in Japan, they have a data set containing the geolocation of the tornado-occurring areas. As a consultant, you are there to advise them and highlight and identify the areas which are more prone to tornados. Which chart visualization do you think will be suitable to develop in this situation? You advise them to create a density map to identify the areas prone to tornadoes You advise them to create a box-and-whisker plot to identify the areas prone to tornadoes You advise them to create a bubble map as the greater the size of the bubble greater it will be prone to tornadoes You advise them to create a heap map chart to identify the areas prone to tornadoes Your given answer is wrong Your given answer is correct Solution You advise them to create a density map or density map to identify the areas prone to tornadoes Density maps or Heat Maps help you identify locations with greater or fewer numbers of data points. They are most effective when working with a data set containing many data points where there’s substantial overlap between the marks on the map. https://help.tableau.com/current/pro/desktop/en-us/maps_howto_heatmap.htm 16 / 17 Cons-F-T-1013 – You have a requirement to migrate a data source, How you will identify the workbooks that are connected to the data source that is planned to be migrated. Tableau Catalog is the option that should be used Tableau Meta Data is right option for the given scenario Content Migration Tool would be a suitable choice Tableau Repository can help you to get this information Your given answer is wrong Your given answer is correct Solution For a detailed understanding of the topic, refer the article below https://help.tableau.com/current/server/en-us/perf_collect_server_repo.htm?_gl=1*mk74sv*_ga*NDAzODUyNDY2LjE3MDU3MTg1NDg.*_ga_8YLN0SNXVS*MTcwNTc2Nzg5OS4yLjEuMTcwNTc3MDI4Ny4wLjAuMA.. 17 / 17 Cons-F-T-1 :3 There is a dashboard that contains data for customer master, the table contains around 0.1 million records. The customers’ table does not have timestamps or update time columns. What type of extract should be created for such data source so that the most updated information should be reflected in the report? Extract based on the Full refresh is suitable for the given scenario Extract based on custom refresh will be most suitable for the given scenario Extract based on the Incremental refresh should be created based on the customer segment to reflect the updated data Extract based on the incremental refresh with the option to refresh all rows should be created Your given answer is wrong Your given answer is correct Solution Extract based on the Full refresh is suitable for the given scenario Your score is 0% Restart quiz Rate this Practice exam Appreciate if you spare couple of minutes to give feedback on our quality and your overall experience with us. It will help us to understand and server you better. Send feedback 5 Reason why people fail in Tableau Exams In this short video, we are sharing you five reason why people in Tableau exms. Additionally, we are sharing the tips how you can avoid. Back to the Free Exams Page Know more about our Paid practice exams for Tableau Consultant