Accurate & Verified 2024 New TCC-C01 Answers As Experienced in the Actual Test!
TCC-C01 Certification Sample Questions certification Exam
NEW QUESTION # 31
A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.
Which calculation should the consultant recommend?
- A. DATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7
- B. DATEPART('weekday', [Order Date])>=6
- C. DATEPART('iso-weekday', [Order Date])>=6
- D. DATENAME('iso-weekday', [Order Date])>=6
Answer: A
Explanation:
The calculationDATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7is recommended because the ISO standard considers Monday as the first day of the week (1) and Sunday as the last day (7). This calculation will correctly identify Saturdays and Sundays regardless of the locale settings of the workbook's data source, ensuring that the report includes these days as specified by the client.
References:The use of the 'iso-weekday' part in the DATEPART function is consistent with the ISO 8601 standard, which is independent of locale settings.This approach is supported by Tableau's documentation on date functions and their behavior with different locale settings123.
To accurately identify weekends across different locale settings, using the 'iso-weekday' component is reliable as it is consistent across various locales:
* ISO Weekday Function: The ISO standard treats Monday as the first day of the week (1), which makes Sunday the seventh day (7). This standardization helps avoiddiscrepancies in weekday calculations that might arise due to locale-specific settings.
* Identifying Weekends: The calculation checks if the 'iso-weekday' part of the date is either 1 (Sunday) or 7 (Saturday), thereby correctly identifying weekends regardless of the locale settings.
References:
* Handling Locale-Specific Settings: Using ISO standards in date functions allows for uniform results across systems with differing locale settings, essential for consistent reporting in global applications.
NEW QUESTION # 32
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 # 33
A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.
Which set of charts should the consultant use to meet the client's requirements?
- A. Gantt and bar charts
- B. Waterfall chart and tree map
- C. Scatter plot and pie chart
- D. Line and bubble charts
Answer: B
Explanation:
To effectively display quarterly profit growth and aggregated sales totals across different product categories, a combination of a Waterfall chart and a Tree Map is recommended:
* Waterfall Chart: This chart type is excellent for visualizing the sequential growth or decline of profits across different quarters for each sub-category. It clearly shows how profits accumulate over time, highlighting both positive and negative changes, which makes it ideal for tracking profit growth or decline through the quarters.
* Tree Map: A Tree Map can efficiently display aggregated sales totals where each block size represents the total sales of a product category, providing a quick, visually impactful comparison across categories.
This is especially useful when the client wants to understand which categories contribute most to sales in a glanceable format.
Together, these charts provide a comprehensive overview of both profit trends over time (Waterfall Chart) and a comparative snapshot of sales performance across categories (Tree Map), meeting the client's need to analyze performance dynamics in a detailed yet consolidated manner.
ReferencesThese recommendations are based on common best practices for data visualization in Tableau, where specific chart types are chosen for their strengths in communicating certain types of data relationships and dynamics, as detailed in Tableau's official visualization guides.
NEW QUESTION # 34
A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.
Which two actions should the client use to access the necessary metadata? Choose two.
- A. Access metadata through the Metadata API.
- B. Download metadata through Tableau Catalog.
- C. Query metadata through the GraphiQL engine.
- D. Connect directly to the Site Content data source within the Admin Insights project.
Answer: A,C
Explanation:
To track which data sources are used most frequently across a site in Tableau Cloud, the client should use the GraphiQL engine and the Metadata API.The GraphiQL engine allows for interactive exploration of the metadata, making it easier to construct and test queries1.The Metadata API provides access to metadata and lineage of external assets used by the content published to Tableau Cloud, which is essential for tracking data source usage2.
References:The actions are based on the capabilities of the GraphiQL engine and the Metadata API as described in Tableau's official documentation and learning resources321.
NEW QUESTION # 35
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. Change the data source permissions for the connection to "Prompt User."
- 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. Ensure that "Allow Refresh Access" was checked when the data source was published.
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 # 36
A university has data on its undergraduate students and their majors by grade level (Freshman, Sophomore, Junior, Senior). The university is interested in visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?
- A. Radar Chart
- B. Tree Chart
- C. Sankey Diagram
- D. Chord Chart
Answer: C
Explanation:
To visualize the path students take as they change majors across different grade levels, a Sankey Diagram is highly effective. This type of visualization illustrates the flow and quantity between different stages or categories:
* Sankey Diagram: It allows for a visual representation of students' movements between majors over time. Each flow's thickness is proportional to the number of students moving from one major to another, giving a clear, immediate visual cue of major popularity and student migration patterns.
* To create a Sankey Diagram in Tableau, you typically need to prepare the data specifically for this type of chart. The data must include source (starting major), target (ending major), and the value (number of students). It often requires custom calculations and data reshaping to get the data in a format that a Sankey can use.
* Once the data is prepared, you can use a combination of calculated fields, path binning, and line charts to simulate the flow effect in Tableau. External plugins or web-based integrations might also be employed for more direct implementations.
ReferencesSankey Diagrams are not natively supported in Tableau but can be implemented through creative use of data preparation and calculations, as suggested in advanced Tableau user communities and demonstrated in various Tableau public galleries.
NEW QUESTION # 37
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.
From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
Answer:
Explanation:
See the complete Steps below in Explanation:
Explanation:
To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
* Compute Average Sales by Segment for Each Category and Year:
* Open the CC workbook and navigate to the Categorical Sales worksheet.
* Drag the 'Sales' field to the Rows shelf if it's not already there.
* Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.
* Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'.
This will compute the average sales for each segment within each category and year.
* Create a Calculation for Year-over-Year Percentage Change:
* Right-click in the data pane and select 'Create Calculated Field'.
* Name the calculated field something descriptive, e.g., "YoY Sales Change".
* Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
* Click 'OK' to save the calculated field.
* Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
* Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
* Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
* Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Help: Offers guidance on creating calculated fields and using table calculations.
* Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.
These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.
NEW QUESTION # 38
A client has a published data source in Tableau Server and they want to revert to the previous version of the data source. The solution must minimize the impact on users.
What should the consultant do to accomplish this task?
- A. Delete and recreate the data source manually.
- B. Select a previous version from Tableau Server, download it, and republish that data source.
- C. Request that a server administrator restore a Tableau Server backup.
- D. Select a previous version from Tableau Server, and then click Restore.
Answer: D
Explanation:
To minimize the impact on users when reverting to a previous version of a published data source in Tableau Server, the consultant should use the built-in revision history feature. By selecting a previous version from the revision history and clicking 'Restore', the data source will revert to that version without the need for a full server backup restoration or manual recreation of the data source. This process is quick and has the least amount of disruption to users.
References:The functionality and process for reverting to a previous version of a data source are outlined in Tableau's official documentation on working with content revisions1.This feature is part of Tableau Server's capabilities to manage and maintain data sources effectively21.
NEW QUESTION # 39
For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.
What is the most performant approach to model the data for a live connection?
- A. Relating the tables in Tableau Desktop
- B. Blending the first two tables with the third
- C. Joining the tables in Tableau Desktop
- D. Joining the tables in Tableau Prep
Answer: A
Explanation:
For a performant live connection in Tableau Cloud, especially when dealing with large datasets that preclude the use of extracts, relating the tables in Tableau Desktop is the recommended approach. This method allows for flexibility in how the data is queried and can improve performance by leveraging Tableau's relationships feature, which optimizes queries for the underlying database.
References:The best practices for live connections in Tableau Cloud suggest using relationships to manage complex data models efficiently1.Additionally, Tableau's documentation on connecting data sources recommends using relationships for better performance with live connections2.
NEW QUESTION # 40
A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source.
Which Tableau tool should the consultant use?
- A. Activity Log
- B. Data Management
- C. Tableau Advanced Management
- D. Prep Conductor
Answer: C
Explanation:
To identify which workbooks need to be updated to point to a new data source after a migration, a consultant should use Tableau Advanced Management. This component of Tableau provides comprehensive management capabilities including the ability to track workbook dependencies and data source usage across your entire Tableau environment. Using Tableau Advanced Management allows consultants to assess the impact of changes in the data source on connected workbooks and efficiently manage updates.
NEW QUESTION # 41
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 filter action, set "Run action on" to Menu, and set "Clearing the selection will" to Show all values.
- B. Add a highlight action and set Target Highlighting to All Fields.
- C. Add a highlight action and set Target Highlighting to Sub-Category.
- D. Add a filter action, set "Run action on" to Select, and set "Clearing the selection will" to Exclude all values.
Answer: D
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 # 42
A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?
- A. Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views.
. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.
. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you created. - B. Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.
. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.
. Add navigation buttons to both dashboards. - C. Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True.
. Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object.
. Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
"Target Parameter" and "Source Fields" to the parameter and calculated field you created.
. Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created. - D. Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."
. Right-click the parameter and select Add to Sheet for both worksheets.
. Navigate back to the dashboard and to the upper corner of the two worksheets.
. Enable the Use as Filter option.
Answer: C
Explanation:
The most efficient method for toggling between two views (forecast summaries and year-on-year metrics) while keeping main KPIs visible involves using a parameter and calculated fields for controlling visibility:
* Create a Boolean Parameter: This parameter will have two aliases representing the two views ("Forecast View" and "Year-on-Year View"). This allows the user to select which view they wish to see directly from the dashboard.
* Calculated Field: Create a calculated field that always returnsTrue. This field acts as a constant placeholder to enable the visibility control tied to the parameter.
* Dashboard Setup: Place both the forecast summary and the year-on-year metrics sheets on the dashboard. Set the year-on-year metrics sheet as a floating object over the forecast summary.
* Visibility Control: Use the "Control visibility using value" option in the Layout tab for the floating year-on-year metrics view. Tie this setting to the Boolean parameter so that changing the parameter will show or hide this view without affecting the main KPIs displayed on the dashboard.
* Interactivity: Implement a "Change Parameter" dashboard action where selecting different options in the dashboard (e.g., clicking on certain parts) triggers the parameter to change, thus toggling the visible view.
ReferencesThis method leverages Tableau's dashboard interactivity features including parameters, calculated fields, and visibility settings, as recommended in Tableau's user guide on dynamic dashboard design.
NEW QUESTION # 43
A client's dashboard has two sections dedicated to their shops and warehouses shown when a viewer chooses either shops or warehouses with a parameter.
There are a few quick filters that apply to both, while others apply to only shops or only warehouses.
Currently, the quick filters are all shown at the left side of the dashboard. The client wants to hide all filters, but when shown, make it easy for the viewer to find the quick filters that work for only shops or only warehouses.
Which solution should the consultant recommend that meets the client's needs and is most user-friendly?
- A. Hide container with all quick filters with a Show/Hide Button.
- B. Use Dynamic Zone Visibility to show only the quick filters that apply with the chosen parameter value and a Show/Hide Button to hide container with all the filters.
- C. Divide the quick filters into three groups: General, for shops. Place the general filters on the left of dashboard for warehouses. Place other filters next to the sections to which they apply.
- D. Use Dynamic Zone Visibility to inform viewers which quick filters apply to warehouses or shops.
Answer: B
Explanation:
The most user-friendly solution is to use Dynamic Zone Visibility in combination with a Show/Hide Button.
This approach allows the dashboard to dynamically display only the relevant quick filters based on the viewer's selection of shops or warehouses, thus reducing clutter and focusing the user's attention on applicable filters.The Show/Hide Button further enhances the userexperience by allowing viewers to toggle the visibility of the filter container, providing a clean and organized dashboard interface1.
References:Dynamic Zone Visibility is a feature in Tableau that enables dashboard elements to appear or disappear based on the value of a field or parameter1.This functionality is ideal for creating interactive and user-friendly dashboards that adapt to user interactions and selections1.
NEW QUESTION # 44
A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.
. Group 1: Viewers who cannot see any information on profitability
. Group 2: Viewers who can see profit and profit margin
. Group 3: Viewers who can see profit margin but not the value of profit Which approach should the consultant use to provide the required level of access?
- A. Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to Group 2 and use the calculation in the view in the report.
- B. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
- C. Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table data to create user filters in the report.
- D. Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and use the calculation in the view in the report.
Answer: A
Explanation:
The approach of using user filters to control access to data on profitability for Groups 2 and 3, combined with a calculated field that restricts the visibility of profit value to only Group 2, aligns with Tableau's best practices for managing content permissions. This method ensures that each group sees only the data they are permitted to view, with Group 1 not seeing any profitability information, Group 2 seeing both profit and profit margin, and Group 3 seeing only the profit margin without the actual profit values.This setup can be achieved through Tableau Server's permission capabilities, which allow for detailed control over what each user or group can see and interact with12.
References:The solution is based on the capabilities and permission rules that are part of Tableau Server's security model, as detailed in the official Tableau documentation12. These resources provide guidance on how to set up user filters and calculated fields to manage data access levels effectively.
NEW QUESTION # 45
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. Publish to Tableau Mobile for viewing.
- 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. Embed views into Salesforce.
Answer: D
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 # 46
A client is searching for ways to curate and document data in order to obtain data lineage. The client has a data source connected to a data lake.
Which tool should the consultant recommend to meet the client's requirements?
- A. Tableau Catalog without Tableau Data Management Add-on
- B. Tableau Prep Conductor
- C. Tableau Catalog with Tableau Data Management Add-on
- D. Tableau Catalog with Tableau Server Management Add-on
Answer: C
Explanation:
To effectively curate and document data for obtaining data lineage, particularly from a data source connected to a data lake, the recommended tool is:
* Tableau Catalog with Tableau Data Management Add-on: This add-on enhances the capabilities of Tableau Catalog, providing extensive features for data management, including detailed data lineage, impact analysis, and metadata management.
* Functionality: The Tableau Catalog with the Data Management Add-on allows users to see the full history and lineage of the data, trace its usage across all Tableau content, and understand dependencies.
It also facilitates better governance and transparency in data handling.
* Why Choose this Tool: For a client needing comprehensive data lineage and documentation capabilities, this add-on ensures that data stewards and users can maintain and utilize a well-managed data environment. It supports robust data governance practices necessary for large and complex data ecosystems like those typically associated with data lakes.
ReferencesThe recommendation is based on the functionalities offered by the Tableau Data Management Add-on, as described in Tableau's official documentation on managing and documenting data sources for enhanced governance and operational efficiency.
NEW QUESTION # 47
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. Published data sources that use extracts
- B. Tableau Prep flows
- C. Published data sources that use live connections
- D. Workbooks
Answer: B
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 # 48
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 Prep to add new rows.
- C. Create a temporary table in the database.
- D. Use Tableau Desktop to visualize null values.
Answer: B
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 # 49
A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.
- A. Amount of data storage used on the client's existing server
- B. Whether or not the client needs the ability to connect to public, cloud-based data sources
- C. Whether or not there are large numbers of concurrent extract refreshes
- D. Whether or not the client plans to leverage single sign-on (SSO)
Answer: C,D
Explanation:
When considering a migration from Tableau Server to Tableau Cloud, two critical factors to consider are the client's need for single sign-on (SSO) and the volume of concurrent extract refreshes.
* Single Sign-On (SSO):Tableau Cloud supports SSO, which can streamline user authentication and enhance security.If the client plans to leverage SSO, Tableau Cloud may be a suitable choice1.
* Concurrent Extract Refreshes:The number of concurrent extract refreshes is a significant factor because it impacts performance and resource allocation.Tableau Server might be more appropriate if the client has a high volume of concurrent extract refreshes, as it allows for more control over the infrastructure to manage these workloads2.
References:The decision between Tableau Server and Tableau Cloud should be based on specific organizational needs, including security, compliance, performance, and scalability.The official Tableau resources provide guidance on these factors12.Additionally, discussions in the Tableau Community highlight the importance of considering these elements when choosing between Tableau Server and Tableau Cloud1.
NEW QUESTION # 50 
From the desktop, open the NYC
Property Transactions workbook.
You need to record the performance of
the Property Transactions dashboard in
the NYC Property Transactions.twbx
workbook. Ensure that you start the
recording as soon as you open the
workbook. Open the Property
Transactions dashboard, reset the filters
on the dashboard to show all values, and
stop the recording. Save the recording in
C:\CC\Data\.
Create a new worksheet in the
performance recording. In the worksheet,
create a bar chart to show the elapsed
time of each command name by
worksheet, to show how each sheet in
the Property Transactions dashboard
contributes to the overall load time.
From the File menu in Tableau Desktop,
click Save. Save the performance
recording in C:\CC\Data\.
Answer:
Explanation:
See the complete Steps below in Explanation:
Explanation:
To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:
* Open the NYC Property Transactions Workbook:
* From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.
* Start Performance Recording:
* Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.
* Select 'Settings and Performance', then choose 'Start Performance Recording'.
* Open the Property Transactions Dashboard and Reset Filters:
* Navigate to the Property Transactions dashboard within the workbook.
* Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.
* Stop the Performance Recording:
* Go back to the 'Help' menu.
* Choose 'Settings and Performance', then select 'Stop Performance Recording'.
* Tableau will automatically open a new tab displaying the performance recording results.
* Save the Performance Recording:
* In the performance recording results tab, go to the 'File' menu.
* Click 'Save As' and navigate to the C:\CC\Data\ directory.
* Save the file, ensuring it is stored in the desired location.
* Create a New Worksheet for Performance Analysis:
* Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.
* Drag the 'Command Name' field to the Columns shelf.
* Drag the 'Elapsed Time' field to the Rows shelf.
* Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.
* Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.
* Customize and Finalize the Bar Chart:
* Adjust the axes and labels to clearly display the information.
* Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.
* Save Your Work:
* Once the new worksheet and the performance recording are complete, ensure all work is saved.
* Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.
References:
* Tableau Help Documentation: Provides guidance on how to start and stop performance recordings and analyze them.
* Tableau Visualization Techniques: Offers tips on creating effective bar charts for performance data.
By following these steps, you have successfully recorded and analyzed the performance of the Property Transactions dashboard, providing valuable insights into how each component of the dashboard contributes to the overall load time. This analysis is crucial for optimizing dashboard performance and ensuring efficient data visualization.
NEW QUESTION # 51
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 an incremental extract refresh every day and publish a secondary data set containing data revisions.
- B. Publish a live connection to Tableau Server.
- C. Publish an incremental refresh every Saturday.
- D. Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
Answer: D
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 # 52
A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?
- A. { FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) } - B. [Sales]
>
{ FIXED [Order ID] : SUM([Sales]) } - C. { FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } - D. { FIXED [Order ID] : SUM([Sales]) }
>
{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }
Answer: C
Explanation:
To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:
* Correct Formula:{ FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED
[Order ID] : SUM([Sales]) }) }
* This calculation uses a Level of Detail (LOD) expression:
* The left part of the formula{ FIXED [Order ID] : SUM([Sales]) }calculates the total sales for each individual order.
* The right part{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }calculates the average sales per order within each region.
* The>operator is used to compare these two values to determine if the sales for each order exceed the regional average.
ReferencesThis formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.
NEW QUESTION # 53
......
Certification Topics of TCC-C01 Exam PDF Recently Updated Questions: https://www.exams-boost.com/TCC-C01-valid-materials.html
TCC-C01 Exam Prep Guide: Prep guide for the TCC-C01 Exam: https://drive.google.com/open?id=1Uz5l331SkOCvu0CuynyFeWWpQsZdBkxs