Quiz
Einstein Analytics Certification Questions
Questions in this quiz (200)
1A large company is rolling out Einstein Analytics to their field sales. They have a well-defined role hierarchy where everyone is assigned to an appropriate node on the hierarchy.
An individual Sales rep should be able to view all opportunities that she/he owns or as part of the account team or opportunity team. The Sales Manager should be able to view all opportunities for the entire Sales team. Similarly, the Sales Vice President should be able to view opportunities for everyone who rolls up in that hierarchy.
The opportunity dataset has a field called 'Ownerld' which represents the opportunity owner.
Given this information, how can an Einstein Consultant implement the above requirements?- AAs part of the dataflow, use the flatten operation on the role hierarchy and create a multivalue attribute called 'ParentRolelDs' on the opportunity dataset and apply following security predicate: 'ParentRolelDs' == "$User.UserRoleId" && 'Ownerld' == "SUser.Id".
- BAs part of the dataflow, use computeExpression on the Roleld field to create an attribute called
'ParentRolelDs' on the opportunity dataset and apply following security predicate: 'ParentRolelDs' == "$User.UserRoleId" || 'Ownerld' == "$User.Id". - CAs part of the dataflow, use computeRelative on the Roleld field to create an attribute called
'ParentRolelDs' on the opportunity dataset and apply following security predicate: 'ParentRolelDs' == "$User.UserRoleId" || 'Ownerld' == "$User.Id". - DAs part of the dataflow, use the flatten operation on the role hierarchy and create a multivalue attribute called 'ParentRolelDs' on the opportunity dataset and apply following security predicate: 'ParentRolelDs' == "$User.UserRoleId" || TeamMember.Id' == "$User. Id" || 'Ownerld' == "SUser.Id".
2To see predictive insights, what option do you select in the Story toolbar?
- AWhat Changed Over Time
- BHow Can I Improve It
- CPredictions & Improvements
- DWhy It Happened
- EWhat Happened
3A 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?- ALimit widget actions and exploration so users will focus only on the high-level information.
- BUse the different chart types to make the dashboard interesting and appealing
- CDesign the dashboard with the desktop in mind and use the same layout for mobile devices for consistency.
- DUse charts to help users ask questions, not illustrate a conclusion.
4A Salesforce administrator wants to create a new dashboard that uses custom geoJSON to display data; however, the administrator is unable to upload the file via the UI.
What should be done?- AAdd the system permission "Manage Analytics Custom Maps" to the permission set used.
- BEnable "Custom maps with geoJSON" in the analytics settings.
- CUpload the geoJSON via the API because it is not a function in the UI.
- DContact Salesforce support and request to get custom maps and geoJSON enabled for the org.
5A consultant built an Einstein Analytics app for the Sales Operations team. The team wants to share this app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
In the process of creating the template, which role does the original Einstein Analytics app for the Sales
Operation team play?- AIt is the template.
- BIt is the instance.
- CIt is the master.
- DIt is the target.
6In the list of insights, the first insights that you see are the ones that explain, statistically, the most variation in the outcome variable. The insights that appear later, as you scroll through the story, explain variables that, statistically, account for less of the variation in the outcome variable.
When you select one variable, what are you comparing?- ASelected variable with CLV
- BSelected variable average with the mean
- CSelected variable with a different variable
- DSelected variable average with the filtered average
- ESelected variable with all story data
7A 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?- AAdd 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.
- BAdd 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.
- CCreate 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.
- DAdd the new field to the existing dataset and use "Security Predicates' to hide it from users who should not access it.
8A data architect wants to use a dataflow transformation to implement row-level security that is based on role hierarchy in Salesforce. Which transformation should be used to level the dataset hierarchy'?
- Adigest transformation
- Bflatten transformation
- Cdelta transformation
- DsfdcDigest transformation
9Mosaic recently hired a new development coordinator, Zoe. First, Danielle grants Zoe the Einstein Analytics Platform license, but Zoe reports that she still can't access Einstein Analytics. What could be the problem?
- AAn admin hasn't run a dataflow.
- BDanielle still needs to grant Zoe a permission set containing the Manage Analytics permission.
- CDanielle didn't share the Mosaic app with Zoe in Einstein Analytics.
- DDanielle still needs to grant Zoe a permission set containing the Use Analytics permission.
10A consultant built a very useful Einstein Analytics app for Sales Operations and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as an Einstein Analytics template app, but needs to locate specific information to get started.
What is the REST API URL where the consultant can find current template apps?- A/services/data/v##.#/wave/apps
- B/services/data/v##.#/analytics/wizard
- C/services/data/v##.#/wave/templates
- D/services/data/v##.#/analytics/projects
11A consultant built an Einstein Analytics app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
A set of JSON files will be generated after a template is created from the Sales Operations app. What is the
name of the JSON file that manages template metadata and all other template elements?- Aui.json
- Btemplate-to-app-rules.json
- Cmaster- info.j son
- Dtemplate-info.json
12A consultant is asked to configured a user to view a dashboard, within a designated app, without the ability to create and save lenses.
After adding the user to the app, which action should the consultant take to implement this requirement?- AAssign the Manager role the user
- BEnsure the user has the Analytics permission
- CAssign the Editor role the user
- DAssign the view role to the user
13What are predictive insights good for?
- APredicting outcomes that you don't actually have the right data for
- BExploring your existing data to see what already happened
- CDrilling down into the underlying reasons behind a prediction
- DChoosing between all possible outcomes for a single variable
14What are Einstein Analytics prebuilt permission sets? Select 2:
- AEinstein Analytics Platform Admin
- BEinstein Analytics Platform User
- CEinstein Analytics
- DEinstein Analytics Superadmin
15What kind of org should you use for checking challenges when you do Trailhead modules about Analytics?
- AAn enterprise org, because that type of org is typically used by large companies
- BA trial org, because you don't need to save anything
- CA Developer Edition org, because it's a free, safe environment where you can try things out
- DA higher education org, because analytics requires advanced math
16Universal 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.
Given that the steps are using different datasets. which two changes can an Einstein Consultant make to solve this issue' Choose 2 answers
- AUse 'Connect Data Sources" and create a connection to connect the two datasets.
- BUse selection binding in the filters section of Che step "Step_pie_2."
- CUse "Connect Data Sources" and create a connection to connect the two widgets.
- DUse selection binding in the filters section of the step "Type_l."
17What can you do on the Edit Field Attributes page when uploading a CSV file to Analytics?
- AChange a field's name
- BChange a field's format
- CChange a field's type
- DAll of the above
18Which of the following are requirements for enabling Analytics for Communities?
- AWait at least 3 days after purchase.
- BHave a Customer Community Plus or Partner Community license.
- CBe nominated by your community peers.
- DAssign your community members the Analytics for Communities permission set license.
- E(B&D)Have a Customer Community Plus or Partner Community license.
&
Assign your community members the Analytics for Communities permission set license.
19What are the steps in the data exploration process?
- AView, Explore, Refine, Save, Share
- BView, Explore, Reduce, Save, Share
- CDownload, View, Refine, Save, Share
20A Einstein Analytics consultant is asked to help a company report on their sales activity. The company wants to train some users to create their own dashboards. They also want another team to only be able to use the dashboards.
What must be configured to address these requirements?- ACreate two permission sets with different system permissions.
- BUse a permission set license with two different levels of access.
- CGrant "Manage" access permission to the apps.
- DCreate a permission set license assignment with two different levels of access
21Yasmine wants to create a lens with the Seed Bank Orders dataset, but she currently doesn't see any rows in the dataset. Since Yasmine is Hadiqa's manager, Yasmine asks Hadiqa if she's experiencing the same problem, but Hadiqa replies that she can see all the rows. Why is this happening?
- AThe dataset's security predicate was set up incorrectly.
- BYasmine doesn't have the Manager app role.
- CYasmine wasn't assigned a permission set.
- DYasmine doesn't have the Create and Edit Analytics Dashboards permission.
22What does Einstein Analytics check when a user submits a query against a dataset?
- AWhether the user has access to the app
- BWhich fields the user has access to
- CIf the user has access to the dataset
- DWhich rows the user has access to
23Maximum concurrent API Analytics calls per org
- A200
- B500
- C100
- D50
24What is the order of filter, limit, order and offset functions in SAQL?
- AFilter and order can be interchanged. Offset must be after filter/order and limit must come after offset.
- BOffset can be anywhere, but filter/order and limit must come after offset. Filter and order can be interchanged.
25You are asked to update and maintain your company's Einstein Analytics dashboards. A request comes in for one of the dashboards that contains steps from different datasets. The request is to make it possible for a table from one dataset to be filtered by the results of a chart from another dataset. Your solution is to create a results binding.
Which three steps should you implement to create the binding?- ALook up the API name of the filtering field
- BLook up the API name of the source field
- CFind source and target step names
- DConfigure the results binding on the target step in the dashboard JSON.
26A small Business Intelligence team is overwhelmed with multiple requests to create new dashboards. An option is to use layout templates to help with dashboard development.
What are two advantages of using layout templates? Choose 2 answers- ALayout templates offer a consistent end user experience.
- BLayout templates are fast to create because they are fixed and read-only.
- CLayout templates fdcDigest transformation offer a universal layout thus reducing the hours spent on design.
- DLayout templates are equipped with design best practices, such as optimally positioned KPIs and filters.
27Why are insights in the Unrelated category important?
- AThey explain everything about the outcome.
- BThey aren't important. Hence the name, Unrelated.
- CThey explain how interaction terms affect the outcome.
- DThe outcome might not have much to do with related variables. It might have more to do with global effects.
28A consultant built a very useful Einstein Analytics app for Sales Operations, and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as an Einstein Analytics template app, but needs to locate specific information to get started.
Given the code statement above, which endpoint should it be posted to?
- A/services/data/v##.#/wave/apps
- B/services/data/v##.#/analytics/wizard
- C/services/data/v##.#/analytics/projects
- D/services/data/v##.#/wave/templates
29What does the Division is Naval section of the waterfall graph tell you?
- AHow combinations of factors affect the CLV for Naval customers
- BHow individual factors separately affect the outcome for Naval customers
- CWhat the relationship is between significant and insignificant factors as they impact CLV for Naval customers
- DHow the chosen variable is related to all other factors in the model for Naval customers
30The Universal Containers company plans to upload target data from an external tool to Einstein Analytics so they 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 representative, the target amount, and the month of the target. For each sales representative, 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?- AUpdate
- BAppend
- COverwrite
- DUpsert
31Is there a need for a separate Permission Set Licence for an Analytics app?
- AYes
- BNo
32What do you have to assign to users before they can access Analytics?
- AAnalytics permission set license (PSL)
- BPermission set with at least one Analytics user permission
- CUsername and password
- D(A & B) Analytics permission set license (PSL) & Permission set with at least one Analytics user permission
- E(B & C) Permission set with at least one Analytics user permission & Username and password
33What kind of insight is "What Is The Difference"?
- ADescriptive
- BDiagnostic
- CPredictive
- DPrescriptive
- ESelective
34Salesforce Analytics is...
- AAn application built on top of Salesforce
- BA tool for analyzing surf reports and forecasts
- CA CRM alternative to Salesforce
- DAn online repository of infographics
35Why would you use a merge key in a dataset recipe?
- ATo find out what the merge icons represent in a dataset
- BTo schedule when a dataset recipe runs
- CTo join related data from different sources
- DTo deal with duplicate records
36Trending data limits: Maximum number of trended datasets per user and rows per snapshot:
- A5 per user, 200,000 per snapshot
- B10 per user, 100,000 per snapshot
- C10 per user, 200,000 per snapshot
- D5 per user, 100,000 per snapshot
37What is the test called that helps to identify categories that exhibit a pattern outside the overall average?
- ANull hypothesis test
- BSignificance level test
- CCritical region test
- DChi-square test
- ET-test
38The model quality metrics of an Einstein Discovery story indicate that the GINI coefficient in the four folds are 0.82, 0.83, 0.84, and 0.75, respectively.
Which two actions should a consultant take? Choose 2 answers- ADeploy the story, because the variation in the metrics is within the normal range.
- BConfirm that the overall GINI coefficient is good prior to deploying the story.
- CResearch and check the dataset for outliers in the target field and the main predictors that are shown on top of the story.
- DDo not deploy the story immediately, and research why one fold is performing worse than the others.
39Max number of dataflow definitions (with data sync enabled)
- A35
- B55
- C25
- D15
40A large company has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able to view the attainment data for each rep in their division. Each rep should only be able to see their own commission data.
Which option should be used to enforce this requirement?- ACreate separate datasets for attainment and commission and apply security predicates and/or sharing inheritance.
- BApply a security predicate on the existing single dataset.
- CUse sharing inheritance.
- DAdd the sales organization to the attainment dataset access list.
41Which permission gives you view-only access to Analytics?
- AUse Analytics
- BManage Analytics
- CCreate and Edit Analytics Dashboard
- DNone of above
42Upper and lower limits on rows in discovery.
- A1000 row minimum, 15,000,000 max
- B3000 row minimum, 20,000,000 max
- C00 row minimum, 20,000,000 max
- D500 row minimum, 25,000,000 max
43Can you share data from a widget?
- ANo, you can't share data from a widget.
- BSelect the step of the widget and share data.
- CSelect "Share" icon, click on "Download", and select "Download in .png, .XLS, or CSV" format.
- DOnly with the proper Einstein Analytics Platform license.
44The 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?- ASegment the account data per region and deploy the same model to all segments.
- BDeploy the same model to all accounts and set the region field as an actionable variable.
- CDeploy the same model to all accounts and use an Apex trigger to call the appropriate prediction.
- DSegment the account data per region and deploy the appropriate model for each segment.
45How many groupings can you have in a Compare Table?
- ANone
- BOne
- CInfinite
- DUp to four
46Universal 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?
- AUse the Show Summary option in the compare table.
- BAdd a formula field to calculate the summary.
- CUse a SAQL query since the summary is not available in standard interface.
- DCreate a computeExpression field in the Dataflow to calculate the summary.
47Timeout for ETL jobs that have been scheduled but not executed
- A5 minutes
- B15 minutes
- C20 minutes
- D10 minutes
48How do you open the Actions menu for a particular case shown in a dashboard?
- AClick the Actions bar from a bubble chart
- BHover over the case number column of the values table widget and click the arrow that appears
- CDouble-click the case number in the Actions widget
- DSimply @mention the case manager for that segment
49What's a good way to see which required questions in the configuration wizard don't have default values?
- AAnswer only questions that involve custom objects
- BTry each option in the dropdown one at a time
- CDownload the app and run a SAQL query on the JSON
- DClick "Looks good, next" and look for questions highlighted in red
50Which statement best describes how to ensure Einstein Analytics dashboards are easily used across both desktop and mobile devices?
- ACreate multiple layouts, and reorder all the widgets so that they fit nicely within the new default width.
- BCreate a single layout and allow Einstein Analytics to automatically organize dashboard contents to be optimal for the device type.
- CCreate a single layout and reorder all the widgets so that they fit nicely when viewing on either device.
- DCreate multiple layouts, ensure the layout selectors match the device, and resize/hide widgets as necessary to ensure the content is appropriate for the device screen size.
51A client has a dashboard for Sales Managers. They want to have a list filter that shows the name of the month. However, based on the "CloseDate_Month" field, the list filter shows numbers instead of names.
How can an Einstein Consultant use the Dataflow nodes to generate the name of month as a new dimension in the dataset?- Aflatten
- Bcompute Relative
- Ccompute Expression
- Dappend
52Which widget property allows a consultant to restrict the view to a domain bounded by the values entered?
- AAdd Custom Domain
- BFilter by Range
- CAdd Custom Range
- DAdd Filter
53How many stories can you create in Analytics Plus?
- A5,000
- B1,000, but more can be purchased
- C75, but more can be purchased
- D500, but more can be purchased
54In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.
Which SAQL statement will fetch all Opportunities, even if they don't have associated Activities, and fetch related Activity data, if it exists?- Aq = cogroup Opportunity by 'Id', Activities by 'Opportunityld';
- Bq = cogroup Opportunity by 'Id', Activities by 'Opportunityld' left;
- Cq = cogroup Opportunity by 'Id' right, Activities by 'Opportunityld';
- Dq = cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';
55A consultant is asked to configure a user to view a dashboard, within a designated app, without the ability to create and save lenses. After adding the user to the app, which action should the consultant take to implement this requirement?
- AAssign the Editor role to the user.
- BAssign the Viewer role to the user.
- CEnsure the user has the Use Analytics permission.
- DAssign the Manager role to the user.
56Einstein found a recommendation to improve the story: apparently there are two variables that behave the same. Given there is no additional information, what is the correct action?

