Question 1

In which of the following scenarios would having a live connection be more beneficial than using an extract?

Options :

A : Analyzing and tracking real time flight updates

B : Analyzing real time stock prices

C : Analyzing real time data from production systems

D : Analyzing historical housing prices

E : Analyzing a subset of a dataset having 1 billion rows

Answer: A,B,C

Question 2

Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Options :

A : $16,581

B : $147,950

C : $48,115

D : $33,768

Answer: A

Question 3

________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

Options :

A : .tde

B : .tbm

C : .tds

D : .twb

Answer: C

Question 4

True or False: It is possible to add a field to more than one hierarchy

Options :

A : True

B : False

Answer: A

Question 5

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Options :

A : False

B : True

Answer: B

Higher Test Marks with Free Online Analytics-101 Exam Practice

Buying Options: