Pass with Analytics-Con-301 Practice Materials 100% for sure

A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:
Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}
The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.
The client asks a consultant to rewrite the calculation so the result meets their expectation.
Which calculation should the consultant use?

• A. {EXCLUDE [Customer ID]: COUNTD([Order ID])}
• B. {FIXED [Customer ID], [Region], [Order Date]: COUNTD([Order ID])}
• C. {FIXED [Customer ID], [Region]: COUNTD([Order ID])}
• D. {INCLUDE [Customer ID]: COUNTD([Order ID])}

A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.
How should the shipping clerk create a chart that depicts the above information?

• A. Search and download a suitable Connector from Tableau Exchange.
• B. Search and download a suitable sandboxed Accelerator from Tableau Exchange.
• C. Search and download a suitable sandboxed Viz Extension from Tableau Exchange.
• D. Use Show Me to start a view based on the fields selected.

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?

• A. IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• B. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSEIF [ProfitMargin] <0 Then 'Unprofitable'END
• C. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• D. IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')ELSE 'Unprofitable'END

In what way does View Acceleration improve performance?

• A. By improving the performance of views that contain long-running queries with transient functions
• B. By optimizing the performance of views built only on extract-based data sources
• C. By precompiling and fetching workbook data in a background process
• D. By enhancing the rendering speed of visuals, such as drawing shapes and maps

A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.

They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse structure.
What should the client do to achieve the desired result?

• A. Update the Widget Inventory Table to be a daily snapshot.
• B. Use Tableau Desktop to visualize null values.
• C. Create a temporary table in the database.
• D. Use Tableau Prep to add new rows.