Exhibit: A shipping company created a dataset. 'Bookll,' containing budget per region per month for the first six months of 2018. The dataset is shown in the graphic. Now, they want to create a lens showing the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.How can an Einstein Consultant help this company build this lens?

Use a SAQL query leveraging the 'fill' statement with a 'partition' parameter.

Use a SAQL query to create fake rows for any data that is missing data from the dataset.

Use a 'Compare Table' and use the 'Show summary' option.

Use a 'Compare Table' and add a column leveraging the 'Running Total' function.

Exhibit: Universal Containers has a Sales Manager dashboard. They need to build a table as shown in the graphic and calculate the summary as the first line in a compare table.How can the summary be calculated'

Use the Show Summary option in the compare table.

Add a formula field to calculate the summary.

Use a SAQL query since the summary is not available in standard interface.

Create a computeExpression field in the Dataflow to calculate the summary.

In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word 'Yes' in green; a value of false should result in the display of the word 'No' in red.In which two ways can this be accomplished? Choose 2 answers

Download the XMD for the dataset and change the values and color for the fields and then upload to the dataset.

In the explorer, select the boolean fields and use the 'edit values' option on the fields to change values and colors.

Download the XMD for the dataset and change the values and color for the fields and then upload to the dataset.

In the explorer, select the boolean fields and use the 'edit values' option on the fields to change values and colors.

Create an XMD node in the dataflow to change the label and color of the values in the fields.

In the explorer, select the boolean fields, then create a derived dimension that references the boolean fields, and then modify the values and colors of the derived dimension.

Exhibit: Which two statements can be determined based on the Why it Happened graphic above' Choose 2 answers

Call Center is a generally poor performing product, and since there is more in Germany that has a negative effect.

Germany sells more Call Center product and that helps them increase their win rate.

Germany performs lower than average but better when the product is Call Center.

The -2.2 Unexplained means there are effects that Einstein will never be able to explain regardless of the dataset.

Call Center is a generally poor performing product, and since there is more in Germany that has a negative effect.

Germany sells more Call Center product and that helps them increase their win rate.

A company uses role hierarchy to implement data security in Salesforce. They want the same role-hierarchy-based security model to apply in Einstein Analytics, but want the users in a role to see data owned by other users in the same role.Using the 'flatten' transformation, which attribute setting achieves this requirement?

Set the attribute 'include_self_id' to true.

Set the attribute 'selfjield' to true.

Set the attribute 'selfjield' to false.

Set the attribute 'include_self_id' to true.

Set the attribute 'include_self_id' to false.

Universal Containers has a dashboard for Sales Managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. An Einstein Consultant created a static step to display three values: ClosedDate_month, ClosedDate_quarter, and ClosedDate_year.What should the consultant do next?

Use selection binding to update the grouping in the chart.

Use nested binding to update the grouping in the chart.

Use selection binding to update the measure in the chart.

Use result binding to update the measure in the chart.

Use selection binding to update the grouping in the chart.

A Senior Sales Business Analyst asks for a dashboard that contains fiscal year product opportunities. Information is maintained in a spreadsheet which is comprehensive, but its contents often need to be explained. After sketching the dashboard, the consultant is ready to start building.Which concept should be applied to this dashboard?

Use charts to help users ask questions, not illustrate a conclusion.

Limit widget actions and exploration so users will focus only on the high-level information.

Use the different chart types to make the dashboard interesting and appealing.

Design the dashboard with the desktop in mind and use the same layout for mobile devices for consistency.

Use charts to help users ask questions, not illustrate a conclusion.

A company used Einstein Analytics to create two datasets:1. 'Opportunity With Account- dataset, which contains data from the Opportunity standard object augmented by the Account data.2. 'Case with Account' dataset. which contains data from the Case standard object augmented by the Account data.The company wants to build a lens showing the total number of Opportunities and Cases per Account. How can a consultant help them build this lens?

Use a SAQL query to group and join the 'OpportunityWithAccount' and 'CaseWithAccount' datasets then generate the results.

