[Jun 11, 2024] Get Up-To-Date Real Exam Questions for TCC-C01 with New Materials [Q11-Q30]

[Jun 11, 2024] Get Up-To-Date Real Exam Questions for TCC-C01 with New Materials

Updated TCC-C01 Certification Exam Sample Questions

NEW QUESTION # 11
A client is using the Tableau Content Migration Tool to move content from an old Tableau Server to a new Tableau Server.
Which content will need to be moved using a different tool or process?

• A. Workbooks
• B. Published data sources that use live connections
• C. Published data sources that use extracts
• D. Tableau Prep flows

Answer: D

Explanation:
When migrating content between Tableau servers, certain types of content may require special consideration or different tools for migration:
* Tableau Prep Flows: These are specific to Tableau Prep and are not included in the standard content migration capabilities of the Tableau Content Migration Tool. Tableau Prep flows often require separate processes for migration due to their distinct setup and integration with data sources and workflows.
* Published Data Sources and Workbooks: These can typically be migrated directly using the Tableau Content Migration Tool, which supports moving published data sources (both live connections and extracts) and workbooks without requiring additional tools.
References:
* Tableau Help and Support: Offers comprehensive tutorials and guidelines on using different tools for migrating various types of content, including the specific requirements for migrating Tableau Prep flows which are not covered by the standard content migration tool.

NEW QUESTION # 12
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?

• A. ZN([Sales])*(1 - ZN([Discount]))
• B. SUM([Profit])/SUM([Sales])
• C. POWER(ZN(SUM([Sales]))/
  LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))
  - 1
  END
• D. CASE [Sector Parameter]
  WHEN 1 THEN "green"
  WHEN 2 THEN "yellow"

Answer: B

Explanation:
To improve performance by moving calculations to the data layer and materializing them in the extract, the consultant should choose calculations that benefit from pre-computation and significantly reduce the load during query time:
* Aggregation-Level Calculation: The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an aggregate level, which is ideal for pre-computation. Materializing this calculation in the extract means that the complex division operation is done once and stored, rather than being recalculated every time the report is accessed.
* Performance Improvement: By pre-computing this aggregate ratio, Tableau can utilize the pre-calculated fields directly in visualizations, which speeds up report loading and interaction times as the heavy lifting of data processing is done during the data preparation stage.
References:
* Materialization in Extracts: This concept involves pre-calculating and storing complex aggregations or calculations within the Tableau data extract itself, improving performance by reducing the computational load during visualization rendering.

NEW QUESTION # 13
A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?

• A. Filter with the table calculation used to create labels.
• B. Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())
• C. Use a calculation with TOTAL() function instead of a quick table calculation.
• D. Add the [Profit] filter to the context.

Answer: D

Explanation:
When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.
References:The solution is based on the principles of context filters and their order of operations in Tableau, which are documented in Tableau's official resources and community discussions123.
When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a "context filter," which effectively changes how data is filtered in calculations:
* Create a Context Filter: Right-click on the profit filter and select "Add to Context". This action changes the order of operations in filtering, meaning the context filter is applied first.
* Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.
* View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.
References:
* Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.

NEW QUESTION # 14
A client has a large data set that contains more than 10 million rows.
A consultant wants to calculate a profitability threshold as efficiently as possible. The calculation must classify the profits by using the following specifications:
. Classify profit margins above 50% as Highly Profitable.
. Classify profit margins between 0% and 50% as Profitable.
. Classify profit margins below 0% as Unprofitable.
Which calculation meets these requirements?

• A. IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• B. IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')
  ELSE 'Unprofitable'
  END
• C. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• D. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSEIF [ProfitMargin] <0 Then 'Unprofitable'
  END

Answer: A

Explanation:
The correct calculation for classifying profit margins into categories based on specified thresholds involves the use of conditional statements that check ranges in a logical order:
* Highly Profitable Classification: The first condition checks if the profit margin is 50% or more. This must use the ">=" operator to include exactly 50% as "Highly Profitable".
* Profitable Classification: The next condition checks if the profit margin is between 0% and 50%. Since any value falling at or above 50% is already classified, this condition only needs to check for values greater than or equal to 0%.
* Unprofitable Classification: The final condition captures any remaining scenarios, which would only be values less than 0%.
References:
* Logical Order in Conditional Statements: It is crucial in programming and data calculation to ensure that conditions in IF statements are structured in a logical and non-overlapping manner to accurately categorize all possible values.

NEW QUESTION # 15
A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?

