When defining a relationship between two logical tables in Tableau Desktop, you can optionally supply extra information that helps Tableau issue more efficient queries. Which optional setting provides this performance benefit?
Assigning default number formatting to shared measures
Choosing a specific federated join engine for cross-database queries
Setting custom colors for each table in the data model
Declaring referential integrity between the tables
In the Relationship dialog you may declare that referential integrity exists between the related tables. When Tableau knows every related record in the child table has a match in the parent, it can safely substitute inner joins for outer joins at query time, reducing data volume and improving performance. Changing table colors, default number formats, or picking a federated engine are not part of the relationship definition and do not influence how Tableau builds the underlying queries.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is referential integrity in Tableau?
Open an interactive chat with Bash
How do inner joins differ from outer joins in terms of performance?
Open an interactive chat with Bash
What are the steps to declare referential integrity in Tableau?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .