What are temporary tables, and how can they be used to optimize queries?Review LaterTemporary tables are permanent tables used to store intermediate results in a database.Temporary tables are used to store metadata about the database schema.Temporary tables are tables created and used within a single session or transaction.Temporary tables are used to encrypt sensitive data in a database.

Activity Overview As data calculations become more complicated, there are many components to keep track of, such as range, cost, time elements, products, and more. Some people use sticky notes for this, while others use checklists. In the data profession, a temporary table is just like a sticky note. You learned about temporary tables in SQL in earlier lessons, so take a moment to review. Temporary tables, or temp tables, store subsets of data from standard data tables for a certain period of time. Temp tables allow you to run calculations in temporary data tables without needing to make modifications to the primary tables in your database. Because they are temporary, they are automatically deleted at the end of your SQL session. By the end of this activity, you will have gained more experience creating temp tables and using them to run queries. Review the following scenario. Then complete the step-by-step instructions. A bikeshare company has reached a milestone, and their marketing team wants to write a blog post announcing the popularity of their most-used bike. They want to include the name of the station where that bike can most likely be found, so they ask you to determine which bike is used most often. 1. Question 1 Reflection How would you change the query to find the least frequent starting station of the bike ridden for the most time? Choose the correct code revision. 0 / 1 point 123 -- In the second occurrence of ORDER BY: ORDER BY trip_ct ASC 3 -- In the first occurrence of ORDER BY: ORDER BY trip_duration ASC 52341 ORDER BY trip_duration ASC ... ORDER BY trip_ct ASC 312 SELECT bike_id, MIN(duration_minutes) AS trip_duration

Question 4Why might a data professional add a CREATE TABLE statement to a temporary table?1 pointInclude metadata about the data in the tableGive multiple people access to the tableCreate a second table within the temporary tableAutomate calculations in the table

Which SQL statement is used to drop a temporary table?

When working with a temporary table in a SQL database, at what point will the table be automatically deleted? 1 pointAfter completing all calculations in the tableAfter ending the session in the SQL databaseAfter running the query in the SQL databaseAfter running a report from the table

Question 2In this activity, you created a temporary table to run calculations without needing to make modifications to the primary tables in your database. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:Why was the JOIN statement necessary to use in this activity? What is the benefit of executing a query in a temporary table rather than a primary table in a database?