Important Salesforce ANC-201 Exam Questions

Universal Containers (UC) is using CRM Analytics to create two datasets.

* Dataset A: Contains a list of activities with an "activityID" dimension and a "userID" dimension

* Dataset B: Contains a list of users with a "userID" dimension

UC wants to delete all activities from Dataset A related to users in Dataset B.

How should the CRM Analytics consultant help UC achieve this?

A CRM Analytics consultant has been asked to refactor a dashboard so that it loads quicker. After some analysis, the consultant found that most of the dashboard queries run in less than 5 seconds; however, the Opportunities Table takes more time to load when scrolled down from its initial view.

How should the consultant improve the performance of this dashboard?

AW Computing will start using Tableau Online to report on some of its Salesforce data to users who do NOT have an SFDC license.

What is the first step the CRM Analytics consultant should take?

A CRM Analytics consultant is working on Sales dashboards with multiple datasets and advanced queries in the Sales Analytics app.

Sales managers in the organization have been given Editor/Manager access to the app, whereas sales reps have been given Viewer access.

Some dashboards that are in progress are not ready to be rolled out to sales reps and should only be viewable by sales managers.

How should the consultant accomplish this?

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?