Analytics-DA-201 Exam Question 1

You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?
  • Analytics-DA-201 Exam Question 2

    A Data Analyst wants to create the following table in a view:

    Which function should the analyst use to create the Position column?
  • Analytics-DA-201 Exam Question 3

    You have the Mowing dashboard.

    Which two elements are floating? Choose two.
  • Analytics-DA-201 Exam Question 4

    You conned to a Microsoft SQL Server database
    You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

    Analytics-DA-201 Exam Question 5

    You have the following dataset.
    When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
    What should you do?