Prepare for the Tableau Desktop Certified Associate Exam exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.
QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Tableau Desktop-Certified-Associate exam and achieve success.
In which of the following scenarios you should use the blend?
Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.
Connect to the "Kiva Loans - India" data source, find out the average number of days it took to disbursed the funded amount in catering activity, and what is the total funded amount?
Filter the Activity = Catering
Drop the activity to rows, and no of days to columns, change the aggregation to AVG.
Also, drop the Funded Amount to the Tooltip.
Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the month of May 2012 were profitable?
Here we have created the Fixed LOD expression and fixing the order date. If profit is greater than 0 it means profitable day/month/quarter/year depends on what you need to find. If profit < 0 then not profitable.
Drop the Order Date to the rows and drill-down it till months.
Drop the profitable days field to the Text, aggregated as SUM. So it will find a number of days.
Connect to the Olympic Athletes data source, which athlete won at least one gold in 2008 Olympics and then won at least 4 golds in 2012 Olympics.
Find out how many gold medals each athlete won in the 2008 Olympics
Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:
Now we need work on 'won at least 4 golds in 2012 Olympics'
Drop years to filters and select 2012.
Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)
Final view:
Which of the following are valid calculations?
You cannot mix the aggregated and non-aggregated calculations.
MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.
SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.
You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.
SUM([Profit]) * SUM([Quantity]) - Both are aggregated
Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits
Get All 108 Questions & Answers