• A. Use user groups defined on Tableau Server to build user filters in the report's data source.
• B. Add user filters from Tableau Server to each worksheet and select only sales and marketing user groups.
• C. Grant access to the report on the Tableau Server only to the members of sales and marketing user groups.
• D. Prepare a row-level security (RLS) entitlement table to define limitations of the access and use it to build user filters in the report's data source.

Answer: C

Explanation:
The most efficient way to limit report visibility to specific user groups on Tableau Server is to manage permissions directly on the server. By granting access to the report only to the sales and marketing user groups, the client ensures that only members of these groups can view the report. Thismethod is straightforward and does not require the additional steps involved in setting up row-level security or user filters.
References:The approach is supported by best practices in managing user permissions and visibility on Tableau Server, as described in the Tableau Community and official Tableau resources12.

NEW QUESTION # 16
A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query." Which step should the consultant take to resolve this issue?

• A. Replace SUM([Value]) with WINDOW_SUM([Value]).
• B. Replace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
• C. Replace the TOTAL([Opportunities]) calculation with a Grand Total.
• D. Replace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).

Answer: D

Explanation:
To improve the loading time of the pipeline dashboard, which primarily suffers from long query execution times due to a comprehensive Relative Date filter:
* Relative Date Filter Issue: The existing Relative Date filter on "Created Date" covers a broad range (5
* years), leading to significant data processing overhead as it includes granular date calculations over a large dataset.
* Optimized Approach: By replacing the Relative Date filter with a Multiple Values (Dropdown) filter based on YEAR([Created Date]), the filter granularity is reduced. Filtering by year simplifies the query by limiting the volume of data processed and reducing the complexity of the filter condition.
* Implementation Benefit: This approach still provides the flexibility to view data across different years but does so by reducing the load on the database during query execution, which is critical for improving the performance of the dashboard.
ReferencesThis recommendation aligns with Tableau performance optimization strategies, specifically regarding the management of date filters to minimize their impact on query load, as discussed in Tableau performance tuning sessions and guides.

NEW QUESTION # 17
A consultant plans a Tableau deployment for a client that uses Salesforce. The client wants users to automatically see Tableau views of regional sales filtered by customer as soon as the users sign into Salesforce.
Which approach should the consultant use to deliver the final visualization?

• A. Embed views into Salesforce.
• B. Create subscriptions for each view to deliver reports by email.
• C. Create a list of URLs that the users can click in Salesforce.
• D. Publish to Tableau Mobile for viewing.

Answer: A

Explanation:
To ensure that users automatically see Tableau views of regional sales filtered by customer as they sign into Salesforce, embedding the views directly into Salesforce is most effective:
* Embedding Views: Tableau provides capabilities to embed its dashboards into web applications such as Salesforce. This approach ensures that the visualization is part of the Salesforce user interface, enhancing user experience by not requiring users to navigate away from Salesforce to view the data.
* Implement this by using Tableau's embedding code, which can be generated from the Tableau Server for each specific view. Place this embed code into the Salesforce Visualforce pages or use Salesforce Canvas to integrate these views seamlessly.
* This setup allows the Tableau views to inherit user credentials from Salesforce, enabling personalized data visualization based on the user's access rights and region, directly aligned with their Salesforce login session.
ReferencesThe embedding technique is documented in both Tableau's and Salesforce's official integration guides, which provide step-by-step instructions on embedding Tableau views into Salesforce platforms.

NEW QUESTION # 18
From the desktop, open the CCworkbook. Use the US PopulationEstimates data source.
You need to shape the data in USPopulation Estimates by using TableauDesktop. The data must be formatted asshown in the following table.

Open the Population worksheet. Enterthe total number of records contained inthe data set into the Total Recordsparameter.
From the File menu in Tableau Desktop,click Save.

Answer:

Explanation:
See the complete Steps below in Explanation:
Explanation:
To shape the data in the "US Population Estimates" data source and enter the total number of records into the
"Total Records" parameter in Tableau Desktop, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
* Navigate to the Population worksheet by selecting its tab at the bottom of the window.
* Format and Shape the Data:
* Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.
* To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select "Change Data Type" if necessary.
* Calculate Total Number of Records:
* Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".
* Enter the formulaCOUNT([Record ID])orSUM([Number of Records])depending on how the data source identifies each row uniquely.
* Drag this new calculated field onto the worksheet to display the total number of records.
* Enter the Value into the Total Records Parameter:
* Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select
"Edit".
* Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.
* Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.
This process will ensure the data in the "US Population Estimates" is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.

