Database connections (SQL Server, PostgreSQL) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to connect Tableau to a SQL Server database using the correct driver name.

Tableau

connection = tableau.connect(driver='[1]', server='sqlserver.example.com', database='SalesDB')

Drag options to blanks, or click blank then click option'

APostgreSQL

BSQL Server

CMySQL

DOracle

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'PostgreSQL' instead of 'SQL Server' as the driver name.

Using a driver name that does not match the database type.

The correct driver name for connecting to SQL Server in Tableau is SQL Server.

2fill in blank

medium

Complete the code to connect Tableau to a PostgreSQL database specifying the correct port number.

Tableau

connection = tableau.connect(driver='PostgreSQL', server='pg.example.com', port=[1], database='AnalyticsDB')

Drag options to blanks, or click blank then click option'

A5432

B1521

C1433

D3306

Attempts:

3 left

💡 Hint

Common Mistakes

Using the MySQL port 3306 instead of PostgreSQL's 5432.

Confusing SQL Server port 1433 with PostgreSQL port.

The default port for PostgreSQL is 5432. This is required to connect properly.

3fill in blank

hard

Fix the error in the connection string by selecting the correct authentication method for SQL Server.

Tableau

connection = tableau.connect(driver='SQL Server', server='sqlserver.example.com', authentication='[1]')

Drag options to blanks, or click blank then click option'

ABasic

BOAuth

CKerberos

DWindows

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'OAuth' which is not standard for SQL Server connections.

Confusing 'Basic' authentication with Windows authentication.

For SQL Server, Tableau commonly uses Windows authentication to connect securely.

4fill in blank

hard

Fill both blanks to complete the Tableau connection code for PostgreSQL with SSL enabled.

Tableau

connection = tableau.connect(driver='[1]', server='pg.example.com', sslmode='[2]')

Drag options to blanks, or click blank then click option'

APostgreSQL

BSQL Server

Crequire

Ddisable

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'SQL Server' driver for PostgreSQL connection.

Setting sslmode to 'disable' when SSL is needed.

To connect to PostgreSQL with SSL, use driver PostgreSQL and set sslmode to require.

5fill in blank

hard

Fill all three blanks to complete the Tableau connection code for SQL Server using a specific port and database.

Tableau

connection = tableau.connect(driver='[1]', server='sqlserver.example.com', port=[2], database='[3]')

Drag options to blanks, or click blank then click option'

ASQL Server

B1433

CSalesDB

DPostgreSQL

Attempts:

3 left

💡 Hint

Common Mistakes

Using PostgreSQL driver or port for SQL Server connection.

Leaving the database name blank or incorrect.

SQL Server uses driver SQL Server, default port 1433, and the database name is SalesDB.