Atlas connection string setup in MongoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the correct format of a MongoDB Atlas connection string?

Given the following connection string, what is the expected output when trying to connect to the database?

mongodb+srv://user:[e-mail]/myFirstDatabase?retryWrites=true&w=majority

Assume the credentials are correct and the cluster is accessible.

A Connection established successfully to the 'myFirstDatabase' database.

B Syntax error due to missing port number in the connection string.

C Connection established but to the default 'admin' database instead of 'myFirstDatabase'.

D Connection fails because 'retryWrites' is not a valid parameter.

💡 Hint

Look carefully at the connection string format and parameters.

The connection string uses the correct 'mongodb+srv' protocol, includes username, password, cluster address, and specifies the database 'myFirstDatabase'. The 'retryWrites' and 'w' parameters are valid options. No port is needed with 'mongodb+srv'.

📝 Syntax

intermediate

Identify the syntax error in this Atlas connection string

Which option contains a syntax error that will prevent connection to MongoDB Atlas?

A mongodb+srv://user:[e-mail]/myFirstDatabase?retryWrites=true&w=majority

B mongodb+srv://user:[e-mail]/myFirstDatabase?retryWrites=true&w=majority&ssl=true

C mongodb+srv://user:[e-mail]/myFirstDatabase?retryWrites=true&w=majority&

D mongodb+srv://user:[e-mail]/myFirstDatabase

💡 Hint

Check the query parameters and their separators.

Option C ends with an extra '&' which is invalid syntax in a URI query string and will cause connection failure.

🧠 Conceptual

advanced

Why is the port number omitted in MongoDB Atlas connection strings using 'mongodb+srv'?

Select the correct reason why Atlas connection strings with 'mongodb+srv' do not include a port number.

A Because the SRV record in DNS automatically provides the host and port information.

B Because Atlas only supports connections on the default MongoDB port 27017.

C Because the port number is included in the username field instead.

D Because the driver ignores port numbers when using 'mongodb+srv'.

💡 Hint

Think about how DNS SRV records work.

The 'mongodb+srv' protocol uses DNS SRV records to discover the hosts and ports automatically, so the port number is not needed in the connection string.

🔧 Debug

advanced

Why does this connection string fail to connect to Atlas?

Given this connection string:

mongodb+srv://user:[e-mail]/?retryWrites=true&w=majority

Why might the connection fail even if credentials are correct?

A Because the protocol should be 'mongodb' not 'mongodb+srv'.

B Because 'retryWrites' is set to true which is not supported.

C Because the password is missing in the connection string.

D Because the database name is missing after the cluster address.

💡 Hint

Check if the database to connect to is specified.

The connection string does not specify a database name after the cluster address, so the driver may default to 'test' or fail depending on configuration.

❓ optimization

expert

Optimizing Atlas connection string for read preference

Which connection string option correctly sets the read preference to 'secondaryPreferred' for better read scalability?

A mongodb+srv://user:[e-mail]/myDB?read_preference=secondaryPreferred

B mongodb+srv://user:[e-mail]/myDB?readPreference=secondaryPreferred

C mongodb+srv://user:[e-mail]/myDB?readPreference=secondary_preferred

D mongodb+srv://user:[e-mail]/myDB?readPreference=secondaryPreferred=true

💡 Hint

Check the exact parameter name and value format.

The correct parameter is 'readPreference' with value 'secondaryPreferred'. Underscores or extra '=true' are invalid.

Practice

1. What is the main purpose of a MongoDB Atlas connection string?

easy

A. To create a new database in MongoDB Atlas automatically

B. To connect your application to a MongoDB database hosted on Atlas

C. To backup your local database to MongoDB Atlas

D. To encrypt data stored in MongoDB Atlas

Solution

1. Step 1: Understand what a connection string does

   A connection string tells your app where and how to connect to a database.

2. Step 2: Identify the role of Atlas connection string

   Atlas connection strings specifically connect your app to a MongoDB database hosted on Atlas cloud.

