Question 1

Exhibit

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is: YoY = [(This Year — Last Year) / Last Year] % Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value. What is the correct function to use?

Options :

A : substr()

B : coalesce()

C : replace()

Answer: B

Question 2

What does XMD stand for?

Options :

A : Configuring unsupported fields

B : Lenses Dataset Fields

C : Extended Metadata

D : Create a JSON

Answer: C

Question 3

A versioning feature allows CRM Analytics users to be added as Publishers and make changes separately while a ‘Live’ version is still being usedby other users. Once the changes are complete, the user can then set their updated version as the Live version. Which CRM Analytics item is this leveraged for?

Options :

A : App

B : Dataset

C : goats

Answer: A

Question 4

What kind of insight is "What Is The Difference"?

Options :

A : Descriptive

B : Diagnostic

C : Predictive

D : Prescriptive

E : Selective

Answer: B

Question 5

Concurrent queries per user?

Options :

A : 20

B : 50

C : 10

D : 25

Answer: C

Free ANC-201 Mock Exam – Practice Online Confidently

Buying Options: