Higher Test Marks with Free Online dbt-Analytics-Engineering Exam Practice

Given the below yaml

sources:

   - name: stripe

     database: raw 

     tables:

       - name: orders

       - name: customers

What is the right compiled code for a model which runs

select *

 from {{ source('stripe', 'customers') }}

Given the snapshot config, how check_cols will be used

{{

        config(

          target_schema='history',

           target_database='analytics',

          strategy='timestamp',

          unique_key='id',

          updated_at='updated_at',

          check_cols=[“col_1”, “col_2”]

        )

    }}

Which 2 are NOT valid property for Exposure

Given following .yml config, how dbt behaves if the environment variables are not set when dbt run is invoked

profile:

  target: prod

  outputs:

    prod:

      type: postgres

      host: 127.0.0.1

      # IMPORTANT: Make sure to quote the entire Jinja string here

      user: "{{ env_var('DBT_USER') }}"

      password: "{{ env_var('DBT_PASSWORD') }}"

      ....

How the SQL will be compiled based on the following model:

{% set payment_methods = ["bank_transfer", "credit_card", "gift_card"] %}

select order_id,

{% for payment_method in payment_methods %}

       sum(case when payment_method = '{{payment_method}}' then amount end) as {{payment_method}}_amount,

{% endfor %}

from {{ ref('raw_payments') }}

group by 1