Free TCC-C01 Exam Braindumps (page: 5)

Page 4 of 15

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?

  1. Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
  2. Publish a live connection to Tableau Server.
  3. Publish an incremental refresh every Saturday.
  4. Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.

Answer(s): A

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 corrections.


Reference:

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 data.



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.

  1. Connect directly to the Site Content data source within the Admin Insights project.
  2. Query metadata through the GraphiQL engine.
  3. Access metadata through the Metadata API.
  4. Download metadata through Tableau Catalog.

Answer(s): B,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 queries. 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 usage.


Reference:

The actions are based on the capabilities of the GraphiQL engine and the Metadata API as described in Tableau's official documentation and learning resources.



A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.

Which calculation should the consultant recommend?

  1. DATEPART('weekday', [Order Date])>=6
  2. DATEPART('iso-weekday', [Order Date])>=6
  3. DATENAME('iso-weekday', [Order Date])>=6
  4. DATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7

Answer(s): D

Explanation:

The calculation DATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7 is 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.


Reference:

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 settings.

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 avoid discrepancies 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.


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.



A client uses Tableau Data Management and notices that when they view a data source, they sometimes see a different count of workbooks in the Connected Workbooks tab compared to the lineage count in Tableau Catalog.

What is the cause of this discrepancy?

  1. Some workbooks have been connected to the data source, but do not use any fields from it.
  2. Some workbooks have not been viewed by enough users yet.
  3. Some of the workbooks connected to the data source are not visible to the user due to permissions.
  4. Some Creators have connected to the data source in Tableau Desktop but have not yet published a workbook.

Answer(s): C

Explanation:

The discrepancy between the count of workbooks in the Connected Workbooks tab and the lineage count in Tableau Catalog can occur because of user permissions. In Tableau Data Management, the visibility of connected workbooks is subject to the permissions set by administrators. If a user does not have permission to view certain workbooks, they will not see them listed in the Connected Workbooks tab, even though these workbooks are part of the data source's lineage and are counted in Tableau Catalog.


Reference:

This explanation is based on the functionality of Tableau Data Management and Tableau Catalog, which includes managing user permissions and access to workbooks. The information is supported by Tableau's official documentation on data management and security practices.






Post your Comments and Discuss Tableau TCC-C01 exam with other Community members:

TCC-C01 Discussions & Posts