Crucial Exams

Tableau Desktop Foundations Practice Question

While designing the logical layer of a Tableau data source, you need to combine a daily Sales table with a monthly Targets table on Customer ID and Month without duplicating rows or changing either table's level of detail. What should you do?

  • Union the two tables and use a calculated field to identify each record's source table.

  • Define a relationship between the Sales and Targets tables on Customer ID and Month in the logical layer.

  • Create an inner join on Customer ID and Month in the physical layer of the data source.

  • Add the Targets table as a secondary data source and blend it to the primary Sales data by Customer ID.

Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot