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.

Practice

1. What is the main purpose of connecting Tableau to a database like SQL Server or PostgreSQL?

easy

A. To access and visualize live data directly from the database

B. To create new tables inside the database

C. To backup the database automatically

D. To write SQL code inside Tableau

Solution

1. Step 1: Understand Tableau's connection role

   Tableau connects to databases to fetch data for analysis and visualization.

2. Step 2: Identify the main use of connection

   The connection allows Tableau to access live data, not to modify or backup it.

3. Final Answer:

   To access and visualize live data directly from the database -> Option A

4. Quick Check:

   Database connection = live data access [OK]

Hint: Think: Tableau reads data, not changes it [OK]

Common Mistakes:

• Confusing data access with data modification
• Assuming Tableau creates or backs up database tables
• Believing Tableau writes SQL code inside itself

2. Which of the following is the correct way to specify the server name when connecting Tableau to a PostgreSQL database?

easy

A. port=localhost;server=5432

B. server=5432;port=localhost

C. server=localhost;port=5432

D. localhost=server;5432=port

Solution

1. Step 1: Identify correct server and port syntax

   Server name is usually a hostname or IP, port is a number; for PostgreSQL default port is 5432.

2. Step 2: Match correct key-value pairs

   Correct format is server=localhost;port=5432, meaning server is localhost and port is 5432.

3. Final Answer:

   server=localhost;port=5432 -> Option C

4. Quick Check:

   Server=host; Port=number [OK]

Hint: Server is name, port is number; order matters [OK]

Common Mistakes:

• Swapping server and port values
• Using port as a hostname
• Incorrect key-value syntax

3. Given the following Tableau connection details to SQL Server:
Server: sqlserver.company.com
Database: SalesDB
User: analyst
Password: correct_password
What will happen if the password is incorrect?

medium

A. Tableau will show an authentication error and fail to connect

B. Tableau will connect but show empty data

C. Tableau will connect but only show partial data

D. Tableau will connect and ignore the password

Solution

1. Step 1: Understand authentication in database connections

   Tableau requires correct credentials to connect; wrong password blocks access.

2. Step 2: Identify expected behavior on wrong password

   Connection fails with an authentication error; no data is retrieved.

3. Final Answer:

   Tableau will show an authentication error and fail to connect -> Option A

4. Quick Check:

   Wrong password = connection error [OK]

Hint: Wrong password stops connection, no data shown [OK]

Common Mistakes:

• Assuming connection succeeds with wrong password
• Thinking Tableau shows partial or empty data
• Ignoring authentication errors

4. You try to connect Tableau to a PostgreSQL database but get an error: Could not connect to server: Connection refused. What is the most likely cause?

medium

A. The database name is misspelled

B. The password is incorrect

C. Tableau does not support PostgreSQL connections

D. The server name or IP address is incorrect or unreachable

Solution

1. Step 1: Analyze the error message

   "Connection refused" means Tableau cannot reach the server at the network level.

2. Step 2: Identify common network causes

   Incorrect server name or unreachable IP causes connection refusal before authentication.

3. Final Answer:

   The server name or IP address is incorrect or unreachable -> Option D

4. Quick Check:

   Connection refused = server unreachable [OK]

Hint: Connection refused means server not reachable [OK]

Common Mistakes:

• Assuming wrong password causes connection refused
• Thinking misspelled database name causes connection refused
• Believing Tableau cannot connect to PostgreSQL

5. You want to create a live connection in Tableau to a SQL Server database named FinanceDB hosted on finance.company.com using Windows Authentication. Which steps should you follow to set this up correctly?

hard

A. Select PostgreSQL connector, enter finance.company.com as server, use SQL Authentication, then connect

B. Select SQL Server connector, enter server as finance.company.com, database as FinanceDB, choose Windows Authentication, then connect

C. Select SQL Server connector, enter FinanceDB as server, leave database blank, use Windows Authentication, then connect

D. Select SQL Server connector, enter finance.company.com as server, database as FinanceDB, use SQL Authentication with blank password, then connect

Solution

1. Step 1: Choose correct connector and enter server details

   Use SQL Server connector and enter the server name as finance.company.com.

2. Step 2: Specify the database and authentication method

   Enter database name FinanceDB and select Windows Authentication for login.

3. Step 3: Connect to establish live connection

   Click connect to access live data from FinanceDB using Windows credentials.

4. Final Answer:

   Select SQL Server connector, enter server as finance.company.com, database as FinanceDB, choose Windows Authentication, then connect -> Option B

5. Quick Check:

   Correct connector + server + database + auth = successful connection [OK]

Hint: Match connector and auth type to server and database [OK]

Common Mistakes:

• Using wrong connector for SQL Server
• Mixing authentication types incorrectly
• Entering database name as server