Free Salesforce ANC-301 Practice Test & Real Exam Questions

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?

An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.
Which data transformation should the consultant use to determine if a subscription is new or a renewal?

Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

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?

A CRM Analytics consultant has been asked to bring data from an external database as well as five external Salesforce environments into CRM Analytics. Twenty-five objects have been enabled from the local Salesforce connector.
The requirements are:
* 10 objects should be enabled from an external database
* 12 objects each from three of the external Salesforce environments
* 15 objects each from the remaining two external Salesforce environments The consultant estimates each connector will, per object, bring between 1,000 and 1 million rows of data.
Which limit will be exceeded?

A model created with a GLM algorithm produced unsatisfactory results.
When re-running the model, which type of algorithm should the consultant use to improve the results?

The CRM Analytics consultant at Universal Containers (UC) has set up data sync for the Salesforce Opportunity object with the Amount currency field added. This is being used in multiple datasets and dashboards, as UC is a multi-currency organization.
The currency used in Salesforce records is set up in GBP but the data on the dashboard is converting to USD. Conversion logic is not set up on any of the recipes.
Why is the currency converting?