Questions and CORRECT Answers
Which of the following is the best reason to use an extract instead of a live connection?
a. Your data source only supports a live connection via ODBC.
b. You need the freshest possible data at all times.
c. You need to apply an aggregation that takes too long when using a live connection.
d. You need to join tables that are in the data source. - CORRECT ANSWER - c. You
need to apply an aggregation that takes too long when using a live connection.
You created a group by selecting field labels in a view. How can you remove members from the
group?
a. In the view, right-click the group members you want to remove and select Exclude.
b. In the Data pane, right-click the group and select Edit Group. c. In the view, right-click the
group members you want to remove and select Format.
d. On a color legend, right-click a member you want to remove and select Format legends. -
CORRECT ANSWER - b. In the Data pane, right-click the group and select Edit Group.
Which of the following can you use to create a calculated field that returns data independent of
the data granularity in a view?
a. An INCLUDE LOD calculation
b. A table calculation
c. A basic calculation
d. A FIXED LOD calculation - CORRECT ANSWER - d. A FIXED LOD calculation
Interactive elements that you can add to a dashboard for users include ______. (Select all that
apply.)
a. URL actions
b. edit tooltip options
c. filter actions
, d. hide and unhide all sheet options - CORRECT ANSWER - a. URL actions
c. filter actions
A field that shows average home values for the United States in 2016 is most likely:
a. A discrete date part dimension
b. A continuous date value dimension
c. A geographical dimension
d. An aggregated measure - CORRECT ANSWER - d. An aggregated measure
A field that shows average product price most likely become a - CORRECT ANSWER -
continuous measure
Which of the followings are correct? - CORRECT ANSWER - a. discrete dimensions
fields are blue (textual, qualitative data)
i. e.g. (Dates)
ii. **doesn't mean that blue is dimensions
b. continuous measures fields are green (numeric data)
Measures - CORRECT ANSWER - can be discrete or continuous so they can be either
blue or green
A date field is - CORRECT ANSWER - a good example of a discrete or continuous
dimension
What do you need to create a scatter plot? - CORRECT ANSWER - at least 2 continuous
measures
What do you need to create a histogram? - CORRECT ANSWER - 1 continuous measures