3. Final Answer:

   To connect your application to a MongoDB database hosted on Atlas -> Option B

4. Quick Check:

   Connection string = Connect app to Atlas DB [OK]

Hint: Connection strings tell apps where the database lives [OK]

Common Mistakes:

• Thinking connection string creates databases
• Confusing connection string with backup tools
• Assuming connection string encrypts data

2. Which of the following is the correct format for a MongoDB Atlas connection string?

easy

A. atlas+mongodb://username:[e-mail]/myDatabase

B. mongodb://[e-mail]:27017/myDatabase

C. mongodb+srv://username:[e-mail]/myDatabase?retryWrites=true&w=majority

D. mongodb+srv://cluster0.mongodb.net/username:password/myDatabase

Solution

1. Step 1: Recognize the standard Atlas connection string prefix

   Atlas uses the prefix mongodb+srv:// to connect using DNS seedlist.

2. Step 2: Check the correct order of username, password, cluster, and database

   The correct format is mongodb+srv://username:password@cluster-address/database?options.

3. Final Answer:

   mongodb+srv://username:[e-mail]/myDatabase?retryWrites=true&w=majority -> Option C

4. Quick Check:

   Correct prefix and order = mongodb+srv://username:[e-mail]/myDatabase?retryWrites=true&w=majority [OK]

Hint: Look for mongodb+srv:// with username:password@cluster [OK]

Common Mistakes:

• Using wrong prefix like atlas+mongodb://
• Placing username after cluster address
• Missing password or using wrong separators

3. Given this connection string: mongodb+srv://user123:[e-mail]/sampleDB?retryWrites=true&w=majority, what database will the application connect to?

medium

A. sampleDB

B. user123

C. cluster0

D. majority

Solution

1. Step 1: Identify the database name in the connection string

   The database name appears after the cluster address and slash: sampleDB.

2. Step 2: Understand other parts of the string

   user123 is username, cluster0 is cluster address, and majority is a write concern option.

3. Final Answer:

   sampleDB -> Option A

4. Quick Check:

   Database name = sampleDB [OK]

Hint: Database name is after cluster address and slash [OK]

Common Mistakes:

• Confusing username with database name
• Picking cluster name as database
• Mistaking query options for database

4. You try to connect using this string: mongodb+srv://user:[e-mail] but get an error. What is the likely problem?

medium

A. The prefix should be mongodb:// not mongodb+srv://

B. Password is incorrect format

C. Cluster address is invalid

D. Missing database name after cluster address

Solution

1. Step 1: Check required parts of connection string

   A valid connection string must include the database name after the cluster address.

2. Step 2: Analyze given string

   The string ends at cluster address without specifying a database, causing connection failure.

3. Final Answer:

   Missing database name after cluster address -> Option D

4. Quick Check:

   Database name missing = connection error [OK]

Hint: Always include database name after cluster address [OK]

Common Mistakes:

• Assuming prefix mongodb+srv:// is wrong
• Thinking password format causes error
• Ignoring missing database name

5. You want to securely connect your app to MongoDB Atlas without exposing your password in the connection string. Which approach is best?

hard

A. Store the connection string with password in environment variables and read it in your app

B. Hardcode the full connection string with password in your app code

C. Use a connection string without username and password

D. Share your connection string publicly but change password often

Solution

1. Step 1: Understand security best practices for connection strings

   Passwords should not be hardcoded or shared publicly to avoid leaks.

2. Step 2: Use environment variables to keep secrets safe

   Storing connection strings in environment variables keeps passwords out of code and allows secure access.

3. Final Answer:

   Store the connection string with password in environment variables and read it in your app -> Option A

4. Quick Check:

   Use env variables for secrets [OK]

Hint: Keep passwords out of code; use environment variables [OK]

Common Mistakes:

• Hardcoding passwords in source code
• Using connection strings without authentication
• Sharing connection strings publicly