Salesforce ANC-301 Exam Questions Instant Access

Question 1

At Universal Containers, a dashboard is built to track sales metrics. The Opportunity amount field has conditional formatting added --- it turns green for closed won and red for closed lost.

How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?

APosition Alt Texts next to the KPIs to make it more understandable.

BAdd up and down arrow next to the KPIs to make it more understandable.

CMake the numbers bold to emphasize whether it is won or lost.

Answer : B

Enhancing accessibility, especially for users with color vision challenges, is critical. Adding up and down arrows next to the KPIs:

Visual Cues: Provides a non-color dependent method to indicate whether metrics are positive (up arrow) or negative (down arrow).

Accessibility: Improves understanding for users with color vision deficiencies, ensuring that the dashboard is inclusive.

User Experience: Enhances the overall usability of the dashboard by making the interpretation of data straightforward and less reliant on color.

Question 2

Universal Containers' sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard.

Which action is required to accomplish this?

ACreate a query and sort descending by revenue and limit it to 10 results.

BCreate a query with a results based interaction as a filter using the limit query to pass in the 10 Account IDs.

CCreate 2 query with a selection based interaction as a filter using the limit query to pass in the 10 Account IDs.

Answer : A

To create a dashboard showing the top 10 accounts by revenue dynamically, the best approach is to create a query that sorts the accounts in descending order by revenue and limits the results to the top 10. This query can then be used as the data source for the widget, ensuring that it dynamically adjusts based on the filters applied to the dashboard.

This method efficiently handles the task because sorting by revenue and limiting the results to 10 ensures that only the top accounts are displayed, and it remains dynamic with dashboard filters.

Question 3

A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a few users. They should be able to view the data but unable to export it.

Which permission should the consultant make sure to NOT include?

AExport CRM Analytics data

BDownload CRM Analytics data

CView CRM Analytics Assets

Answer : B

Question 4

Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org.

Which CRM Analytics user interface features should be used to complete these requirements?

AAnalytics REST API used in conjunction with dataflows/recipes.

BMicrosoft Azure SQL Data Warehouse Connector used in Conjuction with dataflows/recipes

CCRM Analytics Connector for Excel used in conjunction with dataflows/recipes

Answer : B

CRM Analytics provides out-of-the-box connectors for integrating external data sources like Microsoft Azure SQL Data Warehouse. To meet the requirement of daily automated data loading, the Microsoft Azure SQL Data Warehouse Connector can be used to pull data into CRM Analytics. Once the data is imported, dataflows or recipes can be used to transform and merge this data with the organization's Salesforce data. Recipes allow for merging datasets and applying any necessary transformations, ensuring the data from Azure is combined and transformed appropriately before analysis. Reference: CRM Analytics Connectors and Dataflows

Question 5

The CRM Analytics consultant at AW Computing is designing dashboard. They want to add a rate between two metrics and display it in a new chart. They are finding that the new chart seems to prejudice the design of other charts.

What should the consultant do to resolve this?

ACreate a component with the rate chart and insert it in one of the tooltips.

BClone the dashboard and replace one of the charts with the new rate chart.

CAdjust the dashboard widgets to accommodate the rate chart.

Answer : A

Question 6

A project team member uploads a CSV file to CRM Analytics, and they notice a few records failed during the upload. The manager wants to view the error log generated so this can be fixed and uploaded again. The manager has the CRM Analytics administrator permission but is unable to download the error log details.

Why is the manager unable to download the log details?

AThey do not have the Upload External Data to CRM Analytics permission enabled.

BThey do not have the Download CRM Analytics Data permission enabled.

COnly the user who uploaded the external data file can download the error log.

Answer : C

In CRM Analytics, when a CSV file is uploaded and errors occur during the upload process, an error log is generated. However, only the user who uploaded the external data file can download the error log, even if other users have administrative permissions. This restriction ensures that only the user responsible for the data upload can access the details to resolve the issues.

Question 7

Universal Containers intends to use a custom Salesforce big object in its org and visualize the data using CRM Analytics. As the number of rows to be synced is quite large, the CRM Analytics consultant is looking to set up an incremental sync with additional filters added as part of the data sync to improve performance.

What should the consultant keep in mind while implementing this?

AIncremental data syne Is NOT supported for big objects.

BCustom big objects are NOT supported by CRM Analytics.

COnly SOSL queries can be used as data syne filters.

Answer : A

Salesforce Implement and Manage CRM Analytics ANC-301 Exam Questions