Free Salesforce ANC-301 Exam Questions

Become Salesforce Certified with updated ANC-301 exam questions and correct answers

Page: 1 / 72

Total 360 Questions | Updated On: Jan 08, 2025

Add To Cart

Question 1

ExhibitUniversal 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?

A : substr()

B : coalesce()

C : replace()

Answer: B

Question 2

A customer wants to change the default blue color on a bar chart. What is the easiest way to change blue to another color?

A : conditional formatting under the bar chart widget properties by selecting the dimension.

B : conditional formatting under the bar chart widget properties by selecting the measure.

C : bindings to specify a color per bar.

D : eate a compare table formula to specify a hidden metric for coloring purposes.

Answer: B

Question 3

Which statement best describes how to ensure CRM Analytics dashboards are easily used across both desktop and mobile devices?

A : Create multiple layouts and reorder all the widgets so that they fit nicely within the new default width

B : Create multiple layouts and allow CRM Analytics to automatically select and organize dashboard contents to be optimal for the device type.

C : Create multiple layouts, ensure the layout selectors match the device, and resize/hide widgets to ensure the content is appropriate for the device screen size.

Answer: C

Question 4

Exhibit.Given that the queries are using different datasets, which change should a CRM Analytics consultant make to solve this issue?

A : Use "Connect Data Sources" and create a connection to connect the two datasets.

B : Use “Connect Data Sources" and create a connection to connect the two widgets.

C : Use result binding/Interaction in the filters section of the query "Type 1”.

Answer: A

Question 5

A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and quotes. How should the CRM Analytics consultant accomplish this?

A : Bucket for each measure and then use a global bucket to segment accounts.

B : Aggregate to summarize related data to account level.

C : Cluster in the recipes and select the metrics used for clusterization.

Answer: B

Page: 1 / 72

Total 360 Questions | Updated On: Jan 08, 2025

Add To Cart