- ARetain Promotion; it is an actionable variable and without it, we cannot recommend prescriptive actions.
- BCancel this story and redefine the dataset.
- CRetain Amount; not knowing the size of a deal makes it hard to predict if will be won.
- DDo nothing; they appear to be similar, but there might be differences from the business perspective.
57A customer wants to change the default blue color on a bar chart. What is the easiest way to change blue to another color?
- AUse conditional formatting under the bar chart widget properties by selecting the dimension.
- BUse conditional formatting under the bar chart widget properties by selecting the measure.
- CUse bindings to specify a color per bar.
- DCreate a compare table formula to specify a hidden metric for coloring purposes.
58What is an Einstein Discovery story?
- AAn account of imaginary or real people and events told for entertainment
- BA collection of graphs, statistical analysis, and text that helps you understand the relationships between multiple outcome variables and the factors that influence those variables
- CA collection of graphs, statistical analysis, and text that proves exactly what caused an outcome
- DA collection of graphs, statistical analysis, and text that helps you understand the relationships between a single outcome variable and the factors that influence that variable
59A company's Salesforce org has multi-currency enabled. This company's business intelligence team used Einstein Analytics to build a dataflow that creates a dataset, "OpportunityDataSet". This dataset is populated with data extracted from the standard object, Opportunity. One of the extracted fields is the standard field, Amount.
If a user explores the "OpportunityDataSet" in Einstein Analytics, in which currency will the Amount values be shown?- AIn the connected user's currency
- BIn the integration user's currency
- CIn the currency that is set on the "currency" attribute in the dataset
- DIn the currency that is set on the "currency" attribute in the dataflow
60Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customersThe formula used is: YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is no 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?
- Areplace()
- Bnumber_to_string()
- Ccoalesce()
- Dsubstr()
61When creating a story in Einstein Discovery, do all potential collinear fields need to be removed before executing the build story?
- ANo. Einstein Discovery is impervious to collinearity, so the story and subsequent model will be fine.
- BNo. 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.
- Cyes. If all collinear variables are not excluded, the model will over-fit and not make any sense.
- DYes. If the collinear variables are not removed, the Einstein Discovery model build will fail.
62Which three statements are true regarding sharing inheritance? Choose 3 answers
- AIf a user can see more than 3,000 records on the object in Salesforce, but the user does not have the "View All Data" permission, sharing inheritance is not used. The backup security predicate takes effect. This limitation does not apply to the Opportunity object.
- BSharing inheritance supports Account, Campaign, Case, Contact, Opportunity, Lead, Order, User, and custom objects. If you use other objects, such as Idea or Site, you must use security predicates for those objects.
- CA dataset using sharing must also have a security predicate defined.
- DSharing inheritance supports a foreign key for enforcing security.
- EWhen sharing inheritance is enabled, security predicates are ignored.
63An 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?- AThe field does not contain any data in Salesforce.
- BThe user who runs the dataflow does not have access to the field.
- CThe "Integration User Profile" does not have access to the field.
- DThe ""Security User Profile" does not have access to the field.
64Universal Containers (UC) is a multinational company that utilizes Salesforce and has a variety of internal systems. UC uses Einstein Analytics for their data analysis platform and they want to automate their weekly manual process to create a dataset from their on-premise data warehouse. Which solution should a consultant recommend to meet this requirement?
- AUtilize a Salesforce weekly export feature
- BUtilize Analytics Connector
- CUtilize middleware with Analytics External Data API
- DUtilize a dataflow
65What can you change in a Compare Table formula column?
- AThe filters
- BThe measure
- CThe grouping
- DThe formula and the name
66What's the magic of faceting?
- AIt binds charts together so that selecting something in one chart filters other charts by that choice.
- BIt shifts the time period of the chart you're viewing.
- CIt turns the dataflow on and off.
- DIt creates a chart that shows all the faces of your data in a diamond chart.
67When you set up Analytics, which of the following features can you enable?
- ALow-fuel notifications
- BSharing of apps with Communities
- CAccess to the API
- D(A & B) Low-fuel notifications & Sharing of apps with Communities
- E(B & C) Sharing of apps with Communities & Access to the API
68A consultant created a dashboard using Einstein Analytics for her client, a shipping company. It sources data from very large datasets. Now the client has requested that the consultant add more steps to the dashboard.
To ensure that the dashboard has acceptable performance, what two actions should the consultant take? Choose 2 answers- ACheck if any steps can be reused for multiple purposes.
- BReplace AggregateFlex steps with SAQL steps.
- CSplit the steps and charts into different pages in a dashboard.
- DAvoid using conditional formatting.
69About what does the configuration wizard ask you questions about how you measure?
- ACase duration
- BCustomer geography
- CCustomer satisfaction
- DCase resolution
- EAll of the above
70Which chart type is best suited to track progress of sales revenue that is realized versus the target?
- ABar chart
- BFlat gauge
- CPivot table
- DPie chart
71What can changing an answer to a wizard question do?
- AAlter your Service Cloud implementation
- BFine-tune dashboards to reflect how your company measures key indicators
- CCreate a new set of dashboards with new KPIs
- DUse up one of the three wishes granted you by the wizard
72Can you share dashboards with others in your org?
- AClick on the "Share" icon on the dashboard. From there, you can set up sharing options, post a dashboard screenshot to Chatter, get a URL to share, or download a screenshot.
- BClick on the "Share" icon on the lens. From there, you can set up sharing options, post a dashboard screenshot to Chatter, get a URL to share, or download a screenshot
- CNo, you can't share dashboards.
- DClick on the "Share" icon on the dataset.
73An Einstein consultant created a dashboard that went through review. Some few charts were added and removed in the process. The dashboard is now approved for production.
Which best practice should be done before releasing the dashboard?- AModify the XMD so all labels and values are user-friendly.
- BRename all the steps to correspond with the defined naming convention.
- CRemove the redundant steps to ensure dashboard performance.
- DApply conditional formatting on the new charts.
74A consultant is working with the client to define goals and metrics for an app that will be built. The consultant decides to base the dashboards on personas and is in the design phase prior to starting the actual build.
Which two design considerations should be determined at this time? Choose 2 answers- AWhich fonts to use for headers and body text
- BWhich charts to use to best support the defined goal
- CHow many charts should be allowed on a single dashboard
- DWhich colors to use and how to use them
75An Einstein Analytics team wants to create a dashboard using two standard Salesforce objects. The dashboard should display data from the Case object, along with related data from the Account object.
Which two processes can achieve this?- AExtract data from the case and account objects using "sfdcDigest" transformation, Q use "append" transformation to add case data with account data, store as a dataset, and then build a dashboard using the generated dataset
- BExtract data from the case and account objects using an ETL tool, use the ETL tool to join account and case data, and then upload the data to Einstein Analytics. Build a dashboard using the ETL generated dataset
- CExtract data from the case and account objects using "sfdcDigest" transformation, use "augment" transformation to add case data with account data, store as a dataset, and then build a dashboard using the generated dataset
- DExtract data from the case and account objects using "dataloader", create a CSV file Q with account and case data, and then upload the CSV as a dataset to Einstein Analytics. Build a dashboard using that dataset
76What is a keyword in SAQL? And what case must it be in?
- AA keyword is basically just a function in SAQL, like group, foreach, etc. And it has to be lowercase.
- BA keyword is basically just a function in SAQL, like group, foreach, etc. And it has to be uppercase.
77Universal Containers has a Sales Manager dashboard- They have a compare table that displays the count of Customers and the Sum of Annual Revenue per year and per Account type. A consultant is asked to add more groupings to enhance details about their customers.
What is the maximum number of grouping columns that the consultant must be aware of in order to continue using a compare table versus creating the query using SAQL?
- A8
- B4
- CUnlimited
- D10
78What is an appropriate response when a client is disappointed that Einstein Discovery only detected patterns that were already known?
- ARemind them that the technology is only as good as the data.
- BAdvise them that the use case may not be accurate.
- CHighlight that Einstein reduces time to insight, which is much faster than learning from experience.
- DRecommend using a visualization tool, like Einstein Analytics, to uncover the details.
79The 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?
- Aq = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (dateCols=('Date_Year, Date_Quarter', "Y-Q"), partition=Region', ignoreLast=true);
- Bq = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (Iength = 12, dateCols=('Date_Year', 'Date_Month". "Y-M"), partition='Region');
- Cq = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter', "Y-Q"), partition='Region', seasonality=4);
- Dq = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter',"Y-Q"), partition='Region');
80What permissions are necessary for someone to edit the XMD?
- AUpload External Data to Analytics
- BManage Analytics Templated Apps
- CEdit Analytics Dataflows
- DEdit Dataset Recipes
81A consultant built an Einstein Analytics app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
What can the consultant do to give the Sales team more choices and options with future apps that are generated from the Sales Operations app?- AUpdate contents in the Sales Operations app and changes will be pushed down to its generated apps.
- BEnsure the Sales team has the necessary permissions to customize their apps.
- CCreate a configuration wizard for the app.
- DUpdate contents in the Sales Operations app and create new template versions of the app.
82What are two main steps for creating a dataset?
- ARun and monitor
- BPlan and map
- CExtract and prepare
- DBuild and explore
83The Universal Containers company used Einstein Analytics to create two datasets:
Dataset A: contains a list of activities with an "activitylD" dimension and a "userlD" dimension
Dataset B: contains a list of users with a "userlD" dimension
The team wants to delete from Dataset A all activities related to users in Dataset B.
How can an Einstein Consultant help them achieve this?- AUse the dataflow transformation "delete" and set "userlD" as the deletion ID.
- BUse a combination of dataflow transformations: "augment" and "filter."
- CUse an external ETL tool to extract both datasets and delete records.
- DUse the recipe operation "delete" and set "userlD" as the deletion ID.
84Concurrent queries per user?
- A20
- B50
- C10
- D25
85Benito has Viewer access to a new Einstein Analytics app. He wants to build and edit a dashboard using the Seed Bank dataset in this new app.
What must an admin do for Benito to do this?- AGrant Benito access to all datasets in the org.
- BAssign Benito a permission set that contains the permission: Create and Edit Analytics Dashboards.
- CGrant Benito access to the app that contains the Seed Bank dataset and assign him a permission set that contains the Create and Edit Analytics Dashboards permission.
- DAssign Benito a permission set that contains the permission: Create and Manage Analytics Apps.
86In a story investigating margin, large variations between product groups are dominating the story. Which action might an Einstein Consultant take to resolve this?
- AAdd more data to the dataset.
- BNormalize the margin by product group.
- CEliminate extreme values in the dataset.
- DRun separate stories for each region.
87How do you analyze data from a CSV file using Einstein Discovery?
- AImport the CSV file into Einstein Discovery.
- BImport the CSV file into the most similar Salesforce object, then run reports on that object.
- CYou can't import data from a CSV file
- DImport the CSV file into an Einstein Analytics dataset, then create a story.
88Upper and lower limits on columns (vars) in discovery:
- A20 column minimum, 50 maximum
- B10 column minimum, 200 maximum
- C2 column minimum, 50 maximum
- D2 column minimum, 25 maximum
89To use the Sales Analytics app, which permission set license do you need?
- ASales Wave
- BSales Analytics Apps
- CAnalytics Templated Apps
- DSecurity User
90A 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?
- AUse a SAQL query leveraging the "fill" statement with a "partition" parameter.
- BUse a SAQL query to create fake rows for any data that is missing data from the dataset.
- CUse a "Compare Table" and use the "Show summary" option.
- DUse a "Compare Table" and add a column leveraging the "Running Total" function.
91A consultant built an Einstein Analytics dashboard for a company. The company then requested an enhancement to the dashboard and provided additional data that needs to be displayed. As a result, the consultant decides to "augment" the dataflow.
Which phrase describes this transformation?- AAdd data based on the right-side grain
- BJoin data similar to an SQL statement
- CAdd data as a lookup relationship (left side is the lowest grain)
- DJoin data based on a many-to-many relationship
92The Event Monitoring Analytics app brings prebuilt insights and analytics to what type of existing data in your org?
- AField audit trail data
- BForensics data
- CSales Cloud data Login
- DEvent log file data
93After getting approval of the dashboard layout design for a desktop, the Einstein Analytics consultant is ready to start the design process for a mobile layout.
What are three considerations that the consultant should keep in mind when developing the layout? Choose 3 answers- AIf no layouts are eligible for the mobile device, the first defined layout is used.
- BIf no layouts are eligible for the mobile device, an error message will be displayed.
- CIf more than one layout is eligible, the one with the most device properties set is used. If there is a tie, the most recently defined layout is used.
- DA layout for mobile is eligible for use when the device meets all the device properties set in the Layout panel.
- EThere are widgets that cannot be displayed on mobile layouts.
94Einstein Discovery gives you several different kinds of recommended insights. Which of these insights is descriptive?
- AWhat Happened
- BWhy It Happened
- CPredictions & Improvements
- DWhat Is the Difference
95Einstein Discovery is a tool that:
- AIs like having a personal data scientist on staff
- BReplaces your team of BI experts and data analysts
- CHelps you hire the best data scientist for your business
- DUnderstands your business better than you do
96Default # rows in compare table.
- A1,500
- B1,000
- C3,000
- D2,000
97When organizing information in an Einstein Analytics dashboard, what does the "Progressive Disclosure' design principle mean?
- AOnly provide the user with the level of detail they need to see, with the option to drill down deeper into more details.
- BUtilize the latest templates for the most modern look and feel.
- CIntentionally omit specific details so that users can do ad-hoc exploration if needed for root-cause analysis.
- DImplement strict security predicates to minimize the amount of information displayed to users.
98What does XMD stand for?
- AConfiguring unsupported fields
- BLenses Dataset Fields
- CExtended Metadata
- DCreate a JSON
99Philip adds a recently created Seed Bank Orders dataset to an Einstein Analytics app for which the Mosaic Seed Bank project team has the Viewer app role.
How much data in the Seed Bank Orders dataset can a project team member see?- ANone of the data
- BOnly rows designated by the Salesforce administrator
- CAll rows and fields in the datasets
- DOnly rows designated by the App Manager
100Using the Setup menu, the Universal Containers company activated data sync (replication) in the Einstein Analytics settings. After running the sync, they notice that the aggregate sum of a field within their dataset is different than what they manually calculated by summing the same data in the Salesforce object from which the dataset was populated.
Which two differences in the newly synced data can explain this? Choose 2 answers- ADifferences involving permanently deleted records
- BDifferences involving workflow-updated fields
- CDifferences involving formula fields
- DDifferences involving trigger-updated fields
101Insights in a story show you how different variables and combinations of variables explain the variation of what kind of variable?
- AExplanatory variable
- BOutcome variable
- CGlobal variable
- DLocal variable
- ETertiary variable
102The Universal Containers company thinks it knows everything about its business. However, Einstein Discovery surfaces an unexpected pattern that is concerning. They call in departmental experts and hold a meeting to discuss next steps with an Einstein Consultant.
What should the consultant advise as the next action?- AConsult a Data Scientist for further analysis.
- BDetermine if the pattern is a data issue or a new insight.
- CFilter out the data that causes the unexpected pattern and analyze the new results.
- DAccept the new pattern and have confidence that Einstein knows the business as accurately as the customer
103The Vice President of Sales wants to create a "Pipeline Trending" dashboard in Einstein Analytics that displays specific colors depending on the values of the fields.
Which two techniques can a consultant use to help address this requirement? Choose 2 answers- AUse an XMD file and assign colors to each field value.
- BUse SAQL queries to calculate a color field and assign it to each field value.
- CUse a compute Expression to calculate a color field and assign it to each field value.
- DUse the "fields" menu when exploring the dataset and assign colors to each field value.
104Before using bindings, you can try using facets to specify interactions between widgets.
- ATrue
- BFalse
105How many external files can be uploaded to Einstein Analytics on rolling 24 hour basis?
- A100 files per dataset
- B300 files per dataset
- C500 files per dataset
- D50 files Per dataset
106A 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?- ASet the attribute "selffield" to true.
- BSet the attribute "selffield" to false.
- CSet the attribute "include_self_id" to true.
- DSet the attribute "include_self_id" to false.
107Why is it important to select the right root object when you use the dataset builder?
- AThe root object determines who can see the dataset.
- BOnly data from the root object can be included in the dataset.
- CThe root object determines what related objects you can add to the dataset.
- DThe root object determines what app the dataset is saved in.
108An Einstein Analytics consultant has been asked to refactor a dashboard so that it loads more quickly. After some analysis, the consultant found that most of the dashboard steps run in less than five seconds; however, the Opportunities Table takes 30 seconds to run.
How can the consultant improve the performance of this dashboard?- ACreate a second page on the dashboard and move the table to this new page.
- BCreate a link to download the list of opportunities as an Excel file.
- CCreate a Visualforce page and display a list view of the opportunities on this new page.
- DCreate a second dashboard and move the table to this new dashboard.
109Default rows in values table
- A100
- B200
- C50
- D75
110How do you create a regression timeseries?
- AIn SAQL, use the timeseries function with the following arguments: Partition (the group_by piece), Seasonality (set to 12 to get yearly seasonality).
- B....no other options
111The 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?- ACreate one application for each department and use roles to share applications.
- BCreate one application for each department, put common datasets in the shared app, and use profiles to share applications.
- CCreate one application for each department, put common datasets in the shared app, and use roles to share applications.
- DCreate one application for each department, put common datasets in the shared app, and use permission sets to share applications.
112What happens if the ui.json file is empty?
- AYou create a text-only version of an app.
- BThe template will not include a configuration wizard.
- CThe dataflow fails.
- DThe app includes all possible dashboards by default.
- E(B & D) The template will not include a configuration wizard & The app includes all possible dashboards by default.
113A company created a dataset called myExternalDataset. It contains a dimension, called UserRegion, that is populated by the standard User object's picklist: Region.
The company has security requirements for this dataset:
1. Only a subset of users should be able to access the dataset.
2. Users who can access the dataset should see only data that belongs to their region.
In which two ways can an Einstein Analytics consultant help them implement these requirements? Choose 2 answers- ASave the dataset under "My Private App" so only a subset of selected users can access the dataset.
- BUse a security predicate in the dataset so users can see only rows belonging to their respective regions.
- CCreate a sharing rule in Salesforce based on the Region field in the user object and set the dataset to inherit sharing from Salesforce.
- DSave the dataset under a new application and give "viewer" access to a public group containing the list of users allowed to see the dataset.
114In Einstein Analytics, which node is used in a dataflow to extract data from a registered dataset?
- AsfdcDigest
- Bdigest
- Cexport
- Dedgemart
115After loading data to Einstein Discovery and creating a story, the client asks the Einstein Consultant to explain the "Unexplained Bar" in the "Why it Happened" chart.
Which explanation is correct?- AIt should always be 0 or the model should not be used.
- BIt shows the difference between the predicted outcome and the observed outcome.
- CIt displays the difference between the analyzed data and the data not reviewed.
- DIt only appears for outcomes that do not have an explanation.
116Which conclusion can be made regarding the strength of the model shown?

- AThe model is very strong. A GINI coefficient of .535 shows that this model is very effective.
- BThe model is pretty good; the accuracy rating of .7597 means we can predict both wins and losses at a fairly high rate.
- CThe strength of the model cannot be determined with the metrics shown.
- DThe model is very weak and doesn't provide useful predictions due to the low threshold.
117An Einstein Consultant is reviewing the "Why it Happened" Insights provided by Einstein Discovery with the customer. The customer would like to validate the results. Which action should the consultant take?
- AShow the customer how to export and review the R-Code model validation results
- BCheck the p-values and standard deviation
- CUse the Share and Export feature to help the customer determine if the findings make logical sense
- DConsult with a Data Scientist to validate the findings
118An Einstein Consultant needs to add some data values to an existing dataflow: a text field, a number (via a case statement), and a date (via SAQL).
In order to achieve this, which compute option should be used?- AcomputeExpression
- BcomputeData
- CcomputeValue
- DcomputeField
119A consultant built an Einstein Analytics dashboard for a shipping company. The dashboard displays data from several data sources- The consultant enabled data sync (replication) to increase the speed of data refreshing from these sources.
What is the maximum number of dataflow definitions available in this situation?- A45
- B35
- C25
- D30
120A client has two datasets that are used across seven different dashboards. Three of these dashboards are used by marketing and four are used by sales. The client requires that only marketing can access the marketing dashboards and only sales can access the sales dashboards.
What solution should be recommended?- ACreate two custom apps: one for marketing dashboards with marketing as "viewer" and one for sales dashboards with sales as "viewer." Add the datasets as references to both custom apps.
- BCreate three custom apps: one for marketing dashboards with marketing as "viewer," one for sales dashboards with sales as "viewer," and one for datasets where marketing and sales are "viewer."
- CCreate one custom app for the datasets and share it with marketing and sales as "viewer."
- DDuplicate the datasets and create two custom apps: one for marketing dashboards and datasets with marketing as "editor" and one for sales dashboards and datasets with sales as "editor."
121An Einstein Consultant is implementing encryption for a customer.
Which two statements about Einstein Analytics Encryption are true? Choose 2 answers- AWhen Einstein Analytics Encryption is enabled, all newly registered datasets are encrypted at rest.
- BBy default, the same keys are used to encrypt data in Einstein Analytics as are used to encrypt data in Salesforce objects.
- CThe customer's org must have a Shield Platform Encryption tenant secret.
- DBring Your Own Key is not supported.
122Why would you use the Actions menu in a chart?
- ATo expand the time period shown in a dashboard
- BTo rearrange widgets in dashboards
- CTo post to Chatter
- DTo create workout plan for you and your team
123A company wants to build a webpage that displays KPIs that can be derived from values in datasets stored in Einstein Analytics. How can an Einstein Analytics consultant derive those KPIs from those datasets?
- AUse the Analytics External Data API and leverage the "query" resource.
- BExport the dataset as an XLS file and use the Einstein Analytics Connector for Excel.
- CUse the Analytics REST API and leverage the -query" resource.
- DExport the dataset as a CSV file and load it to an external database.
124In 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- ADownload the XMD for the dataset and change the values and color for the fields and then upload to the dataset.
- BIn the explorer, select the boolean fields and use the "edit values" option on the fields to change values and colors.
- CCreate an XMD node in the dataflow to change the label and color of the values in the fields.
- DIn 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.
125What can you do with the dataflow?
- AExtract data from an external CSV file into Analytics
- BExtract Salesforce object data into Analytics
- CBuild a dashboard
- DExplore a dataset
126Which dataflow transformation does data sync (replication) reference, in an existing dataflow, to determine which Salesforce objects and fields are currently being extracted?
- Aedgemart
- BsfdcRegister
- Cexport
- DsfdcDigest
127A dataset for building the Einstein Discovery story contains 72 fields that are potentially relevant predictors.
Which approach is considered best practice to assess the top predictors in order to get to a meaningful and robust model?- AThis dataset is too big and cannot be used in Einstein Discovery. Request a new dataset with fewer predictors.
- BBuild the story with all the predictors and indicate that Einstein Discovery should show the top predictors.
- CGo back to the data preparation and reduce the number of fields to less than 30 in order to produce a story.
- DBuild a story with a first set of predictors and assess which predictors are important to the story. Then drop the less important ones and add the predictors that were omitted in the first run and assess their impact.
128A consultant wants to optimize data loads by extracting Salesforce objects using independent Einstein Analytics dataflows ahead of time. Which construct should be used to accomplish this?
- AAugment
- BDataflow
- CClone
- DData Sync (Replication)
129Universal 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?- AUse nested binding to update the grouping in the chart.
- BUse selection binding to update the measure in the chart.
- CUse result binding to update the measure in the chart.
- DUse selection binding to update the grouping in the chart.
130In Einstein Discovery:
- A'What Is The Difference' insights are comparative insights that help you better understand the relationships between explanatory variables and the goal (target outcome variable) in your story. These insights, based on a statistical analysis of your dataset, help you figure out which factors contribute to the biggest changes in the outcome variable. Einstein Discovery uses waterfall charts to help you visualize comparisons in What Is The Difference insights.
- B'Why It Happened' insights help you take a deeper look into the exact factors that led to an outcome. Why It Happened s/ Q insights drill deeper into the various factors that contributed to your story's goal. These insights are based on a statistical analysis of your dataset. Einstein Discovery uses waterfall charts to help you visualize Why It Happened insights.
- C'Predictions and Improvements' insights help you explore what might happen in the future. For example, you can interactively perform "what if analyses in your story. Einstein Discovery provides you with predictions and suggested improvements based on a statistical analysis of your dataset and predictive analytics. To help you visualize these insights, Einstein Discovery uses:
- waterfall charts for predictions
- bar charts for suggested improvements - D'What Happened' insights are the primary insights in your story. They are descriptive insights that help you explore, at an y/ Q overview level, what factors contributed to the outcome, based on a statistical analysis of your dataset. .Einstein Discovery uses bar charts to help you visualize What Happened insights.
131Why is it important to prepare the data in a CSV file before you bring it into Analytics?
- ATo remove column headers
- BTo make sure the content is interesting
- CTo add currency symbols to numeric fields
- DTo make sure Analytics can set the field type correctly
132A company wants to allow users who belong to an account team to see all the Opportunities associated with that Account in Einstein Analytics.
Which two actions accomplish this requirement? Choose 2 answers- AApply sharing inheritance.
- BCreate a master-detail relationship between the Salesforce Account and Opportunity objects.
- CIn the dataflow, extract the AccountTeamMember object and augment it with the Opportunity object using 'Accountld' as the join field and apply following security predicate: 'AccountTeamMember.Userld' == "$User.Id".
- DIn the dataflow, extract the OpportunityTeamMember object and augment it with the Opportunity object using 'Opportunityld' as the join field and apply the following security predicate: 'OpportunityTeamMember.Userld' == "$User.Id".
133The client asks an Einstein Consultant to build a dashboard with a chart that shows revenue and quantity of units sold.
Which type of Combo Chart can the consultant use?- ALine over Scatter Plot
- BGrid over Bar
- CLine over Bar
- DLine over Stacked Bar
134Which of the following is true about the Service Analytics Overview dashboard?
- AIt instantly provides key metrics on open cases, average time to close, first contact resolution, and customer satisfaction.
- BIt lets you drill down to more detailed dashboards, like agent performance, channel review, and telephony metrics.
- CIt's available on desktop and mobile.
- DIt's a great place to start your analysis.
- EAll of the above.
135What can you do in a dataset recipe?
- AExtract external data into Analytics
- BBuild a dashboard
- CCombine data from different datasets
- DMake a data chili
136Which of the following are included in the template object?
- Aui.json
- Bapp.json
- Cvariables.json
- D(A,B & C) ui.json & app.json & variables.json
- E(A & C) ui.json & variables.json
137What happens if you first disable Analytics, and then you re-enable Analytics later? Select 2
- AUser permissions are removed from each defined permission set if Analytics is disabled.
- BUser permissions are not removed from each defined permission set if Analytics is disabled.
- CYou must define the permission sets again if Analytics is re-enabled.
- DYou must not define the permission sets again if Analytics is re-enabled.
138Which of these standard deviations is for a curve that has values that are the most spread out away from the average?
- A8
- B1
- C4
- D16
139What does a configuration wizard do?
- AAutomatically creates multiple versions of the same app
- BLets you know the best way to set up your Salesforce data
- CAsks you questions about how you store data in your org to help you create your app
- DCustomizes your template based on Salesforce settings
140An Einstein Consultant receives a request from the Marketing department to help them understand lead conversion. Presently, they are unaware of the percentage of leads that get converted to sales. They hope to view results by account manager, value, and quarter. The data is there, so the consultant can add it to the marketing dashboard.
How should this metric be calculated?- ACreate a new step in the dashboard using a compare table and define a formula.
- BCreate a formula field on the lead object in Salesforce and add it to the dataset.
- CCreate a computeExpression in the dataflow.
- DCreate a new step in the dashboard using a compare table and the running total function.
141A company wants to create a timeline chart to visualize the evolution of their Closed Won Opportunities. What are the required parameters to build a lens that displays output similar to the image shown?

- A2 measures, 0-2 groupings if trellis is disabled, or 0-4 groupings if trellis is enabled
- B1 measure, 1-2 groupings if trellis is disabled, or 1-4 groupings if trellis is enabled
- C1 measure, 1 grouping by a date field, and either 0-1 groupings by a dimension if trellis is disabled, or 0-2 groupings if trellis is enabled
- D1 measure, 0 groupings if trellis is disabled, or 0-2 groupings if trellis is enabled
142A client has a dataset comprised of Opportunity data and Opportunity Line level data. The client wants to use this dataset with Einstein Discovery to understand the Opportunity win rate.
What must be done to the dataset to achieve this goal?- ASelect the isWon = True outcome variable and generate the story.
- BFilter to only look at isWon = True records to avoid skewing the results.
- CClick Create Story and Einstein will take care of the rest.
- DChange the grain by removing the line level detail as it will skew the win rate.
143Which Einstein Analytics asset or assets are created when using an App Template to create an app?
- AThe app, dataflows and datasets, dashboards, and permission sets
- BThe app, dataflows and datasets, and dashboards
- CThe app, dataflows and datasets, and users
- DAn empty app
144In the context of Analytics, what is faceting?
- ARepresenting the number of widgets on a dashboard
- BFiltering all related widgets in a dashboard by your selection
- CSomething only programmers can access
- DMeasuring the number of significant digits of precision for a particular metric
- EChoosing the color of the background in a graph
145A 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?- ACreate a recipe to generate a new dataset from the "OpportunityWithAccount" and "CaseWithAccount" datasets aggregated by Account, and use the generated dataset in a lens.
- BUse "Compare Table" to join the "OpportunityWithAccount" and "CaseWithAccount" datasets using the "Accountld" and then aggregate by Account.
- CSet up Connect Data Sources in the UI between the "OpportunityWithAccount" and "CaseWithAccount" datasets.
- DUse a SAQL query to group and join the "OpportunityWithAccount" and "CaseWithAccount" datasets then generate the results.
146What is a valid permission for a permission set?
- AEnable Parental Control
- BAlways Sign Me Up for Dreamforce
- CSales Analytics Apps
- DAccess Sales Cloud Analytics Templates and Apps
147Permissions of which 2 internal users are used by Analytics to gain access to Salesforce data?
- AEach user has a corresponding Profile assigned (Analytics Cloud Integration User and Analytics Cloud Security User profiles).
- BWhen you query a dataset that has row-level security based on the User object, Analytics uses the permissions of the Security User to access the User object and its fields.
- CAnalytics uses the permissions of the Integration User to extract data from Salesforce objects and fields when a dataflow job runs.
148What's the best way to describe the template-info.json file?
- AIt's a read-only file with all the user documentation for a template.
- BIt's the boss of the template with all the information needed to create the app.
- CIt makes sure that the app includes all the right Salesforce data.
- DIt's automatically populated every time you create an app from the template.
149Which security feature can be used to give Regional Development Coordinator roles access to only their designated regions and seed bank orders?
- AInherited security
- BSecurity predicates
- CSeparate apps for each region
- DSharing rules
150Which chart type is suitable for rendering five measures in a lens visualization?
- ATreemap chart
- BScatter chart
- CMetric Radar chart
- DStacked Bar chart
151An Einstein Analytics consultant is notified of a performance issue with data sync (replication). The consultant researches the issue and determines that unnecessary data is being synced.
Which solution should the consultant implement to help improve data sync (replication) performance?- AModify dataflows to exclude unused fields and include a filter to extract relevant data.
- BScale down the number of datasets to help improve data sync (replication) performance.
- CStart over again with new dataflows that exclude unused fields with a filter to extract relevant data.
- DUpdate the existing data sync (replication) process by removing unused fields with a filter to extract relevant data.
152As part of their analysis, Yasmine, Tonya, and Hadiqa need to create and save lenses to their project app. What is the minimum app role they need to do this?
- AManager
- BViewer
- CEditor
- DDesigner
153Which three parameters are used in a compare table formula field to calculate and display a field as percentage value? Choose 3 answers
- ACalculation
- BColumn Color
- CFormat
- DLength
- EColumn Name
154In what order does Einstein Discovery present the insights that it uncovers?
- AAlphabetical, in ascending order
- BAlphabetical, in descending order
- CInsights that explain the most variation in the outcome variable, in ascending order
- DInsights that explain the most variation in the outcome variable, in descending order
155A consultant is asked to create a dashboard for sales to see the forecasted sales per product family. After gathering the requirements, the consultant decides to leverage the timeseries SAQL statement to predict sales.
Which two actions must be performed when writing the SAQL query? Choose 2 answers- ADetermine if the timeseries required parameter, prediction interval, should be 80 or 95.
- BInvestigate which prediction model is best for the data available.
- CValidate that there is enough data in the dataset to make a good prediction.
- DInclude the fill SAQL statement to fill any missing dates.
156In a Compare Table formula, you can refer to other columns with:
- ATheir names
- BNumbers (1..9)
- CLetters (A..Z)
- DAll of the above
157The Universal Containers Einstein Analytics team built a dashboard with two widgets:
1. List widget associated to the step "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Pie chart widget associated to the step "Step_pie_3" and grouped by the dimension "Type"
The team wants to use bindings so any selection in the List widget will filter the Pie chart.
Additional notes:
* The steps use different datasets.
* Users should be able to choose more than one Type (multi-selection).
What is the right syntax for the binding?- A"filters": [
[
"Type",
"{{column(Type_2.selection,[\"Type\"]).asString()}}"
]
] - B"filters": [
[
"Type",
"{{cell(Type_2.selection,0, \"Type\").asString()}}"
]
] - C"filters": [
[
"Type",
"{{column(Type_2.selection,[\"Type\"]).asObject()}}"
]
] - D"filters": [
[
"Type",
"{{cell(Type_2.selection,0, \"Type\").asObject()}}"
]
]
- A"filters": [
158How can you restrict access to Analytics data at the row level?
- AManually add a flag to each row to prevent access.
- BUse a security predicate to filter which rows are returned.
- CUse subtle thought control.
- DRemove restricted rows from the JSON file.
159Creating an Einstein Discovery story involves:
- ASelecting a Dataset in Einstein Analytics, then clicking Create Story
- BCopying text from company reports and pasting into Einstein Discovery
- CUploading a Microsoft® PowerPoint® presentation
- DEntering notes about the data
160An insurance company has many Einstein Analytics dashboards that show the influence of weather, such as atmospheric temperature, on customer cases. A service agent commented that it is sometimes difficult to determine, by looking at a dashboard, whether the temperature data is reported in degrees Fahrenheit or in degrees Celsius.
How can a dashboard designer ensure the temperature data is easier to interpret on the dashboards?- AAdd a text widget to the dashboard to indicate Fahrenheit or Celsius.
- BUse the XMD node in the dataflow to customize the number format of the field.
- CCustomize the number format in the number widget properties of the dashboard.
- DIn Explorer, go to the Fields menu and then customize the number format of the measure.
161Which security option is not available in Einstein Analytics for securing datasets?
- AInherited security
- BRow-level security with security predicates
- CField-level security
- DApp level security
162Which two statements can be determined based on the Why it Happened graphic above' Choose 2 answers

- AGermany performs lower than average but better when the product is Call Center.
- BThe -2.2 Unexplained means there are effects that Einstein will never be able to explain regardless of the dataset.
- CCall Center is a generally poor performing product, and since there is more in Germany that has a negative effect.
- DGermany sells more Call Center product and that helps them increase their win rate.
163A company wants to use Einstein Analytics to analyze the trend of their sales pipeline. The company wants to accelerate the sales process. To do so, they need to know the average time an opportunity spends in each stage. This value is not pre-calculated in Salesforce, so a consultant recommends using a dataflow to calculate it.
How can a dataflow be used to calculate the average time an opportunity spends in each stage?- AcomputeExpression Transformation with SAQL Expression to calculate the duration
- Bflatten Transformation with Offset Expressions to calculate the duration
- CcomputeRelative Transformation with offset parameter to calculate the duration
- DcomputeRelative Transformation with SAQL Expression to calculate the duration
164What are the 3 basic actions within a query in Analytics? Choose 3:
- AAggregate by a measure
- BCount rows by measure you want to visualize
- CFilter to narrow down your results
- DGrouping by a dimension
- EDisplay the results graphically
165The edgemart transformation gives the dataflow access to an existing, registered dataset that can contain Salesforce data, external data, or a combination of both.
Where is an edgemart transformation specified?- ADataflow Editor
- BRecipes Editor
- CStep Editor
- DSettings
166Universal 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.
Which two changes can an Einstein Consultant implement to solve this issue, given that the steps are using the same dataset? Choose 2 answers
- AUse selection binding in the filters section of the step "Step_pie_1."
- BEnable the option "Apply filters from faceting" in the step "Region_1."
- CEnable the option "Apply filters from faceting" in the step "Step_pie_1."
- DUse selection binding in the filters section of the step "Region_1."
167An Einstein Analytics consultant is asked to add a new SalesTax field to a Product Sales dataset. The formula to calculate SalesTax is (SubTotal/CountyTax).
Which node should the consultant use in a Dataflow to calculate and insert SalesTax to the dataset?- Aappend
- BcomputeExpression
- Caugment
- DcomputeRelative
168Which of these is not a method for controlling record-level access?
- AProfiles
- BSharing Rules
- COrganization-Wide Defaults
- DRole Hierarchy
169Yasmine told Danielle she's interested in using the artificial intelligence provided by Einstein Discovery to enhance analysis Mosaic probably wouldn't have considered through their own means. How can Danielle use Einstein Analytics to load data into Einstein Discovery?
- AIt's not possible. Danielle will need to log into Einstein Discovery and import the data from there.
- BDanielle needs a permission set containing the Download Analytics Data permission, then she can use the Export node to load data into Einstein Discovery.
- CDanielle needs a permission set containing the Upload External Data to Analytics permission, then she can log into Einstein Discovery and import the data from there.
- DData loaded into Einstein Analytics as datasets can then be used in Einstein Discovery without a separate load process.
170What are the two types of bindings? Choose 2:
- AResults binding
- BData bindings
- CDescription bindings
- DSelections bindings
171Which set of statements generates monthly amount on a cumulative basis annually?
- Aresult = load "opportunity1";
result = group result by ('CloseDate_Year', 'CloseDate_Month');
result = foreach result generate 'CloseDate_Year', 'CloseDate_Month', sum(sum(Amount)) over ([..0] partition by all order by ('CloseDate_Year', 'Close_Month')) as 'Cumulative Close Amount'; - Bresult = load "opportunity1";
result = group result by ('CloseDate_Year~~~CloseDate_Month');
result = foreach result generate 'CloseDate_Year', 'CloseDate_Month', sum(sum(Amount)) over ([..0] partition by 'CloseDate_Year' order by ('CloseDate_Year', 'Close_Month')) as 'Cumulative Close Amount'; - Cresult = load "opportunity1";
result = group result by ('CloseDate_Year', 'CloseDate_Month');
result = foreach result generate 'CloseDate_Year', 'CloseDate_Month', sum(sum(Amount)) over ([..] partition by 'CloseDate_Year' order by ('CloseDate_Year', 'Close_Month')) as 'Cumulative Close Amount'; - Dresult = load "opportunity1";
result = group result by ('CloseDate_Year', 'CloseDate_Month');
result = foreach result generate 'CloseDate_Year', 'CloseDate_Month', sum(sum(Amount)) over ([..0] partition by 'CloseDate_Year' order by ('CloseDate_Year', 'Close_Month')) as 'Cumulative Close Amount';
- Aresult = load "opportunity1";
172An Einstein Consultant receives a new project from a client that wants to implement Einstein Analytics. They do not currently have Einstein Analytics, but want guidance around how to ensure that their users have correct access.
They have 1000 users with a small team of three people who will build datasets and dashboards. An additional 15 people should be able to create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?- ACreate and assign Salesforce permission sets according to the three types of roles defined.
- BAssign the app permissions "viewer/' "editor," and "manager" to the three types of roles defined.
- CCreate and assign three new Salesforce profiles according to the three types of roles defined.
- DAssign "Einstein Analytics Explorer" licenses to users that should only view the dashboard, and assign "Einstein Analytics Developer" licenses to users that should be able to create datasets and dashboards.
173Max Analytics API calls per user per hour
- A50,000
- B10,000
- C5,000
- D100,000
174What is another name for the type of insight that examines how one variable explains variation of the outcome variable?
- AThird-order analysis
- BObject-oriented analysis
- CSecond-order analysis
- DFirst-order analysis
- ESpectrum analysis
175When you assign any Analytics permission set to users in your org, Salesforce auto-assigns the Analytics Platform
permission set license to that user.- ATrue
- BFalse
176Which isn't an option for setting a security predicate for a dataset created from an external data file?
- AIn the metadata file associated with the external data file using the rowLevelSecurityFilter key
- BIn the Register transformation node of a dataflow that uses this dataset
- CIn the dataset Security Predicate
- DOn each row prior to upload
177Max story creations per org per day:
- A40 per org
- B40 per org per day
- C20 per org
- D20 per org per day
178How many concurrent stories per org are allowed?
- A5
- B4
- C2
- D1
179What is an Analytics app?
- AA specialized version of the Einstein Analytics platform that runs outside of Salesforce
- BAnalytics for iPad
- CA collection of datasets, dashboards, lenses, and a dataflow
- DThe blueprint for your org's Einstein Analytics implementation
180The Einstein Analytics Plus Platform license is enabled for a Salesforce org and assigned to each user. However, these users cannot see the Einstein Analytics Studio in the App Launcher.
How can this issue be addressed?- AShare the app with the users in Einstein Analytics.
- BCreate user accounts for the users in Einstein Analytics.
- CAssign the users to the permission set containing Use Analytics.
- DAssign the users to the permission set containing Manage Analytics.
181A customer displays a lot of data and wants a way to dynamically emphasize certain values on a bar chart in order to properly grab the user's attention.
What can an Einstein Consultant use to accomplish this task?- ACustomize tooltip
- BChart Markers
- CXMD
- DCompare Table
182An Einstein Analytics team plans to enable data sync (replication).
Which two limits are specific to data sync (replication) and should be considered before enabling the feature because they might impact existing jobs? Choose 2 answers- AMaximum number of dataflow definitions
- BMaximum number of dataflow transformation
- CMaximum number of objects that can be enabled for data sync (replication)
- DTimeout for ELT (Extract Load transform) jobs that are scheduled but not yet executed
183An Einstein Discovery team created a model to maximize the margin of their sales opportunities. They want to deploy the model to the Opportunity object in order to predict the outcome of every newly created or updated Opportunity.
What are the steps to accomplish this?- ACreate a trigger on Opportunity and use the Salesforce External Connector to get predictions from Einstein Discovery.
- BCreate an Apex batch on Opportunity and use the REST API to get predictions from Einstein Discovery.
- CCreate a trigger on Opportunity and install the Einstein Discovery Writeback managed package from the AppExchange.
- DCreate a trigger on Opportunity and use the REST API to get predictions from Einstein Discovery.
184The Einstein Analytics team at a company created a clataset based on the Opportunity__c custom object. The VP of Sales reports seeing the message "No results found" when opening the dataset to explore it. Other users below the VP in the role hierarchy can see rows on the same dataset.
Which two problems might be causing this issue?- AThe Salesforce profile for the VP does not have read permission on some fields of the Opportunity__c custom object
- BThe Security Predicates set up at the dataset level are preventing the VP from seeing data
- CThe dataset is inheriting sharing from Salesforce and the VP can see more than 3000 rows
- DThe Salesforce profile for the VP does not have read permission on the Opportunity__c custom object
185A dataset is ready for analysis in Einstein Discovery.
What is the first step a consultant should take after the data is loaded?- AIdentify data types and define the appropriate data as numeric.
- BAnalyze data columns and decide which, if any, to drop.
- CProduce a graph of the data to analyze.
- DLoad the data into Einstein Analytics.
186What do Analytics apps do?
- ALet you add new types of charts to Salesforce
- BAlert you when you need a visa for an upcoming trip
- CUse ready-made dashboards to tell easy-to-follow stories about your data
- DLet you create configuration wizards to make Analytics setup easier
187Number of queries per user per day
- A10,000
- B50,000
- C1,000
- D20,000
188An Einstein Analytics team created a funnel chart to show the number of opportunities in each stage. The managers who use the chart report that the funnel shows stages in alphabetical order instead of sales cycle order.
In which two ways can a consultant help them address this issue? Choose 2 answers- AUse a dataflow to rename the stages with a preceding number.
- BUse a dashboard JSON to rename stages.
- CUse a dataflow to sort the stages by their internal name.
- DUse a dataset XMD to rename stages.
189You can get data into Einstein Discovery:
- ABy connecting a USB drive to your laptop
- BBy using an Einstein analytics dataset
- COnly if your database administrator does it for you
- DOnly if Salesforce does it for you
190An Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle database.
What are two options to load the data from the Oracle database into Einstein Analytics? Choose 2 answers- AUse the Salesforce SOAP interface.
- BUse the Analytics External Data API.
- CUse Oracle database connector.
- DLoad the data as a CSV file.
191A list widget is added to a dashboard with existing charts and tables. What must be true for the list widget to facet the dashboard charts and tables using widget properties?
- AThe list, chart, and table steps must share a common name.
- BThe list, chart, and table steps must share common dimensions from different datasets.
- CThe list, chart, and table steps must share the same dataset.
- DChart and table steps must have their own list widgets.
192A consultant is working with a credit card company that needs help with ongoing fraudulent transactions. The company provides a representative sample dataset for the consultant to analyze in Einstein Discovery. The story's initial assessment shows that a third-party payment app is the source of these fraudulent transactions. However, the company rejects this assessment outcome, stating they have not had a partnership with this payment app long enough for it to be a concern.
What is the recommended next step to improve the story outcome?- AMake adjustments to the story to better demonstrate that the third-party payment app is the culprit.
- BUse the credit card company's domain knowledge and exclude the third-party payment app from the story.
- CExplain to the company that the story has returned unbiased results and the initial assessment is accurate.
- DAsk the credit card company for a more comprehensive dataset to analyze.
193Which three things can be done with the Einstein Analytics Dashboard Inspector? Choose 3 answers
- AAutomatically remove bottlenecks to make queries run faster.
- BGet a list of recommendations on how to improve the performance of the dashboard.
- CView all queries and the time it took to run each one.
- DView the total time required to run all queries.
- ESee the final query for each step along with query results.
194What are two benefits of designing using the "Progressive Disclosure" principle? Choose 2 answers
- AImproved ease of use for end users
- BDiscounted EA licenses when growth is achieved
- CAutomatic conditional formatting
- DBetter dashboard performance
195A dashboard dataset is growing and the Einstein Analytics consultant notices an impact on performance. The consultant needs to make a few adjustments.
Which three actions can the consultant take to improve dashboard performance? Choose 3 answers- AReorganize the dashboard widgets.
- BDistribute steps among separate pages.
- CUse SAQL code to join datasets at runtime.
- DReplace separate step filters with a global filter.
- EMove calculations to a dataflow.
196A consultant created an Einstein Analytics dashboard in a sandbox. Now, the dashboard needs to be migrated into production.
To complete the migration, what are the consultant's three options? Choose 3 answers- AAnt Migration Tool
- BAnalytics External Data API
- CAnalytics REST API
- DChange sets
- EAnalytics dashboard connector
197The Universal Containers company uses a Microsoft Azure SQL Data Warehouse to gather information about sales representatives' objectives. They want to use Einstein Analytics to gain insights from this data; therefore, they need to automatically load the warehouse's data into an Einstein Analytics dataset on a daily basis. The data also needs to be transformed and merged with data from the company's org.
Which three Einstein Analytics user interface features can be used to complete these requirements? Choose 3 answers- ADataflow
- BMicrosoft Azure SQL Data Warehouse Connector
- CEinstein Analytics Connector for Excel
- DRecipes
- EAnalytics REST API
198What are two core design principles to consider when building Analytics apps or dashboards? Choose 2 answers
- AEmphasis: make sure they have space for important information, such as headlines and key charts.
- BClarity: make sure they are uncluttered and easy to interpret.
- CConsistency: make sure they have a sense of familiarity to strengthen your users' ease of use.
- DBalance: make sure they have a balance of different charts to get a more interesting design.
199What are the two main parts of a lens/exploration?
- AQuery
- BVisualization
- CDataset
- DMeasure
- EGrouping
200Max story creations per org per month
- A1,000 (can purchase more)
- B500 (can purchase more)
- C200 (can purchase more)
- D500
Information
- Description
- Quiz on Einstein Analytics Certification Questions, created by Vince Casarez on 31/08/2020.
- Author
- Vince Casarez
- Language
- English
- Views
- 144
- Tags
- Rating
- No ratings yet Rate this quiz