Free demo
Analytics-Con-301 Free Demo Questions
A sample from the full question set for this exam.
QUESTION 1 OF 5
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?
Correct 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.
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.
QUESTION 2 OF 5
A client has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departments give different answers to the same business questions, and the departments cannot trust the data. The client wants to know what causes data sources to return different data. Which tool should the client use to identify this issue?
Correct Answer: C
The Tableau Catalog is part of the Tableau Data Management Add - on and is designed to help users
understand the data they are using within Tableau. It provides a comprehensive view of all the data
assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify
issues such as data quality, data lineage, and impact analysis. In this case, where different
departments are getting different answers to the same business questions, the Tableau Catalog can
be used to track down inconsistencies and ensure that everyone is working from the same, reliable
data source.
understand the data they are using within Tableau. It provides a comprehensive view of all the data
assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify
issues such as data quality, data lineage, and impact analysis. In this case, where different
departments are getting different answers to the same business questions, the Tableau Catalog can
be used to track down inconsistencies and ensure that everyone is working from the same, reliable
data source.
QUESTION 3 OF 5
A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version. The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.
A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version. The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.
The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed. The client wants to improve the performance of the dashboard while also getting an accurate count of site visitors. Which modifications to the data tables and join should the consultant recommend?
Correct Answer: B
To improve the performance of a Tableau dashboard while maintaining accurate counts, particularly
when dealing with unknown or NULL BrowserIDs in the data tables, the following steps are
recommended
Modify the Browser Table Add a new row to the Browser Table labeled "Unknown," assigning it a
unique BrowserID, e.g., 0 or 4.
Update the Site Visitor Table Replace all NULL BrowserID entries with the BrowserID assigned to the
"Unknown" entry. This ensures every record in the Site Visitor Table has a valid BrowserID that
corresponds to an entry in the Browser Table.
Change Referential Integrity Setting Change the Referential Integrity setting from "Some Records
Match" to "All Records Match." This change assumes all records in the primary table have
corresponding records in the secondary table, which improves query performance by allowing
Tableau to make optimizations based on this assumption.
when dealing with unknown or NULL BrowserIDs in the data tables, the following steps are
recommended
Modify the Browser Table Add a new row to the Browser Table labeled "Unknown," assigning it a
unique BrowserID, e.g., 0 or 4.
Update the Site Visitor Table Replace all NULL BrowserID entries with the BrowserID assigned to the
"Unknown" entry. This ensures every record in the Site Visitor Table has a valid BrowserID that
corresponds to an entry in the Browser Table.
Change Referential Integrity Setting Change the Referential Integrity setting from "Some Records
Match" to "All Records Match." This change assumes all records in the primary table have
corresponding records in the secondary table, which improves query performance by allowing
Tableau to make optimizations based on this assumption.
QUESTION 4 OF 5
A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes . All files have the same schema. . Multiple files have something in common among their file names. . Each file has a unique key column. Which data transformation strategy should the consultant use to deliver the best optimized result?
Correct Answer: B
Moving calculations to the data layer and materializing them in the extract can significantly improve
the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic
calculation that can be easily computed in advance and stored in the extract, speeding up future
queries. This type of calculation is less complex than table calculations or LOD expressions, which are
better suited for dynamic analysis and may not benefit as much from materialization 1 2 .
the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic
calculation that can be easily computed in advance and stored in the extract, speeding up future
queries. This type of calculation is less complex than table calculations or LOD expressions, which are
better suited for dynamic analysis and may not benefit as much from materialization 1 2 .
QUESTION 5 OF 5
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract. Which calculation should the consultant use?
Correct Answer: C
To improve performance by moving calculations to the data layer and materializing them in the
extract, the consultant should choose calculations that benefit from pre - computation and
significantly reduce the load during query time
Aggregation - Level Calculation The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an
aggregate level, which is ideal for pre - computation. Materializing this calculation in the extract
means that the complex division operation is done once and stored, rather than being recalculated
every time the report is accessed.
Performance Improvement By pre - computing this aggregate ratio, Tableau can utilize the pre -
calculated fields directly in visualizations, which speeds up report loading and interaction times as
the heavy lifting of data processing is done during the data preparation stage.
extract, the consultant should choose calculations that benefit from pre - computation and
significantly reduce the load during query time
Aggregation - Level Calculation The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an
aggregate level, which is ideal for pre - computation. Materializing this calculation in the extract
means that the complex division operation is done once and stored, rather than being recalculated
every time the report is accessed.
Performance Improvement By pre - computing this aggregate ratio, Tableau can utilize the pre -
calculated fields directly in visualizations, which speeds up report loading and interaction times as
the heavy lifting of data processing is done during the data preparation stage.
Question 1 of 5