dbt Labs dbt Analytics Engineering Certification 認定 dbt-Analytics-Engineering 試験問題:

1. A raw source table undergoes periodic bulk updates that temporarily disrupt dependent models when they are running. Which of the following strategies might help prevent errors in these models? (Choose two)

A) Implement incremental materializations if possible.
B) Utilize snapshots to capture the state of the raw table before the bulk updates.
C) Schedule dbt jobs to run after the bulk updates are typically complete.
D) Add retries with a delay to any 'ref calls referencing this table.

2. The dataset raw user activity is critical to several models. You've been informed that a major schema change is scheduled for this source. Select the best way to proactively mitigate the potential impact of this change on your dbt project.

A) Create custom data tests that validate the critical columns in raw_user_activity.
B) Run dbt test after the schema changes and address any failures.
C) Pause all dbt jobs until the schema change risk is fully assessed.
D) Communicate with the relevant data team to create a temporary staging table mirroring the old schema.

3. Security best practices dictate that data warehouse access should follow a "least privilege" principle. How would you implement this within dbt environments?

A) Create separate data warehouse user accounts for development, staging, and production, each with minimal required permissions.
B) A combination of the above approaches.
C) Leverage dbt's built-in grants mechanism to fine-tune object-level access within models.
D) Restrict access to sensitive data in development and staging environments using encryption or masking techniques.

4. You've updated a model's description in a YAML file to reflect a new business requirement. You've also added additional context to the column descriptions. After regenerating the documentation, you notice the model description has updated, but the column descriptions have not. What could be the most likely reasons?

A) You are viewing an older cached version of the documentatiom
B) The model's YAML file has incorrect syntax preventing column descriptions from rendering.
C) The documentation was not configured correctly to display column descriptions.
D) You forgot to run dbt docs generate after modifying the YAML file.

5. You've just added some schema tests to a critical model. Which command should you execute to ensure these new tests are run?

A) dbt seed
B) dbt compile
C) dbt test
D) dbt run

質問と回答：