ExamGecko
Home / Tableau / TCC-C01 / List of questions
Ask Question

Tableau TCC-C01 Practice Test - Questions Answers, Page 2

Add to Whishlist

List of questions

Question 11

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 12

Report Export Collapse

An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.

The consultant needs to know the average number of days that a customer must wait before a product is shipped.

Which calculation should the consultant use?

Become a Premium Member for full access
  Unlock Premium Member

Question 13

Report Export Collapse

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there is a performance difference among these three data types.

What should the consultant tell the customer?

Become a Premium Member for full access
  Unlock Premium Member

Question 14

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 15

Report Export Collapse

An executive-level workbook leverages 37 of the 103 fields included in a data source. Performance for the workbook is noticeably slower than other workbooks on the same Tableau Server.

What should the consultant do to improve performance of this workbook while following best practice?

Become a Premium Member for full access
  Unlock Premium Member

Question 16

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 17

Report Export Collapse

A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.

What should the consultant recommend to limit the data source for optimal performance?

Become a Premium Member for full access
  Unlock Premium Member

Question 18

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 19

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 20

Report Export Collapse

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.

Become a Premium Member for full access
  Unlock Premium Member
Total 55 questions
Go to page: of 6
Search

Related questions