NEW QUESTION # 19
A client has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departments give different answers to the same business questions, and the departments cannot trust the data. The client wants to know what causes data sources to return different data.
Which tool should the client use to identify this issue?

• A. Tableau Catalog
• B. Tableau Prep Conductor
• C. Ask Data
• D. Tableau Resource Monitoring Tool

Answer: A

Explanation:
The Tableau Catalog is part of the Tableau Data Management Add-on and is designed to help users understand the data they are using within Tableau. It provides a comprehensive view of all the data assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify issues such as data quality, data lineage, and impact analysis. In this case, where different departments are getting different answers to the same business questions, the Tableau Catalog can be used to track down inconsistencies and ensure that everyone is working from the same, reliable data source.
References:The recommendation for using Tableau Catalog is based on its features that support data discovery, quality, and governance, which are essential for resolving data inconsistencies across different departments12.
When different departments report different answers to the same business questions using the same databases and tables, the issue often lies in how data is being accessed and interpreted differently across departments.
Tableau Catalog, a part of Tableau Data Management, can be used to solve this problem:
* Visibility: Tableau Catalog gives visibility into the data used in Tableau, showing users where data comes from, where it's used, and who's using it.
* Consistency and Trust: It helps ensure consistency and trust in data by providing detailed metadata management that can highlight discrepancies in data usage or interpretation.
* Usage Metrics and Lineage: It offers tools for tracking usage metrics and understanding data lineage, which can help in identifying why different departments might see different results from the same underlying data.
References:
* Tableau Catalog Usage: The Catalog is instrumental in providing a detailed view of the data environment, allowing organizations to audit, track, and understand data discrepancies across different users and departments.

NEW QUESTION # 20
A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:
Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}
The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.
The client asks a consultant to rewrite the calculation so the result meets their expectation.
Which calculation should the consultant use?

• A. {FIXED [Customer ID], [Region], [Order Date]: COUNTD([Order ID])}
• B. {EXCLUDE [Customer ID]: COUNTD([Order ID])}
• C. {INCLUDE [Customer ID]: COUNTD([Order ID])}
• D. {FIXED [Customer ID], [Region]: COUNTD([Order ID])}

Answer: D

Explanation:
The calculation{FIXED [Customer ID], [Region]: COUNTD([Order ID])}is the correct one to use for this scenario. This Level of Detail (LOD) expression will calculate the distinct count of orders for each customer within each region, which is then averaged per month. This approach ensures that the average number of orders per customer is accurately calculated for each region and then broken down by month, aligning with the client's expectations.
References:The LOD expressions in Tableau allow for precise control over the level of detail at which calculations are performed, which is essential for accurate data analysis.The use of{FIXED}expressions to specify the granularity of the calculation is a common practice and is well-documented in Tableau's official resources12.
The initial calculation provided by the client likely overestimates the average number of orders per customer per month by region due to improper granularity control. The revised calculation must take into account both the customer and the region to correctly aggregate the data:
* FIXED Level of Detail Expression: This calculation uses a FIXED expression to count distinct order IDs for each customer within each region. This ensures that the count of orders is correctly grouped by both customer ID and region, addressing potential duplication or misaggregation issues.
* Accurate Aggregation: By specifying both [Customer ID] and [Region] in the FIXED expression, the calculation prevents the overcounting of orders that may appear if only customer ID was considered, especially when a customer could be ordering from multiple regions.
References:
* Level of Detail Expressions in Tableau: These expressions allow you to specify the level of granularity you need for your calculations, independent of the visualization's level of detail, thus offering precise control over data aggregation.

NEW QUESTION # 21
A client has a dashboard that uses a bar chart to visualize sales by Sub-Category and a detail table that has all the orders for the products within Sub- Category. The table has more than 10,000 rows of data and is slow to load.
A consultant plans to add an action so when the client interacts with the bar chart, only the relevant data appears in the table.
What will provide the fastest rendering of the dashboard?

• A. Add a highlight action and set Target Highlighting to All Fields.
• B. Add a filter action, set "Run action on" to Select, and set "Clearing the selection will" to Exclude all values.
• C. Add a filter action, set "Run action on" to Menu, and set "Clearing the selection will" to Show all values.
• D. Add a highlight action and set Target Highlighting to Sub-Category.

Answer: B

