Question 1

Creating a scatter plot requires a minimum of how many measures?

Options :

A : 2

B : 4

C : 1

D : 3

Answer: A

Question 2

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Options :

A : Data source Filter

B : Extract Filter

C : Context Filter

D : None of the these

Answer: C

Question 3

You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32).

What should you include in the calculation?

Options :

A :

[Customer Name] + "," + "STR[Age]''

B :

STR([Customer Name]) + "," STR(Age")

C :

"Customer Name," + [Age]

D :

[Customer Name] + "," + STR([Age])

Answer: D

Question 4

When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point

Which feature helps us fix this issue?

Options :

A : Replace References

B : Fix Metadata

C : Renaming

D : Aliases

Answer: A

Question 5

Relationships are represented by __________________ and operate at the ____________________.

Options :

A : noodles, logical layer

B : noodles, physical layer

C : Venn diagrams, physical layer

D : Venn diagrams, logical layer

Answer: A

Free Desktop-Specialist Mock Exam – Practice Online Confidently

Buying Options: