Question 1

You have the following view You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas. Which type of filter should you use?

Options :

A : Wildcard

B : Condition

C : General

D : Top

Answer: A

Question 2

I move fields in the columns and rows shelves.They are shown with green and blue backgrounds.What technically is the difference between the green and blue pills?

Options :

A : Greens are continuous, and blues are discrete.

B : Greens are always dimensions, and blues are always measures.

C : Greens are discrete, and blues are continuous.

D : Greens are always measures, and blues are always dimensions.

Answer: A

Question 3

You need to create a calculated field to filter your data based on Year-to-Date (YTD) sales. Following the steps below, which calculation should you use to filter for YTD sales, and how would you apply it to your dashboard?Go to Analysis > Create Calculated Field.Name the field YTD Sales.Use a calculation that filters the current year's sales up to today's date.Apply this calculated field as a filter by dragging it onto the filter shelf and selecting "True".What is the correct calculation to filter the data for YTD sales?

Options :

A : DATETRUNC("year", [Order Date]) = DATETRUNC("year", TODAY())

B : DATETRUNC("month", [Order Date]) = DATETRUNC("month", TODAY())

C : DATETRUNC("year", [Order Date]) = DATETRUNC("year", NOW())

D : YEAR([Order Date]) = YEAR(NOW())

Answer: A

Question 4

What does Data Interpreter do?

Options :

A : It shows anomalies in your data (rows with too high or too low a figure).

B : After you select some fields, it creates a viz.

C : It analyses your data when you import it.

D : It suggests appropriate joins or relationships between your data sources.

Answer: C

Question 5

Connect to the "WorldBank Data" and use the Development Indicators table. Create a country map of the Europe and Central Asia region. Find out which neighboring country of Romania is having a greater average GDP per capita than Romania?

Options :

A : Ukraine

B : Serbia

C : Hungary

D : Hungary

Answer: C