Pass4Future also provide interactive practice exam software for preparing Salesforce Certified Tableau Consultant (Analytics-Con-301) Exam effectively. You are welcome to explore sample free Salesforce Analytics-Con-301 Exam questions below and also try Salesforce Analytics-Con-301 Exam practice test software.
Do you know that you can access more real Salesforce Analytics-Con-301 exam questions via Premium Access? ()
For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third
table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes
using an extract.
What is the most performant approach to model the data for a live connection?
Answer : A
For a performant live connection in Tableau Cloud, especially when dealing with large datasets that preclude the use of extracts, relating the tables in Tableau Desktop is the recommended approach. This method allows for flexibility in how the data is queried and can improve performance by leveraging Tableau's relationships feature, which optimizes queries for the underlying database.
A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server
audit, a consultant notices that the asset permissions for the client's top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.
The consultant recommends checking "Apply to Nested Projects" to enforce compliance.
Which impact will the consultant's recommendation have on access to the existing nested projects?
Answer : B
When ''Apply to Nested Projects'' is checked in Tableau Server, the permission rules set at the top-level project are enforced for all assets in the project and all nested projects. This means that any custom access previously granted to nested projects will be overridden, and the permissions will revert to those defined at the top-level project. This action ensures consistent application of the data governance strategy across all divisions.
A company has a data source for sales transactions. The data source has the following characteristics:
. Millions of transactions occur weekly.
. The transactions are added nightly.
. Incorrect transactions are revised every week on Saturday.
* The end users need to see up-to-date data daily.
A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.
What should the consultant do to create and publish the data?
Answer : A
A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant
used a quick table calculation to create the labels.
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?
Answer : B
When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.
When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a 'context filter,' which effectively changes how data is filtered in calculations:
Create a Context Filter: Right-click on the profit filter and select 'Add to Context'. This action changes the order of operations in filtering, meaning the context filter is applied first.
Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.
View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.
References:
Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.
A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard
that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.
Which dashboard building strategy will deliver the desired result?
Answer : D
For modeling shipping costs based on varying vendor contracts and ensuring speed in dashboard performance, the suggested approach involves:
Calculated Field with Parameter: Utilize a calculated field that dynamically references a user-selected parameter for the shipping vendor. This parameter adjusts the cost calculations based on selected vendor characteristics (like volume and speed).
Aggregate Results: After calculating individual shipping costs, aggregate these costs to provide a concise, summarized view of potential expenses for the upcoming week. This method ensures the dashboard remains performant by reducing the load of processing individual line items in real-time.
Why This Works: By using parameters and calculated fields, the dashboard can quickly adapt to user inputs without needing to re-query the entire dataset. Aggregating the results further improves performance and user experience by simplifying the output.
References This strategy leverages Tableau's capability to handle dynamic calculations with parameters and is recommended for scenarios where performance and user-driven interaction are priorities. Tableau's performance optimization resources and dashboard design guidelines detail these techniques.
