ANALYTICS-CON-301.pdf
Q: 1
A client wants to report Saturday and Sunday regardless of the workbook's data source's locale
settings.
Which calculation should the consultant recommend?
Options
Q: 2
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?
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?Options
Q: 3
A client creates a report and publishes it to Tableau Server where each department has its own user
group set on the server. The client wants to limit visibility of
the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?
Options
Q: 4
A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only
one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
· SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values
A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the
longest-running event is "Executing Query."
Which step should the consultant take to resolve this issue?
Options
Q: 5
A university has data on its undergraduate students and their majors by grade level (Freshman,
Sophomore, Junior, Senior). The university is interested in
visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?
Options
Q: 6
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?
Options
Q: 7
A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The
consultant needs to implement a dashboard design that
provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?
Options
Q: 8
A client currently has a workbook with the table shown below.
Which method will produce the output for the Total Sales Value field for all the categories shown in
the table?
Which method will produce the output for the Total Sales Value field for all the categories shown in
the table?Options
Q: 9
SIMULATION Refer to the exhibit. 
From the desktop, open the NYC Property Transactions workbook. You need to record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook. Ensure that you start the recording as soon as you open the workbook. Open the Property Transactions dashboard, reset the filters on the dashboard to show all values, and stop the recording. Save the recording in C:\CC\Data\. Create a new worksheet in the performance recording. In the worksheet, create a bar chart to show the elapsed time of each command name by worksheet, to show how each sheet in the Property Transactions dashboard contributes to the overall load time. From the File menu in Tableau Desktop, click Save. Save the performance recording in C:\CC\Data\.
Your Answer
Q: 10
SIMULATION
From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.
Your Answer
Question 1 of 10
