Free Salesforce CRM-Analytics-and-Einstein-Discovery-Consultant Practice Test & Real Exam Questions

A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data wasuploaded successfully. Upon analyzing the data using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?

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 asingle 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?

A CRM Analytics consultant wants to move a dataflow to a recipe in order to use aggregation nodes. To do so, they use the Dataflow to Recipe convertor and the recipe runs successfully.
However, they are unable to see the aggregated data in the dataset.
What is causing the issue?

Universal Containers has a single dataset that contains the attainment and commission fields for all sales reps.
Each sales rep should be able view the attainment data for each rep in their division. Each repshould only be able to see their own commission data.
Which option should a CRM Analytics consultant use to enforce this requirement?

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?

The CRM Analytics consultant at Cloud Kicks is asked to a dashboard displaying Opportunities data on the account's record page. The dashboard should display only opportunity data related to the current account viewed.
How should the consultant accomplish this?

Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

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?

CRM Analytics consultant receives a new project from a client that wants to implement CRM Analytics. They do not currently have CRM Analytics but want guidance on how to ensure their users have the correct access.
They have 1,000 users with a small team of three people who will build both datasets and dashboards. An additional 15 people should be able to only create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?
Which recommendation should the consultant give the client?