Analytics-Con-301 Dumps Special Discount for limited time Try FOR FREE [Q33-Q51]

Q33. A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.

Q34. 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?

Q35. 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?

Q36. 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?

Q37. A consultant plans a Tableau deployment for a client that uses Salesforce. The client wants users to automatically see Tableau views of regional sales filtered by customer as soon as the users sign into Salesforce.
Which approach should the consultant use to deliver the final visualization?

Q38. A business analyst is creating a view of the top 10 customers for each region. The analyst has set a “Top 10” filter on Customer Name. However, it did not display the top 10 customers per region, as shown in the image below.

Which type of filter should the business analyst add to filter for region?

Q39. A consultant is creating a dashboard to report on hourly sales data. The data should be refreshed hourly and is used for timely decision-making, so it is important to alert dashboard viewers when data has not been refreshed.
Which feature of Tableau Catalog should the consultant use to ensure dashboard viewers understand this message?

Q40. A Tableau consultant tasked with evaluating a data structure is handed the below sample dataset.
Which two statements are true about the dataset? Choose two.

Q41. 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?

Q42. SIMULATION
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.

From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.

Q43. A client has a large data set that contains more than 10 million rows.
A consultant wants to calculate a profitability threshold as efficiently as possible. The calculation must classify the profits by using the following specifications:
. Classify profit margins above 50% as Highly Profitable.
. Classify profit margins between 0% and 50% as Profitable.
. Classify profit margins below 0% as Unprofitable.
Which calculation meets these requirements?

Q44. A client calculates the percent of total sales for a particular region compared to all regions.

Which calculation will fix the automatic recalculation on the % of total field?

Q45. A client calculates the percent of total sales for a particular region compared to all regions.

The Sales percentage is inadvertently recalculated each time the filter is applied to the Region.

Which calculation should fix the automatic recalculation on the % of total field?

Q46. A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client’s requirements?

Q47. 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?

Q48. A client’s fiscal calendar runs from February 1 through January 31.
How should the consultant configure Tableau to use the client’s fiscal calendar when building date charts?

Q49. 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?

Q50. An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.
The consultant needs to know the average number of days that a customer must wait before a product is shipped.
Which calculation should the consultant use?

Q51. Which technique should a Tableau consultant use to make visualizations faster?