TDA-C01 Practice Test

TDA-C01 Practice Test practice questions, page 8 of 9, with answer review and explanations.

Question 36

You have a dataset that contains daily sales by business segment from 2017 to the present. You want to use monthly historical trends to predict sales by segment in the future. Which three actions should you perform in order? (Place the three correct options in order Use the arrows to move Options to Answer Area Use Answer Area arrows to re-order the options.)

Question 37

You have the following chart that shows profits and discounts over time. You need to combine the lines to appear as shown in the following chart. What should you do?

  1. Drag Discount to Color on the Marks card
  2. Drag Discount to the Columns shelf.
  3. Set Discount to Dual Axis
  4. Convert Discount to Discrete

Question 38

You have the following chart that shows the cumulative volume of sales from various dates. You want the months to appear as shown in the following chart. What should you do?

  1. Select Show Missing Values for the date
  2. Convert the date to Attribute
  3. Convert the date to Continuous
  4. Convert the date to Exact Date

Question 39

In which three formats can you export a worksheet from the Worksheet menu? (Choose three.)

  1. .csv
  2. .xlsx
  3. .png
  4. .html
  5. .pptx
  6. .txt

Question 40

You have the following dataset that contains null values in the Profits field. You want the data to appear as shown in the following table. Which two formulas achieve the goal? (Choose two.)

  1. ISNULL((Profits])
  2. IF [Profits] != null then [Profits] END
  3. IFNULL([Profits],0)
  4. ZN([Profits])