Review

Question 1

What is the difference between DATE, DATEPARSE, and MAKEDATE?

Answer 1

DATE can take a string or integer and return a date, DATEPARSE can take only strings and requires a date format, MAKEDATE requires a year, month, and day

Question 2

What is the difference between DATEPART and DATENAME?

Answer 2

DATEPART returns the specified date part as an integer, while DATENAME returns the specified date part as a string

Question 3

What fields are required to create a pie chart?

Answer 3

Dimension in color, measure in angle, pie as mark type

Question 4

What fields are required to create a scatter plot?

Answer 4

One measure in columns and one measure in rows

Question 5

What fields are required to build a Gantt chart?

Answer 5

Date or time field in columns, dimension in rows, continuous measure in size, auto or Gantt in Marks

Question 6

What fields are required to build a box plot?

Answer 6

Dimension in columns shelf, measure in rows, dimension in detail, mark type circle, reference line (box plot)