Question 1:

Which standard chart type would be best to show the proportions of Government spending on Health care, military etc., including 3 levels of categories within categories?

Question 1 options:

1. Small Multiple Pie charts
2. Box and whisker chart
3. Pie chart
4. Tree Map

Question 2:

An important disadvantage of rendering pie charts with a 3D look is ?

Question 2 options:

1. It can be harder to tell the relative size of slices at the back vs front of the 3D view.
2. It takes longer for a computer screen to display a complex image.
3. 3D looks can be considered more professional.
4. Slices can be fully hidden by other slices closer to the front.

Question 3:

When showing time series data with values between 40,000 and 42,000 ,which chart type would be the best choice ?

Question 3 options:

1. Horizontal bar chart
2. Tree Map
3. Line chart
4. Area chart

Question 4:

Which standard chart type would be best to show which areas of a large industrial complex had the most accidents ?

Question 4 options:

1. Area chart
2. Map
3. Pie chart
4. Column chart

Question 5:

Which compound chart type would be best to show the sales in each Canadian province over time, and their total ?

Question 5 options:

1. Clustered Column chart.
2. Line + column chart.
3. Stacked Column chart.
4. Small multiples of pie charts.

Question 6 :

AI smarts are mainly added to BI products to address what problem?

Question 6 options:

1. BI users often miss important facts that are in the data, because they aren't using statistics.
2. Using BI is just not enough fun, it needs to be more game like.
3. Managed BI authors need help developing effective visualizations.
4. Self service BI users spend more time focused on using the tool, than business questions.

Question 7:

Why do automatic chart generators usually provide a choice of multiple chart types?

Question 7 options:

1. The software does not know what question you want to answer.
2. There are no reasonable heuristics for inferring a suitable chart type.
3. Chart type is simply a matter of personal taste.
4. It is quicker to program generating many chart types than one.

Question 8:

Which of these features is most likely to require Natural Language Processing technology ?

Question 8 options:

1. Generating an initial dashboard based on a statistical search for anomalies.
2. Automatic joining of tables together.
3. Generating a dashboard based on a typed question.
4. Generating suggested charts based on user choice of columns of interest.

Question 9 :

Which of these is NOT commonly used as a heuristic for finding suitable columns to join tables together?

Question 9 options:

1. Column position, first column in both tables, etc.
2. Columns with the same Names.
3. Columns with a large proportion of values in common.
4. Columns that are identified as a Key or Index in the Database schema.

Question 10 :

Which of these could be added to a BI tool without using AI technology or heuristic rules ?

Question 10 options:

1. Automatic joining of data tables.
2. Automatic Generation of Charts that match current best practice in visual design.
3. Automatic generation of an initial dashboard of charts.
4. Automatic cleansing of data provided.