A Tableau CRM 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 queries 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 Visualforce page and display a list view of the opportunities on this new page.
BCreate a link to download the list of opportunities as an Excel file.
CCreate a second page on the dashboard and move the table to this new page.
DCreate a second dashboard and move the table to this new dashboard.
A customer is reviewing a story that is set to maximize the daily sales quantity of consumer products in stores, and the customer sees this chart related to promotional activities and to San Francisco specifically.
What conclusion can be drawn from this insight?
AThe best promotion type is Display.
BPromotions increase sales stronger in San Francisco than they do in other cities.
CThe Other stores (visualized with the gray bars) show no significant data for the sales promotions.
DOf all promotions types in San Francisco, sales were the highest using Display promotion.
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?
AUse a SAQL query since the summary is not available in standard interface.
BCreate a computeExpression field in the Dataflow to calculate the summary.
CUse the Show Summary option in the compare table.
DAdd a formula field to calculate the summary.
A 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.
Which recipe transformation can a Tableau CRM consultant use to generate the name of month as a new dimension in the dataset?
Aflatten
Bcluster
Cbucket
Dformat dates
A training dataset is being prepared for an Einstein Discovery story. One of its predictor (input) fields is skewed with outliers.
What action should the Einstein consultant take?
AChange the method of binning to fixed width.
BNothing, because the field is not the outcome variable.
CRemove the outlier rows.
DRemove the field because it has bad data.
What are two benefits of designing using the "Progressive Disclosure" principle? (Choose two.)
AImproved ease of use for end users
BDiscounted EA licenses when growth is achieved
CBetter dashboard performance
DAutomatic conditional formatting
A company uses role hierarchy to implement data security in Salesforce. They want the same role-hierarchy-based security model to apply in Tableau CRM, but want the users in a role to see data owned by other users in the same role.
Using the "flatten” transformation in a recipe, which attribute setting achieves this requirement?
ASet the attribute “Include Record ID Column value” to true.
BSet the attribute “include_self_id” to false.
CSet the attribute “include_self_id” to true.
DSet the attribute “Include Record ID Column value” to false.
Which set of statements generates monthly amount on a cumulative basis annually?
A
B
C
D
A Tableau CRM Consultant needs to add some data values to an existing dataflow: a text field, a number (via case statement), and a date (via SAQL).
In order to achieve this, which compute option should be used?
AcomputeField
BcomputeValue
CcomputeData
DcomputeExpression
A Tableau CRM consultant receives a new project from a client that wants to implement Tableau CRM. They do not currently have Tableau CRM, 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?
AAssign the app permissions “viewer,” “editor,” and “manager” to the three types of roles defined.
BCreate and assign three new Salesforce profiles according to the three types of roles defined.
CAssign “Tableau CRM Explorer” licenses to users that should only view the dashboard, and assign “Tableau CRM Developer” licenses to users that should be able to create datasets and dashboards.
DCreate and assign Salesforce permission sets according to the three types of roles defined.
A 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 a Tableau CRM Consultant use to accomplish this task?
AXMD
BCustomize tooltip
CCompare Table
DChart Markers
Universal Containers has a Dashboard for Sales Managers. They need to visualize their win rate.
Which chart type can be used to keep track if they are below or beyond the target?
AMetric Radar
BHeatmap
CLine
DGauge
A consultant built a Tableau CRM dashboard for a shipping company. The consultant enabled data sync (replication) to increase the speed of datasets refreshing.
How often will the data on the dashboard be refreshed?
AWhen the dashboard viewer clicks the Refresh button.
BWhen Data Sync runs to completion, and then Dataflow runs to completion.
CEach time a user opens the dashboard.
DWhen Dataflow runs to completion, and then Data Sync runs to completion.
The Vice President of Sales wants to create a "Pipeline Trending" dashboard in Tableau CRM that displays specific colors depending on the values of the fields.
Which two techniques should a consultant use to help address this requirement? (Choose two.)
AAssign conditional formatting on a dashboard widget.
BUse a Recipe and assign colors to each field value with the Color transformation.
CUse a computeRelative to calculate a color field and assign it to each field value.
DChoose the "Show Fields Panel" option when exploring the dataset and then assign colors to each field value.
The Universal Containers company uses Tableau CRM 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 a Tableau CRM address this need?
ACreate one application for each department, put common datasets in the shared app, and use profiles to share applications.
BCreate one application for each department, put common datasets in the shared app, and use roles to share applications.
CCreate one application for each department, put common datasets in the shared app, and use permission sets to share applications.
DCreate one application for each department and use roles to share applications
A consultant built a Tableau CRM 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 a Tableau CRM template app.
In the process of creating the template, which role does the original Tableau CRM app for the Sales Operation team play?
AIt is the target.
BIt is the template.
CIt is the instance.
DIt is the master.
A Tableau CRM team plans to enable data sync (replication).
Which limit is specific to data sync (replication) and should be considered before enabling the feature because it might impact existing jobs?
AMaximum number of dataflow transformations
BMaximum number of recipes allowed
CTimeout for ELT (Extract Load Transform) jobs that are scheduled but not yet executed
DMaximum number of objects that can be enabled for data sync (replication)
A 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 two.)
AHow many charts should be allowed on a single dashboard
BWhich colors to use and how to use them
CWhich fonts to use for headers and body text
DWhich charts to use to best support the defined goal
A consultant created a dashboard using Tableau CRM for a client, a shipping company. It sources data from very large datasets. Now the client has requested that the consultant add more queries to the dashboard.
What two actions should the consultant take to ensure that the dashboard has acceptable performance? (Choose two.)
AReplace AggregateFlex queries with SAQL queries.
BSplit the queries and charts into different pages in a dashboard.
CAvoid using conditional formatting.
DCheck if any query can be reused for multiple purposes.
A company used Tableau CRM to create two datasets:
"OpportunityWithAccount" dataset, which contains data from the Opportunity standard object augmented by the Account data.
"CaseWithAccount" 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?
AUse "Compare Table" to join the "OpportunityWithAccount" and "CaseWithAccount" datasets using the "AccountId" and then aggregate by Account.
BUse a SAQL query to group and join the "OpportunityWithAccount" and "CaseWithAccount" datasets then generate the results.
CUse a Salesforce Direct query to join "OpportunityWithAccount" and "CaseWithAccount" datasets.
DSet up Connect Data Sources in the UI between the "OpportunityWithAccount" and "CaseWithAccount" datasets.