A pricing strategy is

During the________ stage of the product life cycle, there are few but an increasing number of competitors.

Using the database you created (“animal name”) for your labs, construct a sql statement to review the history of the loads you have performed.  (data you loaded into your database) Include in the select statement:  Schema Name, File name, table name, last load time and status. Limit the output to show just 10 records. (supply the sql only – not the output)

True or false:  We can query data in our stage but we cannot filter it. 

With file formats we can do which of the following? 

What statement below is true about “Fail Safe”? 

True or False:  Our highest level in the Snowflake Hierarchy is the “Account” 

Using the same query in the first select statement, modify it to only return APAC and EUROPE regions and then group the data by supplier name, account balance, region name and nation name and order the data by account balance in descending order. (supply the sql only – not the output)

The director of Sales comes to you with a request for some new data to be added to the warehouse.  She mentions also that she wants us to get her request added to the next sprint.  Our next step with this new pipeline is what? 

Create a single sql statement that selects the top 50 records from   SNOWBEARAIR_DB.PROMO_CATALOG_SALES.SUPPLIER, SNOWBEARAIR_DB.PROMO_CATALOG_SALES.NATION and SNOWBEARAIR_DB.PROMO_CATALOG_SALES.REGION   — include in your statement the supplier name and account balance, region name and nation name.  (supply the sql only – not the output)