Create a recipe to generate a new dataset from the 'OpportunityWithAccount' and 'CaseWithAccount' datasets aggregated by Account, and use the generated dataset in a lens.

Use 'Compare Table' to join the 'OpportunityWithAccount' and 'CaseWithAccount' datasets using the 'Accountld' and then aggregate by Account.

Set up Connect Data Sources in the UI between the 'OpportunityWithAccount' and 'CaseWithAccount' datasets.

Use a SAQL query to group and join the 'OpportunityWithAccount' and 'CaseWithAccount' datasets then generate the results.

The client is trying to create a SAQL step to predict sales in each sales region. They cannot get the query to return any results, but have identified that the error is in the time series statement. They have asked an Einstein Consultant to review the following query and fix any errors. Which timeseries statement will fix the query'

q = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (Iength = 12, dateCols=('Date_Year', 'Date_Month'. 'Y-M'), partition='Region');

q = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (dateCols=('Date_Year, Date_Quarter', 'Y-Q'), partition=Region', ignoreLast=true);

q = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (Iength = 12, dateCols=('Date_Year', 'Date_Month'. 'Y-M'), partition='Region');

q = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter', 'Y-Q'), partition='Region', seasonality=4);

q = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter', 'Y-Q'), partition='Region');

The Universal Containers company built three Einstein Discovery stories that they want to use in Salesforce to predict and maximize their revenue per customer. The stories are for every region where they have business: EMEA, AMER, and APAC.How can a consultant help them deploy the three Einstein models to Salesforce?

Segment the account data per region and deploy the appropriate model for each segment.

Segment the account data per region and deploy the same model to all segments.

Deploy the same model to all accounts and set the region field as an actionable variable.

Deploy the same model to all accounts and use an Apex trigger to call the appropriate prediction.

Segment the account data per region and deploy the appropriate model for each segment.

An Einstein Analytics team reports that when they start their dataflow it runs successfully with no errors or warnings, but one of the fields does not return values when it is queried.What can be the origin of this issue?

The field does not contain any data in Salesforce.

The user who runs the dataflow does not have access to the field.

The 'Integration User Profile' does not have access to the field.

The ''Security User Profile' does not have access to the field.

The Universal Containers company uses Einstein Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users for the same department have the same role and need to have access to the same dashboards. Dashboards for different departments use some common datasets with the same row-level security.How can an Einstein Consultant address this need?

Create one application for each department, put common datasets in the shared app, and use roles to share applications.

Create one application for each department and use roles to share applications.

Create one application for each department, put common datasets in the shared app, and use profiles to share applications.

Create one application for each department, put common datasets in the shared app, and use roles to share applications.

Create one application for each department, put common datasets in the shared app, and use permission sets to share applications.

A new field called 'CardBalance' is added to the standard object. Account. The team wants to add this new field to an Einstein Analytics dataset that sources the Account object; however, the team needs to limit the users who are able to view that field's data in the dataset.How can an Einstein Consultant help them implement this new requirement?

Create a new Account dataset containing the new field and give access to this dataset only to users who should be able to see the new field.

Add the new field to the existing dataset and use the XMO file parameters to hide the new field from users who should not have access to it.

Add the new field to the existing dataset and activate 'Sharing inheritance' in the Account object so only users who have access to the field in Salesforce will have access in Einstein Analytics.

Create a new Account dataset containing the new field and give access to this dataset only to users who should be able to see the new field.

Add the new field to the existing dataset and use 'Security Predicates' to hide it from users who should not access it.

When creating a story in Einstein Discovery, do all potential collinear fields need to be removed before executing the build story'5

No. Although it is ideal to eliminate collinearity as soon as possible, Einstein will give a warning post-build and the ridge regression will prevent collinearity from over-fitting.

No. Einstein Discovery is impervious to collinearity, so the story and subsequent model will be fine.

No. Although it is ideal to eliminate collinearity as soon as possible, Einstein will give a warning post-build and the ridge regression will prevent collinearity from over-fitting.

yes. If all collinear variables are not excluded, the model will over-fit and not make any sense.

Yes. If the collinear variables are not removed, the Einstein Discovery model build will fail.

Which permission gives you view-only access to Analytics?

Create and Edit Analytics Dashboard

What does a configuration wizard do?

Asks you questions about how you store data in your org to help you create your app

Automatically creates multiple versions of the same app

Lets you know the best way to set up your Salesforce data

Asks you questions about how you store data in your org to help you create your app

Customizes your template based on Salesforce settings

What can changing an answer to a wizard question do?

Fine-tune dashboards to reflect how your company measures key indicators

Alter your Service Cloud implementation

Fine-tune dashboards to reflect how your company measures key indicators

Create a new set of dashboards with new KPIs

Use up one of the three wishes granted you by the wizard

What are predictive insights good for?

Drilling down into the underlying reasons behind a prediction

Predicting outcomes that you don't actually have the right data for

Exploring your existing data to see what already happened

Drilling down into the underlying reasons behind a prediction

Choosing between all possible outcomes for a single variable

How do you open the Actions menu for a particular case shown in a dashboard?

Hover over the case number column of the values table widget and click the arrow that appears

Click the Actions bar from a bubble chart

Hover over the case number column of the values table widget and click the arrow that appears

Double-click the case number in the Actions widget

Simply @mention the case manager for that segment

What does the Division is Naval section of the waterfall graph tell you?

How combinations of factors affect the CLV for Naval customers

How individual factors separately affect the outcome for Naval customers

What the relationship is between significant and insignificant factors as they impact CLV for Naval customers

How the chosen variable is related to all other factors in the model for Naval customers

When you set up Analytics, which of the following features can you enable?

Sharing of apps with Communities

Why is it important to prepare the data in a CSV file before you bring it into Analytics?

To make sure Analytics can set the field type correctly

To make sure the content is interesting

To add currency symbols to numeric fields

To make sure Analytics can set the field type correctly

What does Einstein Analytics check when a user submits a query against a dataset?

Which rows the user has access to

Whether the user has access to the app

Which fields the user has access to

If the user has access to the dataset

Which rows the user has access to

In the context of Analytics, what is faceting?

Filtering all related widgets in a dashboard by your selection

Representing the number of widgets on a dashboard

Filtering all related widgets in a dashboard by your selection

Something only programmers can access

Measuring the number of significant digits of precision for a particular metric

Choosing the color of the background in a graph

What's the best way to describe the template-info.json file?

It's the boss of the template with all the information needed to create the app.

It's a read-only file with all the user documentation for a template.

It's the boss of the template with all the information needed to create the app.

It makes sure that the app includes all the right Salesforce data.

It's automatically populated every time you create an app from the template.

What can you do with the dataflow?

Extract Salesforce object data into Analytics

Extract data from an external CSV file into Analytics

Extract Salesforce object data into Analytics

What happens if the ui.json file is empty?

The template will not include a configuration wizard.

You create a text-only version of an app.

The template will not include a configuration wizard.

The app includes all possible dashboards by default.

What do Analytics apps do?

Use ready-made dashboards to tell easy-to-follow stories about your data

Let you add new types of charts to Salesforce

Alert you when you need a visa for an upcoming trip

Use ready-made dashboards to tell easy-to-follow stories about your data

Let you create configuration wizards to make Analytics setup easier

Salesforce Certified Tableau CRM and Einstein Discovery Consultant Practice Test 3

Universal Containers reports that any selection in the List widget is not affecting the Pie chart in one of their Einstein Analytics dashboards. The step options associated with the List widget and Pie chart are shown in the graphic.

Salesforce Certified Tableau CRM and Einstein Discovery Consultant image Question 81 69534 09232024003313000000

Given that the steps are using different datasets. which two changes can an Einstein Consultant make to solve this issue' Choose 2 answers

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Tableau CRM and Einstein Discovery Consultant Practice Test 3

Question

Drag and Drop

Hot Area

Salesforce Certified Tableau CRM and Einstein Discovery Consultant Practice Tests

Practice Tests