Question 81

A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
  • Question 82

    You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.
    You need to ensure that the extract also refreshes on the last day of the month at 18:00.
    What should you do?
  • Question 83

    The following table displays the row-level data in a Tableau data source:

    A Data Analyst creates this calculated field:
    SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
    What is the result of this aggregate calculation?
  • Question 84

    You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.

    The following is a sample of the sales data for me division in Germany.

    You have population data in a file named Populatio.csv. the following is a sample of the data.

    You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
    You need to prepare the data to support the planned visualization. The data source must support being published .
    Which four actions should you perform in order?
    (Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
    Use Answer Area arrows to re-order the options)

    Question 85

    You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

    You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?