Database connections (SQL Server, PostgreSQL) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Connection Types in Tableau

Which of the following statements correctly describes the difference between a live connection and an extract connection in Tableau when connecting to SQL Server or PostgreSQL databases?

A Both live and extract connections query the database directly, but extracts are faster because they use caching on the server side.

B A live connection queries the database directly every time you interact with the dashboard, while an extract connection uses a snapshot of the data stored locally in Tableau.

C A live connection stores all data locally and never queries the database, whereas an extract connection queries the database on demand.

D Live connections only work with SQL Server, and extract connections only work with PostgreSQL.

💡 Hint

Think about how Tableau handles data updates and performance when connected to a database.

Live connections send queries directly to the database each time you interact with the dashboard, ensuring up-to-date data. Extract connections create a snapshot of the data stored locally, improving performance but requiring refreshes to update.

🎯 Scenario

intermediate

Choosing the Right Authentication Method

You want to connect Tableau to a PostgreSQL database hosted on a remote server. Which authentication method should you choose to ensure secure access without storing your password in Tableau?

A Use Windows Authentication (Kerberos) if your environment supports it, so Tableau uses your Windows credentials securely.

B Use username and password authentication and save the password in Tableau for convenience.

C Use no authentication since the database is on a trusted network.

D Use anonymous login to avoid entering credentials.

💡 Hint

Consider security best practices for enterprise environments.

Windows Authentication (Kerberos) allows Tableau to use your existing Windows credentials securely without storing passwords, which is safer than saving passwords in Tableau.

❓ dax_lod_result

advanced

Calculating Total Sales per Region with LOD Expressions

Given a Tableau data source connected live to SQL Server with sales data, you want to calculate total sales per region regardless of filters on product categories. Which Tableau LOD expression achieves this?

Tableau

{ FIXED [Region] : SUM([Sales]) }

A { FIXED [Region] : SUM([Sales]) }

B { EXCLUDE [Category] : SUM([Sales]) }

C SUM([Sales])

D { INCLUDE [Region] : SUM([Sales]) }

💡 Hint

Think about which LOD expression ignores filters on other dimensions.

The FIXED LOD expression calculates the sum of sales fixed at the Region level, ignoring filters on other dimensions like Category.

🔧 Formula Fix

advanced

Troubleshooting Connection Errors in Tableau

You try to connect Tableau to a PostgreSQL database but receive the error: 'SSL connection is required. Please specify SSL options.' Which option correctly fixes this issue?

A Disable SSL in Tableau connection settings to avoid the error.

B Use a live connection instead of an extract to fix SSL errors.

C Change the database port to 80 to bypass SSL requirements.

D Enable SSL in Tableau connection settings and provide the required certificates if needed.

💡 Hint

SSL errors usually mean the connection requires encryption settings.

Enabling SSL and providing certificates as required by the PostgreSQL server ensures a secure connection and resolves the SSL error.

❓ visualization

expert

Designing a Dashboard to Monitor Database Connection Performance

You want to create a Tableau dashboard that shows the average query response time for SQL Server and PostgreSQL connections over the last 30 days. Which visualization best communicates this information clearly and accessibly?

A A pie chart showing the proportion of total queries from SQL Server vs PostgreSQL.

B A scatter plot with query response time on the x-axis and query count on the y-axis.

C A line chart with two lines, one for SQL Server and one for PostgreSQL, showing average response time by day.

D A stacked bar chart showing total queries per day for both databases combined.

💡 Hint

Think about how to show trends over time for two categories.

A line chart with separate lines for each database clearly shows trends in average response time over days, making it easy to compare performance.