Explanation:
To optimize the dashboard rendering, particularly when dealing with a large dataset, a filter action is the most effective tool. Here's why the specified choice is optimal:
* Add a filter action: This action creates a direct filter on the detail table based on the selection in the bar chart. It ensures that only data related to the selected sub-category is loaded into the table, significantly reducing load time and improving performance.
* Set "Run action on" to Select: This setting means the filter action will be triggered as soon as the user selects a bar in the bar chart. Immediate activation of the filter ensures that the dashboard is interactive and responsive.
* Set "Clearing the selection will" to Exclude all values: When the selection is cleared, this setting ensures that no data is shown, which avoids loading the entire dataset unnecessarily. This maintains performance when no sub-category is actively selected.
ReferencesThis strategy follows Tableau's performance best practices by using actions to limit the amount of data processed and rendered, as detailed in the Tableau User Guide and training materials on Dashboard Actions for optimizing large datasets.

NEW QUESTION # 22
A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The consultant needs to implement a dashboard design that provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?

• A. Build one dashboard and fix the size of the dashboard.
• B. Build one dashboard and set the size to Automatic.
• C. Build one dashboard for each type of device and fix the size of the layouts.
• D. Build one dashboard that has desktop, tablet, and phone layouts, and fix the size of the layouts.

Answer: D

Explanation:
For a consultant designing a dashboard to be consumed across multiple device types, the best approach is:
* Multi-device Layout: Tableau provides the capability to design device-specific layouts within a single dashboard. This feature allows the dashboard to adapt its layout to best fit the screen size and orientation of desktops, tablets, and phones.
* Fixed Size Layouts: By fixing the size of each layout, the consultant can ensure that the dashboard appears consistent and maintains the intended design elements and user experience across devices. Fixed sizes prevent components from resizing in ways that could disrupt the dashboard's readability or functionality.
* Implementation: In Tableau, you can create these layouts by selecting 'Device Preview' and adding custom layouts for each device type. Here, you define the dimensions and the positioning of sheets and controls tailored to each device's typical viewing mode.
ReferencesThis approach leverages Tableau's device designer capabilities, which are specifically designed to optimize dashboards for multiple viewing environments, ensuring a seamless user experience regardless of the device used. This functionality is well documented in Tableau's official guides on creating and managing device-specific dashboards.

NEW QUESTION # 23
A company has a data source for sales transactions. The data source has the following characteristics:
. Millions of transactions occur weekly.
. The transactions are added nightly.
. Incorrect transactions are revised every week on Saturday.
The end users need to see up-to-date data daily.
A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.
What should the consultant do to create and publish the data?

• A. Publish a live connection to Tableau Server.
• B. Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
• C. Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.
• D. Publish an incremental refresh every Saturday.

Answer: B

Explanation:
Given the need for up-to-date data on a daily basis and weekly revisions, the best approach is to use an incremental extract refresh daily to update the data source with new transactions. On Saturdays, when incorrect transactions are revised, a full extract refresh should be performed to incorporate all revisions and ensure the data's accuracy.This strategy allows end users to have access to the most current data throughout the week while also accounting for any necessary corrections12.
References:The solution is based on best practices for managing data sources in Tableau Server, which recommend using incremental refreshes for frequent updates and full refreshes when significant changes or corrections are made to the data12.

NEW QUESTION # 24
A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes:
. All files have the same schema.
. Multiple files have something in common among their file names.
. Each file has a unique key column.
Which data transformation strategy should the consultant use to deliver the best optimized result?

• A. Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).
• B. Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.
• C. Use join option to combine/merge all the files together before doing the data transformation (calculations).
• D. Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.

Answer: A

Explanation:
Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculationZN([Sales])*(1 - ZN([Discount]))is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries.This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.
References:The answer is based on the best practices for creating efficient calculations in Tableau, as described in Tableau's official documentation, which suggests using basic and aggregate calculations to improve performance1.Additionally, the process of materializing calculations in extracts is detailed in Tableau's resources2.
Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:
* Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process.
* Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward.
* Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file.
References:
* Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation.

NEW QUESTION # 25
A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.
Which dashboard building strategy will deliver the desired result?

• A. Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.
• B. Recommend that the client model for only profitability for the next 24 hours instead of a full week.
• C. Calculate the potential shipping cost for each order with each vendor, display the aggregate costs in a large table, and use quick filters to limit the options visible to the user.
• D. Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.

Answer: D

