Black Friday / Cyber Monday Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

A business analyst is filtering for this year’s data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

A.

X-axis settings

B.

Column settings

C.

Explore settings

D.

Row settings

Full Access
Question # 5

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

A.

Select the dimension Created Month, and pivot on the dimension Created Year.

B.

Select the dimension Created Year, and pivot on the dimension Created Month.

C.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

D.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Full Access
Question # 6

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:

“At least one dimension should be of type Location or have a map_layer specified”.

There are currently three fields in the Explore:

  • City Name (Dimension)
  • Population (Measure)
  • Number of Museums (Measure)

What should the analyst do to resolve this error?

A.

Remove the Number of Museums measure from the Explore

B.

Select the Static Map visualization instead of Interactive

C.

Contact the LookML Developer

D.

Add a table calculation that evaluates location (${cities.city_name})

Full Access