Blog

What statement below is true about “Fail Safe”? 

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

True or false:  The main purpose of an external stage is to store business data only used in certain scenarios. 

What’s true about micro-partitions? 

What’s the primary purpose of an MDM program? 

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)

Which of these commands helps us extract data from a json file?

Which of the steps below are a part of the dimensional modeling process?

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 is 10 years.   What is the 2023 Pension Expense (in thousands)?

Which of the following changes would NOT be accounted for using the prospective approach?