Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading “All Results Unavailable.”

What are three causes of this message? (Choose three.)

A.

The Row Limit chosen in the Look is too high.

B.

There is a table calculation in the Look.

C.

Unlimited results are unsupported by CSV format.

D.

The Row Totals option is turned on in the Look.

E.

There is a Running Total measure in the Look.

F.

The Totals option is turned on in the Look.

Full Access
Question # 5

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error “Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time”.

How can the analyst resolve this error while showing the rank as a column visualization?

A.

Pivot the Explore by the Brand Name dimension.

B.

Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

C.

Pivot the Explore by brand Rank.

D.

Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

Full Access
Question # 6

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.

What should the analyst do to meet this requirement?

A.

Filter the dashboard for the advanced value “yesterday”, and create a new schedule.

B.

Edit the dashboard data filters default value to be the previous day’s date, and create a new schedule.

C.

Create a new schedule and modify the filter’s default value to the previous day’s date.

D.

Create a new schedule and modify the schedule filter to be the advanced value “yesterday”.

Full Access