TDS-C01

TDS-C01 practice questions, page 5 of 5, with answer review and explanations.

Question 21

Which two types of aggregations can be applied to string fields? (Choose two.)

  1. Minimum
  2. Sum
  3. Average
  4. Count Distinct

Question 22

You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals. What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

  1. Create a new view.
  2. Color encode the hotel chain names.
  3. Include an Other group.
  4. Include the Summary card.

Question 23

You have the following string value: Sales Data. Which calculated field produces an output of Sales?

  1. LEFT (“Sales Data”)
  2. LEFT (“Sales Data”, 5)
  3. LTRIM (“Sales Data”)
  4. RTRIM (“Sales Data”)

Question 24

You create a dual axis chart that shows sales and profit over time. What should you do to distinguish sales from profit? (Choose two.)

  1. Adjust the time frame displayed.
  2. Change the mark types of sales and profit.
  3. Adjust the aggregations for sales and profit to be different.
  4. Change the color of sales and profit.

Question 25

What are two use cases for creating hierarchies from the Data pane? (Choose two.)

  1. To organize related fields together
  2. To add drilldown functionality for fields
  3. To create faster-performing queries
  4. To concatenate all fields into a single field