Creating tables via dashboard in Supabase - Practice Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Table Creation Steps in Supabase Dashboard

Which of the following sequences correctly describes the steps to create a new table in the Supabase dashboard?

A Navigate to Database > Tables, click 'New Table', define columns, set primary key, then save.

B Go to Authentication > Users, click 'Add User', define user details, then save.

C Open Storage > Buckets, click 'New Bucket', set permissions, then save.

D Access SQL Editor, write CREATE TABLE statement, then run query.

💡 Hint

Focus on the dashboard section dedicated to tables and the typical steps to define a table.

Creating a table via the dashboard involves navigating to the Database section, selecting Tables, then using the 'New Table' button to define columns and keys before saving.

❓ dax_lod_result

intermediate

Result of a DAX Measure Using Table Created in Dashboard

Assume you created a table named Sales in Supabase dashboard with columns Product and Amount. You write this DAX measure in Power BI connected to Supabase:

 TotalSales = SUM(Sales[Amount]) 

What will TotalSales return if the table has rows: (Product: A, Amount: 100), (Product: B, Amount: 200)?

A Error: Table not found

B 100

C 200

D 300

💡 Hint

Think about what SUM does over the Amount column.

The SUM function adds all values in the Amount column. 100 + 200 = 300.

❓ visualization

advanced

Best Visualization for Newly Created Sales Table

You created a Sales table with columns Product and Amount. You want to show total sales per product in a dashboard. Which visualization type is best?

A Scatter plot of product vs amount

B Line chart showing sales over time

C Pie chart showing sales distribution by product

D Table showing raw data only

💡 Hint

Consider which chart best shows parts of a whole for categories.

A pie chart clearly shows how total sales are divided among products, making it easy to compare proportions.

❓ data_modeling

advanced

Modeling Relationships After Creating Tables

You created two tables via Supabase dashboard: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount). What is the best way to model their relationship in your BI tool?

A Create a one-to-many relationship from Customers.CustomerID to Orders.CustomerID

B Create a many-to-many relationship between Customers and Orders without keys

C Merge both tables into one flat table

D Do not create any relationship; use separate visuals

💡 Hint

Think about how orders relate to customers in real life.

Each customer can have many orders, so a one-to-many relationship from Customers to Orders on CustomerID is correct.

🔧 Debug

expert

Debugging Table Creation Error in Supabase Dashboard

You try to create a table named Sales with columns Product (text) and user (number). After saving, you get an error: 'Column name "user" conflicts with reserved keyword.' What should you do to fix this?

A Ignore the error and refresh the dashboard

B Rename the column from user to TotalAmount and save again

C Remove the Product column and save

D Change the data type of user to text and save

💡 Hint

Reserved keywords cannot be used as column names. Try renaming the column.

Renaming the column to a non-reserved name like TotalAmount avoids the conflict and allows saving.