Final Exam Flashcards
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?
A. Create a Visualforce page and display a list view of the opportunities on this new page.
B. Create a link to download the list of opportunities as an Excel file.
C. Create a second page on the dashboard and move the table to this new page.
D. Create a second dashboard and move the table to this new dashboard.
D. Create a second dashboard and move the table to this new dashboard.
A company used Tableau CRM to create two datasets:
1. “OpportunityWithAccount” dataset, which contains data from the Opportunity standard object augmented by the Account data.
2. “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?
A. Use “Compare Table” to join the “OpportunityWithAccount” and “CaseWithAccount” datasets using the “AccountId” and then aggregate by Account.
B. Use a SAQL query to group and join the “OpportunityWithAccount” and “CaseWithAccount” datasets then generate the results.
C. Use a Salesforce Direct query to join “OpportunityWithAccount” and “CaseWithAccount” datasets.
D. Set up Connect Data Sources in the UI between the “OpportunityWithAccount” and “CaseWithAccount” datasets.
B. Use a SAQL query to group and join the “OpportunityWithAccount” and “CaseWithAccount” datasets then generate the results.
In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word “Yes” in green; a value of false should result in the display of the word “No” in red.
In which two ways can this be accomplished?
A. Create an XMD node in the dataflow to change the label and color of the values in the fields.
B. In the explorer, select the boolean fields and use the “edit values” option on the fields to change values and colors.
C. Download the XMD for the dataset and change the values and color for the fields and then upload to the dataset.
D. In the explorer, select the boolean fields, then create a derived dimension that references the boolean fields, and then modify the values and colors of the derived dimension.
C. Download the XMD for the dataset and change the values and color for the fields and then upload to the dataset.
A consultant built a very useful Tableau CRM 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 a Tableau CRM template app, but needs to locate specific information to get started.
{
“folderSource” : { “id” : “Sales Operations ID”}
}
Given the code statement above, which endpoint should it be posted to?
A. /services/data/v##.#/wave/templates
B. /services/data/v##.#/analytics/projects
C. /services/data/v##.#/analytics/wizard
D. /services/data/v##.#/wave/apps
B. /services/data/v##.#/analytics/projects
Which three statements are true regarding sharing inheritance? (Choose three.)
A. A dataset using sharing must also have a security predicate defined.
B. If 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.
C. When sharing inheritance is enabled, security predicates are ignored.
D. Sharing inheritance supports a foreign key for enforcing security.
E. Sharing inheritance supports Account, Campaign, Case, Contact, Opportunity, Lead, Order, and User. If you use custom objects, you must use security predicates for those.
A. A dataset using sharing must also have a security predicate defined.
B. If 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.
E. Sharing inheritance supports Account, Campaign, Case, Contact, Opportunity, Lead, Order, and User. If you use custom objects, you must use security predicates for those.
Which widget property allows a consultant to restrict the view to a domain bounded by the values entered?
A. Add Filter
B. Add Custom Range
C. Add Custom Domain
D. Filter by Range
C. Add Custom Domain
A Tableau CRM 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?
A. computeExpression
B. augment
C. computeRelative
D. append
A. computeExpression
Universal Containers reports that any selection in the List widget is not affecting the Pie chart in one of their Tableau CRM dashboards. The query options associated with the List widget and Pie chart are shown in the graphic.
Given that the queries are using different datasets, which two changes can a Tableau CRM Consultant make to solve this issue? (Choose two.)
A. Use selection binding in the filters section of the query “Type_1.”
B. Use selection binding in the filters section of the query “Step_pie_2.”
C. Use “Connect Data Sources” and create a connection to connect the two widgets.
D. Use “Connect Data Sources” and create a connection to connect the two datasets.
B. Use selection binding in the filters section of the query “Step_pie_2.”
D. Use “Connect Data Sources” and create a connection to connect the two datasets.
Which three things can be done with the Tableau CRM Dashboard Inspector? (Choose three.)
A. Automatically remove bottlenecks to make queries run faster.
B. Get a list of recommendations on how to improve the performance of the dashboard.
C. See the final query for each query along with query results.
D. View all queries and the time it took to run each one.
E. View the total time required to run all queries.
B. Get a list of recommendations on how to improve the performance of the dashboard.
D. View all queries and the time it took to run each one.
What are two benefits of designing using the “Progressive Disclosure” principle? (Choose two.)
A. Improved ease of use for end users
B. Discounted EA licenses when growth is achieved
C. Better dashboard performance
D. Automatic conditional formatting
A. Improved ease of use for end users
B. Discounted EA licenses when growth is achieved
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?
A. computeField
B. computeValue
C. computeData
D. computeExpression
D. computeExpression
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?
A. When the dashboard viewer clicks the Refresh button.
B. When Data Sync runs to completion, and then Dataflow runs to completion.
C. Each time a user opens the dashboard.
D. When Dataflow runs to completion, and then Data Sync runs to completion.
B. When Data Sync runs to completion, and then Dataflow 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.)
A. Assign conditional formatting on a dashboard widget.
B. Use a Recipe and assign colors to each field value with the Color transformation.
C. Use a computeRelative to calculate a color field and assign it to each field value.
D. Choose the “Show Fields Panel” option when exploring the dataset and then assign colors to each field value.
B. Use a Recipe and assign colors to each field value with the Color transformation.
D. Choose 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?
A. Create one application for each department, put common datasets in the shared app, and use profiles to share applications.
B. Create one application for each department, put common datasets in the shared app, and use roles to share applications.
C. Create one application for each department, put common datasets in the shared app, and use permission sets to share applications.
D. Create one application for each department and use roles to share applications
D. Create 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?
A. It is the target.
B. It is the template.
C. It is the instance.
D. It is the master.
B. It is the template.
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?
A. Maximum number of dataflow transformations
B. Maximum number of recipes allowed
C. Timeout for ELT (Extract Load Transform) jobs that are scheduled but not yet executed
D. Maximum number of objects that can be enabled for data sync (replication)
D. Maximum 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.)
A. How many charts should be allowed on a single dashboard
B. Which colors to use and how to use them
C. Which fonts to use for headers and body text
D. Which charts to use to best support the defined goal
A. How many charts should be allowed on a single dashboard
D. Which 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.)
A. Replace AggregateFlex queries with SAQL queries.
B. Split the queries and charts into different pages in a dashboard.
C. Avoid using conditional formatting.
D. Check if any query can be reused for multiple purposes.
B. Split the queries and charts into different pages in a dashboard.
C. Avoid using conditional formatting.
Which three parameters are used in a compare table formula field to calculate and display a field as percentage value? (Choose three.)
A. Length
B. Column Name
C. Column Color
D. Format
E. Calculation
A. Length
D. Format
E. Calculation
A consultant plans to extract an Opportunity object for training and wants to create a story to identify opportunities that are likely to be won.
Which two actions should the consultant take to prepare the training dataset? (Choose two.)
A. Exclude IsClosed (FALSE).
B. Maximize on IsWon (TRUE).
C. Include opportunities that are in all stages for completeness.
D. Include StageName because this field is highly correlated to IsWon (True).
B. Maximize on IsWon (TRUE).
C. Include opportunities that are in all stages for completeness.
A Tableau CRM 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?
A. Modify dataflows to exclude unused fields and include a filter to extract relevant data.
B. Start over again with new dataflows that exclude unused fields with a filter to extract relevant data.
C. Update the existing data sync (replication) process by removing unused fields with a filter to extract relevant data.
D. Scale down the number of datasets to help improve data sync (replication) performance.
C. Update the existing data sync (replication) process by removing unused fields with a filter to extract relevant data.
A Tableau CRM consultant decides to use a recipe to create a new dataset.
Which two source types can be used for the recipe? (Choose two.)
A. Records from a Salesforce object
B. Dataset lens
C. Connected data(Synced)
D. Existing datasets
A. Records from a Salesforce object
B. Dataset lens
After loading data to Einstein Discovery and creating a story, the client asks the Einstein consultant to explain the Unexplained Bar in the “Why does this do better/ worse” chart.
Which explanation is correct?
A. It shows the difference between the predicted outcome and the observed outcome.
B. It only appears for outcomes that do not have an explanation.
C. It should always be 0 or the model should not be used.
D. It displays the difference between the analyzed data and the data not reviewed.
A. It shows the difference between the predicted outcome and the observed outcome.
A consultant wants to optimize data loads by extracting Salesforce objects using independent Tableau CRM dataflows ahead of time.
Which construct should be used to accomplish this?
A. Clone
B. Dataflow
C. Data Sync (Replication)
D. Augment
C. Data Sync (Replication)