Explanation:
For modeling shipping costs based on varying vendor contracts and ensuring speed in dashboard performance, the suggested approach involves:
* Calculated Field with Parameter: Utilize a calculated field that dynamically references a user-selected parameter for the shipping vendor. This parameter adjusts the cost calculations based on selected vendor characteristics (like volume and speed).
* Aggregate Results: After calculating individual shipping costs, aggregate these costs to provide a concise, summarized view of potential expenses for the upcoming week. This method ensures the dashboard remains performant by reducing the load of processing individual line items in real-time.
* Why This Works: By using parameters and calculated fields, the dashboard can quickly adapt to user inputs without needing to re-query the entire dataset. Aggregating the results further improves performance and user experience by simplifying the output.
ReferencesThis strategy leverages Tableau's capability to handle dynamic calculations with parametersand is recommended for scenarios where performance and user-driven interaction are priorities. Tableau's performance optimization resources and dashboard design guidelines detail these techniques.

NEW QUESTION # 26
A client is using Tableau to visualize data by leveraging security token-based credentials. Suddenly, sales representatives in the field are reporting that they cannot access the necessary workbooks. The client cannot recreate the error from their offices, but they have seen screenshots from the field agents. The client wants to restore functionality for the field agents with minimal disruption.
Which step should the consultant recommend to accomplish the client's goal?

• A. Ensure that "Allow Refresh Access" was checked when the data source was published.
• B. Renew the security token via the Data Connection on Tableau Server.
• C. Ask the workbook owners to republish the workbooks to refresh the security token.
• D. Change the data source permissions for the connection to "Prompt User."

Answer: B

Explanation:
When field agents are unable to access workbooks due to issues with security token-based credentials, the most immediate and least disruptive solution is to renew the security token. This can be done through the Data Connection settings on Tableau Server. Renewing the token will restore access for the field agents without requiring them to take any action or affecting other users.
References:The use of personal access tokens (PATs) in Tableau and the procedure for renewing them are documented in Tableau's official resources.It is noted that PATs are long-lived authentication tokens that can be revoked and renewed to manage access securely1.Additionally, there have been discussions in the Tableau Community regarding issues with concurrent PAT access, which further supports the need to manage tokens effectively2.

NEW QUESTION # 27
A client has a published dashboard. They change the dashboard and then republish it. Now, usersreport that their web browser bookmarks to the dashboard are broken.
What are two possible causes for this issue? Choose two.

• A. The dashboard was published with a new name.
• B. New credentials were embedded into the data source.
• C. Tableau Server was upgraded.
• D. The dashboard was published to a different project.

Answer: A,D

Explanation:
When a client republishes a dashboard after making changes and users report broken bookmarks, the likely causes include:
* The dashboard was published to a different project: Changing the project location alters the URL path, causing bookmarks to point to a now non-existent dashboard location.
* The dashboard was published with a new name: Altering the dashboard's name changes its URL, resulting in broken bookmarks as the previous URL no longer leads to the intended dashboard.

NEW QUESTION # 28
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.

Answer:

Explanation:
See the complete Steps below in Explanation:
Explanation:
To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
* Navigate to the City Pareto worksheet by selecting its tab at the bottom of the window.
* Construct the Pareto Chart:
* Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.
* Sort the sales data in descending order to properly align the cities according to their sales contribution.
* To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select
'Quick Table Calculation', and choose 'Running Total'.
* Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.
* Add Reference Lines for the Pareto Principle:
* Click on the Analytics tab in the sidebar.
* Drag a 'Reference Line' element and drop it onto the chart area.
* Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.
* Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.
* Adjust the Appearance of the Chart:
* Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.
* Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Help: Offers detailed guidance on creating Pareto charts and adding reference lines.
* Tableau Visualization Best Practices: Provides tips on effectively displaying cumulative data and principles such as Pareto.
By following these steps, you will have successfully enhanced the City Pareto worksheet to include a complete Pareto chart with reference lines that illustrate how the sales data compares to the Pareto principle, making it easier to analyze and communicate the distribution of sales across cities.

NEW QUESTION # 29
A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.

They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse structure.
What should the client do to achieve the desired result?

• A. Update the Widget Inventory Table to be a daily snapshot.
• B. Use Tableau Desktop to visualize null values.
• C. Create a temporary table in the database.
• D. Use Tableau Prep to add new rows.

Answer: D

Explanation:
For a client who needs a daily visualization of widget inventory but cannot modify the data warehouse structure, the best approach is to use Tableau Prep to add new rows. Tableau Prep can be used to manipulate the existing dataset by adding missing date entries and appropriately adjusting inventory counts based on available data. This allows the creation of a complete daily snapshot for visualization without needing changes to the underlying database structure.

NEW QUESTION # 30
......

TCC-C01 Study Guide Cover to Cover as Literally: https://passleader.dumpexams.com/TCC-C01-vce-torrent.html