Free Salesforce ANC-201 Exam Questions

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

Page: 1 / 72

Total 360 Questions | Updated On: Jul 29, 2025

Add To Cart

Question 1

Cloud Kicks needs a CRM Analytics consultant to install the Appointment Analytics App. After installation, they realize the wrong field was picked and the app did not have access to a newly created field that should be used instead of the old one. What is the first step the consultant should take to prevent erroneous dataset/dashboard creation?

A : Cancel running installations from Setup

B : Stop the recipe from running in Data Manager.

C : Update the app with the new field after installation.

Answer: B

Question 2

What are the 3 basic actions within a query in Analytics? Choose 3:

A : Aggregate by a measure

B : Count rows by measure you want to visualize.

C : Filter to narrow down your results.

D : Grouping by a dimesnsion

E : Display the results graphically

Answer: A,C,D

Question 3

The Tableau CRM team at a company creates three recipes. 1) myRecipeOne: this recipe takes 2 hours to run.

2) mvRedpeTwo: this recipe takes 1 hour and 30 minutes to run. 3) myRecipeThree: this recipe takes 1 minute and 30 seconds to run. If all three recipes run, how many count towards the 24 hour rolling recipe run limit.

A : 2

B : 1

C : 0

D : 3

Answer: A

Question 4

Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

How should a CRM Analytics consultant help UC build this lens?

A : Use a "fill" statement in SAQL query with a "partition" parameter.

B : Use a “Compare Table" and add a column leveraging the “Running Total” function.

C : Use a "Compare Table" and use the "Show Totals" option.

Answer: B

Question 5

How can you restrict access to Analytics data at the row level?

A : Manually add a flag to each row to prevent access.

B : Use a security predicate to filter which rows are returned.

C : Use subtle thought control.

D : Remove restricted rows from the JSON file

Answer: B

Page: 1 / 72

Total 360 Questions | Updated On: Jul 29, 2025

Add To Cart