What is Supabase - Practice Questions & Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Supabase Core Functionality

Which of the following best describes the primary purpose of Supabase?

A A frontend framework for building user interfaces with reusable components.

B A platform that provides a ready-to-use backend with a database, authentication, and storage services.

C A cloud service that only offers virtual machines for running custom backend code.

D A tool for managing DNS records and domain registrations.

💡 Hint

Think about what services Supabase offers to developers to build applications quickly.

Supabase is designed to provide backend services like databases, authentication, and storage, making it easy to build apps without managing infrastructure.

❓ Architecture

intermediate

Supabase Architecture Components

Which component is NOT part of the typical Supabase architecture?

A PostgreSQL database for storing data.

B Authentication service for user management.

C Realtime server for live data updates.

D Built-in frontend hosting service.

💡 Hint

Supabase focuses on backend services; consider what it does not provide directly.

Supabase provides backend services like database, realtime, and auth, but does not include frontend hosting as a core service.

❓ service_behavior

advanced

Realtime Data Updates in Supabase

What happens when a row in a Supabase PostgreSQL table is updated and you have subscribed to realtime changes on that table?

A Supabase sends an email notification about the update.

B The client must manually refresh to see the updated data.

C The subscribed client immediately receives the updated row data via a websocket connection.

D The update is queued and delivered after 24 hours.

💡 Hint

Realtime means instant updates pushed to clients.

Supabase uses websockets to push realtime updates to subscribed clients instantly when data changes.

❓ security

advanced

Supabase Authentication Security

Which of the following is a security feature provided by Supabase Authentication?

A Password hashing and secure token generation for user sessions.

B Automatic firewall configuration for user devices.

C Encryption of frontend code to prevent copying.

D Blocking all IP addresses except one.

💡 Hint

Think about how user credentials and sessions are protected.

Supabase Authentication securely hashes passwords and generates tokens to keep user sessions safe.

✅ Best Practice

expert

Best Practice for Using Supabase Storage

When storing user-uploaded files in Supabase Storage, what is the best practice to ensure security and proper access control?

A Use Supabase Storage policies to restrict file access based on user roles and authentication status.

B Disable authentication to speed up file uploads.

C Store files outside Supabase and link to them without any access control.

D Make all files public so users can access them without logging in.

💡 Hint

Consider how to protect files so only authorized users can access them.

Using Supabase Storage policies allows fine-grained control over who can access files, enhancing security.

Practice

1. What is Supabase primarily used for?

easy

A. Creating graphics and animations

B. Designing user interfaces for websites

C. Providing backend services like database and authentication

D. Managing local computer files

Solution

1. Step 1: Understand Supabase's role

   Supabase offers backend services such as databases and user authentication.

2. Step 2: Compare options

   Options B, C, and D relate to frontend design, graphics, and local files, which are not Supabase's focus.

3. Final Answer:

   Providing backend services like database and authentication -> Option C

4. Quick Check:

   Backend services = A [OK]

Hint: Supabase is backend, not frontend or design [OK]

Common Mistakes:

• Confusing Supabase with frontend tools
• Thinking Supabase manages local files
• Assuming Supabase creates graphics

2. Which of the following is the correct way to connect to Supabase in code?

easy

A. const supabase = createClient('url', 'key');

B. connectSupabase('url', 'key');

C. new SupabaseClient('url', 'key');

D. supabase.connect('url', 'key');

Solution

1. Step 1: Recall Supabase client creation syntax

   The official way is using createClient with URL and key.

2. Step 2: Check other options

   Options A, C, and D use incorrect function or class names not in Supabase docs.

3. Final Answer:

   const supabase = createClient('url', 'key'); -> Option A

4. Quick Check:

   Use createClient() to connect [OK]

Hint: Supabase uses createClient() to connect [OK]

Common Mistakes:

• Using wrong function names
• Trying to instantiate Supabase with new keyword
• Calling connect() method which doesn't exist

3. Given this code snippet, what will be the output?

const { data, error } = await supabase.from('users').select('*').eq('id', 1); console.log(data);

medium

A. An empty array because no users exist

B. An array with user data where id equals 1

C. An error message about invalid syntax

D. A boolean true value

Solution

1. Step 1: Understand the query

   The code selects all columns from 'users' where id equals 1.

2. Step 2: Predict output

   If user with id 1 exists, data will be an array with that user's info; no syntax error or boolean expected.

3. Final Answer:

   An array with user data where id equals 1 -> Option B

4. Quick Check:

   Query returns matching user data array [OK]

Hint: select('*').eq('id', 1) returns matching user array [OK]

Common Mistakes:

• Expecting error due to syntax
• Thinking output is boolean
• Assuming empty array without checking data

4. Identify the error in this Supabase code snippet:

const supabase = createClient('url', 'key')
const { data, error } = supabase.from('profiles').select('*')
console.log(data)

medium

A. Missing await keyword before supabase.from() call

B. Incorrect function name createClient

C. Using console.log instead of return

D. No error, code is correct

Solution

1. Step 1: Check async usage

   supabase.from().select() returns a promise, so await is needed to get data.

2. Step 2: Verify other parts

   createClient is correct, console.log is valid for output, so no error there.

3. Final Answer:

   Missing await keyword before supabase.from() call -> Option A

4. Quick Check:

   Async calls need await [OK]

Hint: Always await async Supabase calls [OK]

Common Mistakes:

• Forgetting await on async calls
• Thinking createClient is wrong
• Confusing console.log with return

5. You want to build an app that stores user files and authenticates users without managing servers. Which Supabase features should you use together?

hard

A. Functions and Realtime services

B. Database and Authentication services

C. Realtime and Database services

D. Storage and Authentication services

Solution

1. Step 1: Identify needed features

   Storing user files requires Storage; authenticating users requires Authentication.

2. Step 2: Match options

   Storage and Authentication services combines Storage and Authentication, fitting the app needs. Database or Realtime alone don't handle file storage.

3. Final Answer:

   Storage and Authentication services -> Option D

4. Quick Check:

   Files + login = Storage + Authentication [OK]

Hint: Files need Storage; login needs Authentication [OK]

Common Mistakes:

• Choosing Database instead of Storage for files
• Confusing Realtime with Authentication
• Ignoring Storage for file management