Salesforce ANC-301 Exam Practice Test Instant Access

Question 1

A team of CRM Analytics developers has been working on an existing recipe to add new derived fields. The edited version has been failing ever since, and management is requesting that the dashboard show refreshed data while they work on the edits.

How can the developers add new fields while keeping the dataset refreshed?

AA recipe for the new fields and when that is successful, add it to the existing recipe as a join node.

BClone the existing recipe to add fields and roll back the original recipe to the last working version.

CRefresh the dataset after working hours to avoid the edited version from failing.

Answer : B

When faced with the need to continue refreshing data while developing new features in a recipe, the best practice is:

Clone the Existing Recipe: By cloning the recipe, developers can experiment with adding new fields and transformations without affecting the production data flow. This allows for testing and development in a sandbox-like environment.

Roll Back to a Stable Version: Rolling back the original recipe to the last stable version ensures that the production dashboards continue to receive refreshed data, maintaining business operations without disruption.

This approach not only ensures data continuity but also provides a safe environment to address any issues that may arise from new developments.

Question 2

After the initial creation of a model, the first model insight explains

93% of the variation of the outcome variable. This is unusually high.

What is the most likely reason for this?

AThe dataset contains multiple dominant values.

BThe model contains too many outlier values.

CThe outcome variable may be causing data leakage.

Answer : C

Question 3

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 4

Which recommended technique should a CRM Analytics consultant

use to access CRM Analytics data from a remote app or website?

AUse HTTPS to call the /wave/query API, supplying an encoded SAQL query as a parameter.

BUse an iFrame to embed the Salesforce page in a remote site.

CExport the data to a CSV file and load it on the remote site.

Answer : A

Question 5

Universal Containers (UC) is looking to create a dashboard for whitespace analysis. UC wants to view a particular customer and see what similar customers have bought.

Which recipe transformation is helpful for the consultant to use while creating the dataset?

ATimeseries Forecasting

BCluster

CPredict Missing Values

Answer : B

Cluster transformation is a powerful tool in CRM Analytics recipes used for grouping similar records together based on shared attributes. In this scenario, Universal Containers (UC) wants to perform whitespace analysis by viewing a particular customer and comparing their purchase history with similar customers. The Cluster transformation would help in identifying groups of customers who have made similar purchases. This can then be used to provide insights into what the viewed customer might also be interested in purchasing, based on similar customer behaviors. Reference: CRM Analytics Recipes and Transformation

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

A consultant is tasked with creating a dataset and a dashboard for a sales team. During the requirements gathering, it was highlighted that security of the data is important.

It was noted that the Opportunity object has organization-wide defaults set to Private with access via the role hierarchy. Sales wants to keep this security in place for the dashboard. Looking at the Opportunity data, the consultant sees that the VP of sales can have access to up to 20,000 records and is unsure if sharing inheritance can be used.

Which approach ensures data security for the new Opportunity dataset?

AEnable Inherit Sharing from Salesforce in the analytics settings and set Opportunity as the source on the dataset.

BFlatten the role hierarchy in the dataflow recipe and set a security predicate based on Opportunity owner and role path.

CRun the Sharing Inheritance Coverage Assessment for the Opportunity object in the analytics settings.

Answer : C

For ensuring that the security settings on the Opportunity object are appropriately replicated in the CRM Analytics environment, running the Sharing Inheritance Coverage Assessment is an effective strategy. Here's why:

Assessment of Inheritance Feasibility: This tool assesses whether sharing rules on the Opportunity object can be effectively inherited in the analytics environment, ensuring that the organization-wide defaults and role hierarchy are maintained.

Identification of Limitations: The assessment will identify any potential issues or limitations with inheriting sharing settings due to the large number of records (up to 20,000 for the VP of Sales), providing clear insights on how to proceed.

Guided Decision Making: Based on the outcome of the assessment, the consultant can make informed decisions about whether to directly inherit sharing or consider alternative strategies like flattening the role hierarchy or using security predicates.

Salesforce Implement and Manage CRM Analytics ANC-301 Exam Practice Test