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)

What were the 2 main difference between Bill Inmon’s version of a data warehouse and Ralph Kimbal’s version? 

Questions 33 through 34 are based on the following information:   The following information pertains to DISC Corporation’s defined benefit pension plan (in thousands):   PBO   Plan Assets January 1, 2023 $7,500   January 1, 2023 $9,000   Service cost 1,050    Actual return on plan assets 8%             (expected10% )  720   Interest cost, 6% ?   Cash contributions 1,480   Actuarial loss (gain) on PBO 90         Retiree benefits paid ?     Retiree benefits paid ? December 31, 2023 $8,500   December 31, 2023 ?   There was no amendment to the terms of the pension plan in 2023. The balance of Net Gain – AOCI at the beginning of 2023 is $950 (amortization calculated using the corridor method: $45) The balance of Prior Service Cost –AOCI at the beginning of 2023 is $900 (amortization: $90 per year). The average remaining service period of active employees expected to receive the benefits are 10 years.   What is the balance of Plan Assets at the end of 2023 (in thousands)?