dbt-Analytics-Engineering 試験問題を無料オンラインアクセス

(Multiple Select)

• A.Long-term storage of the model's output isn't a primary requirement.
• B.You need to grant access to a model's results to users with limited permissions.
• C.The model's data needs to be frequently joined with other datasets for analysis.
• D.The model involves complex transformations that are computationally expensive.

(Multiple Select)

• A.Add {{ log(macros, info=true) statements within the macro to track how it executes-
• B.Check the generated column names in the compiled SQL to ensure they match existing columns in the data.
• C.Run dbt Is to confirm that all dependencies for the macro and the model are resolved correctly.
• D.Implement unit tests specifically for the macro to validate its output under different inputs

you're working with a dbt project where a central model fct_orders is refactored. Several downstream models rely on this fact table. Which of the following is the MOST efficient way to determine which downstream models might be affected by this change?

• A.Use the dbt Is command to generate a lineage graph.
• B.Run dbt test to see which tests might fail.
• C.Utilize the dbt docs generate and dbt docs serve commands.
• D.Manually review the code of all downstream models.
• E.Execute dbt run and observe for errors.

(Multiple Select)

• A.Inserting large volumes of historical transactional data for backfilling purposes.
• B.Defining generic tests that apply to multiple data sources.
• C.Loading configuration data for production environments that differs from development settings.
• D.Populating a lookup table with country codes.

You have a dbt model that depends on several upstream source tables. One of these source tables is occasionally updated very late, causing your job to fail if triggered at the usual time. What configuration could mitigate this?

• A.Configure a dbt hook to run before the job, dynamically checking freshness of the source table.
• B.Redesign the model with an incremental materialization strategy that gracefully handles partial updates.
• C.Add a depends_on relationship pointing to the potentially late table within your model.
• D.Set the -full-refresh flag for the dbt job to ensure all tables are materialized.